Search results

problem with tabs is you can't compare data sets if you are troubleshooting queries...have to flip back and forth...sometimes I like them other times I don't I do like Windows 7, never had Vista... I thought I was going to have more problems with 64 bit system, but I run all my programs and...

ewwww 97, That brings back bad memories of converting to 2000....97 to 2000, is the worst transition, every other version has worked for me without having to convert the database. I've used 2000 for years at home and even have it on a 64 bit Windows 7 PC, it's just as useful...so far I haven't...

I know it's old, but I figured he might be subscribed to it still and would get a notification. Hey Welcome to the Club lol...don't you feel like a moron using 2007, I know I've found most things I need, but there are so many little quirky things you do that are "second nature" that you know...

Hey Coach...I used this link from one of the ones you suggested... I found this version to work the best, but since getting my Hard drives replaced the addin won't load any ideas? looking in options under COM Addins I see DBWindows is unchecked and message showing Load Behavior: Not Loaded. A...

thanks Dave, good to know

They were whole numbers, I'm afraid I have some bad habits with these numerical data types, probably because if it works I'm happy....for a lot of what I have setup the default is "Integer" and if it comes across as "Text" numbers I just use Cint, I just thought CDbl would be then next one up...

I see where I went wrong, and you probably would have picked up on it if I had mentioned it....All of the numbers that errored were greater than 32767...it was literally screaming at be when I look in Table design and the field comes across as "Double"... I didn't even clue in. So this is what...

I have a field that is really giving me a hard time, the data is query from main system, but has the wrong data type...it comes to me as text, and I need to convert to number....this normally isn't a problem for me, but this case is wasting my time... I've tried so many combinations... I use a...

Bob as always you are "Da man"... the me.undo did it...what I wanted was the field to be completely reset as it was still expecting a value and giving that error field can contain a null blah blah.. thanks

Here's the situation...in case another method can be used.... I'm selecting records in a combo, and in the Before update event I am checking for duplicates.... when one is found it triggers a message and I cancel/undo to clear the selection...I am then trying to send the ESCAPE key to, what I...

Hi guys, sorry i didn't post back sooner...the holidays got in the way, I was off for 2 weeks and finally got caught back up to this problem. What I found was not so much the Regional setting but I was contradicting my formatting, or confusing it. I found that if I added the extra M in the...

Ok I got it, this one is using a variable, but you certainly helped remind me not to use Reserved words, I'm normally good at not using things like NAME DATE but these 2 were less obvious. strSQL = "insert into tblUpdateLog(xuser,starttime,endtime,duration,xOption)" strSQL = strSQL +...

option is also a reserved word ( haven't looked it up), I changed them both and aam not getting an error now, but I need to double check the eyntax.... jusy give me a minute

This Line went RED so I changed to double quotes, but still didn't work? SQL = SQL & "Test" & " AS E;" Output: INSERT INTO tblUpdateLog( xUser, StartTime, EndTime, Duration, Option) SELECT 'ziggy' AS A, #07/01/2010 10:31:40 AM# AS B, #07/01/2010 10:31:40 AM# AS C, 100 AS D, Test AS E;

Thanks DCrake, But where should it go? it looks right to me... I tried putting it on it's ow with Dur & "," & "'TEST'" & ")" But I need a comma, there are 5 fields and I have 5 Values all with the correct data types, I even tried using a Variable to pass to the last field?

Error: Syntax error in INSERT INTO statement I have this VBA to create an SQL string, it worked but I added a new field to my table but I can't get it to load. The new Field is: option it is a Text data type in the table. strSQL = "insert into...

Wait spoke to soon, I had just come back from a meeting and saw your post...tried it worked...but that was with a 2 digit day in the date... Nov 18....I forgot to test with a single day.... arghhh...

Thanks Coach...you rock :) date Value did the trick...but I don't understand why my setup wouldn't handle it without it? Access 2007 Form comes with Date Picker when I add the control and choose medium date, the VB already had the date type set and I wrapped # around the variable...the final...

I set this code up to load a table based on beginning ending dates, I thought it was working...then I realized is I enter a begin date where the DAY is a single digit ( 1-9) it mixes it up as a month so where Dec 1/09 is entered it turns it into Jan 12/09? Seems basic, and I'm being lazy by...

This is an example a coworker came up with.... Calc1: DateSerial([yearNumber],1,([WeekNumber]-1)*7+1) The Date serial function adds the days greater than the given month ( I didn't know that), so starting at Jan 1 once the DAY excedes 31 it is added, thus multiplying the Week number x 7...