Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CharlesDFW

    Charles DFW

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

    How can I create a customized InputBox??

    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...
  3. CharlesDFW

    Combo Box

    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...
  4. CharlesDFW

    Listbox

    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...
  5. CharlesDFW

    Cells

    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...
  6. CharlesDFW

    Some questions about efficiency:

    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...
  7. CharlesDFW

    Creating a list for certain data types.

    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...
  8. CharlesDFW

    Changing a SubForm's RecordSource

    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...
  9. CharlesDFW

    Speed: Querydef or recordset string?

    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...
  10. CharlesDFW

    Speed: Querydef or recordset string?

    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...
  11. CharlesDFW

    Searching Before Record Is Entered

    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).
  12. CharlesDFW

    Adding new data to a combo box

    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...
  13. CharlesDFW

    Dynamic SQL select criteria in a Form

    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...
  14. CharlesDFW

    Unexpected Parameter Request for all reports

    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...
  15. CharlesDFW

    Sorting library codes

    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...
  16. CharlesDFW

    Database Question - Data Model

    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>
  17. CharlesDFW

    Look up Customer in table, if not there then notify user.

    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...

Part and Inventory Search

Back
Top