Search results

Set combo rowsource on form open event Unless I’m mistaken you can set a combo box’s rowsource on the openEvent of a form correct? In my combo’s property sheet I specified a type of “Table/query” as well as the number of columns and which one is bound. And then I placed the below code into my...

Well, I guess that’s my answer, yeah I wanted to be able to update the query without viewing the selected records before hand. I tried testing it like you said and it seems it’s the way to go for me currently. Thanks!

Update a parameter query? I’m running a parameter query, and based on the results I see I’d like to be able to update the filtered (paramaterized?) recordset using an update query (I guess) Is this possible? I guess I’m afraid of updating anything other than the results brought up by the...

hey thanks, I just wound up creating a query to suit my needs, and I meant hiding columns in the query. Right now though what I’m doing is: -running macro to open query -going to the bottom of query -going to a field called dealerNumber -microsoft shortcut key / filter by selection -going to...

Hiding query columns How can I hide query columns in using a macro? Please advise.

Voila! strSQL = "SELECT RetailerNumber & '-' & RetailerStoreNumber & ' ' & StoreName AS Retailer,RetailerNumber,RetailerStoreNumber,StoreName,Address1,Address2,City,Province,PostalCode,PhoneNumber,RegionCode FROM tblRetailerStore WHERE RegionCode ='" & 1301 & "' AND StoreName LIKE '*Home...

I modified to this & tells me there’s a syntax error… strSQL = "SELECT RetailerNumber & '-' & RetailerStoreNumber & ' ' & StoreName AS Retailer,RetailerNumber,RetailerStoreNumber,StoreName,Address1,Address2,City,Province,PostalCode,PhoneNumber,RegionCode FROM tblRetailerStore WHERE RegionCode...

SQL help Could someone help me polish my SQL below? I’m trying to set a combo box’s row source and am trying to tell the WHERE clause of my SQL to search a field for an occurrence of the word “Home Hardware” any place in the field, but I haven’t gotten anything to work yet. Please advise...

Never mind I was able to resolve on my own.

Set combo type/rowsource I’m trying to set the row source type and rowsource of a combo box based upon the selection made in a previous combo but right now I keep getting the error that the “data type mismatch in criteria expression” This happens when I use the first combo, and then goto the...

Yes I’m sure its not storing the primary key because when I check the record source behind my form, I can see that the row # of the filtered list is being saved. I put 0 (the list index as the bound property) it should have been 1, problem solved thanks!

It’s a key like 33333-00001.

Combo saving row # not field My bound combo box accurately provides a filtered list of choices to choose from but the value stored in the field bound to the combo control is the row number of the filtered list provided by the combo control. My combo control ought to be storing a retailer number...

Can only make certain combo box selections The row source type for my bound control is from a table. The rowsource is a query based on the table. Essentially combo shows a retailer and retailer store number as well as the retailer name. What I’m finding though is that whenever I make a selection...

Parameter query I’d like to set up a parameter query that displays two fields, a referenceNumber and a field that can be anything from the underlying query. How would I set it up so that the parameter asks for the field name, I type it in and the query displays showing the referenceNumber field...

List box My form allows the user to select items from a list box and then preview the report. The first time I ran it the report ran for a single list box selection. Now when I run it (for whatever selection I make, irregardless) the form continually comes up blank, even after closing it and...

Links within a database I have a database set up as the backend of an asp www site, filled with my reviews. Problem is that I would like the site and my database at home to provide certain functionality, if you read my review below, I sometimes refer to other titles I’ve reviewed. By clicking on...

but 1201 satisfies the condition set by the second case doesn’t it?

Select case I wrote the below but the second case does not execute for something like say, 1201. I was hoping for any insight. Please advise. This fragment appears in the format event of a header of a report grouped upon code. Select Case code 'directors & sal coord... Case 1100, 1200...

thanks!