Search results

I have a products DB with up to 4 images per product: (1) how it is packaged in the box; (2) how the boxes are stacked on a pallet; (3) the label that goes on the product itself; (4) the label that goes on the pallet. Not all products have all 4 images. I use linked images to display the...

I'm using GHudson's A Better Mouse Trap code. It works great. However, I added other code from http://www.databasedev.co.uk/image-form.html to get and save the path to image files and now I think there is a conflict between the sets of code. The Images tab on the form frm_CreateNewSpec is...

I need to create or adapt from a similar database a means to capture time (labor) spent on projects. I've searched for this topic, but have come up empty. Perhaps I'm just not searching on the correct search terminology. Here are the basic requirements: One department can have many...

I don't understand why I'm getting this message. I have a form that is based on a parameter query. The user inputs an item number and the form opens in edit mode. The user clicks the "duplicate" command button and then changes the item number. I've incorporated GHudson's "A Better Mouse...

I have a macro in the On No Data event of a report that displays a message when the item number a user requests does not exist in the table being queried. Now I need to get the same functionality in a form. The form is based on a parameter query with only one criteria [Please enter item...

I need to trap an error if the user enters a item number that does not exist in the table. I created a macro for the OnNoData event and it works great when I test the macro by running the report from the Reports Objects list. However, when I run the report from a command button on my...

I have a database that can be thought of as a Bill of Material database. I have controls for Assembly, ProductLabel and CartonLabel. ProductLabel and CartonLabel are both setup as combo boxes, getting their data from a common tblLabels. For a given Assembly, the ProductLabel and CartonLabel...

I have a data entry form with a memo control physically sized to match the allowable space for this information when printed on a report. Basically, I need to be able to stop the user from further input when the cursor reaches the lower right corner of the memo control. Beeping when reaching...

I've created a multiuser DB with a tabbed form interface. There are separate forms to (1) find a record, (2) create a new record, (3) edit an existing record, (4) duplicate then change a record. I need to print a report based upon the current record in any of these form. I've read many other...

Should the Security Wizard be run to create the user rights before or after splitting the database? If it's run before splitting, does that mean that the .mdw will control both the front end and back end, versus running it after splitting it will only control the front end? I'm planning on...

I am very new to Access and am designing a multiuser database with tabbed forms. One of the tabbed forms has 7 tabs; the first tab contains the part number and other information about a product and the remaining 6 contain additional information about that product. Is there a way to have the...