Search results

Hi - the link for SqlDebugPrint is not working for me.

I know who you mean. I've the utmost respect for the cleverness and capability of all the Access MVPs but holy cow, to recreate the forms for even a moderately complex Access database in PHP seems like it would be a very complex and time consuming task to me.

OK. That's got it - sort of. I get a generic error "ODBC--call failed" - better than nothing! Thank you.

I think the dbSeeChanges is required. This gives me argument error qry.Execute dbSeeChanges, dbFailOnError

Access FE, SQL Server BE. I run a simple insert query in Access in the GUI. A no dup index on two fields in the table rejects it with an error message as it should. However Set qry = CurrentDb.QueryDefs("query2") qry.Execute dbSeeChanges also fails but without an error being displayed so I...

Old post and code but I just want to say it works perfectly for me. Way better than a form timer.

Hi, This list https://stackoverflow.com/questions/24267398/why-is-my-query-not-updateable The table is updateable in Access, including that specific field. Also, I append to it from ztWebRelay in another query without any problems so I'm leaning to thinking it has to be in the join but can't...

I've been through the list of potential reasons for a query being non-updateable. I cannot spot any reason. UPDATE twebrelay INNER JOIN ztWebRelay ON twebrelay.WebRelayID = ztWebRelay.SerialNo SET twebrelay.CBWIdentifier = [ztWebRelay].[CBWID]; twebrelay: Linked ODBC SQL Server table has...

Not exactly. You've built a subform with a combobox on top, yeah? It's cool, but would take too much time and would be more complex than I want. This was more something I just wanted to know if it could be done or not - I can work around it for this particular form with command buttons

I want a checkbox on his cbo not yes/no (see checkbox4 for the way it is displaying). Is it possible the problem is the cbo is unbound?

For anyone else searching on this.. DoCmd.RunSavedImportExport but the import file name has to be static - can't change it runtime.

I should have caught that. That works. Thanks, all!

There is no driver.ProNO field, nor any ProNO field in the source. Using tload.pro_no gives this error. Note I ran the calling code with simpler criteria. Syntax error (missing operator) in query expression 'PKDATE Between #03/02/2014# And #04/30/2014# AND & InStr(tload.PRO_NO, '.') = 0

Thanks, but no. Just a typo. The quoting I used is clearly wrong. I just don't know what is right.

Hi, I'm setting query SQL dynamically from a search form. Typical output is like this: qry.SQL = "SELECT DISTINCT dpay.PRO_NO, dpay.PKDATE, dpay.FROM, dpay.DPDATE, dpay.TO, dpay.DHMILE, dpay.LDMILE, dpay.MITOT, dpay.STOPTOT, dpay.UNLOAD, dpay.HOURS," & _ "dpay.HRTOT...

IIf([Pages]>1,"page# " & [Page] & " of " & [Pages]) Comma, not semi-colon after 1

Hi, I need to download and parse 1000's of emails/day. I don't want to automate outlook for this. A while back I came across several inexpensive 3rd party tools that looked like they might do a good job but can't remember the names/find them. Any suggestions would be appreciated.

Create a new MDB file. Import tables, then queries, then modules, then macros if any, then forms, then reports. If you get to forms and reports without errors, it would be best to import those one at a time. If that is not practical, after you import the forms, check that they have all been...