Recent content by thegooser

Hi all, I am about to embark on a bit of a project and think I may need to get a bit of advise before I do. There will be about 5 million records altogether so I think I need to plan ahead. I will generate csv files containing about 20,000 records a time. I need add these to the database and...

Ahhh...... I can't cope! OK guys I need some help :) So I have a nice simple database with a nice simple form. One of the fields on that form is an email address. I'd like a button that opens up a new outlook email and populates the to field. So if I press the button on the form the result...

Hi all. I have 32 different csv files all with the same fields. I am looking at linking all of the csv files to access. I would then like to produce one query with all of the data inside. The only problem I am having is that would like a field in the final query to tell me which csv file it is...

Is it possibale to alter a property on a field in a web table after it is set up? I want to change a normal text field to a drop down. I can see how I can do it with a new field, but I need to edit the existing field. Any ideas?

thanks for the replys guys.... I just don't understand, with my limited knowledge of Access, how I would implement this. Ideally I would like it added as another field on either a query or on the table.

Is it possible to have a time field within a web database / table? I don't want the date, just the time. Any ideas?

Thanks for the help. How would I create this and where would I put it?

Hi all... I have had a problem for a while when I was using Access 2007, but I recently upgraded to 2010 and I'm trying to solve it again. I have always linked my tables to Excel to solve this problem but I would love to do this all within access if poss. Bassicaly I have two tables in...

The first table is Jobs. So I have an exact Time, Date, and Driver fields. The second table is two date & times. One is the start time and date of a drivers shift. The other is the end time and date. So it is a table of driver name, when they started their shifts and when they finished their...

On the job total can it not take the info thats in the working times table to tell me the shift start date?

Now then.... Is it possible to do the following in Access? I have a table with working shift start and finish times. I also have a table with Jobs / sales which have a time field and a date field. My tables: 1) Jobs- a. Date b. Time c. Driver 2) Drivers Working Times a. Start Time & Date...

Is there anyway you could be a bit more specific? I haven't used subreports and don't know how to get this done. I appreciate any help anyone can give.

Yeah I checked out the template that Microsoft give for timing and billing. The problem is that I don't know how to implement it to my database. I don't know how to filter the results, or how I put the customer details at the top of the report from one table, and the list of sales as the...

Hi all, I'm trying to make a report to be used to invoice customers. I have a table of sales, and a table of customers. I need to be able to select which customer to generate a bill for, and then input the customer details into the report (name, address etc) and ten list the sales underneath...

Hi all, I have a query with a date field and a separate time field. I want ti to show results for the next two hours. The date field criteria is set to Date() which returns the results for today, but could anyone tell me what I need for the time field to return all the results within the next...