Search results

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

I use a different password on my front end (.mde) and my backend (.mdb) files. I am the only one with a password to the backend.

Re: Exporting Excel data: covert to text problem The field you are importing it into in Access needs to be string.

I had a similar problem once, and fixed it using the following methodology: Remove the offending If is Null(coname....) end if staement completely. Save. Close and reopen. It should work now (without that test obviously). Now put the statement back in and save and close etc... TECHNICALLY THIS...

Fair go....,it is just a typo: I cannot get the code debug screen from appearing. should be I cannot stop the code debug screen from appearing!