Search results

You're welcome - I'm glad that I could help.

Hi - I'm an oldtime programmer so I never learned much about macros, so I'll explain code - VBA. Although I think macros are a great learning tool if you take the time to convert them and understand what is happening... When in design mode in your report, click on the Detail bar of your...

I had a similar issue a while back so I searched through my old posts and found this one which sounds like what you may be talking about. Please check it out and let me know if you have any questions that I could help with. http://www.access-programmers.co.uk/forums/showthread.php?t=162609

You have a simple one to many relationship as far as I can see. You could use the wizard to create (create your query first) the main form and a subform within it. I've used the tab structures a lot when I have multiple one to many relationships and I want to work in one form. I think you...

If you're using a combo box, make sure that you have the first column width set to zero, then the second column set to 2" or 3" or whatever you need to display your department name. In the Combo box column width, it would be for example, 0";3" On the data tab of the combo box, make sure that...

In the Detail format event, you can check the value of me.YourFieldName and if is is false, then set Cancel = true and exit the Detail format subroutine. The cancel will skip printing the row that has false, but I'm not sure about your counts you'll have to try and see.

Are you using grouping on your reports? If you're not, then try that. If you have only a detail line on the report using both your parent and child data, on each parent field, set hide duplicates on each parent field.

Hi SOS, Thanks that is just what I needed. In addition, on my form the user selects one of three types of records to look at - open, closed, or all. So when they click the button for the report, I pass an open argrument designating this to the report and on the report's open event, I...

Hi all, I have a continuous form where my users filter the data by any combination of fields and they can print the form which lists all of the rows. This works OK, but what I’d really like to do is capture the recordset clone and use the data in a report. I tried to set the recordsource of...

Hi all, I'd like to retrieve a value from an open form so I can limit the rows in my query. Here is the query: SELECT tblProjects.intProjectID FROM tblProjects WHERE (((tblProjects.ClosedDate)=LimitProjects())) ORDER BY tblProjects.intFiscalYear, tblProjects.IntProjectNo; Below is my VBA...

Thank you so much - that worked! :) I started to have some problems with this fix - the command not being available. So I tried something different. I created a dummy text field on the form where I can move the focus to prior to calling the report in VBA. I set the border style to transparent...

Hello all, I have a modal dialog form that I use for filtering data for reports. On the form I have text fields where the user can enter a search value. I use ribbons in this application which uses the logic behind a button which I hide on the form to call the report (I followed an example in...

Hi, I started to explain the callbacks to you, but I think others would benefit more if I just tell you where I got help. I bought Access 2007 Inside Out by John Viescas and Jeff Conrad. They explained ribbons and included a sample database which I was able to follow and implement...

Galaxiom - you mention temporary files in the front-end... I use them a lot as I did in my 2003 version software without a problem. I have this problem only when I am modifying code, forms, and/or reports. My users haven't had any problems at all... Do you think that the temporary...

I'm using 2007 and I've had the same thing going on for the past 1 1/2 years in my front-end database, but only when I am developing. It seems to happen when I am making a lot of changes within a report or form. The error message seems to stem around a gosub which I can never find. If I...

Have you given any consideration to using tabs on your form. This would not allow you to view all 3 forms at once, but it does save space.

You asked: How can I count the number of records that are linked to the main report, To count the rows in the subform, you can check the recordsetclone of the sub report or sub form. Here is an example of what I do in that situation. on the set rstClone line below, you should be able to use a...

Hi, I have a similar situation with the subreport. When I put the subreport on the report, I always shrink the subreport into a single line on the report. By that I mean I reduce the size of the form into a single line so when you're in design mode in the report, all you see of the subreport...

Hi all, I have a group header in my report and I have set the alternate back color to alternate rows. This works fine. My detail area is next which provide more information pertaining to the header and I'd like them to keep the same alternating color pattern as the header. In my group header I...

Thanks to everyone for the suggestions... I’ve been out sick for 4 days and now I have to get moving on this project – so unfortunately, I’ve had to create a work-around this issue and let it go. Sure does bug me though…. Maybe I’ll get some time in the near future and look again. Again...