Search results

Sorry, I was using short hand :o the actual code is: Dim vFormObj As Form Set vFormObj = Forms![frmRebalMaster]![frmRebalSubReportObj].Form ' Get values from the Calculator form and assign them to ' corresponding textboxes in the report txtPortfolioTotal =...

Thanks Pat for your reply, Yes the form is still open. Like I said it works when the report is opened in acPreview mode but it doesn't work when it is opened in acNormal mode which sends the report directly to the printer.

Hi, I have a report with a number of calculated fields, and information that is pulled from the form that calls the report. Pulling the information is done in the Report_Load() event by setting the report.txtBox = Form.txtBox. When I open the report in acPreview all the calculated fields are...

I ended up resolving this in a completely different way. In essence I am running 3 INSERT queries, to insert data into a temporary table, for each client independently: - First all records that match between the two tables (Join) - Second all the records in Test 2 that are not found in Test1...

Duly noted. My apologies.

Thanks nanscombe, your suggestion works great with the data from the original example. But it looks like I need to know the client for each block of data. This is what I got as the results: Key FK Client Data Display 8 52 Null Null Always 1 21 Bill Yes Always 4 32 Bill Yes Always 5 33 Bill...

Thanks Plog for your suggestion. I tried it out thought I modified the query to include a client field to simulate the multiple clients aspect of the problem. I ended up creating tables Test1 and Test 2 in he database for testing and changed the field K to Key. Here is the modified SQL...

OK, this is a tricky one, but I am hoping someone else might have seen something like this. I am joining two tables but I need to be able to control (turn on or off) certain records returned by the query. I will try to illustrate: Table Test1: K FK Display 1 21 Always 2 22 Always 3 31 Only...

Thanks JHB for your comment, The Print preview does not work (yet - I get a "You can't set the Record Source property in print preview or after printing has started" error) but I did just print it and the boxes expanded as they should. So the Report View does not support the "Can Grow"...

Hi, I am working on a report that will have 16 sub-reports, one right below the other. Because of the complex nature of the calculations in the groupings it seemed easier to "build" the report using vba rather than using the report's built-in grouping ability. The issue I am running into is...

Thanks JHB, Well as it turns out, and I am keeping my fingers crossed, the user has not experienced the form opening since she logged in this morning. So I am hoping it was solved by the "did you reboot" suggestion. I am going to keep an eye on things and if the problem refrains from...

Thanks JHB for your response. The curious thing is that we have not been able to determine what user action causes the window to open. Like I described above it looks like the VBA editing window except without any of the tools or menus. No code is highlighted as far as we have been able to...

I am am not sure if this is the place for this question, but I am not sure where else to go with this. I have a MS Access VBA database/application which has been running pretty good. However, today, for no real apparent reason the MicrosoftVisual Basic for Applications window keeps popping up...