Search results

Is there a way to kick all users out of the database so updates can be made? I have an Access database that is used by several different machines. I need to make my updates around 4pm each day but sometimes the operators forget to log off. I need to be able to kick everyone out so that I can get...

How do I get my query to only pull out the records that have low values(*LV)/no value in a field?

I have a query that includes 4 different tables. It only shows info for the Sales Orders that have information in all four tables. Is there a way to get it to show any information available? For instance, if it only has info in two of those tables, it would show that info and the fields for the...

I am creating a form for a machine operator that with update the number of cycles the machine has to do as they are completed. I have created a command button to subtract 1 from the cycle field amount if the button is clicked but nothing is happening. I even tried creating a macro that executes...

I need to put a check box next to the lines on a report for each of our job presses. The problem is that there can be more than one job per press and I only want the box on the first occurrence. Any ideas on how I should/could go about this?

Is there anyway to create a button on a form that would open Microsoft Notebook??? I have a client who wants to keep 'notes' as he is updating his database.

I'm trying to add a couple of fields to my database that will keep track of what time production jobs should complete for a specific machine. I have fields for cycles, minutes per cycle and what time the machine starts. I want to take the total of cycles*minutes and add this time to the start...

I am needing to set the conditional formatting on a report dependant on values being 1,4,7,10 or 2,5,8,11 or 3,6,9,12. Is there any way I can do this inside the formatting tool? If i put commas between the numbers it tells me it is invalid.

i'm new to Access and am streamlining some old logic for my comany that used to be done entirely in Excel spreadsheets. I have added a calculation to my form and it shows up fine there. However, the total value is not passed to the table. Why is this? Do I need to create a special query in...