Search results

Hello! I have a report from a log-book database that produces "activity Book# detail hours mileage" with running totals by activity and book#. I would like to produce the report without the details just the "activity book# hours mileage" with running totals of hours and mileage. I get the data I...

Hi, I saved a .xlsx file as read-only but when I closed it read-only then re-opened as read-only I was able to edit cells. Would appreciate pointers to what may be causing this!

Hi, I have exported data to a spreadsheet to auto populate a pre-formatted spreadsheet in that workbook from my access DB. This works! This was code I found and modified with some assistance. I am concerned that the data now relies on the integrity of the 2nd sheet in the workbook. Therefore I...

Hi, (moved this from where I incorrectly posted.) I have what seems to be an eternal problem with crosstab queries and null values. Here is my simple crosstab query. The data is one month of activity giving total hours and distance in any given month. Here is my query...

G'day all, I have stitched together code "borrowed" from the net. My little database has been running well for me with thanks to assistance from people on this forum and a lot of searching. I produce reports in pdf which has the data that is required, but it is required in an excel spreadsheet...

Hi, I am having problems with a data entry form. I am trying to prevent duplicate entries in a table the criteria has to be unique over 4 fields. Namely "BookNumber", "Date of Activity", "Activity", "Notes" these are the only fields I can combine to form a unique record index. I have an index of...

Hi, The following code works (waiting for a new record entry) when I enter it into the code window then change the form from design view to form view. But if I close the form and then re-open, it fails and just shows the last entry (or record). The form has a sub form showing the contents of...

Based on the information following, is there some way to select the date range? This procedure works in other reports that do not use a cross tab query. I am trying to generate a report based on a cross tab query, select a date range of the field [Date of Activity} SQL from Xtab query...

G'day, I'm confused I split my DB thinking that it would be safe from users fiddling. I was shocked to find that the tables can be changed, if that happens the front end would/could have problems. What am I missing and what can I do about the tables?

I did a little programming in my past employment, self taught. Been retired for 20 years and find I am not as sharp as I once was.;) I have been searching for information in the forum, currently I am designing an access database.:unsure: Regards