Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.19 seconds.

  1. I suspect Paul has identified your problem, but...

    I suspect Paul has identified your problem, but some further information would be helpful in suggesting a long-term solution. Is this a one-time project, or do you need to do this periodically, and...
  2. Replies
    16
    Views
    765

    For one thing, you haven't defined the type of...

    For one thing, you haven't defined the type of Msg so it defaults to the type variant but you really want it to be a text value so you should say Msg As String. In addition, it may well be that Msg...
  3. Much of what you are seeing was introduced in...

    Much of what you are seeing was introduced in Access 2007, and Transitioning Your Existing ... Apps to 2007 describes the changes and how to best work with the new concept. One that you might...
  4. Replies
    11
    Views
    1,404

    [SOLVED] Your situation seems most unfortunate. For one...

    Your situation seems most unfortunate. For one thing, that error code is an undocumented one in Access, although it is documented for Excel. The most common corruption issues seem to be with the...
  5. Replies
    2
    Views
    215

    Unfortunately that is something that is either...

    Unfortunately that is something that is either very difficult or impossible to do in a query. You can do all sorts of things with a DAO or ADO recordset to create a sequential number, but queries...
  6. [SOLVED] I've never even considered using the multi-valued...

    I've never even considered using the multi-valued field. I converted several legacy systems to Access, and multi-valued fields always caused problems with data integrity and consistency. In your...
  7. Are you closing the database before you try to...

    Are you closing the database before you try to quit Access? If so, you cannot run a macro in a database if that database is closed. So just the QuitAccess should be all you need. If you are not...
  8. Replies
    2
    Views
    462

    I think this tip...

    I think this tip from Allen Browne will help you out. The "Form" must always precede the name of the subform. Also note that the reference should be to the name of the subform control on the main...
  9. Replies
    5
    Views
    601

    You might try creating a SQL Server view of the...

    You might try creating a SQL Server view of the Order table with a join to the Notes table and include only the NotesDateTime field, but use the DISTINCT keyword, and use that as the data source for...
  10. The first question is whether or not you really...

    The first question is whether or not you really need a relational database. Answering that question typically requires answers to a number of questions such as how large the data is, how it is...
  11. Replies
    4
    Views
    550

    Windows networking has changed significantly from...

    Windows networking has changed significantly from XP to 8.1, and that is probably the reason you are having issues trying to start your database. Several questions to help clarify the situation:
    ...
  12. Replies
    1
    Views
    242

    Are you actually importing a report, or is it...

    Are you actually importing a report, or is it something in RTF or comma delimited format? As long as you are able to get it to Access in a text field, then you can use the concatenation capabilities...
  13. Replies
    16
    Views
    2,046

    Some further questions and thoughts based on the...

    Some further questions and thoughts based on the posts of others:

    It's still not clear as to whether you are deploying the front-end to each workstation - from your description it doesn't sound...
  14. Replies
    11
    Views
    737

    If you decide to adopt Office 365, you will face...

    If you decide to adopt Office 365, you will face some choices. Assuming you get the version that includes Acccess, you will end up with what is effectively 2013, though there are hints that a new...
  15. Replies
    16
    Views
    2,046

    The advice from Mark and BHarder is spot on. I...

    The advice from Mark and BHarder is spot on. I don't see any reason to abandon Access completely. I've spent over 20 years developing client/server applications, starting with a beta version of...
  16. Replies
    1
    Views
    190

    The result you see in the debug window is 12:00...

    The result you see in the debug window is 12:00 noon with a zero day - remember that Access stores all dates with a time component as well. Are you doing this in VBA, or in a query? If it is the...
  17. Replies
    1
    Views
    235

    Hi Jack, nice to see you back visiting. ...

    Hi Jack, nice to see you back visiting. Unfortunately the MS Graph applet (for lack of a better term) has a number of limitations, and the current MS party line is to use Automation to build charts...
  18. If I understand your situation correctly, you...

    If I understand your situation correctly, you want to add a new record to the underlying table which is being displayed on a subform, but you want to add the new record at the top of the subform, not...
  19. Replies
    8
    Views
    1,991

    It's reasonably easy to do. Click on the modules...

    It's reasonably easy to do. Click on the modules in the Nav Pane (2007 and later) or the Database Window (2003 and older), and create a new module, copy the code suggested, and that should make it...
  20. Replies
    4
    Views
    1,984

    Another option in Access 2007, 2010 and 2013 is...

    Another option in Access 2007, 2010 and 2013 is to right-click on the print-preview, and that gives you the option to export the report to PDF (as well as some other formats and options). Of course...
  21. You might consider using the IN() construct...

    You might consider using the IN() construct rather than doing so many ="x" clauses, i.e. IIf([Cams_Change_Data1]![Status_Code] In("D","E","O","P","S"),"At EB",.....).
  22. Replies
    8
    Views
    1,991

    A further suggestion - there is a function in VBA...

    A further suggestion - there is a function in VBA that will find the first occurrence of a specified string within a given text string. It is called InStr() and you can read about it here.. It does...
  23. Replies
    8
    Views
    1,991

    With that sort of data, the standard sort...

    With that sort of data, the standard sort routines really don't work. Do you need it sorted that way on numerous reports and forms, or is it just a single report or two. If you are dealing with the...
  24. Replies
    3
    Views
    978

    As long as multiple users will be using a...

    As long as multiple users will be using a database, and you want them all to see the same content, the back-end of the database needs to have a common file path, so you will already have the file...
  25. Replies
    6
    Views
    579

    It appears that you have chosen the automatic...

    It appears that you have chosen the automatic option on the alternate rows feature. Take a look at Access 2010: Change Alternate Row Color and follow the procedure shown there, even though it is...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4