Search results

Ok this one is driving me crazy! I have had this issue before and it seemed to aleyas be just a matter of setting the correct data type (i.e., text) vs. trying to import the value as a number... I am downloading data from an application. If I try to DL the data as an excel spreadsheet or csv...

Yep, that's what I was looking for. Thanks, Gary

So whenever I create a new Access file, I always have to go into: Access Options>>Current Database>> and then change settings like overlapping windows and such... Unfortunately when I open MS Access 2007 without creating a new file and try to do the same thing... the Current Database options...

I looked up this one: http://support.microsoft.com/kb/118623

Ok scratch that last question... Let me ask this in a different way... My issue is that when I choose to enable Macros manually (vs. the nomral process of using a startup form), something happens.. but I don't know where the code is kicking off. So when I go in and try to debug, seemingly none...

I have inherited an Access Database, which programmatically establishes linked tables when the front end of the (split) database is opened. The process is kicked off by a startup form then after the table links are established... opens a switchboard. The issue that I am having is that they now...

Yeah it sure is... under foreign name! Thanks Ken!

Unless I am missing something... which is entirely possible... I don't see whereas this link actually helps, as it doesn't appear to show the original table name anywhere... but like I said... I could very well be missing it.

In 2007? Do you mean "database tools"? I don't see a "tools>option"anywhere...

OK, I feel really stupid already for even thinking about asking this question... I did a search, but it was tough to find the right words for this... I know it will probably be something really simple... and make me feel really dumb for asking... but here goes: I am going through another...

I just loaded and tried it... Works perfectly in 2007! You rock! -Gary

Bob, I checked out the link, but it doesn't say it is intended for 2007/2010 Office products. I am assuming since you posted it... it does, but I wanted to make sure. Smart Indenter Version 3.5 (released 10th February 2005) is available free for Office 2000/2002/2003, Visual Basic 6 and...

Chris, Sorry it took me so long to get back. I actually ran with the other way of running the case statement to finish my project. This morning I went back and took the code you posted (that ran fine on your end). I ended up changing the name of the function to Get_TimeSpan2 (since I am using...

Wow, I am learning a lot from this one post. I didn't realize that when you list variable with commas only the last one gets the designated data type... Hmm... good to know. Also subtracting dates directly gives you the day.That makes things eaiser. For everyone who asked what I am doing...

OK I am not trying to spam my own thread here... but I changed my case statement to this: Select Case intAge Case Is < 10 strRange = "NA" Case Is < 30 strRange = "10 - 29" Case Is < 60...

One more interesting factiod... I changed the case statement line from Case 90 To 999 To Case 460 ...just to see if my 460 value was understood at all... and it seems like it was. See: It ran just as you'd think it should and set strRange = "90+", so there seems to be an issue with the...

I tried to change that line...To: If ((dtBeg <= dtFill) And (dtFill <= dtEnd)) Then But it doesn't seem to make much difference on how it evaluates. In either event it actually does get evaluated to true (see link: ): when dtBeg is less than or equal to dtFill and dtFill is less than or equal...

I am trying to evaluate aging tickets... breaking them up in age ranges. I've created a function that seems like it should do this, but when I run through the code the "TO" keyword in my Case statement doesn't seem to be working correctly. here's my code" What happens here is... intAge comes...

I think i just resolved the issue... I did a repair & compact and that seemed to do the trick. I suppose Access was looking at code I couldn't see or something... Anyway, that worked for me... not the form is pulling up just fine, without prompting me to put in a Service_ID value. Can anyone...

Thanks for looking at this Bob, Sorry it took me a while to get back. I honestly don't know what is going on here. The form I am trying to pull up is a popup form that's used to filter out data from a table. the retrieve contact information based on the filtered search. There are two trypes...