Search results

Hi experts, I have a mainform in which there is a subform. Is there any way that I can retreive the value of the selected cell of the subform in the main form? Currently what I usually do is that using a text box and setting it's control source to that special field in the subform, we have the...

Hi, Attached is a project I'm working on. We want to calculate the total delays on each day. In a form called 'main' there is a subform for the delays on that date. But the 'Total Delays' control does not work. I have used the following format to get the total from the subform...

I tested this solution but it produces error: "Too Few parameters. Expected 1"

Wow That was fast. But how can I do this using the query name? Thanks again

Hi. can we access the results of a saved query as we do with tables such as: set docs= CurrentDB.OpenRecordesets(QueryName) ..... Thanks

Thank you for your consideration,Pat. So we have another question. Suppose we have two forms: form1 & form2. There is also a query (myquery) to be run and there is a criteria in this query based on a vlaue in form1. can we run the same query with the same criteria based on a value in form2?

Thank you. It works well. The reason to use this method is that I don't want to make the query list a long one. and this way i can manage to develop the program easier since every thing is in the code and in hand.

Hi. I want to run a sql command in my vb code using: docmd.runsql "sql command string" Is there any way to put the result in recordset variable as we do with tables: dim docs as recordset set docs= currentdb.openrecordset(tablename).... Thanks again.

Hi. I want to run a sql command in my vb code using: docmd.runsql "sql command string" Is there any way to put the result in recordset variable as we do with tables: dim docs as recordset set docs= currentdb.openrecordset(tablename).... Thanks again.

So it seems there is no way to change the color of some specific row.

Hi! I'm looking for vb code that by giving the name and path of an mdb file, links all of the tables defined in it to my database. (Access97) Thanks

Hi every body. Is there any way so we can lock one or some of the rows of a form which is viewed as a datasheet, depending on the value of one of the fields (or change other properties such as text color) ? I have to do this in Access97. But if it's impossible in 97 please let me know in other...

To have total sums in my reports, I tested the instructions in the article q132017. There are two problems: 1- Applying the instructions to the Northwind sample database works well regarding the total sums, but in the case of producing the total sums of each page seperately, on some of the...

Thank you very much for your help, Rich. Massoud

Hi; At the end of each page I want to have the total from the beginning of the report to the end of that page. Then, this total will be printed at the begining of the next page and .... Thank you for your concern. Massoud

Hi; I have created a report which has a field named Debit. When I put a text box in the "report footer" section with the following control source: "=Sum([Debit])", everything is ok and I have the total at the last page of my report. But when I copy& paste the same control in the "page footer"...

Hi everybody; I'm developing an accounting system with access 97. In one of the reports I want to place the sum of debit & credit amounts at the end of the current page and at the top of the following page. Thank you in advance for your help. Massoud