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 Chriss Miller 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. xwizardx

    Calculate Hrs and min worked, minus lunch break

    CONSIDER: four fields: [TimeIn] = 8:30 [TimeOut] = 16:00 [LunchOut] = 12:30 [LunchBack] = 13:15 The times will vary with the record being processed. Is there a function or procedure that I can use to fill a 5th field: [TotalTimeWorked]? Thanks Barry Davis, President...
  2. xwizardx

    Need way to calculate time worked in a day minus lunch break

    CONSIDER: four fields: [TimeIn] = 8:30 [TimeOut] = 16:00 [LunchOut] = 12:30 [LunchBack] = 13:15 The times will vary with the record being processed. Is there a function or procedure that I can use to fill a 5th field: [TotalTimeWorked]? Thanks Barry Davis, President Small...
  3. xwizardx

    enabling macros at startup in '07 runtime

    I'm trying to set up an ap with my client using the Access '07 runtime. If there is a way to enable all macros at startup I can't find it. Can you help? Thanks! Barry Davis, President Small Business Computing, LLC
  4. xwizardx

    over ten users causes Access application to crash

    oh! And each has his/her own front end file. Barry Davis, President Small Business Computing, LLC
  5. xwizardx

    over ten users causes Access application to crash

    There are about 30 potential users. No more than around ten are on line at any one time. Some number of them are hooking up wirelessly. Also, people who are in the office at any given time have a tendancy to just click into the system and let it sit until they need it. Any given person might...
  6. xwizardx

    over ten users causes Access application to crash

    I've written an application that runs in a small office. It works fine with a small number of users running the application. When it gets up to around ten users, though, the entire system crashes. 1. Is there some limit to how many users can use an Access '07 application? 2. Have others run...
  7. xwizardx

    locking a form on displaying

    I am creating an application that will require that certain forms be displayed but with all the fields locked (disabled) if another field has a value of -1. Is there code or some other way of making this happen? Thanks Barry Davis, President Small Business Computing, LLC
  8. xwizardx

    "File Options" in IE8

    I had the cause of the problem wrong in the first posting. The issue wasn't caused by IE8 but, rather, by Vista. The ability to reach and modify file types was in the Tool menu of Vista. It's not anymore. Thanks, Barry Davis Barry Davis, President Small Business Computing, LLC
  9. xwizardx

    "File Options" in IE8

    In IE7, "File Options" was in the dropdown menu under "tools." I can't find it in IE8. HELP Barry Davis, President Small Business Computing, LLC
  10. xwizardx

    relative placement of several open forms on screen

    I am developing an Access '07 application that requires three or four forms to be open at the same time. They need to be in very specific positions on the screen. "Move-Size" does that very nicely -- but when the ribbon in minimized or the list of "Access Objects" is closed or resized my...
  11. xwizardx

    export from Access to FTP site

    I have an application that converts data from Access tables to comma delimited Text files and exports those files to an FTP site where it is picked up by a central office location. Data that is sent from Quebec, Canada, arrives at the FTP site delimited with semicolons rather than commas...
  12. xwizardx

    loss of fixed width import spec in '07

    I ran into the following last night. Is there a work around to this problem. If there's no solution, five years of applications are down the drain. Below is from a posting in a newsletter I receive: Q. Code for importing data from text files that worked fine in Access 2003 doesn't work in...
  13. xwizardx

    autostart Access 07 app

    I've converted an '03 app to 07. I want the new version to open with the switchboard open and the database window suppressed. In 03 there was a section in "Database Tools" that set this up. How does one do it in '07? Thanks Barry Davis, President Small Business Computing
  14. xwizardx

    How to hot key current date

    Starting with a bound form containing a field named, [dtDateModified], I'd like the user to be able to set this field to the current date with a hot key sequence. Currently, the field opens with the last value that was set there and, to change the date, six keystrokes are necessary. Failing...
  15. xwizardx

    backing up Access tables from within application

    In an application I've developed, I've found a need to be able to restore the original information to a data field that has just been edited on a form. This is simple if the field is bound to a query. If the field is bound to a table, though, there seems to be no way to get back to the...
  16. xwizardx

    Empty Row

    Chris: I had the same problem. It solved by putting a long "IIf" statement into the print field of the report. I had 15 groups, each with 10 possible lines. The solution was, "IIf [field1] is not null and [field2] is not null ... and [field100] is not null,"GROUP TITLE", "") Barry

Part and Inventory Search

Back
Top