Search results

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...

GREAT! I don't have Windows 10 yet but what you told me worked! Thank you.

Uncle Gizmo, would you be kind enough to download that zip file again if you still have it. I think will solve the problem I have but when tried to download it, it only came over as a (.php) file rather than the zip file for some reason. Thank you.....Mark

I think I will just go with creating fakes numbers as you suggested. Thank you very much for your help

Fair enough. In an attempt to “clarify” what I wanted, I obviously confused things. 1. I am a manufacturer’s representative. Our business is to send a price to a distributor for a product of mine that will be used on a new building being built, for example a University. My goal is to...

I have a distributor table within an existing database that I use to keep track of quotations to each distributor for each project our distributors bid. It was simple to design 5 years ago when we only had to quote one mfg to each distributor. However, I now have to quote distributors multiple...