Search results for query: *

Thank-you for the great replies! All very good suggestions! I like the idea of having two tables and I like the idea of keeping it simple. It doesn't look like I'll have too many extra fields. Maybe 10 max. I just have to make sure that the fields aren't required in the table. I can make them...

I'm hoping some of you access geniouses can give me some advice! I've got a fairly decent size project to complete and need some suggestions since this isn't my area of expertise. This is a database for sales people to enter orders and print reports. The products list is large. There are...

Justin, I could search through all columns for that particular ID and retrieve the data I need. Thanks!

Dustin, Thanks for your suggestion. What I'm doing is inserting a name into a field on a form. The name comes from a table which has one record. This database is being distributed to 300 sales people. They will personalize their copy of the database by entering their info. They have different...

I've got a table which has one record. I need to fill a form text box with the value of one field in the record. I won't know the id of the record since that might change so I don't have anything to search on. Help please!?! Thanks!

RGB, I set the startup for the database to load the personal info form. Then in the form I put some code in the on_load event. This code came from various other posts I read. It seems to work fine. Any suggestions/improvements? I haven't created the switchboard form yet. Private Sub...

John, I'm not sure about creating a macro named autoexec? Maybe a module? Can you give me more info? I'm a bit confused. Thanks for your help!!!! - Wendy

I have a requirement to load a form asking the user to enter personal information before the access switchboard can become available. After the user enters personal information (held in a personinfo table. only one record in this table), the switchboard starts. Here is the logic. On loading...