Search results for query: *

Thanks Golom... I'm reading the post and trying to see how it applies to my problem. Research continues! Give a man a fish, and you feed him for a day. Teach a man to fish, and you feed him for life. Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more...

Doesn't quite do it... If I have records available in the underlying table it works fine (always has), but if all the records are deleted I get the error, even with the "IsNull" statement. Grrr.... A Give a man a fish, and you feed him for a day. Teach a man to fish, and you feed him for...

Here's a puzzler: I have the code: Me.EndDate.SelStart = 0 Me.EndDate.SelLength = 10 Set to run in the MouseUp event of the control. The control is unbound... interestingly when there's data in the bound form the code works swimmingly... however, if there are no records in the underlying...

Thanks vaucunita, I'll give it a shot! Give a man a fish, and you feed him for a day. Teach a man to fish, and you feed him for life. Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more by doing it.

I have a user who's experiencing a problem processing commands from a command line interface. Command prompt will open, and I can run DIR, however, when I attempt to use EDIT the window closes abruptly with no error message. Any programs that use the command line interface are also closing...

Thanks John - It's actually pretty hard to do a search for the term "#Deleted" and find anything (I keep getting info on Delete Queries!). I've done a little research on pass through queries and see that it does solve the problem... hopefully I don't have to update any data otherwise I'll be...

I have an Access front-end database in front of an SQL database. I've created a view that is then linked to Access - but when I display the contents in an access query I see "#Deleted" in many of the fields, and my form based on that query won't open properly. Yet, when I run the View in SQL it...

There is a dll file you can replace to remove this nag screen (if memory serves me correctly) - I have it, but haven't used it for some time. Do a google for "cdo.dll". Also there's a nifty program available that allows you to bypass Outlook alltogether for sending e-mail. Check out AddEmail...

I'm running Access with the main window hidden, that way all my other windows are "floating" around and users can have other programs open (AND visible) when viewing my database. The users really like it. At any rate, ALL windows must be set to pop-up, otherwise they open in the minimized area...

I've got a report that displays as a popup - when set to popup the handy menu normally available when you right click on the report does not display. Any one have any thoughts on how to get this to display? What are the criteria for displaying this menu? Give a man a fish, and you feed him...

Not sure if this will help you completely or not - I've found a problem similar to yours, but can't remember what I did to solve it exactly (I'll do some digging) - for now, you can change directories before running the shell command using: ChDrive ("C:")'changes current drive ChDir...

For anyone who might be interested (looks like not many:-) - I found a solution to this problem. By defining a public variable, I was able to overcome the need to commit data before inserting a comment. Here's what I ended up with - feel free to respond to this post if you've got any...

I've got an insert statement that puts user comments into a field when they press say CTRL-0 - the problem is I can only get the data to append to the current data. I modified the code to determine the cursor position and insert at that point, but this only works on data that has been committed...

Long time user of Access and feel it's time to make the move to SQL. Anyone have any suggestions where I might look to train / learn / study / attend classes? Thoughts on where I might get started? Run a few SQL databases, but am WAY out of my league when problems arise. Thanks for any...

I have users that use a few of my databases on Vista. I haven't run into any major difficulties...except one. The wonderful User Account Control feature will cause problems if you store any of your data in directory "c:\Program Files". Also, I have some batch files, and sometimes export...

I tried briefly your solution, WinblowsME (nice handle BTW) - but haven't had time to extensively work it. Will post back if I find a solution - in the mean time, any suggestions will be appreciated. Maybe I can fund some sort of X-Prize for the best solution - what do you think? Monkey Give...

I have tried a variation of this, but seem to get hung up on getting new values. That is, if I use Me.Refresh anywhere in the KeyDown statement it causes strange behavior - without the Me.Refresh, I don't get the right information... and the loop goes on. Have you ever implemented something...

I've worked out some code (with the help of Tek-Tips experts, of course!) that will insert predefined statements into a users active field. Basically the user presses "CTRL" and a corresponding number to import text to a text box. This has worked well enough, but I would like to make it more...

Sorry it's been so long for me to post. I checked through my code and found an error - I was defining a string as an integer. Imagine that, error codes that mean something! Thanks all! Give a man a fish, and you feed him for a day. Teach a man to fish, and you feed him for life. Send a man...

Need to lookup a Max value in a table and then use that to return another value from the same table. Have the code but am getting error 3464 (data type mismatch) when I execute the code. Both fields I'm using to lookup are Long Integers so I'm perplexed why I keep getting the error. I've...