Search results

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

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

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.

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