Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.08 seconds.

  1. [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...
  2. 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...
  3. 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...
  4. Replies
    5
    Views
    415

    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.
  5. 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.
  6. Replies
    4
    Views
    574

    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...
  7. 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...
  8. 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.
  9. 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...
  10. 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:
    ...
  11. Replies
    2
    Views
    475

    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 =...
  12. 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.
  13. 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?
  14. I'm assuming when you said you were " testing of...

    I'm assuming when you said you were " testing of a pass-through query to a MYSQL database compared to an SQL statement " that the SQL statement was an Access query?

    If that is the case, then your...
  15. Replies
    8
    Views
    2,926

    I thought my Office version was up-to-date, but I...

    I thought my Office version was up-to-date, but I checked and was only at SP1. I had auto-update turned-on, but when I ran the update program myself the SP2 update would not install! I had to go to...
  16. Replies
    8
    Views
    2,926

    I don't know, something is wrong. I did a File |...

    I don't know, something is wrong. I did a File | Save As, and the new object didn't show until I closed/re-opened (or compact/repaired). And like I said, this just started happening.
  17. Replies
    8
    Views
    2,926

    Access 2010 odd behavior

    Have you noticed this very recently when using Access2010? You create a new object, but it doesn't appear in the database window. You actually have to close then reopen the database for the object...
  18. Replies
    3
    Views
    845

    I think it has been this way for quite a while. ...

    I think it has been this way for quite a while. Just one of those things you just have to accept and deal with.
  19. Replies
    7
    Views
    675

    You'd want to use: Mid(tpProductID,4)

    You'd want to use: Mid(tpProductID,4)
  20. Replies
    6
    Views
    710

    Is it not allowing you to enter more than 255...

    Is it not allowing you to enter more than 255 characters, or is appearing to be truncated sometime after the fact?
  21. Replies
    3
    Views
    458

    You might consider running a Remote Desktop...

    You might consider running a Remote Desktop Connection from the MAC to a Windows Server. Access within that.
  22. Something doesn't seem right with your query. ...

    Something doesn't seem right with your query. You show that the Title, Forename, Surname, and Organisation fields are in the Category table. Really?
  23. Check your Sorting/Grouping. I'm betting there...

    Check your Sorting/Grouping. I'm betting there is another field being sorted before the "Type of Coverage". You can leave that field in the report, just remove it from sorting.
  24. Replies
    2
    Views
    534

    What is the controlsource for each of those...

    What is the controlsource for each of those controls? Is it just a field from the query? Or maybe an equation?
  25. Setting Default Properties for Controls in Access 2010

    Does anyone know how to set the default properties for controls that are being added to a form in Access 2010? I can do it in 2003 & 2007, but can't find it in 2010! As usual, Access 2010 help is...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4