Search results

I created a form with an unbound text box called Logged On. IN the on open properties I inserted the following code: Me.LoggedOn.RowSource = WhosOn() Hope that works OK for you

Solved my own problem. I added a QTY field to the prices table and bound the control to the field. I added some code to the on open event that updates the quantities to zero to "reset" the form.

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

fixed! I found the answer: For some reason, the form was tied to a query( I don't know why). Since the query relied on input from another form, everything came up blank. I removed the link to the query and all the objects reappeared. Thanks for the suggestion about parking the form in a...

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

not yet Thanks again. However... IIf(DatePart("w",Now())=2,(Between DateAdd("d",-3,Date()) And Date()),Date()-1) returned no records at all. The filter works separately, but not in the if statement. Thanks Bruce

Still only returns Friday's records Thanks for the reply. I tried dateadd but it only returned Friday's records not the entire weekend. Bruce

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

Crosstab Solved my own problem- I created a crosstab query and chose the "First" value for the intersection, rather than a computed value.

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

Thank you, Thank you very much! Worked like a charm- go buy yourself a bottle of good wine and put it on my tab!

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

Thanks for the help It seems I need to rethink the entire project- back to the drawing board... have a GREAT day!:(

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

thankyouthankyouthankyou! this did the trick! It will be a real lifesaver!. I can't thank you enough!

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