Search results

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

INSERT INTO Update_Contact_Details ( Record_Id, Record_Type, Customer_Number, Surname, Phone1, Phone2, Email ) SELECT DISTINCT Order_Master.Record_Id, Order_Master.[Record_Type], Customer_Base.Customer_Number, Customer_Base.Surname, Nz([Customer_Base].[Phone_1],"") AS Phone1...

So it does work only when the customer is entered within the table 1 time, if they in the records with the same account number say different address, it throws them up as changed, like i need to filter to compaire by record id and not account?

Thanks that didn't work either but found the issue it was due to table fields set as short text and not date so i changed this and now its working

its saying yes when the date is not greater so thats the issue is should be blank

whats a PK Field pls?

So I need a query to say "Yes" if a Date is Greater than another, this is what i got but its not working... Expr1: IIf([MaxOf Installation Date]>[MaxOfContract Start date)]=True,"Yes") This is showing "Yes" when the dates are Install Date is 18/05/2021 Start Date is 05/03/2022