Search results

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

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...

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...

"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...

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...

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...

I need to import data from multiple csv files into an access table in my DB. These csv files are being constantly uploaded to a folder on an ftp server, then forwarded to a folder that resides on the Database PC. They need to be added to the database as they arrive. They will have various names...