Search results

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.

ok not sure what the =" & Me. means but back to the internet. thanks for the parts you helped me with.

so what would the line of code you would use look like .. thanks

hi could i get a bit more guidance with how to set out the expression builder. i have an athlete table linked to a race table and bothed linked to a race results table through race id and athlete id. the combo box is at the moment combo 35. i dont really get the domain etc thanks ps how can i...

Hi i have an athlete db i have a form with a combo box i want a cell to tell me how many races an athlete has had once i pick the athlete in the combo box there is also a cell with the date in it i want the "how many races cell" to only show the number of races the athlete competed in before the...

Hi, the form is a main form to the orderdetails table. on the form there are two listboxes one is attached to the CustomerTable one is for the StoreTable then the other fields are what was ordered how many etc that fill the OrderdetailsTable. When i pick the customer in the listbox i want all...