Search results

Greetings I use four buttons (first, last, next and previous). If it is on the last record then a msgbox appears (same with first). Two text boxes display current record and total record count. You should be able to mod this for your .enabled Private Sub btn_next_Click() On Error GoTo...

Just put Exit Sub above your error handling code. That wont run unless there is an error. On Error GoTo DRStats_Err ....all misc code here Exit Sub:D DRStats_Err_Exit: 'THE NEXT LINE IS IN QUESTION.... dbs.QueryDefs.Delete strQName Exit Sub DRStats_Err: MsgBox Error$...

try: if forms("frm_build_ARMS").controls("Check8").value = -1 then 'checkbox is checked, put your code in here end if

Is this what you want to do??

I would have mySQL tables linked to the database using an ODBC connection. Then you don't have to worry about syncing as the data is going straight in. Spent Geezer

Greetings, I have a report history table that is updated with a file name whenever the form is generated/printed. The report is printed to PDF (using Lebans code) and stored in a shared system directory. The table is updated with the file path, date/time and user details. This is essential for...

Re: Form / button / marco Yo Dick, Possible reasons: 1. The on click event is setting the button.enabled = false 2. THere is an event which occurs when the other form is opened that makes .enabled = false. Go to design view and click View \ Code at the top. Then click Ctrl+f and search all...

Interesting.....Does he find the real John Galt?

@ netty pffffffffffft

Who is John Galt?

Could you post your code please? This should fixya: With objOutlook .visible = false .diplayalerts = false end with

Could you post the code that sends the report please?

Not sure if what you want to do is possible. Would it be better if you simply turned the warnings off in outlook (then there is no popup). Alternatively put something like this in your code: With objOutlook '(or whatever you called the outlook object) .DisplayAlerts = False end with

Just use this sample from the Spent Geezers Association..... EDIT - You will have to create tbl_Label for this method to work, and bind it to the report. The table is populated each time a label is created (1 row for each part).

Feeling blue at the moment....

It appears that the action query is still the source for the report. Have you tried changing the source of the report to the new table?

Spent, This is really simple, just increase the row sized (as you would in Excel) and the text automatically wraps. Regards, Spent.

This may help??? I use to replicate records in a database, because replication then a few changes is quicker than starting from scratch in some instances. Private Sub btn_copy_Click() On Error GoTo Err_btn_copy_Click Dim Rd_Set Dim tbl_NamE Dim autonumber Dim obj_cnt As CONTROL Dim obj_FIELDS...

Greetings and Salutations, I have built a questionaire database. I wish to use it on a tablet PC to collect field data. The tablet screen is obviously much smaller than a PC screen. Is it possible to "Wrap text" (like in Excel) for table data in a subform? Otherwise the user has to scroll...

Noob answer: Make a lookup table with all the form names in it...