Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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