Recent content by rangerruss

Cyberlynx: Will you VB code work for access 2003 which I believe does not have the picture primitive built in?

thank you for the quick response.....i dont know how i missed that.....:o

I have a database which contains various case numbers (case #) in the format as "D10-04-1234". I want to be able to click on the case # field in the form so that a new form named "incidents" will open for the above stated format. here is my code which does not work.. Private Sub Case___Click()...

thank you this looks useful and should help in the future:cool:

OK....I understand what both are saying....I will change the field names in the tables, queries and forms to comply...I will also look into the auto-name correct issue.

yes....i understood that.....this just seems to baffle me....plus it forces me to keep two sets of the applications....:confused:

i have checked and recheck this....all are the same...

nothing shows as missing in the tools>references... i am not using VBA on the 9 systems that it functions properly....

This is the control listing for all the installs: control source = date default value = =date() all the units are using XP Pro and Access 2003 SP2 or sp3 on 9 of the 14 boxes it works as above....on the others the field in the form returns #name

OK...but why does is work of some of the installs?

The date() returns today's date on my design box. However, when I move the database to other machines, it returns #name. Using XP professional sp2 and sp3 as well as Office 2003 sp2 and sp3. All references are configured the same way. Any Ideas where to look for the differences.:confused: