Hello, still figuring out Access here. Working with AC 2003. My form is not working correctly anymore and I don't know why. I'm having serious issues this morning, a very, very bad day. I can't log in to upload it, it's too big for the site (~500kb). Ugh. Can email if desired. This is driving me batty.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Not working at all? YOu can send it to me at my home address Zack, and I can take a look tonight after work (about 4 hours from now)......if you don't get resolution before then...
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Thanks Gibbs, I appreciate it. If I don't have it resolved by then, I'll shoot it over to you.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Zack
What's the actual problem?
The form which was working now gives me an error. I have a button on the form which does a DoCmdGotoRecord , , acNewRec (or whatever it is). It errors out right there. I think it's the fields I'm using, I don't think they're working as they should.
I'm not very good at describing this; I really wish I could have uploaded it.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Can you not zip it?
What error messages are you getting, if any?
Hi Zack,
Have you got the sample files from here? I got a lot of my basic code from these.
Regards
Malcolm
http://msdn.microsoft.com/library/de...dbdownload.asp
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
If a goto record statement is erroring out, either the recordset is not identifying properly, or the RowSource query is out of whack.
Did anything change at all since it worked properly? (A new field, or deleted field or anything like that?)
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
The ControlSource changed. I thought I set it right, but guess I didn't. It was screwing up and giving me a #Name! error, so I tried to reset it .. to no avail.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Zack, few things after seeing it.
Make sure the combo box Control Source properties are set to the appropriate column names for what feild will recieve the data on an update record (the row source statements you have are fine, but can be trimmed to exlude the ID column if you want)
Also, be sure that your Form data source is the TABLE Soil Samples and not the query Last Soil Data. When I made those 3 changes (simple changes), the form worked fine.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Perfecto!!!
Thanks to all of you! Gibbs found the solution perfectly!
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Posting Permissions
Reply With Quote
