Search results for query: *

Have you looked at AutoHotKey? www.autohotkey.com It is my first choice when I want keystroke automation. -Ken Z "When your only tool is a hammer, everything looks like a nail.

Yippee!!! That worked. I would have thought that it would trap me in modal hell. Thanks, Ken

I have VBA routine that either previews or prints a series of eight reports, one for each "Agency". Whether to print or preview is dependent upon a global boolean (chkPreview). The db is, and must be, in AC2003 format. However, I develop and run it in AC2007. I no longer have AC2003 installed...

My guess is that the DB2 UPDATE query used Linefeed characters (ascii code 10). Access is expecting a Linefeed/Carriage Return pair. (ascii codes 10 & 13) You may have to condition the field data by replacing the linefeeds. This should work: Replace(YourString,vbLf,vbCrLf) Good Luck

Pesky user training is my preferred method, and I understand that is not always feasible. I had a situation where most users were frequently looking at data and rarely editing it. Occasionally one would inadvertently change data without realizing it. I had two choices: 1. Detect when a changed...

I do not understand why you are locking forms and controls. I know you are trying to "control those pesky users", but I think you are shooting your self in the foot. If you are trying to prevent other networked users from simultaneously changing data, then this type of 'locking' is useless. It...

My guess is that qryActive is only looking at "active" records and when you change the status to inactive, the query no longer has that record in it recordset, so it cannot show it to you. I would have to see the code behind the 'saved' button and possible the queries before I (or anyone else...

How are you determining the week number? Perhaps if you share the code, we can help you better. Are you using the function DatePart? It has an optional parameter "firstweekofyear", which can be one of four values. I assume you are using the default value of vbFirstJan1 which gives the results...

@fumei - Thanks, I had already tried inserting before deleting to no avail. @TonyJollans - Thanks, by going to the following section and changing it in the page setup, I was able to accomplish what I wanted. You know, it shouldn't be this hard.

I am using Word 2007 to edit a Word 2003 .doc file. I have a Section Break (Next Page) and I want to change it to a Section Break (Continuous), i.e. have the next section continue on the same page. When I delete the current Section Break (Next Page) and choose to insert a Section Break...

Years ago I gave up on trying to keep images in an Access DB. My solution was to keep all of the images in a folder in the same location as the backend DB and store the filenames of the images in the DB. I think this this could be a viable solution for you as it sounds like you already have...

>>Im dont know what that means Googling CDO Email should provide an explanation -------------------------------------- Your solution depends on many different factors. Can the report be formatted in plain text? If so, make it the body of a plain email. You can use SendObject here. If it has to...

It would help if we knew: * what version of Access, * is Access up-to-date with Service Packs, * what kind of DB the linked tables are in (another Access DB or SQL Server or ??), * is the linked DB local or on a network, * have you tried Compact and Repair, * etc? My best guess is a corrupt...

Thanks Ace! One thing that was tripping me up was that I was expecting the form to move off of the new record. It appeared as though it was not canceling the new record. Here is what I ended up with - so far works with all the testing I have done. If Me.NewRecord Then Me.Undo...

How can I delete (or cancel) the form's current record when Me.NewRecord is true? Using DoCmd.RunCommand acCmdDeleteRecord throws error #2046 (The command or action 'DeleteRecord' is not available now.) I tried Me.Undo, but that does not delete (or cancel) the record. I need to do this from...

Are you verifying this by inspecting the output CSV in a text editor (like Notepad) and not by inspecting it with Excel? It may not be Access that is tripping you, but rather Excel could be mungling your output. Look at the output in a text editor before you even try opening it with something...

The article you are referring implies that the SetToZero routine is called BEFORE you run the query. This could be accomplished with either a macro or vba code (perhaps behind a button on a form). I cannot think of any way that it could be done within the query itself.

Just for the heck of it, try unwrapping the parentheses from the ssql argument try db.execute ssql I know it sounds silly, but I have had problems with unneeded parens in the past.

I figured it out. I hung msgboxes on all of the form events. Current wasn't firing. The form was set to AllowAdditions = No and the RecordSource was empty. Nothing to show and not allowed to do additions, so the form just sat there, "stuck on stupid". Thanks for stopping by!

Don't re-invent the wheel, and don't make your users stop using Word. I am a policy writer. Word is my hammer and my nail. If Track Changes does not satisfy your needs, invest in a version control system. I have used both SourceSafe and Subversion for tracking versions of documents. That was...