Search results

I have a subform that I use for orders to my storerooms. I have to keep the date for each order id on that delivery form. There a multiple storerooms per delivery form. The problem that I am having is that I need to enter a date on this subform and this date must appear alongside every...

I have an order form that requires me to change the current promotion we're running continually. I need to populate all rows based on the update changes of one textbox. Is this possible? Right now when I update the promotion text box, it only updates the text for row one.

I have a textbox that is set equal to countitem field of a query. The query is based on a subform that exists on the same form. I am trying to update the textbox every time the number goes up or down on the query. Whenever I open my form the number for this textbox is updated. Can I update...

No. Is there anyway to change the label(s) values on the 1st form and when I open the 2nd form the changes are updated based upon those values. I am trying to make the changes universal. I don't want the users of the 2nd form to update anything except for their order quantities. Is there...

I am using the following code in the open event to set the gloves label on my form frm_Delivery_2 equal to the gloves label on form frm_delivery_1. I receive the error that the form frm_delivery_1 cannot be found. When I set the gloves label equal to another label or frm_delivery_2 using the...

I have form that is duplicated so that two different user groups see the same form but use the forms for two different functions; one for ordering and one for scheduling deliveries. The ordering group determines the headings for the items its ordering and the quantities. Is there anyway that...

I have a travel time database that should tally the number of minutes traveled and convert them into a time (hours and minutes). I, however, am having difficulty converting the numeric values cleanly. Is there anyway to convert 102 minutes + 100 minutes + 110 minutes = 312 minutes to 5 hours...

I am trying update all the records. I am trying to update a yes/no field based on null values in my other text fields. If field A, field B, and field C are null for all records, I would like the accompanying yes/no box to be checked yes for signifying their null values.

I have a subform on my main order form. I would like to click a button on my main order form and have it change a control on the subform. For instance, I have 2 controls on my subform, control 1 is a text field, and control 2 is a yes/no box. When i click the button on my main for order form...

That's a great Idea. I will adjust the combo box now.:D

The before update event The intgunnumber field is based on a gun information table so that the gun and it's information is selected from the combo box on the frmEmployees form The employee table has the intgunnumber field and the frmEmployees is based on this employee table. I built the...

:eek: I know that I am doing something wrong because even when I use this code the event is triggered as though every gun i choose is already assigned. That isnt the case.

I am using a combo box to assign gun numbers on an employee form (frmemployees). I also have a query listing only the gun numbers that have been assigned. When I select a gun from my combo box, I what to evaluate if it is already on the gun assignment query. That way I cannot assign the same...

Is there any way to lookup items using DLookup or other functions that will return an array of values not just the first value found. Example: I have three employees in a complaint query. I am using Dlookup to identify them on my employee form. When I get to the same employee/employee id on my...

I have used the dcount before but in this case I need to see if I am looking at employee id #5 on the employee form, the label flashing would be an indication that employee id#5 is on the license suspension table. Is there a way to determine that it's on the query? Thanks again

I have a form that shows employee license information. I also have a query & form based on that query to show licenses currently suspended. I would like to on my employees form to flash "license suspended" label if their name/record id is on the license suspension query. For all employees...

Report to Show last 4 digits of social Thank you it worked great.

I have a report to print that only shows the last 4 digits of the Social Security field. How can I do so for the entire list of social security #'s. Thanks in advance.:cool:

I have quite a few forms and reports in a database that are pop-up and modal. I've also auto centered them so they do not jump all over the screen. However, these forms and reports are centering when you open them but move whenver you close them. I am hiding the database window, which usually...

I am using the after update event to capture the add or delete. I just cannot get how to capture that change in code. For instance 2 is overwritten by 3. I would like to capture that change and record it as "item 2 exchanged by item 3." Is there any code that you can think of.