Search results

Ammended sample is attached

Can you upload your sample database

you can not get data from query on which ledger is based because it doesnot have the opening transactions it is filtered to show transactions which are between ledger period

Yes you can just replace the name of query with the table name

you can use a update query or sql statement to update table

You have to make only one combo and set form view as continous or datasheet then you can add as many records as required

Can you explain in detail what are you trying to do

You can creat it your self open the table in design view go to table properties set property sub data sheet there you have to set the master and child fields there

change the control source of second combo

Its a union query in access it cannot be viewed in design view However here is a quick sample for you using Dsum

You can use dsum or a query to get previous balance Take a look at my sample database Sample Accounting Application It has a report which shows opening balance as per date selected

Creat a seperate table for features and assign groups to them

you can change the sql statement used for filling the list view to incorporate this

Sample is attached

Assuming the name of your list view is ListView1 and name of textBox is TextBox1 Code will be as follows To get the data in first column TextBox1 = ListView1.SelectedItem To get the data in Second column TextBox1 = ListView1.SelectedItem.ListSubItems(1) In your as visible in picture...

What partial characters you want to match

Attached is a quick sample for you There are two queries in database first one calculates year,month of year,week of month, day of week and second (ComparisonWithLastYear) shows you the results as required by you by getting amount for last year and calculation growth rate

I cant guess I have to see whats happenings

you can check your self where the code breaks by stepping into the code and by the way how many assets and customers you have in database

what is the size of file