Search results

I need to make Access automatically create new records in a table for me. Just for example:- Table #1 has 2 fields PersonID (autonumber) PersonData (text) Table #2 has 3 fields ID (autonumber) PersonID (number) MoreData (text) The database user creates a new record in Table #1 using a...

SetValue Question - Please Help! I have a command button that I want to automatically enter the date into a date field on the same form. Setvalue item: [Forms]![FRM_View_Orders]![OrderDate] expression: Date() This works in Access 2000 -- but in Access 2003 I get this error message: "Object...

The purpose of my new database is customer queries. This is for our Customer Support rep, who when she recieves a query from a customer, passes it on to the relevant department, via email, to deal with it. I have a module which has the code to create a new Email. This works, I can get Access...

I have a table which has a date/time field (both the date and time in same field) which specifies when an item was recieved. This is automatically added to the record when the other fields are entered by the user -- it is entered as "=now()" and cannot be altered by the user. I need to make a...

Hello everyone I'm not too hot with Access yet, but I'm starting to get there. Here's my question: I am building a database to deal with queries from customers. It's very simple. I have a table and a form for queries, and another form and table for the responses to the queries. This all...