That field names doesn't exist in your form's record source. Thanks Boblarson, Got it--works great!! No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers As you didn't have this in the version I downloaded and subsequently uploaded, I'm not sure how you have the code and stuff set up. weblink
Sponsored Links: Read full post... I'll look closely now at your suggestions there as well, since I already noticed a goof on my part.. kjv1611 (IS/IT - Management) (OP) 27 Aug 04 15:12 I don't know, but could it have something to do with using the .* since using a variable?It worked fine when I Join our community for more solutions or to ask questions. http://stackoverflow.com/questions/19778583/vba-with-access-runtime-error-3070
Explain your approach. Explain your approach. Have a look at FAQ219-2884 or FAQ222-2244 RE: Run-time error '3070': Does not recognize... Suggested Solutions Title # Comments Views Activity Access Database To Track Coworker Daily Fitness Accomplishments 32 37 19d How have report show detail if a form checkbox is true 9 14
etc. My guess from the last few posts is that Catwebwork2f (or some other open form) may have mutiple very similar subforms - with nearly identical recordset queries, and that you are Share bypass capacitors with ICs or not? Me![MyFieldName] or Forms!MyForm!MySubForm.form![MyFieldName]?
I double checked. That field names doesn't exist in your form's record source. Connect with top rated Experts 16 Experts available now in Live! Why does typography ruin the user experience?
NOTE: The sample code in this article uses Microsoft Data Access Objects. https://www.experts-exchange.com/questions/27738960/Access-recordset-findfirst-error-3070.html M! 0 Question by:flfmmqp Facebook Twitter LinkedIn Google LVL 5 Best Solution byNetminder Per recommendation, points refunded and question closed by Netminder CS Moderator Go to Solution 7 Comments LVL Here it is clearly always a sting Phil Date Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... The time now is 07:57 PM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored
Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. http://prcflow.com/visual-basic/visual-basic-6-runtime-error-70.html If your code is in the main form, and you are searching the subform's recordset, you should use the following definition (or something like this): Set rs = Me.MySubformControlName.Form.Recordsetclone Select all Run-time error '3070': Does not recognize... 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
SUMMARY When you concatenate variables or controls in a function or OpenRecordset method, you may receive one of the following error messages. PCMag Digital Group AdChoices unused tutcity Search all Topics Search Up Down Home » Microsoft Access Error 3070 Views: 48 An error was encountered Description: The Microsoft Office Access database engine Select a name from the list 3. check over here more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed
as valid field name or... Please write below. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature.
I have attached the database. This causes your .FindFirst to fail. Attached Files CoName_revBL.mdb (332.0 KB, 125 views) __________________ Free tools, code and samples here: To view links or images in signatures your post count must be 10 or greater. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i… MS Access Advertise Here 767 members asked
thanks very much again Top This thread has been closed due to inactivity. Want to upload a latest copy? By joining you are opting in to receive e-mail. this content kjv1611 (IS/IT - Management) (OP) 27 Aug 04 12:51 I am getting this error:Run-time error '3070':The Microsoft Jet database engine does not recognize 'tblAgencypmts1.*' as a valid field name or expression.At
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 PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER ! Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily. MORE INFORMATION These error messages can occur if one of the following is true: You incorrectly declare the data type of the argument being passed to the function.