Search results

Add forms! in start of the name of control like [forms]![DB2 FORM]!ORNO

Here is a quick sample for you

Not visible

For example I have a pass through query named "LedgerQuery" I use a form to provide start and end dates for the report which is based on that query I use the below mentioned code for this CurrentDb.QueryDefs("LedgerQuery").SQL = "Select * from Table1 where LedgerDate between " &...

You have to creat an extra field named voucher Number like you use in double entry accounting so your table will look like this ID |Voucher_Number | date | account | sum -------------------------------------------------- 0001 |0001 | 20-04-10 | wages | -50 0002 |0001...

Your parameters will be on server side or you can change the sql of your query according to your parameters using vba

Can you provide detail of your tables

Paste the function below in a module Function GetMonthfromDayofWeek(WkNum As Integer, DyOfWk As Integer, Yr As Integer) As Integer GetMonthfromDayofWeek = Month(CDate((DateSerial(Yr, 1, 1) + ((WkNum - 1) * 7)) + DyOfWk - Weekday(DateSerial(Yr, 1, 1)))) End Function and use like this in your...

you can do this very easily in the report creat a text box set its control source to =1 and set its running sum property to over group or over all

While in query design view double click on the join between tables and select show all record from table 1 (this is your table name)

can you post a screenshot of your query in design view

What error is being displayed

You cannot do this through sql you have to use ado in vba moreover syntax of your check is not appropriate

You cannot view constraint you have to add or drop constraint in code using ADO You can refer to this thread where I have provided code to Add or Drop constrainsts and there is also some more useful information

Where does this beginning balance come from and if A is repeated more than once then you want sum of all qty or want to show each individual item

and what is the query that you have designed for different years

If you tell some detail what is your table structure what is your data what are the logics and what are the results you want to acheive then I can be more specific

First you have to loop through recordset to retrieve the year in which your required total is achieved then using that year you have to perform further action or run a specific query and instead of saving queries you can also build sql string dynamically to achieve what you want

Yes possible but using coding in vba

I dont think there is any limitation can you upload the sample