Search results for query: *

I usually save to notepad or Access, but Tweets require Word to see gray hyperlinks, which must be separately selected between double quotes from within Hyperlink tag. (Not a Programmer nor write code.) Instead of extracting only links in wrong order to a new doc .. Below code (I changed)...

What is updated export types formats for Excel, Word, and text, from Office 97 to current? Here is portion of old code. With lstResult .ColumnCount = 4 .ColumnWidths = "0,0,0" .RowSourceType = "Value List" .RowSource = "-1,-1,-1,Export Type," _ &...

Hello All, An unbound search form searches up to 5 separate criteria for selected table or query by using criteria enclosed in asterisks - *criteria* How can code be changed so criteria can be entered without being enclosed in asterisks? From sections below, not sure how to edit syntax for...

Function isn't available in expressions in query expression ... error occurs for MsysObjects WHERE section. Below code used to work in Access 97 (before reinstalling Access 97 and 2000). It now only works without Where clause, specifically "left$". Is there a missing reference for "left$"...

The below code works fine in the main form (frmClients) to send the current record to Excel. But in the subform (frmContacts), it will only send the first record even if a second or third record is current. This is the only line I changed from the main form. Set rs = db.OpenRecordset("Select...

How do you split code between events? Specifically, activate InputBox before the on timer event fires. Should timer interval initially be set at 0 or 250? Also, which events work in conjunction with On Timer? Double-clicking on a label doesn't seem to activate the on timer (although, not being a...

Hello all, The below code works fine when the main form (switchboard replacement) starts up. I want to retain the below option by a user to choose the scrolling text message using InputBox, which isn't included in the searches on this fora. The only improvement would be to trigger the timer at...

How to change code to avoid apostrophe/single quote Run-time error '3075': Syntax error (missing operator) in query expression 'tblClients.Subgect IN ('1Sample1-Bank','1Sample2-Credit Card')'. Primary key is text (Subgect); CustomerID is defined as AutoNumber in tables and queries...

A query results form's listbox with selected items opens these selected records in either a form or reports when press spacebar. Problem is, sometimes both form and report open to selected records; sometimes both result in: Run-time error '3075': Syntax error (missing operator) in query...

PHV helped me in a previous thread with solution at bottom of this post. I since added to it to open query results in a report as well as a form when press spacebar to display records selected in a listbox. Sometimes both form and report open to selected records; sometimes both (when make...

Hello all, The following code works for 1 form but not this form (frmAndOr). Get error when try to open a query results form (frmCustomer) to show records selected in listbox (extended selection). Thanks John ---- code Private Sub lstResult_KeyDown(KeyCode As Integer, Shift As Integer)...

Hello all, I am getting this error when trying to open a form to listbox-specified records (I have extended selection on): run-time error '2501': The OpenForm action was canceled. You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a...

Hello all, Am getting an error using code: Run-time error '3075': Syntax error (missing operator) in query expression '[CustomerID] IN ({selected items}) I have extended selection turned on; I can select listbox results with shift, control, but when press spacebar to open selected records...

hello all, Is there a variation of IsLoaded Function for any Access version, from 97 - 2003? So far, my entire Access 97 database vba converts to any recent version through Access 2003; I would like to avoid maintaining more than 1 Access version of design masters solely because of IsLoaded...

Hello All, After decompiling a database with a shortcut as this: "C:\Pathto\MSACCESS.EXE" "d:\Pathto\my.mdb" /decompile and compacting twice (in Access 97 through 2003), is it necessary to import any hidden or system tables objects into a new MDB (by temporarily renaming objects without...

Well, I made some progress as far as no more run-time error 91: Object variable or With block variable not set I probably still have certain formatting lines in the wrong with app and with sheet/range sections. This code works now - it transfers the current record to Excel - but, it saves...

hello all, I probably have certain formatting lines in the wrong with statements - with app and with sheet/range. This code simply transfers the current record to Excel. run-time error 91: Object variable or With block variable not set Thanks John ---- Code Private Sub...

hello all, I'm stuck after trying to combine parts of 3 separate code to export to excel (including what to keep or delete). First, can I combine a text primary key and an autonumber in an AND within a WHERE statement? Second, what is the proper sequence of recordset and Excel lines of...

With thanks to PHV, the below code allows selecting an Excel spreadsheet to export to, but my intent is to only export the current record and subform record. Instead, all records are cycled through, one replacing the previous. Also, the sheet1 tab increments with each record; and records...

Hello All, Using a form with a subform, how to export only the current record (and related subrecord) to Excel, as I already do with Word? The following code gives error Run-time error '3061': Too few parameters. Expected 1. Code---- Private Sub cmdExcel_Click() Dim dbmain As DAO.Database...