Search results

This is great! I can't believe I didn't think of that as it's basically the exact routine I'm doing to check if a table in the backend is not in the front end, just with the loops reversed....:banghead: Quick question - is there any way to check if the table it finds is a system table? I've...

1. People can't make any front end tables. 2. As convoluted and untrustworthy as this probably sounds, there are tables keeping track of the new tables! 3. The user never has to 'see' a table. They're not even aware they've created a table, per se - just that the object they've imported is now...

It's the TB.RefreshLink bit which takes time and which ignores the error handling. In my routine, I already have both databases open as DAO.Database objects , and have the path freely available, so anything utilising that should be fine. Thank you so much!

There is no error message involved - none of the forms will try to access a table that has been deleted from the backend. It's just that the front end still thinks the table is there, which is wasted space/clutter and potential confusion if anybody were to look at the tables for some reason...

Ah - I doubt that will work. The issue in question is that the table is removed from the backend and there is still a link to the nonexistant table in the front end. Compact and repair will clean up the saved space in the backend but not delete the link in the front end. I honestly appreciate...

The user has to import excel files as part of general usage. It necessitates creation of tables as if this were to be stored in one table, it would require several thousand fields. Sorry! I don't mean versions in that respect - I meant different copies of the same approved edition. It is set...

Hi, I have an update routine which checks the backend for any new/deleted tables. Firstly, is there a simple way to do this? i.e. make it so that any added or deleted tables will update accordingly in all versions of the front end without needing to do it programmatically? If not, I have an...

Thank you, I'm also aware of this - however, that would mean anybody correctly logged into their PC would be able to do what they wanted...All it does it stops one person from using another person's PC to mess about.

Damn. That's a shame. I supposed it'd be a major security flaw. Hi, I considered using something like this, but it feels very easy to mess about with...

Hi everybody, I want certain functions of my database to be password protected. It's not a very high risk situation which warrants high security, it's just been decided that people shouldn't be allowed to delete things without awareness of knock on consequences etc... Seeing as I wish to...

Yes! I'm so sorry - I figured out how to do it soon afterwards, but lost internets and couldn't update this thread. Thank you though!

Hi, I am struggling in general to deal with navigation forms at all. How could I remotely set the active record of a navigation form via VBA? Thanks, Lady marmalade

Sorry, I meant -1 - typo! The data is in the form -1/0 (and is being correctly recognised by the checkboxes at least)

Thank you for the reply! It was none of those - something to do with relating databases to tables. I found the solution (sort of) here.

Hi guys, I have a function which is intended to return a TableDef Function GetTable(ByVal TableCode As String) As TableDef Dim myTable As DAO.TableDef Dim myDB As DAO.Database Set myDB = CurrentDb For Each myTable In myDB.TableDefs If myTable.Name Like...

I did give that a go - for some reason it's refusing to let me change it to text box. It has no issue with combo box however...

:banghead: Simple question! I have a field that is a 1/0 boolean. I simply want the result formatted as a "Yes/No". It has worked for all the other fields in the table but this one is insisting on formatting as a checkbox and I can't figure out why - there doesn't seem to be any difference in...

Right! It does open in new windows now, but it opens in the background (behind the current form). Any way to deal with that? Thanks! P.S. I can add a screenshot via zipped file, but I don't see how that'd help...

Oh. Of course. Thanks! The database will likely be on a network share which is accessible by all...I'm considering doing it via windows sharepoint. It's not a split database - tables, forms, queries etc. are all in the same file (It'd be slightly pointless having a seperate database for the...

Could you explain please? I mean, the database/tables etc. itself are so ridiculously simple and unlikely to be edited that it doesn't make a huge difference there, but all my coding, button/object names etc. follows relatively easy to understand naming convention (e.g. button to display all...