Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access 97 Query (no pun intended)
Name: Bola Date: December 3, 2004 at 03:31:10 Pacific OS: NT4 CPU/Ram: n/a
Comment:
I have a database at work with an existing form in which we insert record number and year (as seperate fields)as part oif the data entry process. I have a created a new table and form which amongst others also contain these fields. Of course these are blank until and entry is made.
My question is that I want to open the new form from the old one via a button. When it opens I would like the record number and year to autofill with the data from the other form so that these match.
I did this in Access 2 via a macro I created (that was years ago LOL!) and for the life of me I cannot remember how I did it. Any help please!!!
Please let me know if you need any more info and I would prefer it if a macro was the solution. Thanks.
Name: Bola Date: December 3, 2004 at 05:42:17 Pacific
Reply:
Just an update. After going through some old notes I found out how I did it which was setting the form field properties under default value by putting in a formula so that the new forms field equalled the one of the same name of the form I just came from.
Summary: I'm trying to do a minus / except query in MS Access 97 using SQL commands. Here's the SQL code: (SELECT DISTINCT * FROM table1) MINUS (SELECT DISTINCT table1.* FROM table1, table2 WHERE table1.col1 =...
Summary: I'm having problems converting my Access 97 programs to Access 2000. String functions such as right(), date(), and chr(13)& chr(10)used in queries won't convert. I get a message undefined function. ...
Summary: I have a windows NT box running the access 97 database for 8 users. 7 of the users run win 98, they run the access 97 front end locally and attach to the NT box via drive mapping to G:\Access\xxxxxx_...
0 
