Search results

If you open the query in the file it shows all the records I want. When you switch to the design view and join the JudgeName fields between the tblJudge and tblSections two records drop off. Could any one tell me why this is happening and what to do to show the addresses for the 21 records...

PaulO. Would it be better for me to change all commands with a single line?

I want to create an Access runtime file but would like to be able to view the Tables. The attachment has a form set to view the Tables. First can I use this method to view the Tables in Runtime and secondly when I try to close this Form using the control Return to Main Menu I get a message...

Thanks. Got that sorted now.

My data for this report is coming from a query on the report. I wondered if this is the problem. Thought I had written code in correctly. Cannot open report, receiving message -------following error: Member already exists in an Object Module from which this Object Module derives. Have attached a...

I am working from a table which contains amongst other data, a number field (usually numbers are 1 or 2 but could occasionally be more). I have created a label but I would like to print labels to match the number in the Number field. E.G. 1 in the number field 1 label or 2 in the number field 2...

I have tried various combinations using grouping and sorting in the Form Design. Unless I use ExhibitorID I do not get all people getting their awards. Those with same surname get lumped together with the first exhibitor of that surname.

The attached file shows reports displayed by ExhibitorID. I have tried unsuccessfully to rearrange these so they will appear in alphabetical order. No matter what grouping I use where there are Exhibitors with the same Surname the awards are being merged into one report. E.g. B Hollyman page 25...

Can someone please help? The attachment shows the format I would like except that when you look at page 4 you will notice Class 183 and the headings Cage and Place are on this page but the actual boxes for these titles are on the next page. I would like to force that class to the next page (or...

just to advise I sorted this out. found a unmatched data in query wizard which allows me to get what I want.

The attached file shows two queries. The first qryAllSections is as it says i.e. all the Sections. The second is the Sections showing Junior Exhibitors. This data is from a Form (not included) with a yes/no box. The criteria set to yes in the query to obtain this result. What I would like to do...

Thanks. Got that sorted through a Macro but will try to work out now in VBA.

I am wanting to set up my database file in access runtime. There is a report in my file that I want to export to either Word or Excel. Is there some code that would allow me to do this?

I was using the popup and inside height to restrict size of Form on screen. Is there any other way to do this

Thanks that fixed the problem. I had set Popup to yes and in Events On Load added Me.Insideheight = 9000 to set size of Form. Once I removed that the Forms now work okay.

I am using Access 2007. I have set file to open a Form I have labeled Main Menu. From the Main Menu I have control buttons to open another 5 Forms. I have set tabs to appear across the top. What has started to happen is when I now open a Form from the main menu it is appearing behind the main...

Moved Me.requery from Form to first of combo boxes and that has solved problem.

No Bob. It is not working properly. This is what I have found so far. I have switched the Judge Combo Box to right hand side. (because it was not related to the new RiveyID) When I now click on the Add New Record a new ID appears in the subform but when I move to the add a score to the first box...

I have tried to attach a file to view what I am talking about. Not sure about the code you have suggested.

I have a main form containing a subform. On the main form I have 4 drop down list to select data from. The first three lists are used to create an unique ID for that record. At present to move to the Subform I have used a control to close and reopen the main form. I now have to use a separate...