Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.12 seconds.

  1. Replies
    2
    Views
    55

    You can create a query that joins to the crosstab...

    You can create a query that joins to the crosstab query using the Handle field, and add the contact info from tblAllLocated. It should be pretty easy - just another select query using the crosstab...
  2. Because this is such a complex subject, with many...

    Because this is such a complex subject, with many alternatives, a few questions are in order:
    1) Are you proficient in VBA?
    2) Do you understand the Access object model?
    3) Do you have any...
  3. Replies
    9
    Views
    247

    If Meter and LastMeter are field (or expression)...

    If Meter and LastMeter are field (or expression) names, then they should be enclosed in square brackets. Try

    IIf([Meter]>[LastMeter]+672,"Then Cancel"=True)

    However, I don't know if you can...
  4. Replies
    7
    Views
    224

    Have you tried making the table the data source...

    Have you tried making the table the data source for your report (with no sorting)? It certainly sounds like the query is what is truncating the fields.
  5. Replies
    7
    Views
    224

    The most common cause of truncation of memo...

    The most common cause of truncation of memo fields is some sort of sort or other function being applied to the data as a part of the process of building the report. It can be an explicit sort in the...
  6. You are the second person to raise this topic in...

    You are the second person to raise this topic in the last few days on various forums I frequent. From what I've been able to deduce, it got installed if you installed any version of SQL Server prior...
  7. Replies
    6
    Views
    340

    Hopefully, Gary's post will solve your issue. ...

    Hopefully, Gary's post will solve your issue. But it is possible that the database was setup to use User Security - do you get a prompt for both a UserID and a password, or just a password. If it's...
  8. Welcome to the Windows Secrets Databases forum. ...

    Welcome to the Windows Secrets Databases forum. It appears you have done a good job of normalizing your data based on your relationships diagram. A couple of pieces of additional information would...
  9. Replies
    8
    Views
    374

    Unfortunately the ability to modify custom...

    Unfortunately the ability to modify custom toolbars was pretty much removed in recent versions of Access. The only way I've been able to do that is to go back to an installation of Access 2003, do...
  10. Thread: Access ODBC

    by WendellB
    Replies
    5
    Views
    167

    There is a tool to re-link tables called the...

    There is a tool to re-link tables called the Linked Table Manager that will do the trick for you, but if you are actually moving the application from workstation A to workstation B and you have the...
  11. Replies
    2
    Views
    168

    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,...
  12. 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...
  13. 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...
  14. Replies
    8
    Views
    634

    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.
  15. Replies
    6
    Views
    480

    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 -...
  16. 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...
  17. 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...
  18. Replies
    11
    Views
    796

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

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

    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....
  21. 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...
  22. 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?
  23. Replies
    4
    Views
    621

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

    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...
  25. Replies
    5
    Views
    384

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