Search results

When I open a form, I want it to automatically check to see if there is are any updated files. I already have imported files into Access, but want to automatically check to see weather there have been any updates to the files. Example Form opens, Checks the “C:\MyDouments” for any updated...

I have a button that inserts values into a table. But every time is dose this, a update message appears. How can i change this so this doesn’t appear? Is it something to do with the security settings? or is there some code which automatically clicks yes? - I want to min user involvement...

Dim strExcelFile As String Dim strWorksheet As String Dim strDB As String Dim strTable As String Dim objDB As Database strExcelFile = "E:\CSC\LDMS\LDMSDatabaseApp\LDMS_Spec.xls" strWorksheet = "WorkSheet1" strDB = strFilePath & "LDMS_IFF_APP.mdb" strTable = "TEST_DOC" Set objDB =...

I have a button that when I click on it, I want it to create an Excel Spreadsheet with 5 worksheets. Also how can I change the cell formats in Excel from Access? i.e. I have an export function in Access that exports a table into excel, however I want to change the format in Excel i.e. Make the...

I import data from a Spreadsheet into an Access Table. When I import the data I also want to populate one column with name of the Access Table. i.e. i’ve got a table called: MPI_IDS_IFFs so I want my fields to look like this: ID --- USERNAME --- FORMANE --- TABLE_NAME 01 Hewston...

OK thanks for ur help. Here is a tricky one. When I insert the data into the table, i want to insert another colunm that will hold the table name where the record came from for each record. This data isn't sorted so it will have to get the information from the table name. example IDS...

Thanks for the code. It works fantastic. Can i limit the tables I put into it? i.e. I have a table call MPI_ADDSS_IFF and MPI_ADDSS_IFF_ChangeLog, how can i change it so i only have MPI_ADDSS_IFF?

I have this query below: INSERT INTO TEST_DOC SELECT * FROM MPI_ADDSS_IFF; I currently have 10 tables in my database (All with the same colunm names and formats) however i want to click a button that will put all the tables into TEST_DOC, instead of doing it one by one. To do this this i would...

yeah sorry, im new to VBA and SQL and dont no much about the code side of things. Basically i want all the information in my 8 tables, to be put into 1 table - So i will end up with one table instead of 8.

I currently have 8 tables in my Database. How can i extract all the information in those tables and put all the data into one large table? I want to extract everything apart from one table? and can I format the large table once the data have been put in i.e. insert new Columns at the start...

I have an export function below that will export my table "Test" to an Excel Spreadsheet. However I want it so i can choose where that data in the "Test" table will go in the Excel Spreadsheet i.e. I want to export all the data in to Cell "B2" of the SpreadSheet - at the moment it will export...

I have created about 7 tables in Access, which all have the same column names. I want to export all of the table's data at the same time into a Excel SpreadSheet using VBA. Also I want specify where i want the data to go in the SpreadSheet e.g. All data will be exported to cell A4. Any ideas...

I currently have a list Box populated with some table data which has 9 columns and 255 rows. I want to enhance the appearance of the list box i.e. 1 row of data will be blue, and next row will be white, and the next row blue again etc etc How can I do this? Kind Regards Richard

Hi there, I currently have a list box with shows all of my tables in my Access database. However i want some kind of flitering function that limits what the list box will show e.g. The list box currently has the following values: MPI_CORE MPI_IDS MPI_IDS_ChangeLog ...... I want a fliter that...

I have a list box which shows table data, however i have alot of data and i need a Horizontal Scroll Bar in the list box, so i can view the data. Any ideas or help? Kind Regards Richard

I want to display table data in an MS Access form (using a Text box or a grid) using VBA? Any ideas or examples? Kind Regards Richard

I have 2 questions/problems: 1. I want to populate a list box with all the Tables Names in my Database using VBA. 2. I also want to create another List Box or Grid (or any thing that will show table data) that when i have select a Table Name (See above (1)) it will show all the data in that...