Search results

  1. L

    Delete table if it does not exist in backend

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

    Get password of current VBA file via VBA

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

    Setting active record on navigation form

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

    Function returning TableDef

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

    Forced boolean checkboxes

    :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...
  6. L

    Popup Tables

    Greetings! I'm making a few forms which appear as popups; various options here and there allow the user to view tables or queries (so, using VBA such as DoCmd.OpenQuery "Books on Loan", acViewNormal, acReadOnly) However, these insistently appear as part of the access GUI as opposed to a seperate...
  7. L

    Form Borders

    Greetings! I've got a few forms which appear as popup boxes. In design view, everything's nicely clipped. The issue is that when I open it in form view, borders appear. Is there any way to get rid of them? Thank you! Lady Marmalade P.S. I wanted to attach images but I can't until I have ten...
  8. L

    Building a temporary table using records in two different tables.

    Hi there; I'm making a library database program thing... There's an option for the user to view all books on loan. I have two tables: Books, which has columns ID*, ISBN, Author, Title, Year, Location BorrowerStorage, which has columns Book ID, Name, Email Address, Desk Number Book ID in...
Top Bottom