Search results

We have a number of procedures which are called from a form via buttons which trigger events to call the procedures. These have all worked well until we have changed the Window Mode of the form from Dialog to Normal (to enable scroll bars to show when the form won't fin on the screen). The form...

We have been calling a main form to manage yacht races using a hyperlink/macro from a selection form which lists all the yacht races The main form was too big to fit on some screens so we changed it to pop up mode to allow it to be resized and use scroll bars. this works well when the form is...

Thanks. It worked a treat Regards Solar Paul

We have a system which calls a form from a hyperlink. The called form opens in Dialog mode (a box with a border which "Overlays" the screen). It has been working well until now when a new user has started using a computer with a smaller screen which can't display all of the dialog box (they...

Hi I've created a report which shows zeros in various columns where there aren't any values to report. I think the report would look better and be easier to read without these zeros. I would like to suppress them and display blanks instead. I'm not sure how to do this. Can anyone help please?

Is there a built in function which can be used to create line numbers in a query? I've written a query to calculate year to date (YTD) points for yachts in a series of races and sorted it in descending order - so yacht 1 is coming first, yacht 2 is coming second etc. I'm looking for a way to...

Thanks Paul Sounds like good advice. You've helped me out with this

Thanks Paul Your suggestion is working a treat. I can now add my count but it is returning either a zero(0) or #error rather than a null which would be much easier to read in a report. I'm having trouble getting it to return a blank if not one of the tested values. I would appreciate any...

I've created several expressions in a query to test for values in a field (one column for each value for use in a report). The expressions output the value 1 where the test is true. I planned to sum them to establish how many times the value is true but this isn't working. I am only offered a...

I am using datasheets in sub forms. When exiting and reloading the form a filter on a date field is being dropped. A sort of the same date field is retained (I think). Is there a setting to get the form to hold the filter without VBA programming? Background: the form is basically a list of...

Hi Dave Thanks for your response. I have comments about the alternatives you raise as follows: 1 Access Web apps don't support reports - I presume they will at some stage but I don't know when 2 My colleague who has undertaken to write several VBA programs for key functional areas thinks that...

I am interested to get a better understanding of how to make an Access system available for multiple clients. Here is some background: * We have nearly completed developing an Access system * It was originally intended for one user (our local yacht club) * Other clubs may be interested * Rather...

Thanks guys. Your input has given us the confidence to go ahead with the numeric IDs as primary keys. There do appear to be advantages with this approach and it sounds like the problems are few and far between. FYI we are using these fields as foreign keys in other tables and have embraced...

Hi I've built a system with around 20 tables in it. All of these use the standard ID field offered by default by Access as the primary key. A friend with a background in database design and development for large corporates using Oracle has reviewed the database (he is going to do some VBA...

I can't work out how to update the selections available in a combo box as follows: I use a combo box in a main form to select a record (yacht) If it's a new yacht then I use an event linked to a button to call another form to add the new Yacht On exiting the Yacht Maintenance form I return to...

I have created a form (races) with a subform (yachts in a race) to edit data in joined tables. It seems to be working well but I am having difficulty selecting which record to edit in the main form. I can scroll through the records until i get to the correct race but this won't work well when...

Thanks for your detailed response. Things have changed a little since my original post. It looks like the club will host the database in-house and make the system available over wifi for local use and a wide area network using RDP for remote access. So for now we will be building the database as...

Thanks CJ There are off-the-shelf systems and off-the-shelf systems. Most I have found focus on the more traditional style of yacht races with massed starts and staggered finishes. Handicaps are then used to determine place getters. Pursuit racing (staggered start with finishing order the final...

Hi I'm totally new to Access (no hands on system development background and still waiting for my copy of MS Access for Dummies to arrive). But I'm retired from a lifelong career in IT (business process, design and project management), am prepared to commit to putting in a good deal of effort to...

Greetings from Down Under I am actively involved in my sailing club and have been setting handicaps for their Sunday pursuit races over the last year. Although there are a number of off-the-self systems around none of them provide the level of functionality I would like to have available for...