Search results

Just to make matters worse..... RNLI (Lifeboats for our American cousins) and Mountain Rescue, amongst other essential emergency services, are also funded by charitable donations. Over this weekend, 2000 people decided to do fell running for "charity", in one of the worst stoms this year...

Long winded solution, but should work..... Use DateValue to get the serial number. This should have digits to the right of the decimal place. E.g. 9th Oct 2008 14:12:00.345 = 39730.591671 If you used the Int to remove the bit to the left eg myDate = DateValue(#09/10/2008 14:12#) 'I use...

This works for all dates, 30 days or less. cell Value Is>less than or equal to>=Today()+30 To make this highlight just one day, change the 'less than or equal to' to 'equal to'. HTH Art

My god I'd resign if they took me down to 5 weeks PAID leave. Next year I am due 64 days PAID leave (not including 2.5 privalege days (Queens Birthday, Maunday Thursday and 1 extra at Christmas). How did you know I am a Civil Servant? Art

car Crask - brilliant!

I also have heared that the Queen has given Camilla a wedding present... A weekend in paris with a chauffeur driven Mercedes!

Much in the same vien as the LST TESTIMOMY. A BBC male news anchor was noting how the weather was warm and wet, he then turned to the femal weather presenter to ask whether she was warm and wet too!

Bet the Lion Tamer was p*ss*ed :D

I do something similar, but as I need to distribute the spreadsheets within my organisation I decided that I didn't want to distribute the macro code as well. Therefore I got excel to create a new spreadsheet and wrote the data to that. That way you can keep the spreadsheet with the macro code...

String Can't resist this one: A piece of string wearing a Tux walks in to a bar and asks for a beer. 'Certainly', replies the barman,' but, execuse me, are you a piece of string?' 'Yes', replied the string. A few minutes later another piece of string wearing an Armani suit walks in to a bar...

Folks, do any of you know of a work-flow or diary solution, perferably for free? I have a process that uses standard gateways and could design a checklist to ensure that all the correct hoops are jumped through, and who jumped through those hoops, and when. But if something already exists that...

Greetings, I have had a search through the forum and I *think* this is a new question. Like others I am holding a user ID and password in a table. So that people can't just open the table and peek at everyone's passwords I'm wanting to encrypt the password field. 1) Is this possible, and can...

Hi Folks, I want to call eith PSP or Adobe Photoshop causing these applications to open with a filename taken from a column in a table. I am having great problems trying to work out the DDE calls. Can anyone either tell me what the DDE should be or suggest another way to open these graphics...

The VBA help (must press F1 from within your VBA window) is pretty good. Use this forum to get started and use the Help. Also there are loads of *free* examples all over the net. Get these and work through the code with the debug tool. VBA is quiet easy if you have ever done coding before. Art

Is this as simple as Set RST = db.OpenRecordset("Select * From [users]where [user]= '" & Forms!usersignin!User.Value & "'") ??? or caption ??? Art

Your SQL is, or can be, a string so you can use string concatenation. Like this: dim sql1 as string dim sql2 as string dim db as databse dim rst1 as recordset dim rst2 as recordset set db = currentdb() sql1 = “SELECT * FROM [tablename] WHERE [EmployeeID] = 1” set rst1 = openrecordset(sql1)...

You might want to try looking at this URL. I had my first quick look yesterday and there seemed to be plenty of stuff on date handling. http://www.mvps.org/access/toc.htm HiArt

That's not all, I can't dim a recordset either! I've taken to using varients to get by, e.g. DIM dbs AS VARIENT. What a jolly good question. Here's hoping for a good answer! HiArt

I'm fairly new to access myself so I'd be interested in ways of doing this. I would call a pop-up form as part of the form open procedure. To sotre variables across forms a create a module called GlobalVar. Inside this module is a procedure called GlobalLoad. Put nothing in this procedure...

I want to change the field properties on a continuos form put only for fields that display a certain value. For example, I have a continous form displaying 20 rows, a Yes/No field could be "N" and i want the background colour on these feilds to be Red, otherwise (i.e. = "Y") the bacground should...