Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.16 seconds.

  1. Replies
    5
    Views
    300

    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...
  2. Replies
    2
    Views
    116

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

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

    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...
  7. 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...
  8. Replies
    4
    Views
    418

    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:
    ...
  9. Replies
    1
    Views
    186

    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...
  10. Replies
    16
    Views
    1,605

    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...
  11. Replies
    11
    Views
    640

    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...
  12. Replies
    16
    Views
    1,605

    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...
  13. Replies
    1
    Views
    152

    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...
  14. Replies
    1
    Views
    196

    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...
  15. 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...
  16. Replies
    8
    Views
    1,708

    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...
  17. Replies
    4
    Views
    1,458

    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...
  18. 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",.....).
  19. Replies
    8
    Views
    1,708

    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...
  20. Replies
    8
    Views
    1,708

    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...
  21. Replies
    3
    Views
    878

    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...
  22. Replies
    6
    Views
    547

    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...
  23. Replies
    6
    Views
    547

    It's difficult to tell what is making the dark...

    It's difficult to tell what is making the dark background without knowing what version of Access you are using.

    Some possibilities are conditional formatting, or alternating rows, but there may be...
  24. Replies
    4
    Views
    942

    Good to see you in the Lounge again - you've...

    Good to see you in the Lounge again - you've actually been here longer than I have! One question occurs to me in reading Mark's reply. Do you have people who work for a month or two, then don't for...
  25. Replies
    6
    Views
    547

    What version of Access are you using? In more...

    What version of Access are you using? In more recent versions it is possible for text boxes to be grouped together so they all have the same width. However, the design view suggests that isn't the...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4