Search results

  1. R

    Unwanted blank pages in report

    This is counter intuitive but works! Thanks
  2. R

    Unwanted blank pages in report

    I have a report that goes to a new page on change of at field in the input data, which is sorted on that field. This works, but each new section is precede by a blank page. I cannot understand why this happens! The settings I use are: Help appreciated!
  3. R

    Cannot save modified form

    I was very tired yesterday when I posted my problem after an eternity trying to resolve it, and confused two things! So, the problem cropped up when i tried to make a change in a form. The Excel data that I was using to populate a simple Access set of tables (exported from an existing...
  4. R

    Cannot save modified form

    I am using Access 2019 and made a modification to a form. The change was to modify an embedded macro that opened a second form. When I try to save it I get the message: Name conflicts with existing module, project or object library I cannot understand why!
  5. R

    Processing Excel data from within ACCESS VBA

    I need to populate three tables in an ACCESS database from data held in three Excel spreadsheets. However, each spreadsheet needs processing first, removing unwanted columns, renaming columns to used ACCESS field names etc. I would really like all this, including the actual import to be handled...
  6. R

    Help with Dcount!

    Thanks to all who those who have helped. I took the recommendations to remove the field and calculate it when needed. I hope I have found all the places where it is used!
  7. R

    Help with Dcount!

    Wow - that tells me! I accept all that has been said in the above replies. In my defence, when I am producing new forms and reports that require repeated use of a calculated field I store it for speed. Not good practice but I am now where I am. And yes, the saved value has been corrupted so...
  8. R

    Help with Dcount!

    I am trying a simple update task to count the number of records in linked table that belong to one record in a master table. The master table is of Members, the linked table, GroupMembers, is a list of groups that each member belongs to. A simple one to many join. I have tried the following...
  9. R

    Reformatting data fron one table to a new table

    In response to the two replies above....... No it's is not a badly designed table, just big! A lot of the fields are user selectable options that guide the processing carried out within the system. Yes the system does have import facilities but the codification of data is substantially...
  10. R

    Reformatting data fron one table to a new table

    Sounds simple but........... I have an existing database with a membership table consisting of about 40 fields. I want to transfer this data to a new system using Excel as the interchange mechanism. The corresponding table in the new system (not Access based) consists of about 70 fields. Some...
  11. R

    Counting linked records

    Many thanks. All obsolete records gone!
  12. R

    Counting linked records

    Thanks The reason for storing the result is that I currently have a form that shows the member details and the count of groups. However, it will not let me delete a member's record, presumably because the entry consists of data from two tables. Therefore I was going store the values, then...
  13. R

    Counting linked records

    Having passed a big birthday this week I suspect I am getting too old for this game! I cannot figure out how to create an update query that will count the number of linked records and paste this number back into the master record. The master records are a list of members of a society and the...
  14. R

    Subform combobox problem

    Thanks Mark. I am now away for the rest of the week but will have a go when I return.
  15. R

    Subform combobox problem

    I have a form giving details of an academic group, with a datasheet subform showing the pupils in the group. The subform holds the pupil id number and his/her full name. Currently the pupil ID is entered and the full name appears for confirmation. I would like to be able to enter new pupils...
  16. R

    Encryption issues

    I have an Access database which is encrypted and therefore needs a password to open. I can do this successfully, but when I choose to compact the database the password is rejected. This is a new event, having worked perfectly for many months. Any ideas?
  17. R

    Output Query to two Excel spreadsheets

    My goodness, that looks complicated, and I am trying to pass over my work to a less experienced person! I have persevered with a simpler approach with partial success. The code to eliminate duplicates and write to a second worksheet will not be a problem, apart from not being able to close down...
  18. R

    Output Query to two Excel spreadsheets

    I currently remove them in Excel using a standard Excel function. I am keen to do as much processing in Access as possible to simplify operation for users of the system, which is 98% Access based. In Excel, I would use three sheets. Raw data on Sheet 1, copy it to Sheet 2 and remove duplicates...
  19. R

    Output Query to two Excel spreadsheets

    There have been a number of postings regarding outputting data from Access to Excel, but my problems is slightly different. I want to output email addresses to MailChimp, but my members database contains a number of cases where two partners use the same email address. MialChimp does not allow...
  20. R

    Inserting records into Access table from Excel spreadsheet

    Yes!!!!!!! All solved. Thanks guys.
Top Bottom