Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.10 seconds.

  1. Is this a query that was done in Microsoft Access...

    Is this a query that was done in Microsoft Access and you are now trying to create the same query in Microsoft SQL Server in T-SQL? The reason I ask is that Access does not in general use the INNER...
  2. Replies
    3
    Views
    195

    To repair your Access 2013 installation, open...

    To repair your Access 2013 installation, open Control Panel, click Programs, and then click Programs and Features. That will list all of the programs installed on your PC. Find Microsoft Office...
  3. Replies
    2
    Views
    396

    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....
  4. Replies
    3
    Views
    195

    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...
  5. Replies
    29
    Views
    1,313

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

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

    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...
  8. 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...
  9. 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...
  10. Thread: UCase syntax

    by WendellB
    Replies
    7
    Views
    443

    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...
  11. 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.
  12. 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...
  13. Replies
    29
    Views
    1,313

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

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

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

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

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

    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...
  18. Replies
    7
    Views
    628

    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...
  19. 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...
  20. Replies
    3
    Views
    760

    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...
  21. 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...
  22. 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...
  23. 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...
  24. 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...
  25. Replies
    2
    Views
    371

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