Search results

You're right and I do lookup info on other sites (the one you've mentioned I frequent a lot actually) before just coming and asking a question. This isn't exactly easy stuff to learn though so that's why ask you guys (the experts) questions to help me understand more. I don't just try to...

I did and now have these textboxes' control source lookup the value in another table. It now no longer effects my record navigation

See my edit to my previous post...is what I entered in as my control source for that text box the same thing as what you're referring me to do?

Ok...so how do I get these text boxes to update to the correct ID?? It keeps showing the same info on each record. UPDATE: Did some researching and it looks like I got it working although I don't think I understand it all. LOL =DLookUp("[Address]","tblCustomers","[ID] =" &...

Got it!! Thanks dude!

You are correct...now I need to figure out how to correctly type in that DLookup() function. Here goes nothing LOL

I have a textbox that I would like to show data from its table. So, I go into properties for that textbox and go to 'control source.' I click the three lil dots and bring up the expression builder. From there, I go into the folders and select the correct table from which I will select the...

Well...I'm seeing what the problem is but still not sure how to fix it. On a tab within my main form, I added fields per the 'Add Existing Fields' Icon. In the middle section where it says "Fields available in related tables," I took those fields and dragged them onto my tab within my main...

Is there a way that I can make the main form's record source unique again without removing anything?

Thank you to all who have responded...I will go ahead and take a look with these tips and let you know how I come out. This subform is on a tab within the main form. It's just to show my customer's information. vbaInet) Remember the other thread that you were helping me with?? It's that...

If you get a minute, I'd like to see what I had wrong with my original code so I can know for the future. Thanks again, Brady

Hi all, I have a form for entering transactions for my business. On it, there is a field for selecting the customer. On the very bottom of the screen where you can move to the 1st record, next record, last record, etc., I've noticed an issue. By clicking next record, it doesn't take me...

1) Right, but I was hoping to find out what exactly was wrong with my code and where the error was coming in. Just simply trying to learn as much as I can when you take YOUR time to help me, which I really appreciate. That's funny you mention about Access 2007 and the need not to use the...

Btw...when I look at my code compared to the code you used in the event procedure for 'not in list,' the only difference I see is that you put an apostrophe in front of each line of code including the line in between the lines of code. It made the text green, which means it's a comment. So...

Bob... YOU ARE THE MAN! LOL thanks for your help...just like that it's fixed. Just awesome... 1) Why was I getting an error code in the 1st place? 2) What code did you change? Where was I going wrong? 3) Very cool on getting the 1st name to prefill in to the 1st name field and the last...

Perfect...thank you so much!

Here's my formula. =[Price]+[Shipping]-[Fees]-[Shipping Costs] Why isn't it calculating when one of the fields is left blank? Thank you in advance!

Thanks everyone for all your help so far. I've posted my database so you guys can better see what I'm missing. The form name is 'copytest' Please take a look to see if you can help me find where I went wrong. Here's the steps... 1) Open form (copytest) 2) In the top right corner, type...

Well, I had this figured out at one time, but now I'm confused again. I have an attachment field that I'm trying to erase all attachments. So, I do as you instructed, but I keep getting this error. An UPDATE or DELETE query cannot contain a multi-valued field. Please help. Thanks, Brady

So back to post #10... I have no idea how to make this happen. Again, here's my code. Private Sub CustomerID_NotInList(NewData As String, Response As Integer) DoCmd.OpenForm "entercustomer", , , , , acDialog, NewData CustomerID.Undo CustomerID.Requery CustomerID = DLookup("ID"...