Search results

I have VBA code to create an Access database from three Excel spreadsheets. This has worked successfully for a good while. One of the Spreadsheets, obtained from an external source, contains a header row above the column headings and two comments rows at the end. The user sometimes forgets to...

I have a form that displays statistics on a table using Dcount, including looking at missing data. On a general point, why is the first parameter in the Dcount function required? Naming the table/query and the selection conditions is surely all that is needed? I have created a number of counts...

I have imported Excel data into an Access table and the text fields come over as short text. One field contains chr(10) to separate two names. An Access report does not respond and the two names are concatenated. If I use MsgBox to display this field it displays correctly on two lines. The...

I am extracting data into Access from an external system where the data is presented in an Excel spreadsheet. One column holds a name in text format, but very occasionally there are two names (don't ask!). In the external spreadsheet the names appear as two lines but when used in an Access...

I am sure this has been covered before but I cannot find exactly what I need, which is simply to create and populate an Access table from an Excel sheet i.e. using the field names from row 1 of the Excel sheet and the data from subsequent rows. I need this to run from within the Access environment.

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!

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!

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

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

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

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

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

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?

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

I am sure this has been covered many times but I can't seem to find the answer. I have an Excel spreadsheet and I want to import the contents of Sheet 2 into an existing Access table. I can achieve this by using standard Access menu options but I want to achieve it by using VBA so it can be...

There seem to be many ways of tackling this and I have tried a number without success! I have run a membership system and will be allowing subscription payments to be made via online banking. I can download bank transactions into Excel and then upload these into an Access table. However, the...

I have a form with about 20 controls and I set the tab order quite successfully. After adding 4 new controls, I am having problems with incorporating them in an overall tab order. If I put the cursor into an original control and click tab order, I get shown a list of the original controls only...

I have a club member table that has entries for both husband and wife, with separate member numbers. Each entry records the member number of the other half of the couple. When in a form that displays one of the couple, I want to click on the partner number field and refresh the form with the...

I have written some VBA code to send a personalised email with a personalised PDF attachment to 500 members of an organisation. It works! However, I am concerned that the spam police will get involved and classify many or all of these as spam. Has anyone any ideas on whether this is likely to...

I have an excel spreadsheet from a bank, from which I can extract membership renewal payments. My task is to update the membership table with dates and amounts paid. What would be the best approach to this task?