Search results

private sub () Dim db As DAO.Database Dim header_jv As String Dim Details_jv_1 As String Dim Details_jv_2 As String 'Header Variables Dim Bill_Number As String Dim branch_id As Integer Dim Bill_Date As Date Bill_Number = Forms("Bills-or-Expenses").Bill_Number branch_id =...

would you please give small example with attached fill

how to make data enter two relational tables using insert into statement i have two tables for invoicing one for invoic head data and other table for invoice items and details so how to use insert into with in two tables they are related

thanks dear but i have to search more because i need to but at least two lines like accounting entries a line for debit and a line for credit so if you have clear idea how to use select with insert into to put two lines

i have seach online and google bard i found that you can do same as i do but how i will use select the data i want to record on a form not on table

here is the code trying to insert two line in same time by the way one line is working but when trying to add another line it give error 3137 "INSERT INTO test_table_transactions (T_Account_Number ,T_acc_sub_number,branch_id)" & _ " VALUES ('" & Account_Num & "','" &...

database ready i just want to create accounting entry upon saving invoice data to invoicing tables so i need to save some data on my current invoice form to another table not related to invoicing table i think i can use code insert into or DAO recordset like that but i need some one have...

keys but i need the concept of saving data in another table to connected to form

i need simple way to save data to another table in my database i have form_1 saving data in table_1 but i need to take some data on form_1 and save it in another table_2 i need also to edit the data in table_2 if edit the form_1

would you send it to me if you have small eample like 1 form record vendor service bills currently i am saving two tables first bill header table second bill details i want to make voucher or save in another two tables accounting entries vouchers header table + vouchers details

i will explain but first of all to understand what i am going to say you should be accountant or ERP CONSULTANT . all of bills or sales invoices forms should create an Accounting voucher for example if you receive bill from vendor as you received a logistic or transportation service you...

Hi dears I have form for invoicing or bills For example logistics or transportation bill I need to make automatic accounting vouchers after saving the bill I have every thing ready like the item linked to accounting number and vendor linked to accounting number but need idea

Hi Dears Good Day how can i deal with this Error unable to create accde file i want to convert my access project to exe file

Dears Good Day are there any replacement for Navigation Forms i need to collect all my forms in one place with out changing for example Critreia & parameters in my Queries from [Forms]![AccountingReports]![datefrom] to [Forms]![MainForm]![NavigationSubform].[Form]! i have many...

thanks for your reply forget about delete button do you have access database example how to make this

Drears good day i already have many forms i want to put them in one form or navigation form or i use form with Tab control at the end i want to make one save button for all forms one delete button for all forms one search button for all forms thanks in advance

it is done thanks for all of you

where i can run this query it give me message operation must use updateble query how can i use updateble query i already have normal union select query as PIC how do i run this SQL Statement to affect the query by new data

hi dears good day i am asking if i can if there is null on column (name_english) then the yellow data move from (Chart_Name_English) column to the Null column please look at PIC attached

I USE Query Design Criteria can i do the same in Criteria ??