Search results

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.

I have a form that displays data related to a manufacturing process. If the process name is "Build Motor" displayed in the textbox, then I want to hit a button to have Access launch WORD and open a file named exactley the same name Build Motor.DOC If the process name being displayed is...

I have a database that contains several manufacturing processes. The main form displays information about each process as each record is chosen. There is an object frame on the main form that displays a Visio flowchart of the given process. I would like the user to have the ability to click on...

I have one main form that contains a field called [Process NAME].... I also have several sub forms that are unique to each process name. Each of these sub forms are different from one another. If [PROCESS NAME] is "Build" on the record being shown on the main form, then I want a sub form called...

I have a table that contains data for manufacturing processes. I have a bound object frame to display a flowchart for the different processes. As the user scrolls from one process to the next, the flowchart is displayed on the form. What I would like to do is to have a subform appear that is...

Is there a way to display a message box that can contain an image along with the message text? Thanks - John