Search results

Hi, If I have a time like 22:00 and I want to add lets say 300 minutes to it; so it now shows 03:00 how do I do this? I can do it in Excel alright with the TIME function but cannot find a similar feature in Access Liam

Hi guys, I'm just looking for some general views and opinions here and would love to know what people think; advantages/ disadvantages etc. We have a system of spreadsheets traking various ongoing projects in our organisation which are sitting on 6 different regional servers. This poses a...

Hi, This is probably going to be a quick one for somebody, I had a search through old posts and couldn't find anything. I have an Access form and using a button on the form I start an instance of excel. I then have: oExcel.Visible However after I open Excel and make it visible I want to...

Hi, This is probably going to be a quick one for somebody, I had a search through old posts and couldn't find anything. I have an Access form and using a button on the form I start an instance of excel. I then have: oExcel.Visible However after I open Excel and make it visible I want to...

Ya that's where it was, thanks alot for sorting that out. It was a bit or a mystery to me...

When I open my report it keeps asking for the parameter value "intJobIDPK" even though it is contained nowhere on the report of in the query for the report. It makes no difference what value is typed in for this, the report displays the same. How can I find what is causing this or how can I...

Hi, I need to print off an ID card for every record in my database, but the pictures won't change when I go through the records. I am setting the picture using the "Report_Activate()" function, which is obviously just setting the first picture for every record. Is there a function that will...

I've often had this problem with Access D/B's before and I have used the format function to correct them. However this time the date is reverting to the US format outside in the word doc. where I cannot apply something like the format function. This is where I'm getting stuck! Liam

Lads, Here's a little problem that is driving me nuts. I know what is wrong and yet I can't fix it! I have an Access D/B and a mail merge word doc which gets its data from a table in the database. Now the date is in the correct format in the table i.e. uk/european format. The 5 of january 2005...

Ya that looks like the job alright, only thing is that when I try to use your method with my database it gives a compile error with "Dim DB As DAO.Database" saying "Compile Error: User defined type not defined". Any idea what this could be?

Hello, I have a query that returns a list of courses undertaken by certain employees. They are in the format NPTC CS 30; NPTC CS 31; NPTC 33; NPTC FTC 38; NPTC FTC 40 etc... Anyway what I need to do with this is convert these results to a string and manipulate them in such a way that they can...

Thanks SJ worked a treat Liam

Hi, This should be a really quick one for you guys... I read somewhere that Access catches carriage returns in a text field so that even for addresses that will contain more than one line, I can still catch them in a single field and they will display as multi-line values. However when...

Ken, I can do that but what do I set the date to if it is null? I still want the date field in the new table to be a null value. The following does not work ... #" & IIf(IsNull(Me!Date), Null, Me!Date) & "# ... I get run-tiome error 3075 "Syntax error in date in query expression '##'."

I have a form which contains a date field. After the user has entered the relevant information on the form I use some sql to run an append query to write some of these fields to another table. One of these is this date field. However, inputting the date on this form is not mandatory so...

Kodo, No good I'm afraid! How do I put this... it seems to me that you have to force Access to create a fresh instance of the procedure before it'll recognise it.

Thanks Pat, I've had to resort to this I'm afraid but has anyone any clever way around this problem? It would be so much handier if I could just paste the bluddy code without having to create the same procedures/events over and over again Liam

Hi, I dunno has anyone come across this problem before - maybe I'm dreaming! I have noticed this happening in quite a few db's I've developed and used to pass it off as some quirky glitch. I have been copying and pasting code from one form and using it in a second form. However it doesn't seem...

I can trap it in the button ok but I just really wanted to trap it on the form. I'm using the forms OnError event to trap one or two other such errors and I just wanted to catch them all in the one place. Why doesn't this error trigger the forms OnError event?

Hi, I have a form with a button which allows the user to save the record using DoCmd.RunCommand acCmdSaveRecord This will generate a standard Access error (run-time error 3314) message if the user tries to save the record with required fields missing. I wanted to pick this up in the Forms...