Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    4
    Views
    167

    [SOLVED] I think you may also have to set .FilterOn = True

    I think you may also have to set .FilterOn = True
  2. Replies
    4
    Views
    412

    Oop! DateSerial is an Access function. There is...

    Oop! DateSerial is an Access function. There is now a comparable function in SQL 2012 named "DateFromParts" (actually, there are several variations).

    But for SQL 2008 you might try this (it is a...
  3. Replies
    4
    Views
    412

    Date2 = DateSerial(Year(Date1), Month(Date1),1)

    Date2 = DateSerial(Year(Date1), Month(Date1),1)
  4. Based on what you described, I don't understand...

    Based on what you described, I don't understand the reason for that first query, nor do I understand the need for all those intermediate tables! In your 2nd query, can't you just join to the table...
  5. Replies
    2
    Views
    159

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

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

    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...
  7. Well, sometimes dealing with queries can be...

    Well, sometimes dealing with queries can be overwhelming. Forest and trees situation.
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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.
  13. 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...
  14. 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]",...
  15. Have you considered LinkedIn? There are a...

    Have you considered LinkedIn? There are a variety of Groups there that specialize in Access.
  16. 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:...
  17. [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...
  18. 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...
  19. 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...
  20. Replies
    5
    Views
    515

    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.
  21. 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.
  22. Replies
    4
    Views
    643

    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...
  23. 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...
  24. 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.
  25. 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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4