Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.32 seconds.

  1. Replies
    2
    Views
    243

    My suspicion is that your error-handling code is...

    My suspicion is that your error-handling code is hiding an error message that happens when the form is opened. I would disable both of the On Error GoTo Err_Quit_Click statements by putting an...
  2. Replies
    2
    Views
    198

    The usual solution for this issue is to do a...

    The usual solution for this issue is to do a Sum() of the field with the check mark - the True conditions will be a -1 so you then have to take the ABS() function and convert it to a positive number....
  3. Replies
    7
    Views
    418

    That does look to be a more elegant approach than...

    That does look to be a more elegant approach than creating a temporary table.
  4. Replies
    2
    Views
    208

    Are both signatures the same tyhpe of image? If...

    Are both signatures the same tyhpe of image? If one is a BMP for example and the other is a PNG, it may be that one of the types doesn't have a application associated with it. OLE objects in Access...
  5. Replies
    7
    Views
    418

    Are the tables linked using ODBC - if so I think...

    Are the tables linked using ODBC - if so I think it is the outer join that is causing you grief. The ODBC driver has to convert that to either T-SQL or ANSI SQL and that may be the source of the...
  6. Pat has given you the essential details assuming...

    Pat has given you the essential details assuming that you use what is called a bound form - which means that the form (or subform) has the table as it's data source. However if you actually want to...
  7. Replies
    3
    Views
    343

    The bottom line is that Access won't run under...

    The bottom line is that Access won't run under Linux, even with Wine installed. Access first has to be installed, and it has some low-level drivers that cause problems in addition to other issues...
  8. The evolutionary path that Microsoft would...

    The evolutionary path that Microsoft would suggest is to create a web-app using SharePoint, and that might be an alternative, but it does preclude the use of VBA in your "front-end" - does your...
  9. I agree - that's a very appropriate question. I...

    I agree - that's a very appropriate question. I suspect it's the development effort to do a web app and having the existing Access app. We've had some success with hybrid databases using a SQL...
  10. With that additional background, you do need to...

    With that additional background, you do need to be concerned about limiting the amount of data collected. If the main form is only displaying a single record, that works pretty well, and the...
  11. In addition to Rui's comments, are you users all...

    In addition to Rui's comments, are you users all on a co-located LAN? If so, the issue of bound forms isn't that much of an issue, assuming the LAN runs at 100 Mbit. If on the other hand, they are...
  12. Replies
    2
    Views
    211

    Debugging issues on runtime installations is very...

    Debugging issues on runtime installations is very tricky as you don't have the usual error handling tools like you do with a full version of Access. You start the runtime version by clicking on the...
  13. Yes, that does get complicated. You probably...

    Yes, that does get complicated. You probably need to add a sequence field to your table so you can get a predictable order for queries by sorting on that. Then you need to create a query of the...
  14. Is the 4,5,7 sequence in the same record, or are...

    Is the 4,5,7 sequence in the same record, or are they successive records? If they are in different successive records, then you have a real challenge, and you have to resort to some gymnastics using...
  15. Replies
    9
    Views
    863

    Have you tried the UNC path rather than using a...

    Have you tried the UNC path rather than using a mapped drive, as Pat suggested? I've never seen something that would link using the Linked Table Manager, and not link programmatically, but there's...
  16. Replies
    9
    Views
    863

    These tend to be rather thorny problems to debug....

    These tend to be rather thorny problems to debug. First, are the back-end tables in an Access .MDB file, or are they in SQL Server, mySQL, dBase, or other database engines? Also, if they are in...
  17. As best I can tell after doing some limited...

    As best I can tell after doing some limited research, it should be possible to do what you are suggesting. It is possible to initiate a connection to a SharePoint list using VBA, so you should be...
  18. Replies
    13
    Views
    822

    Actually, I think the second suggestion RG made...

    Actually, I think the second suggestion RG made is a better one - it turns out that getting the current page number for a page being printed is quite convoluted when using Group By section breaks to...
  19. Replies
    2
    Views
    206

    There are some issues with doing mail merges from...

    There are some issues with doing mail merges from queries if the query includes a parameter prompt. If you take that approach, then you have to resort to using the older DDE technology. If you want...
  20. Replies
    4
    Views
    261

    If I understand correctly, you are looking at a...

    If I understand correctly, you are looking at a situation where the user enters the house number and the street name in the same text box. In that case there isn't any easy way to search on both, or...
  21. That's not a problem I've seen, but I've only run...

    That's not a problem I've seen, but I've only run Access 2013 on Win8.1. Were you running 2007 previously on Win 7 or Win 8 and then upgraded? Or is this effectively a new PC? In Win 7 there were...
  22. Replies
    3
    Views
    269

    Then I think the only option is to set the record...

    Then I think the only option is to set the record locking option in your Access front-end to lock the record as soon as a user opens the record.
  23. Replies
    2
    Views
    263

    In general combo boxes aren't used to that many...

    In general combo boxes aren't used to that many columns, simply because you run out of horizontal space when all of them are displayed. So I presume you are hiding some or most of the columns. The...
  24. I am suspicious that there may be an...

    I am suspicious that there may be an inconsistency between the OLE Automation (you should have a reference set to that as well as Excel) object for Office 2003 which is probably what Access is using...
  25. In order to do what that line of code is trying...

    In order to do what that line of code is trying to do with Excel, you need to have a reference set to Excel 2013. Open the VBA module and do Tools/References and see if you have a reference set for...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4