Search results for query: *

Oops, my apologies for adding that extra &quot;s&quot; in there.<br><br>Thanks for catching it Amiel

Dirk.<br><br>This is fairly easy to do and it involves the difference between loaded forms and visible forms. Assume the form you want to use to get the date is called &quot;GetMyDate&quot;. The control that contains the date is called &quot;Datebox&quot;<br><br>On your calling form, put a...

If I understand you correctly, this might work.<br><br>For the rowsource in your combobox, include all the fields that you want showing when an order is selected. For example, your rowsource SQL might be<br><br>&quot;SELECT Ordernumber, customer, date, pronumber, billto FROM...

Ah. Similar to your first question. I think you're trying to treat a listbox as a more useful tool than it really is. I've tried a few times to do that myself, and it just ends up not being worth the time spent.<br><br>What you probably want instead is a subform. The object source for the...

Hmm. If I understand your question, I don't think you really can. A listbox is more like a database table than a spreadsheet. It consists of rows determined by the rowsource. When it initializes, it gets from its rowsource the rows to use, and that's what's going to be there for the user to...

Dirkg:<br><br>I would add to DougP's comment.<br><br>If you're hard coding the creation of a querydef, why not simply create the query and keep it in the database as an object. If you don't want users to see it, mark it hidden. I recommend this because as a persistent object in the database, it...

I don't understand this question, specifically, the part about: &quot;that the data type has to use &quot;<br><br>You can work out just about anything like this, though, using a table with two fields. Field 1 is the data you need to use, field 2 is the state. This table becomes the row source...

Brian,<br><br>If it works at all, it should work with the following:<br><br>Me.Subdenclaims.Form.recordsource = &quot;qbfclaimdenall&quot;<br><br>Also, though, if the subform is like an &quot;order items&quot; list to the main form's &quot;order,&quot; you might want to consider applying a...

Many thanks, Doug. I always prefer to use my own SQL string, too. Makes it a lot easier on me.<br><br>But the documentation says that a compiled querydef runs much faster because it uses the database statistics to perform Rushmore optimization on the querydef.<br><br>I guess my question is, is...

Anyone out there know which is quicker?<br><br>A created and compiled querydef with a parameter set by code<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;or<br>Opening a recordset using a generated SQL string.<br><br>Documentation suggests that the...

I agree with DougP. This is what the combobox was made for. And if you set it to &quot;limit to list&quot; and attach code for the &quot;on notinlist&quot; event, that code can call up your data entry form. (Don't forget to set the &quot;Response&quot; flag in that code).

Hmm. I'm a bit confused about how you're doing it. But if choosing something in the first combo box changes the rowsource for the second, then I think adding shouldn't be hard. The documentation is confusing, but this is what I've puzzled out.<br><br>Mark the second combobox as &quot;limit to...

If, for example, you wanted to change the recordsource for the form when a selection is made from combobox cboPickOne on that form, you might have in the combobox's lostfocus event:<br><br>me.filter=&quot;[Myfield]=&quot; & cboPickOne.value<br>me.filteron=true<br><br>As soon as the user chooses...

If the problem is that the query includes jobno, but you don't need it, why not do a new query that doesn't include jobno and use that as the report's datasource.<br><br>If you have to have jobno for the data to work, then you should probably dim a qdf object in code and set the parameter for...

I'm a bit confused. When I enter letter/number combinations in one field of a table, it sorts nicely, letters first, then numbers without splitting anything. Do you mean you must sort the numbers first even though they come after the letters? That suggests they are not subsets of the letters...

Sorry, I lost you in all of that.<br><br>However, as best I can figure, it looks vaguely like a many-to-many join table might work with one table's record recording invoice, customerid, and payment amount.<br><br>Does this fit? Or am I completely off the wall?<br><br>

Lanie,<br><br>The trick is in changing the response parameter that is passed in the first line of the &quot;Sub. . .&quot;<br><br>There are constants that tell Access what to do when a record is added. You need to include the following:<br><br>Response = acDataErrAdded<br><br>Access will...