TempVars unusable in field default value
I'm trying to use a temporary variable to keep track of which CSR is
I have a macro which prompts user for ID code, which is stored in the temp
On a form control default value property, I can use the expression
[TempVars]![TempUser], which will populate that user's ID code into the
However, I cannot use that same expression in the tables field default value
property. If I try, when I save the changes to the table, I get the error
message "Could not find the field 'TempVars]![TempUser'. "
Any ideas why I ca...send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with
one or two fields changed (for example the name of recipient and the
date).How canthis be done?? I would also like to be able to save the
e-mail and use it again and again.
can anyone help
If you have Word installed and it's the same version as Outlook (both 2003,
for example), you can do a mail merge between the two. This would allow you
to set up the text the way you want it to, and you can save the document for
future use. Look at the following page for further information:
http://www.slipstick.com/con...Proper Table(s) Layout
I have created a couple of Dbs which the table structure seemed to simply
fall into place, it was just logical in my head.
That said, I am working on a new db and for some reason I am doubting myself
and wanted a second opinion.
The db is basically a contract db to input all the info, and there is a lot
of info, for each contract. Where I am 'lost' is the fact that the contracts
are broken into categories: clients, components,engineering, warantee... For
all of the components (with the exception of clients) there are a number of
fields but only 1 entry per contract....Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...Pass parameter from FORM to QUERY
I have an append query that I trying to call from a cmd btn...but it
prompts me for the parameter(ie QuoteID)...
How do I tye it into my call:
Dim stQueName As String
stQueName = "Quote Query"
DoCmd.OpenQuery stQueName, acNormal, acEdit
On Apr 13, 12:56 pm, jlt...@hotmail.com wrote:
> I have an append query that I trying to call from a cmd btn...but it
> prompts me for the parameter(ie QuoteID)...
> How do I tye it into my call:
> Dim stQueName As String
> stQueName = "Quote Query"
> DoCmd.OpenQuery stQueName, acNormal, acEd...Office 2007 forms
I am creating a form with office 2007, will those people who do not use
office 2007 be able to fill in my form? should I save it in a particular
Provided you start from the normal template, don't use fonts that were
introduced with Word 2007, and save the form in Word 97-2003 document
format, anyone with Word 97 or later should be able to open it. Use only the
legacy form fields, to which end
http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm will make things
<>>< ><<> ><<> <>>< ><<...C# Adding Days to a Date
I have 2 objects:
objContract.activeon and objContract.expireson.
I am trying to add 364 days to objContract.activeon and assign it to the value
// Contract Start Date
DateTime dt = DateTime.Now;
objContract.activeon = new CrmDateTime();
int iFound = 0;
string sTemp = "";
if (objAccount.paymenttermscode.Value == 1) // due on receipt - use Todays
objContract.activeon = objInvoice.CFDinvoicedate;
else // ...Table link documentation
I am having trouble trying to locate A/P check data that has project related
costs. I found the check data but it is does not indicate the projects, I
found the project data but can not determine thye logical link between the
two tables, I may be using the wrong tables the tables I am using are PM80500
and PA31102. Is there any documentation of how all the tables in the system
are logically link. I am trying to write reports in MS Access, but there
are 1500+ tables in GP (version 10)
In an effort to find the correct table you can do a number of things (believe
me I do)....Field Service Calls and Invoices
We use the Service Call modules for repairs in our Stores and have a
situation that I'm trying to find a workaround. We have situations where our
technicians will pick-up items without prior notification to our dispatchers.
All of a sudden we get an invoice and currently we have to track down the
charge and then we are forcing a PO into the system from the Service Call in
order to properly receive and enter the invoice.
Does anyone have other ways to do this and track the information/cost on the
Service Call without needing to create a PO after the fact.
This is not an applicat...Duplicate record in RM tables
We experienced an issue in Apply Sales Document that may have caused a
duplicate record somewhere. We found this when running Paid Sales
Transaction Removal and received this message:
Violation of PRIMARY KEY contraint PKRM3101. Cannot insert duplicate key in
I ran the RM duplicate tool found in the automated help area of this website
and found the following:
--- Begin copy here ----
Duplicates between RM Open and RM History
Document #: 07-003021-17 Customer #: 079100 RMDTYPAL #: 7
--- End copy ---
It looks like the duplicte tool also logs the qu...Adding support for mfc / atl types in a Win32 project
MSDN says this about adding support for classes shared between atl &
mfc (I'm just after points and rects btw)... just add the header (
I'm getting linker errors for these classes though. Is there a lib I
need to add? Any screwy build options need changing? It's in VC 2003.
In the project wizard I note that atl and mfc support aren't available
when creating an empty Win32 application.
On 26 May 2006 07:42:09 -0700, Simon L wrote:
> MSDN says this about adding support for classes shared between atl &
> mfc (I'm just after points and rect...Changing query execution sequence
I got a spreadsheet which would execute a bunch of queries. It's noted that
the queries are executing in the sequence of when it was added to the
spreadsheet. Does anyone out there know of a way to switch the order without
deleting and recreating them?
...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...140 MB file went to 5.08 MB after editting 1 table
Hello All -
I need some ACCESS insight...please...
Several years ago, I built an access db to track my business
scheduling and accounts payable/receivable.
So this database is EXTREMELY IMPORTANT TO ME.
The file has grown to 140 MB.
Today I made a copy of the file and then edited my calendar table.
I removed all columns which had 2006 data (72 totals columns) - the
table had about 144 columns originally.
I then added 72 columns with 2008 headers. These columns are now
blank since I have not added any 2008 data yet. Afterwards, I looked
around and everything looks good - my 2007 data is the...adding extra marker styles
how do we add extra marker styles into an excel chart? we have used all the
ones it has given us in 2003, but there use3d to be many more in 2002, how do
we get them back?
Here is an explanation on how to add custom markers.
I don't think the marker style have changed since xl2000.
> how do we add extra marker styles into an excel chart? we have used all the
> ones it has given us in 2003, but there use3d to be many more in 2002, how do
> we get them back?
Andy Pope, Micro...cursor missing from form textboxes
I believe that I know 98% of the little intricacies of Publisher, but I'm
stumped on this one. I created a website with a contact page and none of the
standard textboxes will show a cursor to indicate with field you are in (I've
even made the site live to double check). If you tab between textboxes, the
tabbing works, as does typing, there is just no visual cursor to indicate
where you are. If you click on the first textbox and type, all is good you
can tab to the next box and type, and it's fine. I'd like to have the visual
cursor show and can't get it. I also have ...Pivot Table Defaults
In the pivot table field list, whenever I create a new pivot table and I am
inserting fields into the value area, I generally get as default field
setting the 'Count' value. Is there a way to format the spreadsheet to make
Excel recognize the data as all numbers so it defaults to the "Sum" function
as opposed to "text"?
The rule that the PT Wizard adopts is,
If all the values in the field being added to the data area are Numeric,
then it uses Sum.
If any of the values are Text or BLANK, then it uses Count.
It sounds as though you have defin...Like a pivot table
Hello every body
I'm first time requesting in this group, so I opologize in advance for any
mistakes or something annoying
I repeat what I have sent before 10 min because I see it unclear when it
goes to news group
If any one can help me
I'm working with data which most of it comes like a table with feilds as
columns and records as rows. I want it to be as many rows with each feild
what is exist
name age Joining Date Tele
John 20 Jun-90 4321251
Iqbal 30 Jul-95 6583752
George 40 Sep-85 7843125
What I wa...VBA form
Im using a form/macro that i linked to through another thread and a
tailoring it to my needs. I basically have it doing what i need but
cant get a button to do what i want. When the user starts the macro i
brings up the form with a message and 2 buttons (Continue/Cancel). Whe
continue is pressed i want the message on the form to change to aniothe
message and so on until all messages are shown. Ive attacehed what i
working on and apprecaite any help offered.
|Filename: Excel.zip ...multiple iterations of same query
Running Access 2003 on Vista.
I have a query that chooses 15 records at random. This works fine.
What I want to do is run the same query for approx 110 different users, each
with their own randomly selected 15 records. Obviously, I want to avoid
manually running the same query that many times. How can I get around this?
Post your query SQL.
Build a little, test a little.
> Running Access 2003 on Vista.
> I have a query that chooses 15 records at random. This works fine.
> What I want to do is run the same query fo...Duplicating one Field from One table to Another
I have two tables - one position, one personnel - which has a 1-to-many
relationship (1 position record to many personnel records). The department
had a new requirement which made it necessary to change some coding (I
inherited this). I'm using tab forms so that when a position is pulled up,
you can click on the tab that has the personnel information (if there is
any). There is a button on the Personnel form that allows the user to add a
new Personnel record. Since I am using an Auto-number field in the Position
table (which doubles as the PK) the functionality is fine. Wh...Scroll Wheel effecting a form
Is there any way to keep a mouse scroll wheel from having an effect on a
This is a single form for data entry and if are part way thru the form and
for what ever reasom use the scroll wheel all the fields on the form are
effected (they dissapear - like going to the next new record).
My suggestion to get a mouse without a scrool wheel was not met with
Any help here will be appreciated.
Thanks in advance
The scroll wheel is moving you through the records. Nothing except your
view of the records is disappearing. The records are still there. I
wouldn't think y...How to show query parameters on an Excel page header or worksheet?
Is it possible to display query parameters on a page header or on a
worksheet? I have a worksheet that uses a query to retrive data from an ODBC
database. The Query prompts for the Start Date and End Date. I would like
to be able to print the worksheet and display the Start Date and End Date the
user typed in. Thank you for your assistance.