Search results

It worked! Thank you very much for your all your help and your patience! :)

Please excuse my ignorance as I am learning as I go along..... Here is the code I put in the Event Tab/On Load Job Quote Form10-2005-MKD.OrderBy=[specjobs].[Rev_Rept_Date] DESC I have attached the error code I am getting.....I guess I don't understand what "Me.Orderby" represents...

Same thing I describe above....it reopens using the last Sort I performed on the form............

Sorry, I didn't understand your first question....here is the code used to close the form: Private Sub CloseJobs_Click() On Error GoTo Err_CloseJobs_Click DoCmd.Close Exit_CloseJobs_Click: Exit Sub Err_CloseJobs_Click: MsgBox Err.Description Resume Exit_CloseJobs_Click...

Please open the (sortOrder1.jpg) I attached and that will show you the "Order By" code I put in the "Order by" field of this forms Property Box....

I have created a form (see attached form.jpg) that is opened by a macro. I have set the "Order by" criteria to be: "[specjobs].[Rev_Rept_Date] DESC" (as shown in SortOrder1.jpg) This criteria opens to form correctly time and time again UNTIL I have sorted the form, when it already open, by a...

thank you very much! :)

I have attached a Msg Box that pops up the way I want it to in my program, with one exception. Is there anyway to have "Do you want to continue?" be shown on a third line? Here is the code line that handles the actual Message: Msg = ("ATTENTION: The Next Form Which Opens Allows Editing of...

lol I guess we have a communication barrier. Once the user enters Qty and Prod#, a query runs to show the information associated with the product. I will try your suggestion about checking the 2 fields in the after update event....thank you. Mark

Thank you for your reply, Paul. Respectfully, I don't think I need a code to where "everything to the right is pulled up automatically. Perhaps I should have been more clear...once the Qty and Prod# number are entered by user, all other information is automatically "filled" into the fields to...

I have a subform that pulls information on an item up after the item number is entered. If you follow the (.jpg) I have attached: 1=Enter Qty of Product 2=Enter Product # Once those two steps are completed, everything to the "right" is pulled up automatically. Step 3 allows the user to pull up...

Thank you for that suggestion. Unfortunately, I tried it and couldn't find the "rogue" query....

Thanks for the suggestion but I have compacted/repaired the database many times and it still shows up. Just to make sure, I did compacted/repaired again and the "strange" query still shows up....:banghead:

Just recently I have started to see a strange query pop up when I want to create a new query. Please see attached (.jpg) It has a number of "~" signs in it....nothing that I have created. I went into the underlying Visual Basic Code for my program and can't find this query to see if I can...

I don't think so, but how would I go about checking to see if one is or not? thanks

I have a number of existing macro's that I can not create. Also, I can not create any new macro's either. I have attached a (.jpg) of an existing macro which I can not edit. I can get into design mode, but the info under "Arguments" column can not be edited. If I try to edit and/or anything in...

No I have not had the time to do that, but I will ASAP. Thank you!:)

Yes, my issue is: I am looking for something similar.... I have 3 checkboxes and only 1 of them should be checked. I have the checkboxes labeled "Open" , "Won" or "Lost". The default is to have the "Open" box checked when the record is created. If the user checks "won", the "Open" box check...

I am looking for something similar.... However, I have 3 checkboxes and only 1 of them should be checked. I have the checkboxes labeled "Open" , "Won" or "Lost". The default is to have the "Open" box checked when the record is created. If the user checks "won", the "Open" box check is removed...

I am looking for something similar.... However, I have 3 checkboxes and only 1 of them should be checked. I have the checkboxes labeled "Open" , "Won" or "Lost". The default is to have the "Open" box checked when the record is created. If the user checks "won", the "Open" box check is removed...