Search results

Hi Pat, These 4 table linked each other so i am using foreign key to link one-to-many. In some table I am using ID as foreign key. I have tried using query to list all InvoiceNumber which linked to a TaxNumber. The issue is, I can't input data in the form which created from query (not a...

Thanks Pat for your feedback. Ack. In fact, I have 4 tbls: tblJobInfo, tblTaxNumber, tblInvoiceNumber, tbleCharge and its relationship as attached pix. JobNumber is unique in this database. A same TaxNumber can be appeared in different JobNumber(s). A TaxNumber include different unique...

Thanks for your feedback Pat. Yes, I can make a table as Make Table query and it will be replaced totally once I run the query. My question is, can I make a table contents the fields in the query and it will be auto-updated once there's a change in the original table (the tables where the query...

Folks, Can I make a table from a query which data will be updated once there's change in the original database? If yes, how can I do? Thanks folks, Quan

Folks, I have a TEXT field in a report which contents "0" at begin (ex. 01234). When export the Report to excel file, the digit "0" deleted automatically. Is there any solution to solve this issue? Thanks to advise, Folks. //Quan

Thanks for your feedback, Jdraw. Yes, each user has there own FE on their PC. //Quan

Hi there, I have two table tbjJobInfo which contents AGENT field linked (look up) to tblSupplier. An input form created from these two tables. While enter info, user has to enter new Supplier info in tblSupplier for the NEW name. The update take abit long time to be updated in the Combo box...

Dear Paul, Thanks for you advice. I already solved the problem. The missing of parameter while generate the number. Thanks again. Quan

Hi there, I have 2 table: - tblInvoice include Inv#, Type (Debit/Credit), InvoiceDate, ... - tblCharge: ChargeCode, UP, Qty... I have created a qry of these 2 table. It works properly. I added a Number spelling function to convert Total amt to word. The error has happned when I change...

Hi Paul, Thanks for your advice. I will make a change then. Thanks again. Quan

Hi there, I have 2 table: tblJobInfo include: JobNumber, SHPPR, CNEE, AGENT tblSupplier: SuppCode, SuppName SHPPR, CNEE, AGENT look-up a SuppName in tblSupplier In the query the tblJobInfo, I want to exract a value as: Iif(SHPPER=Null, CNEE, SHPPR), the output is not SuppName as my expect but...

Greetings Folks, I am newbie in Access and looking forward you advices. Thanks Quan