Search results

No its not checked, i cant understand why it won't open though, really annoying. Im only just learning access and have little knowledge of Excel so unsure what it wrong. Thanks for your response anyway. :)

Thanks adamlaing, you have solved a problem i have had for weeks!!! :)

Yes i always search the forum before i post and have found many solutions that way...unfortunaitely i did not know what the problem was in the first place so could only search 'excel links' and 'links' and came up with nothing suitable. Thanks for you response, i will have another bash at it :o

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 Pat, It works perfectly...thank you very much for your help again! i wouldnt have known where to start. :o

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

Sorry im confused. Which bit of code should i be using...also on my on-click event where Seth told me to put it, mine goes to the macro which the button is based on. Thanks for both your responses by the way

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

On the properties of your form, set data entry to yes :)

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

Thank you very much...that worked perfect.

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

If i understand you correctly, this is what i would do. On the field where date and time picker is picked from, make this an unbound fieldie no recourd source. On you query under the relevant field for example date_time, for the criteria put: Like [Forms]![your form name goes here]![the name...

No problem! :D

On the properties of the form, for data entry choose yes

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

Thanks so much! im so dozy! How did i not know that

Thank you both for your help :)

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

=Int(CSng(([txtDateDel]-[txtdateRO])*24)) & ":" & Format(([txtDateDel]-[txtdateRO]),"nn")