Recent content by baddy

Ken I have never even heard of that feature before :). I just checked it out, and it was exactly what I needed. Thank you very much for your time you two!

You wan't the range of inbetween numbers to be in once cell like you had in quotes, or if there is a difference if 8 do you want 8 cells to have one number in each? I can't think of any way to do this but I'm thinking...

Thanks Anne, I was able to use that info to record a macro and edit it to be exactly what I wanted. One problem, however, is I was hoping to have it be a button in the spreadsheet and not a toolbar button (there will be multiple of them in the sheet), is there any way you know of to have a...

Is there any way to make a button to expand/colapse rows in an Excel spreadsheet? I am thinking there is probly a way to set a VB button to hide/unhide the rows, but the problem is I really don't know anything about VB. Any ideas? Thanks in advance.

Every time I send an e-mail with an attachment (like anything over half a meg), Outlook will resend the message over and over and over without ever taking it out of the outbox. Oddly, the recipient gets the full message with complete attachment everytime, so its not like its dying before it...

Tried that and it unfortunately brought on the same problems. I worked with the tech support for the software for a bit and we came to the conclusion that the dataset I was working with was somehow corrupt, starting a new file within the program eliminate the errors. Doesn't make much sense...

I am getting the following error when I work in a program that has been working fine up until today: "Access to C:\WINDOWS\Installer\{90150409-6000-11D3-8CFE-0050048383C9}\accicons.exe was denied." The program is one called ClickTracks, but this error appears to be a windows issue...

That did it, thanks again for all your help -- this form is a great solution. Patrick

Thanks Jeremy, that looks great. I am having a bit of a problem with it however -- when I hopen the MDB up as is (a new database with just that form), it works correctly -- but when I am importing it into an existing database, I get "The expression On Open you enteres as the event property...

I was just wondering if it was possible to change what font is used when you are typing in a SQL query in Acess 2002? The font that it defaults with is so skinny and makes me always misjudge where the cursor is at.

Thanks a lot joepole, disabling Windows Messenger fixed the problem for me. It's odd that your problem sounds so similar yet the solution is different. Here are some tips I got for this problem that did not solve it for me, but may help you: * Disable system restore and disable content indexing...

I just got a new work PC, and it is a pretty decent setup (p4 2.6). It shipped from Dell with XP Pro SP1 & Office SB 2002/XP. While Excel and Access are running fine, Outlook is going extremely slow -- when I change messages in the Inbox, it takes ~5 seconds for the preview pane to update...

You got it, thanks a lot.

Thanks xlbo, that is some good info. However, I am having a bit of trouble with HAVING in a query statement. Here is what I tried: HAVING (((user_yr)=[Enter Year])) SELECT * FROM mytable WHERE mytable.year LIKE user_yr; And I get the error " Invalid SQL statement; expected 'DELETE'...

I just looked at all the optiions/prefs in Outlook 2002, and saw nothing like carr described either (unfortunantly).