Search results

Form Sorting Items Hi, Thanks all of for your help its working now. In regard of creating each time new numbering in product subform that resets (and starts from 1) with each new invoice I will try first to code it by my self and if in trouble I will make new thread. Thank for help again, GagaZ

Grouping Hi Bob, I have registered to your website and have send you zipped file, could not do through Access-programers as file was to big. When you have time could you have look and tell me where I'm doing wrong. Thanks, GagaZ

Grouping of same Items in Form Hi, Thanks for help I removed Order By property and now its working for most of the form. There is still problem that same items get grouped. Example I have table Invoice, Invoice details, Products. Invoice details table is in 1 to many relationship to Invoice...

Hi, I have following problem: I'm in Invoice nr 1, and enter following item products: Lettuce Apple Oil Cucumber If I go out of the invoice and come back item are sorted ascending: Apple Cucumber Lettuce Oil I want my Items to stay in order as I have entered them in first place. Please can you...

Hi, Thanks for your advice, we have compromised for Quotations to be Yes/No as you have suggested. Now, in your first answer to my thread you said that my current setup is not normalized and not efficient, I'm refering to the test database in previous attachment.Having tables Inv and Pro with...

Hi Bob, Thanks, will try to talk to the ppl that I work with. I know there will be disagreement as for bookkeeping: there will be Invoice Nr 1,2, 8,9,15..... the missing ones will be quotations. Anyway Thanks very much. GagaZ

Hi Bob, Thank for reply. If I'm understanding good : example I should make table Orders with fields Invoice (Yes/No) and Quotation (Yes/No). So If quotation is getting realized as invoice just to change thick box from Quotation (No) to Invoice (Yes). Is this the way how would you convert...

Hi, Is there any way to append form that contains subform to another form with subform. See attachment. I made sample database: table Inv with fields InvoiceId - autonumber InvoiceDate - date table Quo with fields InvoiceId - autonumber InvoiceDate - date table Pro ProductId - autonumber...

Hi, I have following problem : I want to import data from one form to other in same access program. I have form 1 Quotation (in relation to Customer and Product items tables) and form 2 Invoices (in relation to the same tables) I have created Quotation (nr 125,126,127) all with different data...