Search results for query: *

I'm trying to add an unbound combo box to a Access 97 form, based on unique names in a table. When I click it, it's blank. However, if I put it on a different form, it works fine. It's driving me nuts! What could keep it from working on the original form? Thanks, DB

One place with some helpful info is at: http://www.mvps.org/access/modules/mdl0035.htm --DB

Uncle Jack: Here's another good site of postal formatting for many countries. http://www.bitboost.com/ref/international-address-formats.html --DB

Thanks, Jeff. I spent the weekend reading about automation and think I can solve this now. I already had an Excel macro to do this and, with your guidance, have the formatting commands: ' bold row 1 Rows("1:1").Select Selection.Font.Bold = True ' autofit columns Cells.Select...

Periodically, I have to dump approximately 50 Excel spreadsheets from an Access 97 database, each by customer. For esthetics, I go into each one and format it before sending it as an email attachment to each customer. To save a LOT of time, after the TransferSpreadsheet, I'd like to tell Excel...

I'm certainly hooked too. I've printed reams of paper of helpful routines from y'all while having my morning coffee. Wish I had half the smarts of some of you. All I can say is, Thanks for sharing your time and knowledge!

I'm working on a function in Access 97 to return a sheet of random passwords that a user can select from. The words should be English-like and pronounceable so they are easier to remember. I've had some success with this, but I don't want to reinvent the wheel. Does anyone already have code...

Probably the quickest way is to use a "Go To Record" macro in the form's On Open property. You can set the macro to select last record. DBEngine

Thanks, lameid and Paul. I used the On Open in the report and referenced back to the option group on the form to get the data. Still - some fields sort and others seem to ignore the SortBy. Here's the code I used. Private Sub Report_Open(Cancel As Integer) On Error GoTo Err_rptCustomers Dim...

Generically speaking, I want to set SortBy and SortByOn in an Access 97 report from an option box on a form. How do I do that without first opening the report? Everything works except I get a message that the report name is either closed or nonexistant. I can't see how to change the properties...