Search results for query: *

In Word 2002 I have been trying to do a mail merge with my sql server data. I have successfully created a SQL server connection as I can see all the tables and views but when I browse to the connection I set up, it says "Word was unable to open the data source". Any ideas? Thank you irishhelp

Did this issue ever get resolved? I am currently trying to link my sql server database to a mail merge in Word. I can create a link to one of my Views and test the connection but when I want to select recipients I get "Word was unable to open the data source". I tried...

I think for the 4 Week Query, I don't need to use the Participant Query. I could use the Participant Table and the Q-Referral The Q-Referral is used for a form that is a sub-form of the Participant Form (based on Participant Query). The 4 Week Query is used to query dates that fall between a...

Yes, they are both queries SQL for Q-Participant Entry: SELECT [Participant Entry Table].*, ([Participant Entry Table]![InitialEntryDate]-[Participant Entry Table]![Birth Date])/365 AS [Age at Initial Entry] FROM [Participant Entry Table] ORDER BY ([Participant Entry...

Leslie This is the SQL for the query I'm trying to run. SELECT [Q-Participant Entry].[Last Name], [Q-Participant Entry].[First Name], [Q-Referrals].[4 Week], [Q-Referrals].[Exit Date] FROM [Q-Participant Entry] LEFT JOIN [Q-Referrals] ON [Q-Participant Entry].[S I N] = [Q-Referrals].SIN WHERE...

I did use the DateAdd function

Leslie Unfortunately, if I use a Between(date) and (date) it tells me that it is too difficult to evaluate. If I try >[enter beginning of period] I will only get results if I type for example, 01 jan, 04. 1-jan-04 will not work, nor will January 1, 2004 but 1/jan/04 will work. It must be in...

batteam Do I have to enter the information that way? No. That is how the end users want the information. Oddly enough, the start date has the same format but if I add the same parameter to the start date, I can enter it Jan 1, 04 to Jan 31, 04 but the 4 week date must be entered 1 jan, 04 to...

I have created an expression field in a query based on a date field and then added 28 days so it looks like this: 4 Week: [Referral Table]![Start Date]+28. The start date format in the Referral Table is: dd/mmm/yyyy and the input mask for this field is: 99\->L<LL\-0000;0;;;_. This is...

I have a form that is larger than the screen. When data entry person comes to the end of what is on the screen and hits tab, it moves to the field, but the screen does not change to show that the cursor has moved to the next field which does not appear on the screen. Is there a way to make the...

We have a database developed in Access 97 and two users who use it in 97. We have a 3rd user who accesses the database using Access 2002. The database is set to shared. It appears as though the 97 users must be out of the database before the 2002 user can access. Even then, she receives...

We have two users using one cpu. One of the users uses a database that you must have a login and password to get into the database (part of a workgroup). This is set up as a shortcut. The other user wants to use Access for other databases - using the Microsoft Toolbar. The trouble we've...

Edate was the field on the form. I made a text box using the edate field, then entered [Text110].Value=Date() in the last name properties AfterUpdate but it tells me that it can't find the macro Text110.

I typed in [EDATE].Value=Date() in the AfterUpdate property box in my lastname field. It tells me that [EDATE] is a macro that it can't find.

I added the code: Me.EDATE.Value=Date on my firstname field but when I moved to another field I was told that &quot;The Macro or Macro group does not exist, or the macro is new and hasn't been saved. Note that when you enter the macrogroupname.macroname syntax in an argument you must specify...

Thanks, I'll give this a try.

I'm storing basic demographic information, so what they'd like is that if you update the address field, the last date updated field would automatically update. You mentioned code - I've added =Date() to the underlying table and to the default value for the field but it only inputs the date on...

I have a date field in my form that they would like to update any time a change is made on the form. How do I do this? I'm working in Access 97.

Thanks Rick No one seems to have the original source code and/or developers FoxPro environment nor does anyone have experience with FoxPro development. As it turns out, while information goes in, very little information ever comes out. The program is taking a good look at what information is...

The version of FoxPro is 2.6. Initially, when the user clicks on the database icon, she gets the following message: &quot;An error has occurred in your program. To keep working anyway, click Ignore and save your work in a new file. To quit this program, click Close. You will lose...