Search results

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?

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

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

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

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