Benny- Well, it will sum to more than 24 hours, but it will then display as a date and a time. The trick is a date/time value has the number of days since Dec...
I have created a search form, which prompts the user for several kinds of information--a date range, a team name and a employee name. A report is then...
Sandra- Why not leave your search form open and let the user go back to it after producing each report? They can change the employee name and click a button ...
I thought of that right after I sent the email, John. How do I do that--leave the form open. Right now, I have an OK and a Cancel button on this form. Do I...
John, I have a macro that runs when the user selects this report from the Reports Menu that looks like this: OpenDialog Echo Open Form Opens the DateSearchForm...
What code you you currently have behind the Cancel and OK buttons? Yes, you'll probably have to change it. John Viescas, author "Microsoft Office Access 2003...
Let me guess ... You're calling the open form from the Report Open event - and because you're opening it as a dialog, the macro and the report wait until the...
I'm trying to figure out how to open a specific excel spreadsheet by command button in Access. Any help/ideas greatly appreciated. Thanks, Rose Marie...
The simplest way is to use the FollowHyperlink method in VB code: Application.FollowHyperLink "C:\MySpreadSheets\Sheet1.xls" John Viescas, author "Microsoft...
You are such a help to everyone! Thank you, John. I took the macro call off of my Report Close, and it seems to be working! Also, thank you so much for the...
Hi John, I'm member of the MS-Access Yahoo-group, and I noticed that there's a big gab between most of the other members, with yourself as their chieftain, and...
Peter- I believe my "Running Access 97" is now out of print. I went searching on www.amazon.de and didn't find much that would be useful to you. I don't know...
HELP! I am trying to create a button that allows fields to be copied into other fields with similar names. There are 4 fields total and I want them to be...
... Nicole, Here is some sample code from one of my applications that does just what you want. Be sure to give textbox name the prefix "txt" in order to...
Hello, I have a table with a colum set up with data type as numeber(field size double, and decimal places 14). Everytime I export the table, the records with...
Nichole- Why do you want to do this? What is the business problem you are trying to solve? When you copy the same data to multiple fields in a table, that ...
Neil, Thanks for the information, but for some reason it isn't working. Below is what I typed in. Do you see where I went wrong? Thanks again! Private Sub...
Nicole, One thing that I noticed is that you don't have the error trapping consistent. You say On Error GoTo Err_Error_Logic and then the error block is ...
Neil, I made some changes, I think I have copied your language correctly now. For some reason it doesn't do anything when I click the button. Any ideas?...
Nicole, In design view, look a the form. Open the properties window and set the focus (in design view) on the button you want. Make sure it says "[Event ...
I was wondering if there was a way to basically edit a field in a table with information from another table. For example, I have two tables, A&B. Table A is...
Hello, I have a table where the FIELD11 has the format date MM/DD/YYYY, I want to create another field on the same table with the dates that are in FIELD1 but...
Why? If the field is date/time data type, you can get any output format you want - the internal format of the data has nothing to do with what you see ...
Have a relatively large, complex database that has been working fine. Suddenly, when we open one form - police report - we are getting a message
that there...
Make sure you don't have any imbedded pictures as form backgrounds. These cause memory leaks on win98 and 95 platforms that will eventually cause a need to...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
