Search results

thanks for the reply, where exactly would i put this ? in the query?, where would i set the formatting? Field : Fld_Date_Account_Opened Table : Tbl_Master Total : Group By Sort : Descending from the query With oXL .Sheets("Master Closed").Select End With Set oXLSheet =...

Hi i have a CopyFromRecordset into excel 2003 one column is a set of dates, but when the code runs and copies the date column over, the format is as it should be but alot of dates are showing in american format Cant seem to figure out why, but its not every date, id say 50% of the 1500...

thank you eee

Hi i have a form with a drop down that links to a table where a user can select or type a record, if they type a record that isnt in the table, the form goes completely blank is there a afterupdate event i can do so that if the record doesnt exist, then a msg prompts and the form isnt...

Hi i am having issues with certain users re references, I get weird errors when sending emails through Outlook, is there anyway running some code for me to check a users references? the below is what i have and everything works fine, so would like to check they have these Visual Basic For...

sorted, needed & "'" & either side of store number

Hi please could someone tell me whats wrong with the below im trying to get a record from tbl_new_accounts to tbl_closed_accounts, based on the number entered in a input box Dim StoreNumber As String StoreNumber = InputBox("Please Enter The Store Number", "") CurrentDb.Execute ("INSERT INTO...

works, thank you kind sir

thanks i get a compile error : method or data not found on Set XLSheet = XLApp.Workbooks.Sheets("Master")

thank you, where in this would i put the file path name to my excel workbook thanks

Hi thanks for reply but yes i need to open excel using access, i have been looking on the internet for something to copy, but cant seem to make it work thanks

Hi i have an excel spreadsheet in my documents (H:\My Documents\breakdown.xls) i have a query called Qry_Breakdown, a form with a button named "Update Breakdown" How do i get the details created in the query, to appear in my breakdown sheet, starting from "A2" as i have several headers...

would be great to skip holidays, but if this is too complicated, just skipping weekends will still be ggreat thanks

Thanks for the reply, what would i put in the function? sorry access noob

Hi can someone amend the below, so that instead of doing 4 days, it does 4 working days? thanks <=DateAdd("d",4,Date())

ok thank you

Hi its a master form, the button is on there, once pressed if the date is within 30 dates, that query apends it to another table in the data base thanks

the combo box has account numbers, when they select one, it populates all the other fields on the form, one being Txt_Date_Account_Opened which is linked to Fld_Date_Account_Opened on the table combo box is called Txt_Store_Number_Selector cheers

thanks i cant upload from work, will have to when i get home thank you

Hi the date is not specific, there is a form with a drop down with 100's of a accounts to select every account has a date, if the date is within the last 30 days then the user can click update and the query needs to run, if its older then that paticular query needs to be ignored. hope this...