Search results

Query descriptions created in code I used the below to try & create a temporary query that will be routinely created & deleted whenever it is called. The below code is meant to create it & append a description to the query in case sometime in the future I forget what it’s purpose is. Problem is...

SQL help I get a data type mismatch in criteria expression when I try to run the below SQL as my reports record source. Now in the stl statement below, the WHERE statement is my only addition. GLOBALREGIONCODE is a variant and the DIRECTORCODE being compared against it is a LONG INTEGER, is...

How to append more lines at the end of a memo field? I have table field called NOTES which I use to write various notes, sometimes the same note is stretched across several records & I would like to be able to append it to the records using an update query. However, if any of the affected...

Wrap results of debug.Print? I’m examining my SQL statements in debugger, but some of them are quite long & I have to use the horizontal scroll bar back and forth to examine their run time results. Is there some way to get this statement to wrap onto several lines?

Custom control How do you use the OBJECT command from the FORM/REPORT DESIGN category of a command bar’s customize window? I dropped this combo box looking object onto my toolbar but can’t seem to make any changes to it like adding a list index or anything. Please advise. Enclosed is a jpg of...

Report filter I created a toolbar to open a report using filtered criteria but the results are incorrect as per grouping levels set in the report. As per enclosed JPG you can see the selection made in the toolbar doesn’t yield one group, but two groups (the second one in the JPG is a CO-OP...

How does a macro receive a function argument? I’ve done a search on my problem but can’t find a relevant post to help me out but what I’m interested in is writing a macro that will execute a function that takes a string parameter. Now, how do I specify this argument in the macro if I’m using the...

How to by pass CLOSE event? My report deletes a toolbar whenever the report is closed however, I have an option to re-query the report date in order to “refresh” it with new criteria. For this refresh option I am trying to go into the reports design view & then changing its record source by...

Unsuccessful FOR NEXT loop I’d appreciate any help on resolving below which I’ve been trying to clear or get around, unsuccessfully. I wrote the code to examine command bar combo controls and transform the list index into a value in some other variable. Problem is that my command bar also has a...

Well, placing your code doesn’t stop the error unfortunately. You didn’t address the CommandBarComboBox issue I stated above, is that ok by you? Because access doesn’t think so. :D

Sub/Function not defined I’m trying to user the enclosed function to build my report’s filter criteria but as per below, the COMMANDBARCOMBOBOX statement keeps stopping with the error message that the “Sub or Function is not defined.” Any help would be appreciated. 'determines WHERE criteria to...

Thank you, none of my references were MISSING but when I selected an additional one & then unselected it, my problem was resolved! :D

Function isn’t available I recently moved to a new office. I got a new computer running windows 2000 & it operates on an NT4 server. Ever since my move to the new office my reports and some of my forms in my database are not running properly. For now I’ll discuss reports only. I print & email...

For the mean time I have fixed the problem by using a macro instead of a function, seems to have fixed the problem, but now something else has cropped up. The macro is supposed to place the report in design view & then preview view again, to refresh the data based upon certain criteria I...

Command bar properties I created my command bar objects & set their ONACTION property in code but noticed that it is not populating with the function name I specified. Isn’t it supposed to? Here’s what the offending code looks like :D 'places items onto the "Filter Toolbar"... Public Function...

Hehe…yeah that worked John thanks but as I modified my strSql string now to be much shorter & equal a field I’d like to filter on, I’m just having problems getting that to work now, but thanks anyway! :D

Run timer error 2451 While using a standard code module I keep getting run time error 2451 that the report I’m trying to open is misspelled or not opened, but I’m trying to open it, ofcourse it’s not opened & I am using the correct name. Before opening it I’m trying to set its record source...

How do you Edit a toolbar button image through code? How do you “Edit a toolbar button image” through code because I am creating my toolbar through code and can only use the STYLE property to tell it to be msoButtonIconAndCaption, but how can I specify the image to be used as an ICON? Please...

The default is already specified, getting it to accept landscape mode just won't be accepted though. :D

Listindex property I’ve got a few combo boxes on my command bar & when trying to determine the value selected based upon the LISTINDEX property, what function could I use to transform the property into a meaningful value? INDEX perhaps? Please advise. :D