Search results

So long "Mitt The Twit" and his parade of Crazy, phew, that felt close.

Cheers John, knew it was that bloody select case syntax that was causing the error. Just couldn't work it out. Thanks again mate, very helpful. :D

I did think it was all the code that was relevant. It’s the select case statement that is generating the error. The recordset SQL statement creates a huge recordset with looks like… Surf_id, skid_esc_rv 2001, -0.01 2001, -0.01 2001, -0.14 2001, 0 2001, -0.12 2002, 0 2002, -0.01 Nothing...

Hi Guys, having a wee bit of bother with a select case statement handling a numeric range of values. Basically I’ve quite a bit of data that needs to be summarised. Per record, where each record could have 20 to 2000 readings with the same record number. There is a range, First Range: < -0.1...

Watch out for an Engineer named "O'Conner" (for example) a ' in the name will stuff up your code. User strFilter = "[Engineer1] = " & chr(34) & me!combo50 & chr(34) & " And " .... This should stop this error happening within string values. Good luck mate.

Thanks pbaldy :) So incredibly simple I couldn’t see the tree right in front of me. I was focusing on each checkbox within the frame, not the frame as a whole, stupid. Thanks again mate.

Hi all, I have a simple enough frame with four option check boxes within the Frame. It works fine, if the user selects a value within the frame it returns a value of 1 – 4 If they leave the frame with no values selected (which is the default, showing that this item is of no relevance to the...

Fantastic Worked a treat, I hate the Irish a lot less now. :D Still kidding Thanks very much for your help.

Can you explain whats wrong with the "RunQuery" method Bob? Just wondering

Hi everyone. I have hit a wee issue with an Irish name that I have just never even thought of before. The UserName is "G O'Conner" and I have a bit of VB that filters for a user along these lines Dim strName as String Dim strUserName as String strUserName = "G O'Conner" 'Function to get...

I wish Bill, I wish. And I have to agree with this wee Aussie blogger that perhaps its just a antipodean thing and we are just a little tougher.

Not really a good look skinny white boys doing a Haka, but if they get into the next round I would expect to see a Haka at some point. That's said, and I try here not to detract from the effort that is being put into this tournament by most of the teams and players, but soccer is GAY. And I...

Wow - New Zealand held Italy to nil all. To be honest, as much as this Soccer world cup is interesting (bit like watching the Winter Olympics once every four years), rugby is still the focus of most kiwi's hearts, it would be a strange world if soccer were to take hold. Anyway, drawing with...

No prob' mate. It was as I suspected. Thanks for confirming for me guys, I thought I would ask before I made an assumption. I will have to have a think about how I am going to approach this wee project for future proofing. Thanks '; )

So in 2007 I can save a database as a (example) access 2000 database. Then, Tools > Create mde file > Browse to my shiny new access 2000 database and 2007 will create a access 2000 mde file? Really! Thats great news, cause its a pain in access 2003. Thanks

I think the answer for this will be "no" but I will try anyway. Can you create an Access 2000 .mde from Access 2007? I know you can't from Access 2003 (which is what I am running at the moment.) Thanks for any help guys. :)

Sounds like one of your procedures or queries is calling the [forms]![formname]![Field] before the form has finished loading. Follow the open sequence step by step and you should hunt it down. It's the little things. :)

Hi Guys This is a question that someone my be able to help me with. If I ship a Access_2003.mde app to a client, what licence (if any) would I need to ship Access 2003 Run-time with the application? From the MS Web Site, I'm not sure if I need developers licence. I have a developers licence...

All users that I deal with are running Office 2003 and only access 2k runtime. This has been great. Did move some users up to access 2003 runtime but, this had issues with office that were blamed on the runtime version, I don't think it was the problem, but we went back to A2k runtime anyway.

You can use an action query, Insert into [Table] Where bla bla bla, or you can code it in VBA using Recordsets. Whats you skill set in Access? Perhaps look into Action Queries, Insert, if you have not had to much time with VBA.