Search results

Reference to column not working Hi Pat. The reason I don't want to use the combo box is because the form is for displaying data only, not data entry. I don't want to confuse users by showing the scroll bars. Also (and you might think this silly :o ), I find the internal margins (lines) around...

The column widths of the StatusID combo box are 0cm;3.995cm. The "0cm" column holds the autokey (1, 2, 3, etc.) and the 2nd column is the text. The text is what I want to see in "=StatusID.Column(1)". Since posting the last time, I think I've found the solution. My form was using the table as...

Thanks, Truckname. My reference IS to the name of the combo box, and the reference to the column number the way I've done it is correct. It is interesting to note that, even if I just give a reference to the control, without the column count (i.e. "=SourceID"), it STILL doesn't work - it's like...

Strange problem here on a form. A combobox field, StatusID, has a look-up (SELECT tblStatus.StatusID, tblStatus.Status FROM tblStatus). The column count is 2, with the first column hidden. The name of the field is StatusID. Since I don't want to show the combo box scroll bars, I've hidden...

Hi Max. I'm using Access 2002 SP3 on Windows XP.

Thanks for that, but perhaps I didn't explain the problem well enough. I only have the On Click event. However, if the user double-clicks, then the problem occurs, i.e. only *PART* of the On Click event happens. Christine

Help! My On Click and On Dbl Click events are not behaving! All my command buttons have On Click events, none of them have any code for On Double Click. However, if a user double-clicks by mistake, SOME of the code associated with the On Click event runs, but not all of it. Here's a sample On...

Thanks for your help, Ken. :) Look forward to hearing from anyone who might have thoughts my the DCount vs. Recordcount question, and Ken's comment about performance. Christine

Thank you, Ken - understood it and it seems to work! I just hope it stays consistent, since like I said, "Me.Recordset.RecordCount = 0 worked most but not all the time. One last favour: can you explain why DCount should be used rather than RecordCount? What is a valid reason for using...

Ken, I have a few questions: Help says that code put in the form's On Open event runs before the form is opened. So, I don't understand your comment. Next, If I move the recordcount to the Main Menu (which opens the form), can you explain how I tell Access to use the query, and then count the...

I have a form, frmReviewSearch, that is based on a query. The OnOpen Event for the form is If Me.Recordset.RecordCount = 0 Then MsgBox "Nothing to find.", vbInformation, "No Data" DoCmd.Close End If Sometimes when you open the form, it says there aren't any records. Close the form, open...

Dear CalmWind, Sorry for the delay since you last wrote. Your last two posts, and especially the one for Now() worked like a charm! Thank you so very much. When you see well executed/written code, it makes novices like me realise that, not only do you need to know Access code and syntax stuff...

Dear CalmWind, Many thanks again - I wouldn't have thought of using two queries. I've been playing around with your revised code for the past few hours but can't get it to produce any datail: all the sums = 0. I've attached a copy of the dB in the hopes you can look at it - I hope this isn't...

Thank you for that, CalmWind. I like your code better than the thought of having to construct a whole much of separate queries! Could I trouble you again? I'd like the output so that only the number of records for each critiera are displayed, like this: #CARs #CARs...

I just can’t seem to get the hang of writing queries hope someone can help me figure out what to put where in the query design grid. I feel pretty dumb not being able to figure it out, especially since my boss wants a report asap :confused: . What I need to do is to figure out how many CARs...

I haven't received any response to my post of 27 October and hope that by reposting it someone can help, since I've yet to figure out how to programme what I need. Any takers? Thanks, Christine. The main part of my form has fields for selecting multiple search criteria. The subform shows the...

The main part of my form has fields for selecting multiple search criteria. The subform shows the results of the search. (Based on Dave Eyley’s MultiCriteriaSearch demo from here.) Me.Searchstr = Searchstr Me.Respond_Search_subfrm.Form.Filter = Searchstr...

Where to put Select Case for unbound field - thank you Thanks, Wayne. I thought using so many multiple IIFs would be way too confusing, but your indented the example makes it much easier easier to figure out what's going on. Cheers again. :) Christine

I have a subform, set to Continuous Forms, that presents information from a query in columns: Job Number Current Status There is a hidden field from the qry/Table called “Status”. I would like the output for Current Status (an unbound field) to vary depending on the value of...

Retrieve name of current table? - Thanks Thank you, Tim. Now, why didn't I think of that!!! :o