Search:

Type: Posts; User: MarkLiquorman; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    2
    Views
    73

    Basically the cursor has to be sitting in a text...

    Basically the cursor has to be sitting in a text field that can accept the datastream from the card reader. You'd then then have to the format of the string to do anything with it.
  2. If you populated 1RGC with just the codes you...

    If you populated 1RGC with just the codes you wanted, you don't need a LEFT JOIN, you could have used an INNER JOIN. My suggested use of the LEFT JOIN assume you already had a table with ALL the...
  3. Replies
    1
    Views
    127

    I don't really understand what you are asking. ...

    I don't really understand what you are asking. You might want to include the SQL for your query and give an example of what it is (or is not) doing.
  4. If you don't have one, you need a separate table...

    If you don't have one, you need a separate table that just contains all the codes. You need to create a new query that uses a Left Join to connect this table to your previous query, something like...
  5. Replies
    7
    Views
    195

    I don't know about anyone else, but when you...

    I don't know about anyone else, but when you present a convoluted situation like this (one query is a source for another query which in return is a source for yet another query), it would help me if...
  6. Replies
    6
    Views
    277

    I didn't think you could use dbOpenTable and...

    I didn't think you could use dbOpenTable and .Seek on a linked table? Try using dbOpenDynaset and .FindFirst instead.
  7. Replies
    4
    Views
    193

    Perfect normalization is seldom achievable. My...

    Perfect normalization is seldom achievable. My favorite saying (from a fellow I knew from another forum and who is an Access MVP) is to "normalize until hurts, then denormalize").

    In your...
  8. Replies
    8
    Views
    545

    You need a master table of locations, but you...

    You need a master table of locations, but you don't need a "Used" field. Not only don't you need it, it is a BAD idea; you are dependent on this field being updated properly.

    You just need a...
  9. Replies
    4
    Views
    193

    You need to read-up on database normalization. ...

    You need to read-up on database normalization. Your table design would seem to violate one of the basic principles, which results in your having to go through all sorts of manipulates to get what...
  10. Replies
    8
    Views
    545

    But how do you know what is missing? To know...

    But how do you know what is missing? To know something is missing, you must have some idea of what is available. Do you have a master table of locations? If you do, then this is simple, it is just...
  11. Replies
    8
    Views
    545

    First all all, does the table you are looking at...

    First all all, does the table you are looking at use "location" as the PrimaryKey? Or are you looking at a table that has a "location" field, but can have multiple records with the same location and...
  12. Replies
    1
    Views
    227

    Is the field in question defined as a numeric...

    Is the field in question defined as a numeric field?
  13. If you want to accept no more than 5 digits, you...

    If you want to accept no more than 5 digits, you can use an input mask of "99999". For exactly 5 digits, use "00000".
  14. Put an unbound combobox at the top of your form,...

    Put an unbound combobox at the top of your form, with the rowsource being your table. If user enters something "Not In List", you can pop a msgbox.
  15. Replies
    1
    Views
    170

    If you do data entry into those other table via...

    If you do data entry into those other table via subforms on the form to which you entered your _Job record, you then set the Linking field properties: the Master property as ID and the Child property...
  16. Replies
    7
    Views
    614

    Yes, you can do that. The subform containing the...

    Yes, you can do that. The subform containing the info from tblShipHandle will be a continuous-form or a datasheet, so you can see everyone associated with that ship. When you set the master/child...
  17. Replies
    7
    Views
    614

    >>I haven't done it yet, but I can put fields in...

    >>I haven't done it yet, but I can put fields in tblShips to hold the Handle of each person associated with the ship.<<

    NO! This is the absolute WRONG way to do it! You need to create another...
  18. Replies
    1
    Views
    206

    Well, considering there is no "department field",...

    Well, considering there is no "department field", you are going to have a problem.

    Assuming there will be one, first remove any sorting. Then, select each column for sorting in the reverse order...
  19. Replies
    5
    Views
    196

    Just so we are clear on the situation, most of...

    Just so we are clear on the situation, most of the settings being saved to the registry are user-specific. When I save them in the database, they are still user-specific. This does have the...
  20. Replies
    5
    Views
    196

    Storing options in Registry

    I'm an Access developer. A company I do subcontracting work for tends to store a lot of options in the registry, as Access has SaveSetting and GetSetting functions that make this easy. My preference...
  21. Replies
    5
    Views
    307

    I assume you are doing this during data entry,...

    I assume you are doing this during data entry, probably in the Before Insert event of a form. Knowing nothing else about your data, start with this query (I'm assuming the fields are RecordNo,...
  22. Are you talking about upgrading the databases, or...

    Are you talking about upgrading the databases, or just upgrading the version of Access you are using? If the later, I don't see any problem. If the former, your other users might not be able to use...
  23. Glad to help. Good luck with it.

    Glad to help. Good luck with it.
  24. To run it from Access, your code would be a lot...

    To run it from Access, your code would be a lot simpler, something like:

    set rs=currentdb.openrecordset("SELECT CompanyID, ZipCode FROM tblCompany WHERE ZipCode Is Not Null",dbopendynaset)

    do...
  25. I'm curious as to why some companies are not...

    I'm curious as to why some companies are not represented in the test result. For example, I didn't see any recent testing of Symantec products in the AV Comparative results (apparently last tested...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4