Search results

Ignore last post, managed to work it out for myself - just being slack. Thanks again

Thanks for the reply neileg, can you explain a little more as to how assemble a sql string in vba that would achieve this ?

I have the following IIF function in the criteria of a date field. IIf(Weekday(Now())=6,Between Now()-2 And Now()-10) I want to return dates between 2 and 10 days ago, if today is Friday, but this doesnt return any values at all. Is the statement above correct ? TIA. Mark

Thats great, thanks Jon, much apreciated.

Hi, I'm getting really mixed up here, Im trying to delete all records in table products based on the following query; SELECT products.*, tbl_stage_product_update.[Catalogue No] FROM tbl_stage_product_update INNER JOIN products ON tbl_stage_product_update.[Product Code] = products.pID WHERE...

I need to automate one of my reports to print daily, Is there any other way of achieving this except for using the OnTimer control on a seperate form. I already have a form on my db which is using the on timer event to import .csv files into a table, and dont want to have to add another form to...

I need to automate one of my reports to print daily, Is there any other way of achieving this except for using the OnTimer control on a seperate form. I already have a form on my db which is using the on timer event to import .csv files into a table, and dont want to have to add another form to...

Thanks for the quick reply ghudson, The database form is not seen by users. The only interaction by users is an asp front page on our intranet. It is importing a text file generated by a .vbs script on our network. I need it to ignore the incorrect records in the text file and only import the...

I have some vba code running on a timer event in a form, that imports text files into a table. Some of these text files have misformed records, and will not import correctly in the table using my specified import spec. Is there a way I can supress the error message informing of the type...

DAO wasn't registered...... Thanks for the very quick reply.... Feel embarrased for not even checking Microsoft knowledge base. Thanks again.

"Active X Component can't create object" getting theis error when i try and import any type of text file, or .xls. I was creating an import spec two days ago for a text file fine, but now when i try to import a file I recieve this error message straight away. Trying to import to a new DB...

Thanks Namliam, As I thought, I couldnt see anyway to break the data down, as all data relates to that customer. thanks again Mark

I currently have an access database that imports csv's via the importspec and vba into a table. These csv's hold info on customer details and contain 18 fields for each customer record. I have also added to this table an auto date and time field and an autonumber customer ID field. I am now...

I know the rename files question has been asked a numerous amount of times here before, but can somone give me some advice on how to achieve the following: I need to rename images using strings that would be created from data that the user chooses from various combo boxes. Ideally the user...

Just worked it out, thanks again for the help

Thanks a lot for the help guys. llkhoutx's solution is relevant to what i want but i dont understand how i would set the record source to be a text box on an underlying form ?

Can anyone tell me how i would display a variable from my vba code, to a text box in my report header, I assume that i will have to make the variable global, but where do i go from there. TIA mark

Im using this piece of code to move a csv file from one folder to another after processing. The problem is that if a csv file already exists with that name it does not overwrite this. can anyone sugges the easiest workaround for this. 'Move CSV File to chosen folder Dim fs Set fs =...

I have a script triggered by a timer, that imports csv files when they are uploaded to a file. In one of the fields - "Car Description" each record has some unwanted characters at the beginning and the end. These unwanted characters are the same in each record. Can i set anything in table...

Thanks Aaot for the help guys, Imo, I am using your script, which works really well, except that i have it triggered by a form timer, now when there is no .csv file in the folder to process , the script throws up an error , do you know how to work round this ? thanks again Mark