Search results

Doesn't solve my problem.....

Hi, after the queries i need to fill a document. The problem is not "how to fill the document", but to execute the queries passing data to them.

Hi all and thanks for your help. I need suggestions: I have collected a data in a table: CODE_BANK and CODE_CLIENT I use this table to extract data from other two tables: CLIENT and BANK. For example: record_1 -> CODE_BANK = 12345 and CODE_CLIENT = 112 The result of the query to extract the...

Thanks for the answers: what kind of access tools i need to "export" data from tables/queries to a word document?

Hi all, i have a question about exporting or not a table data. The result is a six page document where only in 2 pages i need to put data from a table. What's the best solution? Formatting a "six-pages report" or export data to a word or pdf document pre-formatted? Thanks for your answers !

Hi all. thanks for support, i love this forum. I have a question: Is there a difference between NEW RECORD FORM and EDIT RECORD FORM? In my case, when i create a New record, i forced many fields to "null" or "calculated". If i want to use the same form, but with edit function, fields mustn't be...

The Report must contain these informations: NAME and SURNAME (from CLIENT_TABLE: ID_client, Name, Surname) ADDRESS (from ADDRESS_TABLE: ID_address, ID_client, street, city) IBAN (from BANK_TABLE: ID_bank, ID_client, IBAN) DOCUMENT_table: ID_document, ID_client, ID_address, ID_bank. Relations...

No difference, there is only the DOCUMENT TABLE.

If i have a document table like this: DOCUMENT NUMBER: automatic number. NAME: id client in client table. ADDRESS: id address in address table. mail: id mail in mail table (because a client could use one of its mail address). Everytime i want to display and print the "document" (report), i use...

Hi jhb, Good question. i need to collect and store data i choose to put into the document. Every document has a unique number. In that way every time I can Edit and reproduce the document. My idea is to collect the references of my choices in the main table and from that table print out the...

TY i'll try to check if i am in these case. Now i am asking if there is a simplest way to reach my scope: I have a CLIENT DOCUMENT 8Document table) that must contain this data: Name (Client Table) Surname (Client Table) Address 1 (Address Table) Address 2 (Address Table) Mail Contact...

Good morning, hi all and ty for your support: this is my situation: a "DATAENTRY_FORM" (that put data in "DATAENTRY_TABLE"). Inside that form there is a TAB with 1 SUBFORM (linked to a "SECOND_TABLE"). There is a relation between DATAENTRY_TABLE and SECOND_TABLE. Through a button, on the...

How Collect big data with forms? If i have a sequence of forms, what things i have to watch to male things better?

I made questions.... If it is a Good way or not...

No suggestion?

Hi all, and thank you for your answers. I have to collect many informations, and with that informations print a document. Informations are divided by 8 "type": - financial informations (bank coordinates) - personal informations (name, fiscal code, address...) - business informations ...and so...

No, but i know that the record is saved.

Ok i solved putting the code: Forms!FirstForm!ComboboxName.requery Inside the Form event Close(). ...why? What is the difference putting the code on ONCLICK() (and docmd.close) and in CLOSE() ????? Seems the same action clicking on a button....isn't it?

Tried, but nothing. The combobox not showing the new "name". Only after closing and re-opening the first form, the combobox show the name.

I think is the same...or not?