Search results

Hi @theDBguy please check your email when free.

Hi All, Please help!!!! Please I am willing to pay anyone who can help me. This is important for me. Please help

Hi @theDBguy @Pat Hartman Private Sub Command663_Click() 'On Error GoTo Err_Handler 'Purpose: Duplicate the main form record and related records in the subform. Dim strSql As String 'SQL statement. Dim lngID As Long 'Primary key value of the new record. 'Save...

Hi @Pat Hartman Insert Into TransactionsDetails ([Description],[Order Quantity],[Received Quantity],[CategoryID],[SpeciesID],[ProcessID],[GradeID],[Price],[Unit of measure],[Cost Unit],[Currency],[Total]) Select [Description],[Order Quantity],[Received...

Hi @Isaac i did read your comment and based on that only i asked you that question. i have a column named category ID in transactiondetails table and it gets the data from category table which has category 1, 2 , 3 in the form of drop-down. now whats my fault in this >??? i am trying my best...

Hi @Pat Hartman @Isaac @theDBguy Hi @Pat Hartman @Isaac @theDBguy Good Morning!! @Pat Hartman You mentioned i need to put stop before the executing lines, how to do that ? how to get the sql code for data ? @Isaac what do you mean by (hint - it's Category #1). ??? @theDBguy please...

Hi @Pat Hartman @Isaac Thank you so much for all the replies my windows just got crashed. I am sending this from my phone. I'll revert back based on your inputs as soon as my laptop is back to normal Thank you once again

I read that but & save new I'd is to store new I'd and it's not a field in my form

Hi @Pat Hartman @Isaac i tried all the possible ways mentioned but i am not able to figure out whats missing in my code what should i do ???

Hi @Pat Hartman Private Sub CopyRecord_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim td As DAO.TableDef Dim SaveNewId As Long Dim SaveOldID As Long Dim strSQL As String SaveOldID = Me.TransactionID Set db = CurrentDb Set td =...

okay rs.AddNew rs![Date Expected] = Me.[Date Expected] rs![PO Date] = Me.[PO Date] rs![Requisitioner] = Me.[Requisitioner] rs![SupplierID] = Me.[SupplierID] rs![Destination ID] = Me.[Destination ID] SaveNewId = rs!TransactionID...

Hi @Pat Hartman i want to clarify something based on the code that you gave me Private Sub CopyRecord_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim td As DAO.TableDef Dim SaveNewId As Long Dim SaveOldID As Long Dim strSQL As...

Hi TransactionsDetails is the table that relates to my subform and for my main its Transactions table so in the code that you just edited for me strSQL = " Insert Into TransactionsDetails ([Date Expected],[PO Date],[Requisitioner],[SupplierID],[Destination ID] )" --- all these are part of...

Hi @Pat Hartman & @Isaac I was able to solve the insert into error from the last reply @Isaac now it shows me error strSQL = strSQL & " Select [Description] " & SaveNewId & " From TransactionsDetails" error is on this line and it states "missing operator in query expression access"

HI All, I tried out the code mentioned above but i am getting error 3134 insert into statement error Private Sub CopyRecord_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim td As DAO.TableDef Dim SaveNewId As Long Dim SaveOldID As Long...

HI @Pat Hartman & @Isaac Thank You so much for taking out the time and helping me. is it possible to give me some explanation about which fields in the code needs to be changed? i am fairly new to access and the database you see attached above is my first database in access. i learned...

Hi @Pat Hartman can you tell me what are the steps to use DAO method ? any article or reference to which i refer to ? Thank You so much for the reply

Hi @theDBguy Good Morning please guide me on what should i do.

Sure no problem, Have a good night !!!

HI @theDBguy First I would like to thank you for your prompt response and the explanation that you wrote in your last reply. Answer to your question will be I would like to duplicate record in transactions table for headform and for subform it would be transactionsdetails table. Correct me if...