Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kzutter

    API Calls or VBKeys in VBA

    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.
  2. kzutter

    Lost preview of a series of reports

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

    Lost preview of a series of reports

    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...
  4. kzutter

    MS Access 2003 will not display new lines for a DB2 table column

    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
  5. kzutter

    Refresh Subform with Save Buttom

    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...
  6. kzutter

    Refresh Subform with Save Buttom

    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...
  7. kzutter

    Refresh Subform with Save Buttom

    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...
  8. kzutter

    Week 53 and week 1, 2010

    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...
  9. kzutter

    Cannot change Section Break (Next Page) to Section Break (Continuous)

    @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.
  10. kzutter

    Cannot change Section Break (Next Page) to Section Break (Continuous)

    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...
  11. kzutter

    vba insert image in ms word form, from a access db table

    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...
  12. kzutter

    Sending a Report in the body of an email

    >>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...
  13. kzutter

    Linked table mystery

    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...
  14. kzutter

    How to programically delete new record?

    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...
  15. kzutter

    How to programically delete new record?

    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...
  16. kzutter

    Export to CSV drops decimal places on one PC

    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...
  17. kzutter

    Ms access query - add a serial/record number?

    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.
  18. kzutter

    db.RecordsAffected doesn't always work

    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.
  19. kzutter

    Form not displaying controls

    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!
  20. kzutter

    tracking changes in word

    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...

Part and Inventory Search

Back
Top