Search results

The query returned me results after i remove the where clause. How do i move on from here?

Thanks! I have fixed the error. However, when i run the query, no records is shown on the query

Thanks! After i have added in the . and run again. It prompt me another error"Syntax error (missing operator) in query expression".

WOW! Thanks for sharing!

Hi all, I get the error when i run my query and i have check that i do not miss out any open or close bracket. How can i fix this? SELECT FabricPOqry* From FabricPOqry LEFT JOIN MainTable ON (FabricPOqry.StyleNO = MainTable.StyleNo) AND (FabricPOqry.[GL Lot] = MainTable.GLA) AND (FabricPOqry.PO...

I managed to solved the error message by using nz(textbox). Thank you.

I have solve it already. However, now i am facing issue whereby it show error message "Invalid use of Null" when i click on my edit button. Private Sub cmdModify_Click() 'check whether there is exists data in list If Not (Me.FormMxdSub.Form.Recordset.EOF And...

There is no error message tho. After i click update, the record will be cleared from my form.

The record is still unable to save into my table after i have took out GLGPO in my update statement

Hello everyone, I am facing problem whereby my record is not saved even after i click onto the "Save" button on my access form. May i know what causes this issue? Below is my code: If Me.txtGLGPO.Tag & "" = "" Then 'this is for insert new 'add data to table...

Yes, I did. I am now having error with my code. The error shows"Object variable or with block variable not set. Below is my code: 'check whether there is exists data in list If Not (Me.Form1.Form.Recordset.EOF And Me.Form1.Form.Recordset.BOF) Then 'get data to text box control With...

Hi, I am using 2007-2016

Omg! Yes, it is madness. As the excel sheet is retrieve from a system which has no primary key, it is very hard on to assign a PK on my database when i import it over to Access.

I tried using this method after my own research, whenever i import data in it will show duplication. How to not have duplication and only import the new data?

I am importing all from excel, as the data is updated every morning thus i will need to import into my access. If the only way is ti delete all records then reimport again, then i will have difficulties on which PO i have done and which PO i have not done.

Yes, the import data is the correct one

Hi,I have attached the sample data above. I have two table. One is sample(import from excel) and the other one is the main table. So basically take the sample table as data that i will be importing from excel and with the insert statement i will put the data from this table into my main table...

All the field might have the possibility that it will be change

Yes, and all this field contains duplicate data

The row that i need from the excel file that is imported into my access and the same row that i need for my main table are: PO, StyleNo, GL Lot, Name, date, Description2, Colour,Fabric Weight,Fabric Cuttable Width,Our Qty,Supplier Qty,GSMBeforeWash,GMS Per SqYD,ModifyDate