Search results

Hi all, I have added about 15 links on a form, linking to word and excel documents. The word documents open fine but all of my excel documents pop up with a messae saying the file cannot be open, yet when i just go to the document on my hard drive they all open fine...does anyone have any...

Hi all, I have a problem which i hope someone may be able to help me with. Basically my users currently look at their sales statistics by looking at a query based on the table where they enter the records from. As the sales figures change, the values in the table change, because the table...

Basically i have a form which logs error corrections. The users enter a 'date received'. My user has now asked to have a date due to automatically be calculated by adding six days. I have done this with no problem: =DateAdd("y", +6, [date received]) My form is not unbound, this date due...

Hey. I have created a button which when clicked imports a table from Excel into Access. Every month the users want to click on this, they want to update the Access table with the updated info in the excel table. My problem is that the whole table is imported again and not just the new rows...

Hi all, At the moment i am trying to produce a button which my users can click on to import some data from Excell to Access. When i just go through it manually, ie file> import etc, the table fom Excel appears in access perfectly, but when i try using my button it brings up the following...

Hi all, I have two date and time fields which format are like: 15/09/05 09:48:43,I have another field which calculates the time difference between these two fields. I am doing a calculation on the time difference field and want the time to be displayed as for example 03:00, but at the moment...

Hi all, In my query i have 5 different fields showing different type of fuel types, these are checkboxes on a form. I have another field which shows the 'dry time' (this is calculated on two other fields, the time of runout and time of delivery) What i want to to is have a selection...

HI i was wondering if anyone could help. I am doing a database for a fuels company. They want to know when fuel has been dry for over 24 hours. There is a 'dry time' field which is actually calculated off the runout date and the delivery date. I thought i would simply have to put >24:00 in...

Hi all, I was wondering if someone would be able to point me in the right direction for my problem. Basically i have a table which shows all of the products sales within a given period, my user currently has to pick out the sales manually of those sales which have been sold out. His criteria...

In a report which asks for the users to enter a date from and date to (based on a query). Is it possible for this data to be shown on the report?

HI all, i have a really annoying proble where the solution is probably staring me straight in the face. Basically i want to produce a report where the user is prompted to enter months to be looked at within a certain period and also the years, in my query i am using: Between [First month] And...

Hi, i have poduced a report and i want to calculate some percentages. Some of the fields i have are: Total Sales Clothes Shoes Pants 200 20 120 60 % 100% 10% 60% 30% As you...

Hi all, i would appreciate it if someone would be able to help solve my problem. Basically i am reporting on sales which have happened over a year. The actual sales are recorded in a different place and im using access to report on trends and to produce statistics. Basically my users enter...

Is there any way of increasing a text field size to above 255?