Recent content by awade
-
A
Check box checked when information placed in folder or table
@minty Sorry for the delay in getting back to you have been in an internet black spot for the last 2 days.. I would like to have the data entered into a table that has all the serial numbers that the database looks at. When new data (a recommendation) is added to the table associated... -
A
Check box checked when information placed in folder or table
@minty I am after a way of being notified that new information has been placed in the database that is linked to a specific serial number. eg Serial number CAE540123 has had new information added to a folder. This can be shown as a checked box. Once that data has been reviewed and actioned... -
A
Check box checked when information placed in folder or table
@Minty, Thanks. I am new to the whole access thing, as i have been using this database all wrong with external folders to store data. I am now trying to learn how to store all the information in the database so i can access current and historical data. My first task is to find a way to input... -
A
Check box checked when information placed in folder or table
I have a form with numerous command buttons that open various folders external to the database. I am looking at creating a folder to store recommendations against a certain serial number item. What i would like to do is have a check box that indicates "checked" when new data is placed in the... -
A
Duplicate entries in a combo box
i have a combo box that quires a table which is linked to an excel spreadsheet external to the database. It has a column that is labeled tail number. this column has numerous duplicate entries that I would like to remove so the combo box only displays one of each entry. I have tried... -
A
Link an excel worksheet to a value in a text box on a form
@JHB I've checked the box, and now everything works. Thanks once again for all of your help. -
A
Link an excel worksheet to a value in a text box on a form
@JHB This is the area of the code where the error is Private Sub OpenExcel_Click() Dim xlTmp As Excel.Application, ThePath As String Private Sub OpenExcel_Click() is highlighted yellow xlTmp As Excel.Application is highlighted in blue. Thanks for looking into this -
A
Link an excel worksheet to a value in a text box on a form
@JHB after running some more testing on the database I am now getting the error as follows; "User-defined type not defined". Below is the code I have against the command button. The text box with the engine serial number in it is named "Core S/N" with the control source "Core S/N"... -
A
Link an excel worksheet to a value in a text box on a form
@JBH. My "A:\" Drive is the network drive where the database and all the associated files are stored. I have used the code you provided yesterday, and everything worked as it should I have now embedded it into the database and it works. Thank you very much for all of your assistance on... -
A
macro to open a specific excel worksheet corresponding to a number in a textbox
@Ranman256. Thanks for the response. Im really new to access so what you have given me has totally confused me. I have made a test form and placed the OpenNativeApp "A:\eDNA\eDNA Database\.xls" against the command button to open the folder, but I get error box "sub or function not defined" I... -
A
macro to open a specific excel worksheet corresponding to a number in a textbox
Good Evening all, I have a form which as a textbox named "Core Serial Number" I have a folder that contains two excel spreadsheets, with the folder name, and the excel spreadsheet name that same as the core serial number displayed in the text box. e.g. Core Serial Number Displayed... -
A
Link an excel worksheet to a value in a text box on a form
@JHB. I have tried A:\eDNA\eDNA Database\* is the path name, and it still does not open the folder associated with the worksheet of the serial number selected. I made a dummy worksheet named CAE540714.xlsx and saved it in the same directory as the database and that works... Is there anyway I... -
A
Link an excel worksheet to a value in a text box on a form
@JHB. Thanks for the sample. I have tried to run the sample database after changing the path. I now get an error saying that A:\eDNA\eDNA Database CAE540151.xls can not be found, and access freezes!!! Could this be that every serial number is in its own folder? and the folders are named... -
A
Link an excel worksheet to a value in a text box on a form
Sorry meant to add the serial number that is displayed in the text box is updated through an excel spreadsheet that is linked to a table. The spreadsheet with all the engine serial numbers is updated by and external agency. The data from that spreadsheet id linked into the table and the table... -
A
Link an excel worksheet to a value in a text box on a form
@JHB The serial number in the text box can change from time to time. eg. Today the Serial Number in the text box is CAE540151. When I press the command button I want the excel workbook CAE540151 to open. If I do an engine change tonight the serial number in the text box tomorrow will be for...