Search results

Steve Just got back and had a play. Good news:) Am aware of normalisation. Think I had mine correct (Touch Wood) as the data held in tblMatches is mainly primary numbers from 14 other tables and will only be relevant to that particular event in that mixture. Revisited the Players form. Looked...

Steve Its for organising inter club golf matches. Form A has combi boxes for up to 20 players on each side. Each event is a single record in the Matches table so its mainly numbers referring to other tables. The drop down for the combi will display Player name and handicap plus hidden columns...

Access 2010. Popup Modal Form A records data to tblMatches has combi Boxes. An update of a combi causes a couple of routines to run which add part of their of details to two textboxes. This All works well. If there is a change to details, double click on the combi opens popup Form B to edit...

MarkK Thanks again for your response. After los of testing and failing finally cracked it. The issue as you so rightly stated was rerunning the procedure. I could not trap the error within the exporting procedure. My data was only 6 columns on one page. but there were two runs to print or...

MarkK Thanks for the response. I tried printing directly which failed as it was too wide. I'm not sure that is the case with my code see below. I thought my code would start correctly as I set the numbers at the beginning of the code. Or am I missing your point? I did reduce the left value...

I have a report that I can see in PrintPreview but it will not print or export to pdf word etc with a rendering issue. It is a single page report split into 6 columns. I pull data to the top of each column only. The rest of all columns have 26 boxes (Rectangles) In the detail format section I...

Hi I have used access 2010 including VBA for several years now and have found my self searching these forums for a particular issues. All my VBA is self taught. I hope to find more answers in the fullness of time BLS