Search results

Hi...I have the following requirement: I have a table called "tblselectrso" with the following fields: stockno rso1 rso2 rso3 rso4 rso5 s1 1 3 s2 2 4 5 stockno is a text field and rso1 through rso5 is a Number...

Here is my requirement: I have a Table called "tblresource" that has two fields - Resource (Text) and ResourceDate (Date). Date format in tblresource goes like this: resource1 1/1/2005 resource2 2/2/2005 resource3 3/3/2005 resource4 4/4/2005 I have a form where I need to show the...

I have a form field whose value is as follows: =Nz(DSum("Capital","Capital_Act","DatePart('q', CVDate([Capital_Month] & ' 1')) = 1 And [projectid]=" & "'" & [projectid] & "'"),0) Since I am using Domain lookup function in this field, it takes considerable time for this field to get populated...

No luck yet. Its surprising to me I was unable to find a DAP expert in this forum. I am continuing to work on this. If I find a solution, I will try to post it here.

Is there a solution without using Domain function? Thanks for the suggestion. If its possible, I would like to avoid using Domain functions altogether. Any other solutions apart from using dlookup / dsum please?

I have a form based on a lengthy SQL query. I have several controls in this form whose control Source has the following formula: =Nz(DSum("Capital","Capital_Act","DatePart('q', CVDate([Capital_Month] & ' 1')) = 1 And [projectid]=" & "'" & [projectid] & "'"),0) When I navigate from one record...

Hi - I am looking for some help understanding the instructions in the msdn article on how to pass a parameter from a DAP. Please refer to the article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_PassParam.asp I was able to follow the instructions until...

Hi, I am trying to run a pass through query from a simple report that I have. The Syntax for the Pass through Query is as follows: SELECT "Assigned-To-Individual+", "Case-ID+" FROM HPD_HelpDesk WHERE "Assigned-To-Group+" = 'TEST' AND "Status" IN ( 'ACCEPTED','ASSIGNED' ) I am able to...

This is my situation: I received an Access db from a co-worker complaining she was unable to modify contents of some of the tables in it. I offered to assist her on this. 1. When I opened it, I was unable to modify the contents of the Tables inside. 'Read Data' and 'Read Design' are the only...

More details in here on my question. Please find attached a Word document that explains what exactly I am trying to do along with my test database attached. I am lacking reasonable coding experience in Access that prevents me from getting this done. Would appreciate if any gurus in this forum...

How to transfer value backward in a Report? Sometime back "Richo" helped me out on this thread and taught me how to move a value from a report footer control from the 1st record to the 2nd record and so on ..... Thanks to Richo! This solution worked wonders for me! Now, on the same report I...

Thank you. Richo - Thanks for helping me out. This is very helpful.

In record 2 there is more than one detail under Bill Of Materials. Is is always the first detail that gets the value from the previous record transferred over? Can there be more than 2 records in this report where the calculation in the footer on record 2 needs to be transferred to the first...

Database attached Richo, Please find my db attached. The field "grandtotalperunit" is on the report footer (bottom right corner) for the report "rptstep". This is a calculated field as you would see. On the first record, this value is 526.89 I want to transfer this value to the next...

How to transfer control value backward? I have a report with a control that is a calculated field. Lets call this field "b" I want to use the value of "b" in the next record for another control. Lets call this field "c" I want to assign c = b (Note that there are about 10 calculations done...

Could someone elaborate on this please? I have a similar situation to access a previous records value in the next record in my report. How can I use the "tag" property to get this done? I looked at the Help on Tag but not able to understand how this can be used towards this situation...

I am writing an Excel VBA code to connect to an Access db and execute an access query. After executing the query, I would like to display the result in the excel spreadsheet. I was successfully able to make the connection to the access db using the following code: Set db = OpenDatabase("file...

Thank you. That worked like a charm!

The report's Onopen event opens the table as a Recordset in your example. Since I am collecting the information from various tables, I replaced your table with a query. I ran the Report's Onopen event in step mode and found out that the Total # of recordset showing up as just 1 instead of 3...

Thanks for the help Pat. That was what I was looking for!