Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds; generated 21 minute(s) ago.

  1. Replies
    2
    Views
    88

    From the Access side, you might try: Update...

    From the Access side, you might try:
    Update tblValuation SET OMDone=False WHERE OMDone=False
  2. Replies
    3
    Views
    358

    The usual reason for a parameter box popping up...

    The usual reason for a parameter box popping up is that you've misspelled a table or a field name.
    Best thing to do is to use "debug.print mySQL" before you run the query to show exactly the...
  3. Well, sometimes dealing with queries can be...

    Well, sometimes dealing with queries can be overwhelming. Forest and trees situation.
  4. The simplest way would be to start with a couple...

    The simplest way would be to start with a couple of queries, one for each year. So your qryShipmentsIn2013 might look like this:

    SELECT ProductID, Sum(Quantity) AS QuantityShipped2013 FROM...
  5. To need to execute the runtime.exe on the user's...

    To need to execute the runtime.exe on the user's PC, which will install Access. You will probably then have to create a shortcut to your frontend.accde file which the user can double-click to bring...
  6. First of all, did you download the 64-bit...

    First of all, did you download the 64-bit runtime? Unless you REALLY need the 64-bit version of Access, you are better off with the 32-bit version. This has nothing to do with your operating...
  7. Look again at what I first wrote. You had to...

    Look again at what I first wrote. You had to create another query which just returned the ID# and Min value (or Max value if that is what you needed). You then join that query to the original table...
  8. When you log-in to your LinkedIn account, you...

    When you log-in to your LinkedIn account, you will see a menu bar with "Home Profile Connections Jobs Interests". There is a dropdown menu under "Interests" for Groups.
  9. You shouldn't be using an aggregate function in a...

    You shouldn't be using an aggregate function in a query. It is very inefficient.

    The best way is to create query which just returns the min year for that batch:
    SELECT BatchID, Min([Year]) AS...
  10. I'm not sure of the context in which you are...

    I'm not sure of the context in which you are using it (in a query, in code, etc.). But this is most likely what you need (notice I removed the quotes around the tablename:

    DLookup("[ACCT_NO]",...
  11. Have you considered LinkedIn? There are a...

    Have you considered LinkedIn? There are a variety of Groups there that specialize in Access.
  12. Does the order of fields in a multi-field Primary Key matter?

    As simplified as I can make, a User goes through a process to select clients they want to include in 1 or more reports. The process writes records into a SelectedClients table, with only 2 fields:...
  13. [SOLVED] No problem running 2003 and 2010. I had 2003,...

    No problem running 2003 and 2010. I had 2003, 2007, and 2010 running on same computer.

    When installing, in addition to renaming the directory (as someone else pointed out), I think you may...
  14. Before I give any suggestions, perhaps you can...

    Before I give any suggestions, perhaps you can give me some more info. Is your current database a single database or is it split between frontend and backend? How big is it? How many users do you...
  15. What do you mean by "it did sort them, but...

    What do you mean by "it did sort them, but descending"? Do you mean it did text before numbers, or Z before A?

    Just so you understand, any sorting of a boolean value (which in your case is the...
  16. Replies
    5
    Views
    455

    I'm not sure I fully understand your problem, but...

    I'm not sure I fully understand your problem, but couldn't you set the AllowAdditions property of the subform to Off, then set it to ON when you're ready.
  17. I'm not sure I see the advantage of having the...

    I'm not sure I see the advantage of having the Prefix be an ID#. Seems like a lot of extra work with little or no benefit.
  18. Replies
    4
    Views
    600

    That's right, moving to another record will...

    That's right, moving to another record will trigger the form's Current event for that record, but no control events will fire. If you wanted specific events to fire, you'd have to manually call them...
  19. If you are just talking database design, the...

    If you are just talking database design, the version of Access you use will not really matter much. If your company is using A2007, then design in that. There are some new things in A2010, but...
  20. I've put an Access database on a Linux server,...

    I've put an Access database on a Linux server, but Access itself was run from a Windows workstation. I think that's the best you can do.
  21. Conflict with Access2010 and HP computers

    We just found this at a client site. I don't know if it is restricted to Access2010.

    If the computer has the HP Protect Tools Management Suite installed (whether or not enabled), then something...
  22. This seems reasonable. I use a similar method,...

    This seems reasonable. I use a similar method, except I use a global variable since I've used the technique long before we had TempVars. So my open statement would look like this:
    ...
  23. Replies
    2
    Views
    500

    I have trouble believing the button works and the...

    I have trouble believing the button works and the afterupdate doesn't!

    I'm assuming the button is on the main form. If so, on the first line of the code you have txtUsderFirstName =...
  24. Go to your Control Panel and select Add/Remove...

    Go to your Control Panel and select Add/Remove Programs, and then look for Microsoft Office 2003. Choose the "Change" button, then look for the option to import/export to Excel.
  25. I don't understand your question. Could you...

    I don't understand your question. Could you elaborate with a better example of what you have and what you want to return?
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4