Search results for query: *

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...

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...

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...

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...

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"...

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...

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...

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!

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...

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...

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.

Yes, it is available via Intellisense.

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...

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.

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...

PHV, thank you! I tested all of the potential drivers and providers and they all work. But I'm a little concerned that if I elect to use SQL Server Native Client 11.0 that there might be problems being that I'm using Access 2003 and SQL Server 2005. Any down side to using it that you know of?

I'm creating a file DSN to store on a network location for use with an Access 2003 mdb that has linked tables that are connected to a SQL Server 2005 database. (There are also local mdb tables which is why it's still an mdb.) Considering that I am having Access 2003 connect to SQL Server 2005...

I need to use ADOX to refresh links to my SQL Server tables as I am using a DSN-less connection. When the user logs on, I want to refresh the links to the SQL Server as well as when I open forms that have queries as the rowsource for objects like comboboxes, etc. just in case the connection to...

OK, I've tested and it works. Can I accomplish this with ADO? Also, how do I know what the timeout is and compensate for it? Do you just call the refresh on a timer or do you call it before loading forms?

Thank you vbajock for the reply! I am using Windows Authentication and the users already have read/write access with their existing network passwords, so Integrated Security is working. But I'm not sure how to get the queries on the forms and reports to work without a DSN. Any time I use ADO...