Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    1
    Views
    50

    So far we haven't made any adjustments, as most...

    So far we haven't made any adjustments, as most of the tablets or ultra-books have a resolution that will work with a design where we expect a resolution of something like 1024 by 768 pixels minimum....
  2. Replies
    1
    Views
    45

    Have you applied all the latest updates for...

    Have you applied all the latest updates for Office/Access 2013? If not, do that first. Then do a Compact and Repair on each database. As they are .mdb extension files, they are either in the 2000...
  3. Replies
    23
    Views
    898

    Thanks to all. I have managed to Capture Username...

    Thanks to all. I have managed to Capture Username and Time of Import through Update SQL. (Note that this could also be done by setting defaults for the 2 added fields.)

    Now I require help on the...
  4. Replies
    4
    Views
    88

    Indexing has to do with the design of tables, and...

    Indexing has to do with the design of tables, and it provides a quick way to find records in one table that link to a specific record in another table. It is a property that you set for a field in...
  5. Replies
    4
    Views
    88

    Does each workstation have it's own copy of the...

    Does each workstation have it's own copy of the front end? If not, that could be an issue. But more than likely the issue is with the data source for the subform and the form. Have you checked to...
  6. Lots of others are debating those same issues,...

    Lots of others are debating those same issues, and it seems there isn't much consensus. In fact there doesn't seem to be much guidance either. I don't have personal experience, but did work with...
  7. Is your form constructed so that the...

    Is your form constructed so that the [Contact_Last_Name] text box is always entered before the [Relationship_to_Applicant] combo box is chosen? If so you could use a VBA procedure on the combo box...
  8. Thread: UCase syntax

    by WendellB
    Replies
    7
    Views
    312

    There seems to be a disconnect here. RG showed...

    There seems to be a disconnect here. RG showed you the correct syntax if you want to convert it to UPPER case using the UCase() function. Your statement would convert it to what is called Mixed...
  9. For web databases, the answer is no as I...

    For web databases, the answer is no as I understand it. The trick used in Access tables is some magic in the Jet or Ace engine, and isn't available in SharePoint or SQL Server web databases.
  10. I don't think the default value for that field...

    I don't think the default value for that field would have any effect here. We really need to know whether the grid you displayed is from a table or a query. If it is from a table then there is...
  11. Replies
    23
    Views
    898

    Sorry for stepping in late, but it appears to me...

    Sorry for stepping in late, but it appears to me there is a communication problem here. On 9 August you said yet on 10 August you say

    I believe that the daily Excel workbook is nowhere near 1...
  12. Replies
    2
    Views
    350

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

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

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

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

    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...
  16. Replies
    7
    Views
    582

    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...
  17. 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...
  18. Replies
    3
    Views
    569

    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...
  19. 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...
  20. 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...
  21. 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...
  22. 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...
  23. Replies
    2
    Views
    313

    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...
  24. 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...
  25. 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...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4