Search results

It does :) And very elegant, too. Thank you very much!

My application creates a table each time the user requests data. This application also creates a copy of each table, Read-Only, for record keeping. Each read-only table is called "Random" and the date/time the table was created. They need to be able to copy and send the contents of any of...

Here you go.....

I design in the lowest resolution settings. In design view you can change the height/width of the buttons, and the text size. So I make the command buttons a little larger, then use slightly larger text, leaving a margin... I set the Left, Right, Top margins to .02, which leaves a little...

Is there a simple way to set text on command buttons so that it stays centered even at different screen resolutions? I am using Access 2003. Also using the form resizer. Thanks!

Thanks for trying :) I found this on the net, and it works flawlessly: "Function PrintDoc() Dim WordObj As Object Set WordObj = CreateObject("Word.Application") WordObj.Documents.Open "T:\Insurance Services db\Classification_Serv\EmpServDB\EmployerServicesDataBase.doc"...

Anyone have any ideas?

I am just finishing up the user's manual for an Access application that is almost finished. The user's manual is a 31 page Word document. Is there a way to open that specific Word document from a command button on the appliation's Main Menu? Thanks!

Is there a line numbering feature that can be turned 'on' so there is a unique line number visible when working with VBA? Some of my code is quite long and similar enough that I would like a way to find an exact spot when moving between VBA code and paper copies of the same code. Thanks,

BTW, this is one of those quirky Access things where the Change event for the control is only available in the dropdown box (the one that says (General)) in the code window; it's not available in the Properties Box. Missinglinq- Thanks for the help- it took about 10 minutes to bumble around and...

I have a form "frmMyForm" with four tabs "Page1" "Page2" "Page3" "Page4" there is a control on page4 named "txt35". When the user selects the forth tab I want to fire an event, if txt35 is set to "Yes" The form is not running the event... Private Sub Page4_Click() if...

UpDate: The routines were running so fast the the color change was requested before the field was through filling, so there was no object there to change color on. I added a 1 secong pause between the fill and color code and it runs fine. Thanks again for all the suggestions :)

No change with the color switch... I will do a work-around, need to get this finished up. Thanks for the suggestions, Dave

The text 100 means that the field is text type and allows up to 100 alpha chars. I changed the names to include the 'me' and it did the same error in the same spot. It follows the instruction about changing the color on the first field, then errs out on the second field with the same code. Thanks

I have the following code to change font colors: Dim lngBlue As Long lngRed = RGB(255, 0, 0) lngBlue = RGB(0, 0, 255) If [activate1desc] <> "" Then [41a].Value = [activate1desc] [41b].Value = [Activate1:] [41a].ForeColor = lngBlue [41b].ForeColor = lngBlue End If It...

I want to update the [Total Employees] field in the tbllassSurvey table to the sum of the different employees by type of work they do [1d]+[2d]. here is my code: UPDATE tblClassSurvey SET tblClassSurvey.[Total Employees] = Sum([1d]+[2d]); Running the query returns error 3122 'You tried to...

Here is the code that prints just the first record. It works correctly. May help you...

There is something just wrong about microsoft software. You can fight with something for days, get a zillion different error messages, and when you get it right finaly there is no fanfare, no good job, nothing. It just does the instructions- quite a letdown when it finally runs. I learn at...

Just went and corrected the syntax to match your suggestion. It printed all four tabs for the current record AND then it stopped, instead of printing all 900 pages. Thank you, Alisa!!

I have not, but will in a couple of minutes. Thanks!