Recent content by Elvaar

Perfect, thanks !

wiremonkey, That is exactly what I am looking for. I am trying to avoid using code for this one.

Not sure if this is possible to do with SQL or not...any help is appreciated! Let's say I have a table that has 5 fields. Patient_ID Patient_Name Pat_Height Pat_Weight Pat_WaistCirc A select query on this table displays results as: Patient_ID, Patient_Name, Pat_Height, Pat_Weight...

This may not be exact but....basically in the "AfterUpdate" event for each checkbox you add some code like: Me.Requery If it's access 2007, the refresh all feature is nice as well. That should at least give you some ideas on where to start looking.... Hopefully !

In may help if we knew exactly what your code was supposed to do. But I do not believe that this part of your code is correct: InStr(1 & [Product] & " mSpec") Proper syntax of InStr function is: InStr( [start], string_being_searched, string2, [compare] )

Doug is there a separate table for the Employees? If so I would suggest a form/subform structure to handle your issue. The Main form would be based on the [employee] table and the subform would be based on the [shifts] table. HTH, Bill

Honestly Doc, I don't know. I sincerely hope not. This isn't my first Access project, but this one has taken on a larger scope than I could have ever predicted. This started out as a side project that has grown into a pretty sophisticated database. Now that we are looking at having somewhere...

I have a general database design question, normally i find my answers with searching - but in this case I really wanted to lay out my specifics. I have a database that I am putting into development. It has 25 tables, a bunch of queries and a bunch of forms. It is a database that has major...

tca_vb If you are still interested in my solution let me know and i can post a copy of my database...

There are some ideas floating around these forums on "booking" databases and whatnot, but I have a bit of a different twist with what I am trying to accomplish. I am trying to develop at database that will allow users to log in and schedule their vacations. I have 2 tables at the moment...

Well it's not beautiful (yet), but I created a form / subform linked on employerID with a one to many relationship. The form is shown as a continous form with all non-relavent data hidden, so sort of a pseudo-multi select list box... Still would love to hear any other opnions on this topic...

Tools --> Startup --> Display Form/Page (Select Your Switchboard Form here) HTH Bill

Hello. First of all, I have spent about 3 hours searching the forums for the answer I am looking for, I have found many examples of different ways to do this...but I am looking for what you guys consider to be the "best" way to do this - both for the user and for databse integrity. Here's what...

I've looked at many examples of Survey databases out there, but I am still having difficulty coming up with a solution to my issue. I am writing a database for employees to take a survey on and so then i can store and analyze the data. i have 3 tables tblUser, tblQuestions, and tblAnswers...

This is basically what i have been trying, but for some reason it is limiting my records. It is only returning records that have a worker entered in the Invoices table, and records that have a worker entered in the transactions table are not returned....this is making no sense to me :( Maybe...