Recent content by byterbit

  1. B

    Changing listbox column head titles?

    Prior to adding data to the listbox, add one line, which will become the column headers, as in: Me.List4.AddItem "Seq" & ";" & "Proc #" & ";" & "NO" & ";" & "Operation" & ";" & "Spec" & ";" & "Tech". Be sure to turn on headers in properties. Note too that I'm adding data to the list box manually...
  2. B

    Version incompatibility issues ? MDBs shared between 2000 and 2010 not working wel

    I have a customer with a mixed Access version 2000, 2007, and 2010 network recently showing what look like incompatibility issues. Once a 2010 user simply saves a shared network file, simple VBA code on a 2000 box opening a form fails. I have also noticed similar but perhaps more...
  3. B

    wia video preview class, not

    "Access is unable to save the WIA Video Preview Class object because it does not support persistence, or your computer may have run out of disk space." I have not run out, nor am I lacking persistence, however: This charming dll , Wiaaut , is giving me the easy capacity in VBA to take a...
  4. B

    Findfirst failing with a variable drawn from an autonumber field.

    Findfirst failing with a variable drawn from an autonumber field. That about says it; I grab a variable from the key field (an autonumber) and then turn it into a string ( Ive tried all the ways possible I think ) to find it against a text field. So, in the code I do vcard_fkey = Me!ID and...
  5. B

    SQL Server Backend: linked tables or no more bound forms ?

    Speed and file size issues are driving me to consider a server (MYSQL or SQL Server) back-end. I love Access and want to keep the front end work anyway. Can I be lazy and just link to my tables in the back ? Or must I dispense with bound forms and work at coding my data entry forms ? I...
  6. B

    Question Cant change the data type ; there is not enough disk space or memory

    This MAY have worked HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Jet 4.0 Set up to 50000 I set it, tested it to no avail, came back this morning after a reboot and this worked. (I spend half my time on Linux and forgot (!) about the need (?) to reboot. I had tried compact/ repair...
  7. B

    Question Cant change the data type ; there is not enough disk space or memory

    Error: " MS Access cant change the data type ; there is not enough disk space or memory." (but of course there is) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Jet 4.0 Set up to 50000 Does nothing. Copied all tables into new MDB; no difference. Copied data into new table structure...
See more
Back
Top Bottom