I would like to have the users be able to type a list of work order numbers and have a query return the status, (open or closed), for each work order. How...
I would use the Windows Task Scheduler to schedule the process and use a startup command in the Startup form to determine if access was opened through the task...
One way would be to use a small local temp table and use an "IN" clause in the query. Give them a continuous form to enter the numbers, with a command button...
Tim- Use the SQL IN clause: WHERE WorkOrderID IN (5, 125, 79, 33) .. but you can't substitute the list as a parameter. That is, you cannot use: WHERE...
Yes, they need those rights. Access creates a locking file (.ldb) when a user opens a database whether it is directly opened or opened via linked tables....
Hai All, I am a beginner in MS Access. I am preparing all the concepts to pragram and develop an efficient application using VBA. But as i dont hav any real...
Greetings All, I completed my report design and it is looking good with one exception. I finally got the syntax correct for adding conditional formatting to ...
For all that might be interested, I worked around the conditional formatting problem by adding a Select Case block in the group footer print event. The block...
Darrell- If you're setting the text box value in code, Conditional Formatting might not work because it might run before you set the value. A timing problem. ...
John please explain a little more. I am fairly new to Access some terms are still unfamiliar to me. The database is always available for you to look at. And...
thanks Bill. Alternatively, I created the subform based on the junction table and added a combo for the Div name based on Div table and defined its Control...
Here is my problem: Say I have a products table: PRODUCT ======== Prod_id Prod_name Dept Type ... It is now possible that some of the products can also be a...
John, It would seem that it would be all or nothing in that case. I had instances where a part number summary would be highlighted but the catalog and PMT...
Thanks ! I'll try your/Bill's solutions today. I already use Task Scheduler to compress/repair my Access db's nightly (via batch file), so this would work out...
George We have a MDE deployment/update batch file in our group files. I use a modified version for all my MDEs. Bill ... and ... was ... process ... ...
Carlos- What is the current Row Source of the list box? What are the names of the two text boxes that contain dates? What are the names of the date fields ...
Hi everyone! I need some help with this code. I'm trying to get the results of a subform to be based on a popup dropdown list. Everyting works accept it...
I guess I'llhave to look into how to set security. When I looked into it a few years ago, it didn't make sense, but back then Access didn't make sense either,...
If you add the Division table to the Record Source of the subform, there will be no need for the DLookup. You can include the Div_Name in the query, and...
Yes, that's the correct design. Define a form to edit products. Add a subform to edit Product_ProductGroup. ONLY when the binary field is true, display the...
Dear mithomas48: When you make an assignment like Me.Absence = rs("Absence"), you're assigning the value to whatever is the current row in the form where this ...
Jim There is a link in our links group for Access Security FAQs. While the article can be daunting first read-thru, once you get through it you will be on your...
I tried to point out the most efficient way to accomplish what you want. The point is that you are making it more resource-expensive by using a DLookup. My...
Wow that is quite a read. Maybe I should just set up a something that just backs up the database daily into a folder that the other group has access to? But...
JHundley, My sample db named ScheduleTracker might be of interest to you. It is available at Rogers Access Library (other developers library). Link -...
Hello all, Is there a way to find out which user has a current record locked? Can I pull their user into a text box on a form so if someone opens that record...
Jim One way would be to use replication. Another way would be to create a utility database with a startup form that runs a function to copy the database and...
Greetings All, Does any one have an example of a user form that utilizes two list boxes for the user to select report/query criteria? If so, would you mind ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
