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?

That worked Bob. its giving me all of the records for the first two tables just like I was needing. THANKS everyone for your input!!!!

The key field is the Sales Order so that isn't going to work. There are WAY too many variables.

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

You are the bomb Bob!!!! Thanks again for your input. Seems to be working just fine.

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?

I figured it out. Looks like the Hyperlink option in the properties box will cure this problem.

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 had tried just adding the total minutes to the start time, but it only showed it broken down to hours, not minutes so the total was incorrect. 'M' = month, 'D' = Day, 'Y'=Year, 'H'=Hour and 'Q'=Quarter.

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

Now THAT makes sense!!!!:D Thanks Paul!!!!

Changed to 'Expression is' and now all rows are met by Condition 1 and should'nt be. My field values are 1,2,3,4,5,6,7,8,9,10,11,12. Condition 1 Expression Is 1 Or 4 Or 7 or 10 Condition 2 Expression Is 2 or 5 Or 8 Or 11 Condition 3 Expression Is 3 Or 6 Or 9 Or 12

I tried using the "Or" clause and it allows it but the conditions aren't met. Condition 1 Field Value Is equal to 1 Or 4 Or 7 Condition 2 Field Value Is equal to 2 Or 5 Or 8 Condition 3 Field Calue Is equal to 3 Or 6 Or 9

Only three 'conditions' are available for this formatting. No 'In' clause is available(although that would be nice).

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.

Ok....Like i said, it shows up fine in my form and the adjoining report but I was just curious why it didn't update the table. Thanks for the info.

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