Search results

Just so I'm not confused, this is needed not only for the Record Source of the form, but for every Row Source of each field. Thanks for the help! This has been driving me crazy.

I created a relationship in the form after checking, but I need this for all Row Sources as well?

I added tables that would relate the tables for the form. I even went ahead and took out what I had in my row source for my drop-down box (although it seemed right). And in either case I still get the error and the form still displays as blank. Do I need a relationship between the two tables...

I have uploaded a lessened version of the database with the problem in question. Open the frmUserID and input 0004, it will open the form and bring up the error. If you End the debugger, you'll see the blank form.

I don't have any subforms. I will try to upload a version of my DB in a few. Thanks for the quick response.

I have a database where I have several input forms. There are certain fields which each have, and other specific to only a few. I just went through the process of normalizing my database, then reconnecting all the fields as needed. My first form works flawlessly. However, when I open any of...

Again, thank you to everyone here for the help. I definitely needed this and appreciate all the replies.

I think the other posters were explaining that I should place all the Shale Shakers, or other pieces of equipment into one table, this I do understand and am quite glad to hear. :) The SolidsControlSum table was created to link to all of the necessary tables for a solids control summary. There...

The reason I have multiples is that there are that many Shale Shakers possible, and each one can output different values under the same field name. I'm not sure if I'm explaining that right, but please tell me if not and I'll try to reword it. The reason the tables didn't have more fields could...

@plog - I did feel at times I was going overboard with the normalization, but I was more afraid of going under-board! So I should combine all the tables that have numbers appended? I assume I would then just have the appended numbers within the table for individualizing? I initially had UserID...

Thanks for the fast replies. @Sketchin - So I should put (for example) all the Shale Shakers in one table and have a number attached to each of their components to individualize them? Or should I have all the equipment like (for example) all the Shale Shakers and Centrifuges together in one...

Thanks for the response. What's funny is that this is a problem because of normalization (at least as I've done it). I did this backwards for reasons, but I originally had one large table and began work that way. I then began normalization and came out to about 40+ tables as there is a lot of...

I have at least one form and one report that require more than the 32 table limit for a query. I'm thinking that I can create two queries and somehow combine them... Can I do this with SQL? Is there a better way?

Thank you so much for the help and insight! I will try this as soon as I get home! Thanks again.

I have two tables, table A has the Days (date) field as a primary key, and table B has the userNum field as a primary key. They have a relationship through the userID field on Table A. I have a form that has the user fill out Days and userID from Table A. I would like to create a DLookup...

Ended up using cmdOldValues.Enabled = True and this worked in place of _Click = True

I tried: If cmdOldValues_Click = True Then Exit Sub End If But I continue to get the error: Expected Variable of Function

Not sure why it didn't dawn on me earlier, but all I should need to do is place the Exit Sub in the code for the check on the date and user ID, state that if the button is clicked then exit the code for the check. I'll reply once I try it.

I thought your suggestion would work, but no matter how I try it, it still hangs on my database due to the check date and user ID code... Here is what I have: Private Sub cmdOldValues_Click() On Error GoTo Err_cmdOldValues_Click DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy...

I have some code that checks the date AND user ID to ensure that there has not been a record for that date and user ID on Form B. This works without issue. On the same form I have a text box to input a new date with a command button that then copies over all the records information and then...