Search results

that's what i'm doing and it seems to be working thanks guys

thanks for the reply i have found that it works flawlessly if i change the worksheet name from '#01' to 'S01' so the issue is definitely with the '#'. it seems that access is treating this as a special character and not just a sting. i have tried using a string variable to force it to be a...

Hi, we get an excel spreadsheet from our suppliers for the silicon wafers they supply us, it contains debug and failure info, and i need to import some of it into our database. my issue is the worksheet names are #01 - #25 and i cant get access to see these worksheets i use...

Thats it thanks for some reason when i looked online it was written as i had it seems Google does not know everything after all :)

Hi, im trying to get a count of the unique customers in an access 2010 database after some research it seems i should be using SELECT Count(Distinct [Customer]) FROM [tblMain]; but when i use this i get Syntax error (missing operator) in query expression 'Count(Distinct Customer)'. i have...

Thank you for the reply he is only using the dates not entering them (that is done on another form as an admin function at the start of the year) so i guess i could change to a different format for the date...will changing the format of the table field mean i need to re-enter all the data ...

sorry the error report is in german, i will get our rep to translate it for me basically what im doing is i have a table (tblMonths) which has the monthname (ie Jan-2014) a start date and an end date. i have a form that lists these month names in a list box. on click for the list box looks...

Hi, this may take a bit of explaining so please bear with me i have been tasked with creating a sales forecast database for use by our sales reps and production coordinator and i seem to have run into a snag. firstly our company does not use the traditional calendar (dont ask) so i have to...

I have been hiding here for some time but need to ask a question so thought i better say Hi first (its only polite) so...Hi :) im from Scotland, been using Access for about a year (i inherited it when our Access guru departed for pastures new)..mostly self tough with a couple of books and a DvD...