Search results

is this carried out in the table properties or the form properties?

ok, please can you show me how you referenced it, i did it like this DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, TableName, selectFile(), False, "'mf020118 Run In'!A2:J50"

yeh i spotted that but still not luck i think it may have something to do with the name of the sheet, as it has spaces in it, but as it is not my sheet, i cannot change the name of the sheet, i have tried referencing the sheet as "Sheets(8), but still no joy. my other option, but im not usre...

thanks for the reply, but the workbook changes everyday as does the name of the file,

hi so im trying to import an excel sheet into access, i want to be able to select the sheet and range, i have tried various different ways to reference the sheet but i just cannot get it to work. does anybody have any suggestions please Private Sub btnCreateInServiceIssues_Click() 'On Error...

hi so im building a method to import an excel spreadhseet into my database so far i have got the method to select the file and import it, and im curious when i use the DoCmd.transferSpreadSheet can i select multiple ranges in a single sheet. the issue i have is, the sheet im trying to import...

hi cj_London so i have created a test database with some date in there, i have place the query i was trying to get to work (subquery1) and i have added an example excel sheet with what i wanted it to look like.

ok do you want me to upload a database with the data or screenshots?

is there an easy way to make all fields mandatory on a form, or will i have to add vba to each field on "BeforeUpdate"?

yeh it counted but not per line ive added a screen shot a an excel sheet, but the output is the same as access

thanks for the reply im doing this so i have quick visibility in terms of a repeat failure, so if the vehicle has the same failure type in 14 days, it will highlight it in levels, ie level 1, level 2 etc. so i have a continuous form, with all the entries on there, then the failure level will...

i have a table called Table_Tracker, in this table i capture events that occur in the day against vehicles, what im trying to do is count the same number of events in a 14 days period, so ive done this in a query, but i cannot get the query to work, a message comes up saying this query will at...

hi all im assuming this is possible, but im still quite new to VBA, but is there any way i can select and import an excel spreadsheet based on last modified date? Also would there be a way to select worksheets as a pose to the whole workbook?

hi im trying to open a form from another form, and select the same id so first form is bound to a query vehicle_ID VehicleType DateCreated and the second is bound to a query with the field Vehicle_ID what i want to do is open another from where the field displays the vehicle_ID i did try...

hi i am building a configuration management/ stock control database, and i need to be able to limit the number of child records from the parent record, im not sure if VBA is the best to do this or not so i have three tables in a many to many relationship table 1 Table_Vehicles Vehicle_ID...

I run and append query to create a new entry from a button, that also opens the form. Sent from my ONEPLUS A6003 using Tapatalk

thank you, didnt occur to me to execute it on the form, was trying to do it from the button.

hi this is probably the most easiest thing to do, but i cannot find and answer i would like to open a form with the most recent record from button click ive found how to load the most recent record, but that requires the form to already be open

LOL am i that predicable :D

thank you again!!