Search results

  1. V

    Exclusive Access - maddening code

    Maddening yeah? :p I'm assuming that either pulling the tableDef or touching the controls is putting some kind of design lock (not a record lock) on the database... but...like...why? how? -- stupid Microsoft... :banghead: The ().close are in there to try to fix this...they weren't in there...
  2. V

    Exclusive Access - maddening code

    Now I remember: Here's the issue with using "Field List" I need this database to be idiot aware (nothing is idiot proof) If you notice - my code puts a dummy default value in the field list. So if the user accidently selects a field - they can change the value back to "Not Selected" When we...
  3. V

    Exclusive Access - maddening code

    Well that would simplify things wouldn't it. I feel like there was a reason I didn't use that in the first place, but I'll see if I can make that work and let you know. Thanks man!
  4. V

    Exclusive Access - maddening code

    :banghead: I'm coding on a locally stored db. I have a code snippet that's locking my database, but it should not be. Code: --Gets field names from the selected table to put into comboboxes on my form. Dim masterTable As DAO.TableDef, thisDatabase As DAO.Database Dim fieldList As...
  5. V

    VBA Recordset DB Corruption

    It's been a while. I've been slammed! Yesterday and this morning I rebuilt my large data cleanup process to update the records using sql queries instead of the record set. It works! It's running right now and I estimate its about 1/2 through the names columns. Normally it would have bloated...
  6. V

    VBA Recordset DB Corruption

    Word. I give it a try and let you know what happens. This may take a while.
  7. V

    Passing an Object (sounds funny dunt it?)

    Maybe put the full control name into a string variable created with each pass then call the object with the string. like so: Private Sub LockReagentPerCraft() Dim i As Integer 'loop counter For i = 1 To 8 cboNameCall = "Me.cboReagent0" & CStr(i) txtNameCall =...
  8. V

    VBA Recordset DB Corruption

    Yep - for the name I update 4 fields for each row. On the 250,000 record table I'm dealing with I update every single one. so that's 1,000,000 updates for the name alone. Sheesh... I have an idea that Might work. I can use VBA to do the cleanup and dump the clean parts into variables then...
  9. V

    VBA Recordset DB Corruption

    Unfortunately the algorythms that I have to run the names through to separate them pretty much eliminates the use of sql queries. If the files I got were in the same format every time I might be able to make it work, but we get random stuff with god-knows-what in them. I created this process...
  10. V

    Passing an Object (sounds funny dunt it?)

    you could try this if you are locking everything: for each ctl in me.controls LockControl (ctl) next ctl
  11. V

    Loop Through Controls to Require User Entry

    Try this If is null(ctl.value) or ctl.value = "" or ctl.value = null Then MsgBox "You must enter information into all fields before continuing." End If
  12. V

    Relinking ODBC tables to Test DB

    Does the name of the test DB change every time or does it remain the same; do the table names stay the same? Are you updating records or are you just selecting? I was thinking that you may be able to use passthrough queries.
  13. V

    VBA Recordset DB Corruption

    I built a process to separate first and last name and remove certain names from various tables that are imported to my database. It works great when the recordset is fairly small. But when I do say 250,000 records at one time the database bloats nearly to the point that it corrupts(the dreaded...
Back
Top Bottom