Search results

Thanks for the response...now it gives me this error. Run-time error '3075': Syntax error (missing operator) in query expression 'ID=Joe Customer'. Private Sub CustomerID_NotInList(NewData As String, Response As Integer) DoCmd.OpenForm "entercustomer", , , , , acDialog, NewData...

btw...here's what my RowSource Property is for the combo box. SELECT tblCustomers.ID, [FirstName] & " " & [LastName] AS Name FROM tblCustomers ORDER BY [FirstName] & " " & [LastName]; Could that be the problem with the error I keep getting in this line of code shown below? CustomerID =...

1) Your new formula that you had ( + 1) works great...every time the pop-up form pops up, it prefills the ID field with the next number in sequence. THANK YOU! 2) When I type the name, "Stu Black" into my combo box and press enter or tab, the 'not in list' event runs and pops up the newly...

I'll post my database here in the future just for clarification. Thanks...I'll double check my work.

Ok...so here's what I put into the Default Value property for the control (ID) on my popup form. Instead of giving me the next one in order, which would be 55, it gave me 100. DMax("ID","tblCustomers") I just closed everything out and opened my pop-up form all by itself. It prefilled the...

Ok I will give that a try...thanks. What about this though?

Correct...as well display the customer in my table customers, which it should do.

That would be my customers table...tblCustomers

I know I know...and I'm sorry upfront for my lack of basic knowledge. I think it is bound from what I said in my earlier post so the answer to your question is yes...as far as I know. Now, where do we go from here?

I'm sorry...I don't know whether I am or not. How would I know? I think it is just because when I created my pop-up form, I used the 'add existing fields' button and added all of the fields from my customer table. Would that make it bound?

http://www.access-programmers.co.uk/forums/showthread.php?p=1105779#post1105779 Here's the new thread that details a lil more what I want it to do...thank you!

If I have a field that is just set up as a number field, is there specific code that will generate the next number in sequence? Each of my customers in my customers have an ID. This field is a number field. On one of my forms, I have all my customers listed in a combo box for entering a...

Ok...when I type a customer's name in a combo box that doesn't match one of the existing customers, I've created an 'event procedure' in the 'not in list' property to pop up a new modal dialog form I created for entering information about a new customer. First field I have for my customers is...

Here is some more code that I've been working on. I've posted my code (in the 1st box) and the sample code (in the 2nd box) to show what I'm trying to do. I can't get mine to autofill a new number in my ID field as well as transferring the new name into the field. Private Sub...

Thanks...I could use your assistance again if you don't mind. Why isn't my code (the 1st one) not working and the second code for the sample database is working. Do you see where my problem would lie? Private Sub CustomerID_NotInList(NewData As String, Response As Integer)...

Ok... thank you sir!

Hi guys, I'm working on the Boutique Fudge database from the Missing Manual: Access 2007 book. In chapter 17, they are teaching me how to have code in the 'on not in list' event to have another form popup that allows me to enter info in it. I understand the code that gets me to open the other...

When trying to read code, I notice the different colors of the text. I've been told that green text are comments, but I'm not sure what blue text is? Could someone please simply clue me in? Thanks!

Dude...that was an awesome explanation. Thank you!

Why would it negate the purpose? Wouldn't it just speed up searching in all fields?? What would be the downfall to it? thanks