Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by glgcag1991

  1. glgcag1991

    Table name f_58E353365D1F420E91DF0D95DECDD042_Data appears when looping through TDF's

    Thanks for the reply Darrylles, I discovered that they are system created tables and that's about it. I didn't go too deep (or call Microsoft) since they just seem to appear in every Access db I create (eventually). Since they all start with "f_" and end with "_data", I just created a function...
  2. glgcag1991

    Table name f_58E353365D1F420E91DF0D95DECDD042_Data appears when looping through TDF's

    I'm looping through TDFs as a part of an object inventory I run on my database and I keep getting a table called f_58E353365D1F420E91DF0D95DECDD042_Data. It is a local table, yet when I set the navigation options to show hidden tables and system tables, I still can't see it. Does anyone know why...
  3. glgcag1991

    Code at close of form isn't working when user closes database

    Here is what I have done: - per 1DMF I have check for edit that runs on form update - on form unload I check for edit too so that if the user hasn't tabbed out of the field they are editing prior to completely closing the database, I get another chance to commit the edit So far it is working...
  4. glgcag1991

    Code at close of form isn't working when user closes database

    I have an unbound form that on open I store the field values in the .tag of the field. On close of the form I run a module to compare and then record any edits. I am having issues with users closing the database with the form open and the edit checking isn't firing, hence the edits aren't...
  5. glgcag1991

    Watermark image behind objects on a form

    Thank you strongm, that worked! There was also an "edit" button the original designers had created so that the bound form became "editable" if the user had sufficient rights. When that was pressed, it changed colors and transparency which was messing things up. With your "send to back"...
  6. glgcag1991

    Watermark image behind objects on a form

    I have a gif image that I am trying to make appear behind all of the objects on my form. It works for objects that have a solid back style but not if the object has a transparent back style. Is there a way to prioritize which transparent object takes precedence? For example, labels on my text...
  7. glgcag1991

    Oldvalue throwing error 3251 inconsistently

    MajP, The field is editable (I have an "Edit" button on the form that changes the field state for users if they have rights). I have tried PHV's code and it is never coming up as a new record. Looking at how the form is opened, I see that the original designer created a table named the same as...
  8. glgcag1991

    Oldvalue throwing error 3251 inconsistently

    This doesn't work either. For now I just commented out the audit code and I'll have to come up with something different. Weird! Not sure why it just stopped working! Thanks guys!
  9. glgcag1991

    Oldvalue throwing error 3251 inconsistently

    So, a little more information: When I create a new record and open the form, I get the OldValue errors. (Keep in mind when I create a new record, the only thing that exists is the ID on the form and the user has to create all the rest of the info once the form is open.) If I close the form...
  10. glgcag1991

    Oldvalue throwing error 3251 inconsistently

    Yes, I did a bunch of research before posting and that was one of the things that came up. It is a bound combo. Also, I found: the OldValue is a string as well as there are issues with forms bound to multitable recordsets. I have found a bunch of posts on various forums about this issue but...
  11. glgcag1991

    Oldvalue throwing error 3251 inconsistently

    Didn't change anything. Even in debug mode if I just hover over the OldValue, it gives me the 3251 error. Something to do with the OldValue property is causing this.
  12. glgcag1991

    Oldvalue throwing error 3251 inconsistently

    Yes, it is available via Intellisense.
  13. glgcag1991

    Oldvalue throwing error 3251 inconsistently

    Checking OldValue of bound comboboxes on multiple forms. Some are throwing error 3251 (Operation is not supported for this type of object). I can't find any consistency for this but it just started happening. It is an Access 2003 database and we have been using it for years without problem. I...
  14. glgcag1991

    ADO to delete linked sql tables requires multiple passes

    I removed the tables.refresh and it is still doing the same thing. What do you mean by counting the tables and then stepping through them from end to beginning? I can do it with a recordset but I can't with the cat.tables collection, at least that I know of.
  15. glgcag1991

    ADO to delete linked sql tables requires multiple passes

    I am writing code to delete links to my SQL Server tables and when I run the function, it doesn't delete all the tables. I have a total of 89 linked SQL tables and I have to run the function 5 times to delete all the tables. Here's the code I'm running: Function DeleteSQLTableLinks() 'On...

Part and Inventory Search

Back
Top