Recent content by jransom1974

Access 2010

Thanks for the quick reply. I have uploaded my database, what I have been working on. I dont think I have used the Dlookup()... any adviced? Also, if you look at the db I posted, I know there is a "lookup"field on the details page. It was there when I downloaded the db and havent changed it...

Hello.............. I am needing to perform a simple search by phone numbers on my form, however, I need to populate sertain fields when the correct number is selected. Any pointers? Also,.... I would like to post my database in my thread to allow others to download.... how do I do this...

Thats sounds great! :D Any way I could see a working example of your work? I would also like to post my databse and see if your code would work for an application like what I am working on.... Hope to hear back from ya! Very cool!:cool:

I am one table by which I am getting this info for my combobox Private Sub cboNames_AfterUpdate() If Len(Me![cboNames].Column(1)) > 0 Then Me.txtPhone = Me![cboNames].Column(1) Else Me.txtPhone = " " If Len(Me![cboNames].Column(3)) > 0 Then Me.txtFirstName = Me![cboNames].Column(3) Else...

Gina- I am not sure I quite understand what you mean. The only table I have shows the ID as the PK.

I am using the ID as the primary key for this table, I need more than one table? I am kinda new to this aspect of Access.

I have created a combobox on my form with the following code; Private Sub cboNames_AfterUpdate() If Len(Me![cboNames].Column(1)) > 0 Then Me.txtPhone = Me![cboNames].Column(1) Else Me.txtPhone = " " If Len(Me![cboNames].Column(3)) > 0 Then Me.txtFirstName = Me![cboNames].Column(3) Else...

I think I am getting comfused, and making this harder than what it actually is. Here is what I am actually trying to do........ I have a database that I collect name number company info and automotive information from customers. What I need to do is... as the customers call back, I want to be...

Will do... thanks!

This may be a dumb question :rolleyes:... but when you create a new thread and that thread has been answered or complete, how do i "close" the thread or mark it "complete" thanks!:)

I figured out what the issue was. For some reason i was getting an error from a macro that was running and looking for a callout for the First Name. I changed it to txtFirstName, and fixed it all..... Now we know.... ahhh.. ya gotta love databases!

Thanks Bilkl... I will give it a few more tries. Yes, I have my database slipt. I appreciate all your help. Thanks ! See ya in the forum world....

see my main problem here Bill is that I am still kinda new to access 2010. and I have not had to use the append query feature.

I have created a PDF with screenshot of the database. Could I email it to you?