Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.10 seconds.

  1. That quickly becomes a challenge when you have...

    That quickly becomes a challenge when you have two or more developers working on a single front-end. One solution is to use a version control system so that a developer "checks out" an object (form,...
  2. Yes, there is a way, and it involves setting a...

    Yes, there is a way, and it involves setting a default value for each field. The most elegant way is to set a default value of zero for those fields in the table, assuming that the data is being...
  3. Remote Desktop and Citrix are pretty similar. ...

    Remote Desktop and Citrix are pretty similar. We've used both and they work pretty well. I'm not sure what they mean by a "Windows Database Server" but as long as your back-end (hopefully your...
  4. Replies
    8
    Views
    256

    What version of Office (if any) do you have...

    What version of Office (if any) do you have installed on your Windows 10? We need more details about your specific situation to be able to suggest what to try next.
  5. Replies
    6
    Views
    282

    If this has been working for some time, then...

    If this has been working for some time, then something in the environment must have changed. What version of Access, and did that change? Any recent updates to Access? What is the back-end -...
  6. Is RateVersion actually stored as a date field or...

    Is RateVersion actually stored as a date field or is it stored as a text field with the formatting included? If it is stored as a date field, then you could use the Format() function to force the...
  7. How are you trying to sort it by the last field? ...

    How are you trying to sort it by the last field? Are you putting something in the property of the query, or are you putting something in the query grid? I would check to make sure there isn't...
  8. Replies
    11
    Views
    530

    That generally means you have a corrupted VBA...

    That generally means you have a corrupted VBA project or a corrupted form. To test that, import objects in steps to see where you get the error. Do the tables and queries first. Then try importing...
  9. Replies
    3
    Views
    406

    Ah, the memo/long text field issue. You can sort...

    Ah, the memo/long text field issue. You can sort on those kind of fields, but in a limited fashion and the DISTINCT clause does an implicit sort. For more background on sorting memo and long text...
  10. Replies
    3
    Views
    406

    How did you design the query - writing SQL...

    How did you design the query - writing SQL directly, or with the "wizard?" The code you posted is indeed a select query, not an action query, and would not insert any values in indexes or the table....
  11. I'm having trouble understanding what isn't...

    I'm having trouble understanding what isn't working. Since Union queries are not action queries, you don't get any warnings when you run them, so the SetWarnings property doesn't have any effect on...
  12. Does the query run if you disable the SetWarning...

    Does the query run if you disable the SetWarning statements? And what is that query expected to do besides display any results of the query?
  13. Replies
    4
    Views
    543

    Are the data entry form and the search form using...

    Are the data entry form and the search form using the same form so that you end up with two copies of the same form when the search form is open? If you can post a simple version of the database...
  14. Replies
    4
    Views
    543

    One approach you might try is to set the form...

    One approach you might try is to set the form mode to Add each time the form gets focus using the OnFocus event for the form and some VBA to set that form property. But it is a bit of a mystery as...
  15. Replies
    5
    Views
    310

    A couple of observations regarding your table...

    A couple of observations regarding your table design:
    Database normalization guidelines advise not storing calculated values - do them on the form
    Ltrs would appear to be Liters in which case I...
  16. Glad you got it solved - your approach uses the...

    Glad you got it solved - your approach uses the subquery which is sometimes more efficient, but I find it more abstract to understand and debug.
  17. Sorry, I've been tied up with other things the...

    Sorry, I've been tied up with other things the last couple of days. It would also help to have a description of the tables involved for problems like this, but I think your issue is that you really...
  18. It would be helpful to post the SQL string for...

    It would be helpful to post the SQL string for they query that you tried. In theory it should be possible to do what you intend, but the devil is likely in the details. You can do that by simply...
  19. Replies
    4
    Views
    684

    [SOLVED] Actually, that is what BHarder described - and...

    Actually, that is what BHarder described - and you have to install the "Developer Version" to do that. The tools have changed from the days of Access 97 and 2000, but it's the same general concept. ...
  20. I'm not sure I have enough detail to help, but I...

    I'm not sure I have enough detail to help, but I suspect that the linked Excel table doesn't really have a primary key as far as Access is concerned. When you link to an Excel workbook, the...
  21. Have you tried to update a record when looking at...

    Have you tried to update a record when looking at the selection query? I suspect you will find that it cannot be edited. The first thing I would look at is whether you have a primary key on the...
  22. 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...
  23. Replies
    16
    Views
    1,595

    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...
  24. 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...
  25. Replies
    11
    Views
    2,076

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