Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    6
    Views
    166

    [SOLVED] If you look at the property sheet for form...

    If you look at the property sheet for form [Progress Report] (btw, you should get out of the habit of embedding spaces in names), you will notice that it doesn't contain anything in the Before Update...
  2. Replies
    6
    Views
    166

    [SOLVED] OK, I downloaded you db, but which form is...

    OK, I downloaded you db, but which form is causing you the problem, and where is the "lame button" you created?
  3. Replies
    1
    Views
    107

    Assuming each item is a record in the detail...

    Assuming each item is a record in the detail section of your report, I create a blank image control. Then in the Detail Section's Format event, I then use something like this:
    ...
  4. Wouldn't it be simpler if you just had a 2 fields...

    Wouldn't it be simpler if you just had a 2 fields for each Employee: DateJoined and DateLeft?
  5. Replies
    5
    Views
    230

    I want to second what Joe said. I've had...

    I want to second what Joe said. I've had situations where some IT guy (who just upgraded their hardware) will say "You have a 64-bit O/S, you should use 64-bit Office". Yeah, and they had problems,...
  6. Replies
    5
    Views
    230

    There is really very little you need to do. No...

    There is really very little you need to do. No conversions are needed, basically you should be able to just using Access 2010. Berton mentioned the 32-bit and 64-bit versions; if you are currently...
  7. When you use a reference to a form in a query,...

    When you use a reference to a form in a query, and then try to use that query in a form or report you frequently run into this error. This can usually be solved by using the Eval() function. For...
  8. Replies
    4
    Views
    338

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

    I think you may also have to set .FilterOn = True
  9. Replies
    4
    Views
    559

    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...
  10. Replies
    4
    Views
    559

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

    Date2 = DateSerial(Year(Date1), Month(Date1),1)
  11. 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...
  12. Replies
    2
    Views
    204

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

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

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

    Well, sometimes dealing with queries can be overwhelming. Forest and trees situation.
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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.
  20. 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...
  21. 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]",...
  22. Have you considered LinkedIn? There are a...

    Have you considered LinkedIn? There are a variety of Groups there that specialize in Access.
  23. 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:...
  24. [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...
  25. 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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4