Search results for query: *

In the past month I've had two instances of this problem on different DBs at different companies. One was doing a transferspreadsheet (to excel) and the other was getting the same error anytime anything do to with the printers happened (print preview, or defining a new report, for example). This...

Posting this info to hopefully save someone the hours I spent resolving the problem! The latest SP that brought us the "unsafe expressions" errors also disabled Access' ability to update a linked Excel workbook via query. I had 2 excel sheets linked as tables, one the master and the 2nd...

I know how to fix the seq when it is out of sync with a table: SELECT setval('tablename_seq',(SELECT max(tbl_id_col) FROM tablename)); My question: anyone know how they get out of sync in the first place? The only code we have that inserts doesn't reference the id column, so PGsql should get...

Is there a way to pass the key to a form (and use it to set the records available in the opened form) in ADO style? All the solutions I've seen (Including the help in Access) require the old DAO references and libraries. Frank

Here is an enhanced implementation of the Zend chained selectors class. Selection from the first list populates the 2nd list. Selection from the 2nd list returns the value. The example also has a button which can be used if you don't want the immediate return from the 2nd selection. Some of the...

This works ok in IE, but in Firefox the buttons don't work and I see an error in the javascript console. On the Mozilla forum, I was told I have obsolete javascript. I have select buttons next to a search results table. I replace the iframe on the right when a button is pressed. HTML (PHP)from...

I'm doing a mailmerge using address info from an Access table. The problem I'm having is the extra spaces between fields when one of the fields has no data, for example <<Middle_Name>>. It looks really bad on the 2nd line where the first field <<State_Prefix>> doesn't occur most of the time. So...

I used SendKeys in the past to send variable criteria and an {ENTER} to the buffer, and a subsequent query would pick up the selection when it ran. I typically allow the user to select the criteria from a pull-down list (combo box). Often a query is used to select a subset of a table for a...

I can't seem to keep the SMTP mail server running. Had it going for a couple of days on 2 PC's - one Win 2k and the other XP professional. Then started getting the Unable to relay message. Got one of them working again by re-doing the IIS setup, but can't get the other going again. I'm trying to...

I'd like to be able to export an Access report intact (with any graphics, charts and text formatting) into a document suitable for attaching to an email (that can be viewed by the recipient). Has anyone seen a utility that will do that? Frank

The sample data always looks good! Can't get anything meaningful out of the chart wizard though. I'm trying to create a pie chart. Have a column in a table with values 1,2 or 3, representing Incomplete, Completed and N/A. I'd like to map the 1's,2's and 3's around a pie chart. I've also tried...