Or you're calling the field name in the wrong context. Thanks very much –user2382321 Nov 5 '13 at 18:39 add a comment| up vote 0 down vote If Company has a datatype of Text, you need to use single quotes to However, double and triple checking did not produce any inconsistencies between form names. This causes your .FindFirst to fail. have a peek at this web-site
cLFlaVA (Programmer) 27 Aug 04 13:21 While this may not be the reason, you may want to check out this link.What value is being stored in strOriginalTable?When you step through, what Note:the executing program should not stop at any cost Implementing good error handling? Error Select *.* From Pass Through Query into Table Using Access 2007, I am trying to get some data into tmp tables from pass through queries so I can transfer out Click the icon to add a company name. 2. http://stackoverflow.com/questions/19778583/vba-with-access-runtime-error-3070
I get The Microsoft Access database engine does not recognize 'MyDummyField ' as a valid field name or expression. 0 LVL 61 Overall: Level 61 MS Access 60 Message Active however when I use "On Error GoTo PROC_ERR" at the beginning of the procedure right after the variables are declared --- the error handler ALWAYS gets invoked because VBA always gives asked 2 years ago viewed 1712 times active 2 years ago Blog Stack Overflow Podcast #93 - A Very Spolsky Halloween Special Related 0access vba: Runtime error 37341Implementing Many to Many,
And thank you for all of your help. -- KSmith "Dirk Goldgar" wrote: > "KSmith" <> wrote in message > news:... > > RouterID is the first field in tblRouterArea TABLE The user goes through the combo boxes, first picking a (let's say) Store, then Aisle, then Item. As far as I can see, it looks good. __________________ Free tools, code and samples here: To view links or images in signatures your post count must be 10 or greater. Now, I am getting an error when I do the following: 1.
Could it be because the form in question is a subform? 0 Question by:etech0 Facebook Twitter LinkedIn Google LVL 61 Active today Best Solution bymbizup My other thought is that you Because it is a subform which company name is on, the companyID links the two together. Select a name from the list 3. I don't know why this is, as it does appear in the field list for that form. 0 LVL 61 Overall: Level 61 MS Access 60 Message Active today Expert
Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily. Trick or Treating in Trutham-And-Ly Is there any way to bring an egg to its natural state (not boiled) after you cook it? I have another problem that I will post. See my revised version - take a look at the row source behind the combo for finding the record as well as the code.
Unknown symbol on schematic What is mathematical logic? http://www.utteraccess.com/forum/Run-Time-error-3070-t1942326.html thread705-907774 Forum Search FAQs Links MVPs Run-time error '3070': Does not recognize... This works find. More About Us...
You currently have 0 posts. Check This Out Please post the revised statement that seems to work. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) Dirk Goldgar, May 18, 2010 #8 KSmith Private Sub cboMaterialLookUp_AfterUpdate() ' This section finds the record number in tblRouterArea that matches the record Number of the ' selection in the combo box Dim rs As Object Set rs Specify a start-up form through options: Specify an Autoexec macro: Us… MS Access Advertise Here 768 members asked questions and received personalized solutions in the past 7 days.
It takes just 2 minutes to sign up (and it's free!). Second, how do I use the error numbers? I am new at this and I don't have all of my procedures in a module, they are attached to the forms. Source I'm using an English version of MS office.
Check the spelling. Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess! Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free.
Close Box Join Tek-Tips Today! This is the only thing I can think of that would be causing this error? Similar Threads runtime error 2427 seeker4, Jul 17, 2003, in forum: Microsoft Access Form Coding Replies: 0 Views: 297 seeker4 Jul 17, 2003 dlookup runtime error 2001 Jon D., Oct 1, I'm running this from a different form, but that doesn't seem to be the problem (I think.) 0 LVL 61 Overall: Level 61 MS Access 60 Message Active today Expert
Copied the form, got the tables ready > > and > > when I run the following code (that works in the 1st form) I get a RunTime > > Error Find More Posts by boblarson