Search results

Hello, So i need to change the date format from 00/00/0000 to YYYYMMDD please can confirm the best way to convert this :)

So is it possible to add a pause to VBS code so that i can check the data created is 100% before the VBS exports to excel?

Does any one have a working method to compact access 365 database from VBS so i can automate it to compact after importing data pls?

AB45 3EQ,,FALSE,, ,,LOW,Last Order Date 160822

yes i am trying to do this via VBA is i add headers to the file it imports but if i remove the headers it fails the data is shared without headers so how can i import the files with no headers?

no sory the txt files doesnt have any headers at all its raw data

I am trying to import a txt file into a table using this.. DoCmd.TransferText acImportDelim, , "Importing_Table", strFileName, False getting error runtime 2391 Field "F1" doesn't exist in the destination table Importing_Table

Thanks not working as the field that has True/False is a short text so guess this is stopping it working..

How do i get a form to show False as Yes/No Tried with a query but didnt work is showing every record as YES Order_Sent: IIf([Dispatch],"Yes","No")

Thanks sorry forgot to say I first have a form in which post code is entered this opens up another form and now on that for i need to show by selecting the customer in the combo

So I need to create a form that will have a combo box which you select the customer account_No and then want it to populate the records in text boxes below for that selected customer TextBox1 = Address TextBox2 = Telephone TextBox3 = Last Order Date ect

I need a query to count the number of times a customer account number appears in a table and update a count total with the results, but to only count the records that have the OrderStatus as "Completed" SELECT [CustomerAC], Sum(IIf([OrderStatusDevice] = "Completed", 1, 0)) As CountTotal...

So i have two tables I need to copy to the main table a date from another table I have the same customer ID in both tables the same i just need to add to table1 "Install-Date" from table 2 - i tried update query but it said needed an updatable query just need copy "Install-Date" from table 2...

No cant get that working

ok i have done it following this method Open the Employees database. Click Forms under Objects in the Database window, click the New button, and then click OK. In Access 2007, click the Create tab and then click Forms Design in the Forms group. Click the Combo box control in the Controls...

stored in backend tables address and then links to customer property info

So i need to create a form that the user enters the Postcode and then have a combo box to select the house number and then populate property details in other text boxes, is this something easy to do

So need to change OR to And? or can i use or along with any as it may just be email gets update and the phone is ok?

So i create a new table of data and the use that table to update the master tables that way i can manually check the changes, but as i said its not working when customer is present twice same account number a different record id