Search results

Well thru trial and error I this works DoCmd.CopyObject "", "Query3", acQuery, "BackupQuery3" I'm hoping it will hold up in real time. Please, let me know if this is a good way the user can reset a query in case he cannot undo his mistakes.

Well I have and it brought me to http://msdn2.microsoft.com/en-us/library/aa210012.aspx I'm having a hard time with the source object type. I don't understand what I;m reading. I did get rid of the bad path code is now DoCmd.CopyObject ("",[Query3],acQuery = "BackupQuery3" ,[BackupQuery3])

While I'm searching what is wrong this DoCmd.CopyObject "([Cardgunner2],[Query3],acQuery = acdefault,[BackupQuery3])" Maybe someone can take a look. I got a run time error 3024 Could not find C:\ my computer path\"([Cardgunner2],[Query3],acQuery = acdefault,[BackupQuery3])".mdb

I think it's right in front of me DoCmd.CopyObject?

I want to create a reset key where if the user messes up the structure of a query he can go to a form and hit a reset button. So this button when pressed would create a copy of BackupQuery1 and past it as Query1. This would then overwrite the mistakes he made and reset the query. What code I...

Also I have a db on here go to http://www.access-programmers.co.uk/forums/showthread.php?t=145843 the last thread there is cardgunner2 database In the footer of cstfrm there is a button labeled Filter by Query. See if that works for you. It does for me. If it doesn't I would say It has...

Are you doing this from your personal computer or from work? Maybe your boss set something to prevent code from running.

Access 2003 Hmmm, I know when I open my db it asks me if it is all right to open the db because it may have code to harm my computer. I used to hit open untill I adjusted the setting on my computer to stop asking me that. Does yours ask you this when you open it up or did it and what did you...

Do you have other forms bith command buttons on them? And do they work there? Have you tried to redo the form you are using? I have not heard of any form property that could get inadvertanly switched so code would not work. I'm not an expert at this so I'm just offering things i might try.

You are using this code in the onclick event of the button? Have you tried deleteing the button and create a new one? the macro that works is it the openquery macro? You set it to your query name set the view to what? Set the data mode to what? Strange. I did get me problem solved with the...

Well I gave up on being able to use the filter by form button that Microsoft provides in the toolbar if I have to filter the records of the mainform and subform. So I create a workaround. Where as a button when clicked brings up a query. The user then selects the field he wants to set criteria...

Adam, You have been a gem. Can you offer some advice for me on the original post. I have failed in my second attempt to restructure this form. I'm going to add another post to the filter by form. I was days away from done now a 2 weeks late and pay withheld. I owe you big time for all...

Adam, I due appreciate your time. It's unbelievable how persistant you have been and it's not your issue. Thank you. I actually got my solution by Me.Recordsource = "Query3" I went into the recordsource of the mainform and changed it from a select statement to Query3. So when I hit the...

That got me in trouble. Not that I needed any. What happens when you need to change it back? You would have to have another back to have it go back the orginal? But is the problem that the onclick is not opening the query? I'm not the right person to be offering advice or solutions. I have...

King, I couldn't get to the db to view. Before you zipped it did you comapct and repair it thru utilities?

Is the query not opening? I have a similar button and it works for me my line of code is DoCmd.OpenQuery "cstfrmjoinqry", acViewDesign, acEdit this opens it up so I can select the criteria . However after I save it and close the query I have to close the form and reopen in order to get the...

makes three of us. I'm using Access 2003. http://www.access-programmers.co.uk/forums/showthread.php?t=146095

new db I attached the new db. The db opens to cstfrm. if you go to filter by query in the footer of form it opens a query where you can select the field or fields you want to filter by. Lets type in the criteria of 1 in the actionid field save the query and X out. now you should be back to...

They are linked (master and child ) by the customerid. It's in the subform's data property. Getting ready for church, but will post db soon. Have you any ideas on the code or command needed that will refresh or requery or rerun the form?

If I have to tomorrow I'll strip my new db and post that as well. I didn't think this was going to be that complicated. But thank you for sticking with ime.