Search results

Sorry about the attachment. I attached another screen shot. Hopefully this one is easier to see. Here is how the process will go: Before the start of the shift, a supervisor will place a check next to every associate that will be working as an order selector for that day. This list of...

Hi David - The project is still in the very early stages so I only have one screen shot to help illustrate what I have envisioned in my mind. I have created a menu with two subforms. On the first subform, the supervisor will check the names of the associates available for selection on that...

Thank you for the response spikepl. The output would be used to assign associates to a work area. The project is to create a tool that will randomly assign associates to eleven different work areas each day. The number of associates per work area will change every day depending on the work...

Does anyone know if it's possible to have the user enter the number of top records to choose in a query? I know that you can enter a number or percentage in the Top Values property of the query but I would like the user to be able to enter this number each time they run the query since it may...

Hello Everyone! I have seen many posts regarding how to turn on double-sided printing through code but I actually have the opposite problem and I can't find any solutions that have worked. In order to be as green as possible, our printers are set up for duplex printing. I have an Access...

Thank you for the reply, Linq! I will try your suggestion of using a numeric value for the "all" selection and will just add a text box with a note on which to choose for "all" for the users.

Hi everyone - I have the following in the RowSource of a list box: SELECT Period FROM qryFiscalPds UNION SELECT "*" FROM qryFiscalPds Period is a numeric field and sorts perfect in qryFiscalPds but when I use the line above in the list box it sorts like this: * 1 10 11 12 13 2 3 I...

Hi Everyone - I have a form (frmAuditEntry) that includes a subform (sfrmAuditDetail). The user will enter audit information on the subform. There is a check box on the subform to identify containers that had errors in selection. When the box is check by the user, a pop up form opens where...

Hi Linq - The checkbox is on each record of the subform.

Hello everyone - I have a form which contains a subform. On this subform, the user will enter several lines of container ID numbers. If one of these containers has errors, they check a yes/no box and a pop up form opens for them to enter the details of the errors. I want two fields that...

Hi everyone - I have a .mdb database that is suddenly having issues running macros. Users of this database are on two different versions of Access (2007 and 2010). Everything was running fine for users in both versions until a couple days ago. Now, users with 2007 cannot run the macro and...

Thank you for all the work. This definitely sends me in the right direction. I understand what you did with the tables and the append query and when I rate each activity it does transfer over. The only problem I saw is that the ObservationNumber and the ObservationType fields change to...

Thank you so much for offering to look at this. The database is just in the beginning stages so there really wasn't much to clear out or make up and there aren't too many objects at all yet. The form is frmObservation and the query is qryPerformanceActivitiesRating. The plan is to have the...

I tried your suggestion but there was no change. Even if I create a new observation, close the form and then go back in, it still doesn't work. The observation numbers (records) all exist in the table but it still won't recognize the observation number on the form in the query. :confused:

Hello everyone! I have the following query: SELECT [forms]![frmObservation]![ObservationNumber] AS ObservationNumber, tblPerformanceActivities.ObservationType, tblPerformanceActivities.PerformanceActivityNumber, tblPerformanceActivities.PerformanceActivityDescription...

Thank you for responding so quickly. I thought the answer was no but wanted to check with the experts first. ;) I will try to do some reformatting of the report and see if that will work for them. Thanks again!

Hi everyone - I have a query that users export to Excel to be emailed. The query SQL is below: SELECT tblItems.Customer, tblCustomers.CustomerName, qryAvailableContainers.ReceiptDate, qryAvailableContainers.ReceiptNumber, qryAvailableContainers.ItemCode, tblItems.Description...

Oh no! I was afraid it was going to be that easy! I really should have caught that. :o Guess it's turning into one of those days. Thank you so much for your replies.

Hello - I have an option group called ReportType set up on a form with two options that will determine the date range selected for a report. In the OnClick event of the button to open the report I have the following: If Me.ReportType.Value = 1 Then DoCmd.OpenReport "rptCorrectiveAction"...

qryIncidentDropOffDates is the name of the query that has the original "Sequence" field and qryReasonForDiscipline2 is the query that I created based on qryIncidentDropOffDates but the "Sequence" field does not show the right number.