Recent content by jboyle

I have cases where I need to have users of a database to replace a table because the structure has changed. The users are not very good about how to delete the exsisting table and then perform a data import function. Is there a way to automate this process? Thanks in advance - John

I have a form that allows the user to click on objects. When a given object is selected I store the selected object label name in a table. The label that is stored is used to filter the next form that is opened to that particular value. This all works fine but after I view that record, I would...

I have a main navigation form. From this navigation form, the user can select other forms to go to. Up to three or four forms deep. I want the user to have the ability to go back to the previous form (Which I do by a simple close form. However, if they choose to get back to the navigation screen...

I have an Access database that creates a report of qualified vendors. I also have a business report that is created in WORD that has a vast amount of information including a table of qualified vendors. I keep forgetting to modify the WORD document to reflect the most recent qualified vendors. I...

I would like the color of the border to change on text boxes when a mouse-over action occurs. Any ideas? Thanks - John

When I create a hyperlink, the link does not save the entire path. Example: G:\Public\John\Procedures\Policy.Doc end up being ..\..\Procedures\Policy.Doc. This ..\..\Procedures\Policy.Doc path works fine on my computer but fails on anybody elses computer. How do I create a hyperlink that will...

I have an Access database that has a button to open another Access database using a hyperlink. The problem is that the database being opened has an autoexec which must run when opening. If there is an autoexec, the application is pushed off the top left hand corner of the monitor. If I open a...

Is there a way to store data in a temp file? I want a query to filter records based on the data in the temp table. Thanks in Advance - John

I have a form that has several labels. Each of these lables has been given a unique name. When the user clicks on one of the labels, I want the name of the label to be stored in a table. What macro or event procedure could I use to store the name of the label in a table called LABEL TABLE.

I have a table that contains a field called container_number and another field called received_date. I am using an append query to get new data from an Excel spreadsheet to populate the access table. These containers are recycled and will be returned and added to the database again. The...

I have a main table and a subtable. The unique field is called container ID. This container ID is in both tables to support the link as the master and child field. However I now have a need to add an autonumber to be able to perform other functions. I added the autonumber to the main table with...

I have a main form that has a subform that the user enters data. After entering the data in the subform, I have the user click a button that Hides the subform and makes another subform visible. However, when they click on the button I get a run-time error about the form having focus. How can I...

I have a main form that contains a subform. One of the fields in the datasheet subform is part number. If any of the listed part numbers begins with 84 (84272451F) then I want a text box on the main form to state EXPORT. If none of the part numbers begin with an 84 then I want the text box to...

Thanks Fizzio, That works GREAT!!!! I did need to type in the path for the file. Is there a way to have the path included? Example C:\Processes\Motor Assembly.Doc

I have a form that displays a text box that contains the Word document name for the given record being shown. I would like to have a button to hyperlink to the given document.