Recent content by smhill

I have a similar problem Pat, I am trying to do something similar, and after perusing the forum, you seem to be the one to ask! I am setting up a test db to learn these things before putting them into action in the real thing--so my field/object names are pretty vague. Basically I want what...

I have two tables that overlap...that is, they contain some identical fields with identical data. How can I make my one form fill in both tables? Ex. Each table contains the ID#s for all my clients. Is there a way I can enter each ID into the form and have it filled in in both tables...

I didn't create the database. My company is working with another and this is the way we send all our information back and forth. They sent me the database with all the forms so I could enter my info. When I recieved it there were 100 records partially filled out that I was supposed to...

I tried to add a new record to my table, but it doesn't show up on the corresponding form. If I try to add it to the form, I'm told one of my fields is prohibited by the validation rule. The validation rule is >=010001 and <=019999. I'm entering 010035, and it's telling me it's prohibited...

I'm rather new to Access, but I have to get this done fast. I have two separate databases: one in table form with all my records and fields; and another that is empty, with the exception of 3 preformatted forms and corresponding tables. My employer wants me to transfer all data from database 1...