Search results

To make this a bit more clear... The 'window' that appears is the same as would come up if you clicked the 'start' button and then 'turn off computer'.

I have a access database sitting on a server accessed by several workstations. One of them is a new workstation with MS Windows XP Professional on it. When the user uses the combo box on a form to lookup a record, about the 2nd or 3rd time, the Windows Restart window appears! The user can...

Add a total to the subform I'm assuming your subform is a datasheet - if so, modify the subform and add a formfooter. Add a unbound field that sums the field, i.e., TD is the field you want the total of; the unbound field might be TotalTD. Set the control source for TotalTD to...

Update query Since you are using a 'select' query to generate the report, why not create a 2nd query like the first only make it a 'update' query to update the date field with the current date, i.e., DATEFIELD = date() Create an event procedure to run the report and run the 2nd query within...

Group by SchoolID If I'm interpreting this correctly, you want to produce a new page everytime the SCHOOLID changes. Add a SCHOOLID header in your report form and in the properties section for the header, under the FORMAT tab, select Force New Page and KEEP TOGETHER as Yes.

I want to be able to group orders by duedate for each week starting with the current date for 1 week. Thus orders dated today (2/7)(Monday) thru Sunday (2/13) would be grouped together. On the following day (2/8)(Tuesday), it would group to Monday (2/14) and so on. Since orders are spread...

I want to be able to assign a value to a field on a form based on a value from another field plus a counter number and need help! I have a pulldown field (named "COMPANY") for the user to select a company name. When selected, I run a make-table query (named "COUNT") that gives me a count of...

I have a order form with a subform in it. The subform contains multiple records with different due dates. I created a query that refers to a date in a table (via a lookup) so that only records in the subform that have a date => the due date are displayed. My problem is that I want to...

Is it possible to set a filter to run when a form opens, based on the first value in another table? My form displays customer orders. I want the form to open and only display customer orders from my customer_orders_table where the order_date is > a record_date in a Record_Date_Table. There is...

Set the form properties 'border properties' field to 'thin'. This prevents the user from resizing the form. There are other form properties as well that can be set to prevent the user seeing the scroll bars, record selectors, and navigation buttons. Also, you can set the 'min/max buttons'...

I created an Access 2000 db for a user who only has a runtime version of 2000. When accessed, the menu bar doesn't give the user the option of 'send to' in the file pulldown so I created a custom menu bar with the 'send to' on it so when the user runs a specific report, that menu bar is...

Can you set the focus to an already open form from another open form which has the current focus? I'd do this using a command button and some sort of code if possible.

Create a event procedure on the field being changed for the 'on change' property. Thus, if the field you are changing is called "DATE1" and the field you want updated is "DATE2" to match DATE1 then the event procedure would be: Me![DATE2] = [DATE1]

My guess is that since there are no orders that day, you have nothing to subtract from the reorder point. The value being returned for "SumOfQuantity" a 'null', not a zero and therefore the calculation is erroring out - try this: =[ReorderPoint]-NZ([qry_todays_totals...

I want to create a combo box that will display items based on day of the week. I have a table listing individual items and a specific day of the week they are made. My order form has a ORDER_DATE and I want the combo box to only display items made up to 2 days from that date. To complicate...