Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    6
    Views
    592

    Re: how to update records through Forms

    A bit confused. In your post you wanted to know how to update records. Now you are saying you want to append records to another table (this is not updating) yet you seem to have these records in a...
  2. Replies
    6
    Views
    592

    Re: how to update records through Forms

    You would have to provide details about the form design and its recordsource. Start with the latter - is it bound or not?
    Then,
    is it single record view,
    datasheet or continuous,
    main form and...
  3. Replies
    6
    Views
    542

    Re: Microsoft Access 14.0 Object Library

    You would need much more familiarity with the Access Object Model than what you seem to have. That can only come through study and learning. There is a M$ web page for the object model, but it's not...
  4. Replies
    6
    Views
    592

    Re: how to update records through Forms

    In addition to binding, it mighty be worth mentioning that in order to commit changes or additions to a form's set of records, you have to do something to cause the change to be committed. This could...
  5. Replies
    4
    Views
    418

    Re: Access: Change Query Sql with VBA

    then there's assigning sql to a variable rather than line continuation characters. Consider aliasing a long table name that get repeated umpteen times.

    Dim strSql As String

    strSql = "SELECT...
  6. Replies
    3
    Views
    396

    Re: Split Access Database Keeps Crashing

    Afraid I have nothing else to offer then, save for suggesting you research Access and 64 bit. Lot's of info/opinion, such as 64b Windows is where the speed gain comes from, not 64b Office, and the...
  7. Replies
    3
    Views
    396

    Re: Split Access Database Keeps Crashing

    Is there any code that hasn't been converted to handle 64 bit memory addresses? Usually this involves API calls and not regular code - except that I have read that some common library references...
  8. Re: "subform datasheet view will only allow me to edit when first opened"

    Sorry I couldn't be of more help. I figured that since you had a prior example that did work and you were trying to replicate it, there had to be something wrong with the filtering. However, if...
  9. Re: "subform datasheet view will only allow me to edit when first opened"

    2 potential reasons I can think of for that - the recordsource only returns 1 record (because of query design) or when it's a table and not a query, the filter causes only one record to be returned....
  10. Thread: Table Compare

    by Micron
    Replies
    7
    Views
    735

    Re: Table Compare

    That means that all values will have the same pattern, but some last names may be for different people? Then I might try adding the Mid function to the prior suggestion to see if what follows matches...
  11. Re: "subform datasheet view will only allow me to edit when first opened"

    Please post more than a few lines of code within code tags (# on forum toolbar).
    I would have guessed that it's not possible to have a table and a field with the same name but I guess I would have...
  12. Thread: Table Compare

    by Micron
    Replies
    7
    Views
    735

    Re: Table Compare

    Therein lies the rub with these sorts of issues. Almost always, the details are revealed one post at a time. What if you have Snuffy, JosephR in one table and Snuffy, Joseph R. in another? I presume...
  13. Replies
    2
    Views
    325

    Re: Tighten up vb code for Access Database

    you could use a clone, but I think all you need is a counter based on the form recordset count and I don't be believe you need to clone the recordset for that. Maybe


    Function RunTotalTestLoop()...
  14. Re: "subform datasheet view will only allow me to edit when first opened"

    could be a number of things, but I'd start with asking if the combo is bound or just has a row source. If you're using it to filter subform records but you have it bound, this is incorrect. Once you...
  15. Thread: Table Compare

    by Micron
    Replies
    7
    Views
    735

    Re: Table Compare

    Just to be clear, those are not examples of different formats. It is the values that are different.
    You have described one simple variation so answers can only be given based on that. If you use the...
  16. Replies
    8
    Views
    1,281

    Re: Maintenance of MS Access Back End

    One other possibility comes to mind. One (or more) users or a process doesn't have the proper permissions on the folder, i.e. the db can be opened but the lock file cannot be created. This will force...
  17. Replies
    5
    Views
    839

    Re: 7: Out of memory (Codes provided)

    This isn't my area of expertise, but since you asked for suggestions, here's mine. You open a connection and if the status is not OK, you don't close the connection. Could you have memory leaks as a...
  18. Replies
    4
    Views
    628

    Re: Preview access report without printing

    After a couple of hours trying to learn how to verify an open database from Excel, I came up with something that was FAR less complicated than what I saw everywhere else. Rather than post it here and...
  19. Replies
    4
    Views
    628

    Re: Preview access report without printing

    a list of runcommand constants
    https://docs.microsoft.com/en-us/office/vba/api/access.accommand

    What you perceive as locking up might just be a slow process, but as I noted, you'll never see it...
  20. Re: Googled but cannot find - Automate a "Run All" button

    That certainly will work, but will also attempt to run if any nosy person opens it to see what it is. If you direct TS to use a shortcut, you can pass a value known as a command line switch from the...
  21. Replies
    4
    Views
    628

    Re: Preview access report without printing

    with 340 you are invoking the print command. Maybe try 54? Or why not just try the OpenReport parameter - acViewPreview?
    Not sure what you are trying to do because I suspect this code won't make the...
  22. Replies
    3
    Views
    491

    Re: Exceptions table

    Did you try using the Unmatched Query Wizard? You should be able to use it to construct a query that returns records from table1 that are not in table 2 and whose sql resembles what was posted.
  23. Re: Update the imported fields with Replace function

    I don't think so. The syntax is

    Replace (string1, find, replacement, [start, [count, [compare]]] )

    REPLACE(MM_Input.SI_ICXX,"" "" """",""))"
    MM_Input.SI_ICXX is string1; the red is what to...
  24. Replies
    2
    Views
    606

    Re: Bound vs. UnBound Forms

    Unless you have a pressing reason to use unbound forms for data, I would not. I see no performance gain; in fact, given that everything would have to be handled by code you'll likely introduce issues...
  25. Re: Update the imported fields with Replace function

    You probably ran into records with Null. You can't use Replace on Nulls, plus you turned off warnings thus wouldn't get the warning that would tell you how many records it couldn't update for the 4...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4