Search results

I've got this table with two particular fields in there (Year) and (Manufacturer). I've just been having these two fields use a value list to select from for entering the correct value for (Year) and (Manufacturer). However, I would like to set two new tables up for these two fields that way...

Here's another funny thing. This new Transaction ID (105) has now already been created. If I exit out of all these forms and go look at my Transactions table, there is a row (or record) that has Transaction ID (105) and all the other details I entered in for this particular transaction. So...

I have three main tables. 1) tblInventory 2) tblTransactions 3) tblTransactionID From my (ID) field in tblTransactionID to my (ID) field in tblTransactions it shows a many-to-one relationship. This popup form is based off a query. In the query, it has a field (which is causing me the...

Bump......

Ok, but why would it work for the 1st new record I enter on the pop-up form but not on the second one? I can see the problem as you described, but it doesn't make sense to me that it wouldn't cause any problems on the 1st record, but when I go to add another record it gives me issues...

So...I looked up some info on this, but I can't seem to figure out why it's happening to my form. So, on my [Transactions] form I am entering a new transaction number. Let's call it (105) So, now I click one of my command buttons which will pop up a new form allowing me to enter new...

So...I looked up some info on this, but I can't seem to figure out why it's happening to my form. So, on my [Transactions] form I am entering a new transaction number. Let's call it (105) So, now I click one of my command buttons which will pop up a new form allowing me to enter new...

ok...let me give that a try. Easy to see now...thanks for correcting my mistake!

Well...originally I had designed a form where this question popped up. However, the more I look at it and after seeing your response, the form could have been designed better where I don't have to worry about this. Thanks for your help.

SCF ID that's exactly how it is

bump..........

bump bump bump

Yes I am, and is there any way to combine the tabs from the different sections?

This is exactly what they are trying to do on this sample form, which I have now incorporated into my database. In reference to your question PBaldy, I did have my form originally set up as a data entry form. This worked fine for entering a new order because it wouldn't bring in the previous...

When you open a macro, on the bottom of the page there are six different action arguments that I see. The one I have a question about is the 'Where Condition' In the Northwind 2007 sample database, it reads 1=0 Does this simply mean that since 1 will never equal 0, it will not match any...

Is there a way to save the lines and colors I've added to a form header and apply that to every other form header in my database? Or be able to choose other forms that I would like this combination of colors and lines in my form header to be used in other form's form headers? Btw...How does...

help needed? Why are tabs in the form header not able to be referenced with the tabs in the detail section?

Thank you...just what I wanted!

Hey guys, I'm using the DLookup function to pull in values from another table into a form. Here's the formula. =DLookUp("[State]","tblCustomers","[ID] =" & [Forms]![EnterNewTransaction]![ID]) =DLookUp("[SCF_ID]","tblCustomers","[ID] =" & [Forms]![EnterNewTransaction]![ID]) The problem is...

Hey guys, I just want to add something to my home form that I can use to remind me of projects I need to get done. Whether this is a simple text box with a checkbox next to it, that I can mark it when I get or done or what I'm not sure. I'm wondering if anybody has any examples or ideas that...