Search results

I think I have missed something very simple, but I am having a senior moment. It am trying to create an invoicing form. I have a table that lists items and prices. I would like to create a form the lists these items and prices but allows the user to input the quantity ( default value of 0)...

All the objects on a Switchboard form suddenly have become invisible. The form is there, but an image, a title and the tabs are missing. Checking in Design view verifies that they were not inadvertantly deleted. I tried repairing the database- no go. I renamed the form and copied a known good...

I am trying to filter a form to show the entire weekend's activity on Monday but only yesterday's activity Tuesday through Friday. Using this code I can return Friday's results on Monday and yesterday's for the rest. How do I get the range Friday to Sunday...

I am trying to build a graphical schedule from a table. Through a series of queries I have managed to whittle the data down to the Dock Number, Slot number, Hour and the intersection value( concatenated Vendor and PO). How do I get this to appear on a report with the slot numbers on one axis...

I have a form that is going to be used as a performance scorecard. To that end, I have several calculated values (from Dlookups) expressed on the form as percentages, as well as several values expressed as fixed numbers. I need to capture all these figures to a history table as the underlying...

I have created a pop up form that works fine as long as there is only one user in the database. If I have multiple users, only one person gets the popup. Is it possible to have everyone get the popup form? Can the pop up be set to only show up if another form is open on the database ( the...

I have a continuous form based on a query. In the detail section of the form, I have action buttons that perform several updates to the table when pushed. The results of these updates are then displayed on the form. This works as planned. The issue: The form as it sits is “busy”. I would like...

I am trying to deconstruct a database that has several linked tables. Is there a way to find the source database for the linked table from within the original database?

We are using Oracle databases for inventory control and connecting to them for reporting with several Access 97 databases running on Windows XP pro workstations. Recently we changed the Oracle password, removing the write access permissions for these small DB's. We relinked every table in every...

I am trying to append records from a form to two different tables. I have the code working to append into one table but I get an error message when I run this code to append data to a different (linked) table INSERT INTO TRAN (VEN_ID, CARRIER, CTRL_NUM, PALLET_TYP, CTRL_ID, CTRL_DT, TRAILER_ID...

I created a database in Access97. I have a report that is exported to Excel 97 with the following code DoCmd.OutputTo acOutputReport, "Outstanding No Stocks Query1", acFormatXLS, "C:\NoStocks.xls", True This works well on my system (Win2k and Ac97) However, I copied the local database (in Acc97...

Activating Calendar Control closes other form I have been asked to fix a minor problem with an older database. When using calendar control on one form(PROJECTION_QUERY) to set the date, the main switchboard form(f_main) disappears! f_main is called through an autoexec macro. It has a lot of...

I have an append query that enters a day's routes to a dispatch table, based on the value of a combo box. There are also two fields that are populated at time of departure and return, respectively. I want to make sure no one can enter the day's routes twice. In other words if a record contains a...

I am experiencing severe speed issues running Access 97 on a Windows 2000 machine. (1.4 ghz, 256 mb ram 16 mb video card), linking to tables over a LAN. Any queries that I run take a long time to execute and seem to lock the computer while they are running. The video display does not refresh...