Recent content by marleyuk

Hi, I'm struggling to produce a report that pulls out pre defined fields from the active record displayed on a form and attach / embed to an email. Can somebody point me in the right direction please? Thanks Ian

Hi, I am working on a database which has two tables used as part of a registration and login process. I would like a couple of fields from table one to automatically update in table two, once the fields in table one are populated without using an 'on click' event. The reason I would prefer...

Thanks for the responses. Do either of you know of any examples of this working?

Hi, I have a database that uses a table to capture work by reference number. I would like to be able to allow users to only be able to see work they have been allocated. Can anyone point me in the right direction please? Thanks, Ian.

Hi, I would like to make an append query to piece together multiple tables into a holding table, once the command button is clicked. Can anyone advice a) how to make an append query in vba, b) Does anyone know how to call an append query on click of a command button? Thanks, Ian.

Thank you! This runs perfectly. This function literally copies the entire database, which is fine now as its small, but if it grows might be a bit more difficult. Is there a way of just backing up the tables within the database? Thanks, Ian.

Hi, I'm having a few issues getting the below backup module to work and hoped someone might be able to point me in the right direction. I've got it setup to launch on button click. I'm getting a path not found error on the following line 'aFSO.CopyFile sourceFile, destinationFile, True'...

Hi, I was wondering if anyone has seen any examples of people using an access database to calculate income tax? I'd like to be able to input the amount I invoice each month into a table and it would calculate Vat and Income tax due. I'm sure its been done many times before however I cant find...

Thanks Rainlover, i've done this and as you say, it works fine. Just abit irritating to have to delete data from the tables before I import the data into them. Is there a way to make it so onclick, a button deletes the contents of a table and then asks which spreadsheet I would like to import...

I made a database to compare two sets of data. The data is generally compared via reference and the reference can be a combination of letters and numbers, I'm using the default wizard queries for identifying duplicates and missing cases. This works however the tables are still showing errors...

Hi, I am putting together a database for a debt management project i have for a few clients. I am trying to help them to challange banks regarding different issues. So far i have created 3 tables; tbl_Clients tbl_PPIComplaint tbl_Charges One client can have multiple complaints and I want...

I was hoping there was a cheeky script that i may have been able to use. Like paste a bit of script that would make it remotely accessable? or do i have no chance?

Yeah but as i cant really use SQL, anyone help with access?

I only need a couple of users at anyone time. Possibly 2. I want it to be as easy to setup as it can be.

Ive got a medium sized database that i use to keep a record of customer details and services i provide made in access. Id like to make this a server and be able to remotely connect to it from other locations. Any ideas on where i can start? Thanks, Ian.