Search results

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

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?

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

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

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

Yes!!!!!!! All solved. Thanks guys.

The full path name, and other contributors have solved the format of how to include the sheet number. So the code runs, but doesn't import any data!! The Excel spreadsheet contains column names that match the table field names, but there are two tables field names that are not present in the...

I used the following statement: DoCmd.TransferSpreadsheet acImport, 9, "BankPayments", FileName, True, Sheet2! but Sheet2 evaluated to zero and gave an error. FileName was correct and taken from a filedialog command.

Yes, I looked at that, but how do you specify a sheet name?

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

I understand the point you are making, but my problem is that I cannot find anywhere where the underlying mechanisms for mechanisms such as seek can be found. The references produced by Microsoft only tell of the what a command does, not how it does it!

Thanks for the insight. I'll give it a go, although my database is not large enough to have any significan processing times on an i7 with 16gb memory.

Thanks. Being a few hours ahead of you I managed to finally crack my problem and it all works well. Being a small database (600 members) I needn't worry about efficiency, but I find with Access that the casual user gets confused by their being many ways to solve a problem and not having any...

Thanks Paul That gives me confidence to continue since it is the approach I am taking. I do need to potentially update both tables, the members to record payment (if made) and the bank transaction table to record success or failure. Initially I wrote a simple update query to action the updates...

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 finally found the problem. I have three tabbed pages on one form, and the offending fields were replicated on each tabbed page, having inadvertently been placed on the master form. Resolving this allowed me to change the tab order. Something new every day!

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

Thanks, so simple!

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