Search results

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

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.

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

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

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.

Hi, I'm attempting to make a fairly simple database for my small recruitment company. At the moment, users complete a registration form online, this is then mailed to me along with an upto date CV. I would like to make a database that i can then fill out the relevant records for users, then...

Hello, ive done a bit of access before but ive got myself a bit confused on my next step. I have a database of books that i loan out. I have a table containing the books instock. I want to be able to loan out book s and reserve books. The problem is whats the best way to do this? Should i have...

Hello, i have a small database thats purpose is to show when a book has been returned to me. I am recording the date that books are loaned out. Books are loaned for a 2 week period. I dont know if it would be easier to just manually put in the date that books should be returned (so that means...

Ok, I am importing dynamic amounts of data into a table, i normalise it and run queries on it. I want the results from these queries exporting to seperate worksheets. So if there are 15 columns of data imported i want them to have queries run on them (minus the first 2 columns because they are...

Hello, im having a real problem running a certain query in access. My database is used to monitor drain spillages, and the query im trying to build needed to look down a column and show descrite water spills. A descrite spill is when water spills for a bit then stops. I need to show how many...

Hello, i need a little help with a couple of sql queriesn that refer to the pervious rows. I have a table that imports dynamic tables, and i need to query this data. The tables have been normalised and ive made 4 queries. I now need help with a couple more. The database ive made is used for...

Is it possible to open a excel template, transfer the data into it, and then run a macro already created on the template? Code so far: Dim strPath As String Dim xlApp As Object Dim xlSheet As Object strPath = "C:\test.xls" ------- I can imagine its a change here ------- Set xlApp =...

Hello, im importing a .csv file into a table and running queries on the fly. I have 2 static columns and the rest are dynamic. I want to count the amount of fields from the original import, remove the 2 static fields from the count, then use the count number to make that amount of column...

Just a nice little score prediction. Im thinking Fowler and Crouch both getting hat tricks, gerrard getting 2 and carragher getting 1

i have a database that imports files with dynamic amounts of fields, runs querys on the data and outputs it to a speadsheet. The The problem is instead of making it run querys on each column, i have it running on them all collectively. Now i want to change it so a query is run on each column...

Hello, i have a database that imports a file, the file is added to a table and then queries are run on it. From here it is exported into a .txt file. The file im importing and processing is about rainfall over a 25 year period. Ill attach some test data to this post as a example of what it looks...