Search results

thanks, this solved my problem, now working fine

thats right, second combo box is un necessary, so i am changing it with textbox

Dear All, I have two combo boxes on a formA, Combo A row source is id, number and name from tlbA, Combo B row source is id, name and number from same tlbA, but i applied criteria that Combo B shows only related Name which number is selected in Combo A, (Working FIne) i set the limit to list...

firstly I will get invoice number via Inputbox, to be repeated InvoiceNo = InputBox("Enter Previous Sale Incoice No# to repeat", "Enter Invoice") here I will get next/New PK SaleID value for parent record NewSaleID = DMax("SaleID", "tblSale") + 1 here I will insert new record into parent table...

I saw in db from where I took this code, that it is used to add incremental value in PK field SaleID. here is the design view of tblSale my PK field is SaleID, and SINo field is for Invoice numbering . I need oldSaleID variable as I have to store SaleID value where InvoiceNo will be equal to...

I found another code in a database which is published in public drive, i modify and added some more code in it according to my conditions. the code is as under; Private Sub Command602_Click() Dim strSQL As String Dim NewSaleID As Long Dim OldSaleID As Long...

dear i am unable to understand this sentence, sorry for that, using append query with paraments, is very difficult for me, so did not used it and cannot comment out the result. thanks for correcting me.

yes i need to use append query to supply old and new ids, using parameters, but it is very difficult for me, how to use append query using parameters as it is mention in the bottom of the code provided by mr. Pat Hartman -------------------------------------------------- The query: INSERT INTO...

i do some more changes in upper code provided by mr. Pat Hartman, Private Sub Command597_Click() 'Code Received Via Mr Pat Hartman, Access-programmers.co.uk On Error GoTo Err_Handler 'Purpose: Duplicate the main form record and related records in the subform. Dim str2Sql As...

here i will try to simplify my db condition. i have two table tblSales, with these fields (screenshots) tblSaleDetails, with these fields i designed main form with its subform >main form is based on tblSale via Query >subform is also based on tblSaleDetails via Query >i need to repeat...

dear i tried to modify this code according to my database, but still unsuccessfull. the modified code is Private Sub Command597_Click() 'Code Received Via Mr Pat Hartman, Access-programmers.co.uk On Error GoTo Err_Handler 'Purpose: Duplicate the main form record and related records in the...

hi members, i want to duplicate form and its subform record where invoice number matched, but i am facing an error 3201, you cannot add or change a record because a related record is required in table tblcustomer..... while this code rstSale.Update got highlighted yellow. my code behind click...

dear members, some of mvps like Richard Rost recommand to avoid aggregate queries and dlookup functions in splitted database. then what are alternative of these important features. please guide.

dear members, my problem of blank subform solved, there is error by my side, as i did not notice record locks was set to = All Records, i change it to edited records. now working well, thanks to all

thanks to all for help, i just removed the unnecessary table of tblprice&pack, now its working ok, now i will apply unique index by using indexes dialog in related table design view. do i remove [Enter....] from parameters? in future i will do that, when i select any product then get sale...

here it is PARAMETERS [Enter SaleID] Long, [Enter ProductID] Long, [Enter Qty] Long; INSERT INTO tblSaleData ( SaleID, ProductID, Qty ) SELECT tblSale.SaleID, [Enter ProductID] AS ProductID, [Enter Qty] AS Qty FROM tblSale, tblPriceAndPack WHERE (((tblSale.SaleID)=[Enter SaleID]) AND (([Enter...

dear members, i am using this append query in start it was working good, but after few days, now it is behaving like this and adding about 32k records in one click. what is going wrong with it.

i distribute each user an seprate copy of front end as .accde (executable) files

my settings are same

i just received this message while opening old sales order form in second pc