Recent content by gbmarlysis

Hi, i have a large table with millions of entries. I want to run a query to return all entries that are on a Saturday. The date stored in the table though is just typical date format eg 15/11/2015. Any help would be appreciated Regards Luke

Hi Gasman, Yep i get it i think, even though there are multiple file names you cant expect access to put a "\" before every one to make it complete the file path, so you need to do it. I added in and it at least started to run but got the error runtime error 2391 field 'f18' doesnt exist in...

Hi Gasman, When i go to the folder where the files are and click on the path to copy and paste it doesnt have a "\" at the end ?? Not sure how to put full path if each file has a different name. My thinking is i can only direct it to the folder to where the files are.

Here is the code I have but returns No files found' Sub Import_multiple_excel_files() Const strPath As String = "C:\Users\Lburch\Documents\Data\Data in Excel Worksheets - Copy\AAA - Copy" 'Directory Path Dim strFile As String 'Filename Dim strFileList() As String 'File Array Dim intFile As...

Hi, I put the code in but when I press run. It does nothing. :banghead:

Hi Gasman, Yep have searched over 40 websites and trialled the code. I must be doing something wrong and have turned to the forum for some more detailed responses. Thanks though.

Hi Mailman, Heres a challenge. Are you able to write the code required. I've spent 48hours to only come up with numerous error codes and a handful of new swear words for VBA.

Hi. Access Version 2010 Excel Version 2010 I have 200 excel files in folder C:\Users\Lburch\Documents\Historic Data\Tedan Data in Excel Worksheets - Copy\AAA - Copy The files only have one worksheet and the column format are the same. Worsheet name is different for every file though. Headings...

how do i construct a reference number combining three fields. Date/race no./event so i can select it from a combo box

hi, i need to count how many entries are before a date in a list box. the issue is the date of the record is used to give it a primary key eg lathl15/06/11r1. can i use dcount for this.

got it mate all sorted thanks.

=dcount("*", "Race Results", "Athlete Id" = & [Me].[Combo35])

the text box is on the sub form aswell, when i do Dcount("*", "race results") i get the count of the number of entries but whenever i put in any criteria to show only the rows with the athleteid that the combo box shows it doesnt work and when i put stuff in the expression it doesnt work

sorry John so how would i set that out. =dcount("athleteidField","Race Results Table", is = to the value in the combo box) thanks

hi cant get it to work. the combo box is on a subform and unbound could this be the issue.