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...
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
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...