Search results

All, Say I have three tables: tblHouses HouseID - PK/AutoNumber HouseName TownID - FK tblTowns TownID - PK/AutoNumber CountyID - FK TownName tblCounties CountyID - PK/AutoNumber CountyName I create a query from this: HouseID (tblHouses), HouseName (tblHouses), TownID (tblHouses), TownName...

All, Quick question from me. I have an Access application that is quite slow over VPN however when loading it or forms within it, it is quite slow. When searching for information within the forms - when entering a search term by the third character of said search term the search grinds to a...

All, I have created a simple, but maybe complex, permissions structure in my database which comprises of users and groups and their permissions. Essentially put the database has a set of defined permissions (and levels - no, yes, read, write, delete etc) in a table and a user is either added...

Hi all, As discussed in my previous thread (http://www.access-programmers.co.uk/forums/showthread.php?p=1472956&posted=1#post1472956) I was trying to create a concatenated primary key. After some assistance a composite key was what I required. I am trying to achieve the following - 4 tables...

Hi all, I have two tables and their format is as follows: SiteInformation ----------------- SiteID - PK DatabaseInformation ----------------------- SiteID - FK UniqueDatabaseID - PK (this is concatenated on the form using SiteID+Databasename) DatabaseName This works well and allowed me to...

Hi all, I just wanted to ask what your naming conventions are for Procedures and modules. Currently, I name: Modules - bas<Name> (basFEExit for example) Procedures - <module shortened prefix><Name of procedure> (bfeeExit) I understand that as long as I'm consistent with naming conventions...

Morning all, I have a form with a number of combo boxes on it. These combo boxes provision a filter mechanism that I am creating. Due to the combo boxes either one, two, three, (so on and so fourth) can be used to filter the record set. Firstly I pick up the control source and name of the...

Morning all, I'm not sure if it's because I'm tired, or my google fuu isn't working... however can someone explain the following: I have three tables, two relationships - one is a one to many and the other is a one to one. From this I have created two relationships to join data between the...

Hi all, I was wondering if someone could confirm/deny and inform me of any workaround for what I feel is a bug within Microsoft Access VBA? Steps to reproduce: Create a form with a text box that is bound to a table, and ensure that text box is bound to a column. Set the form's AllowEdits...

Hi all, Just a quick one for me. I have a 'passwords' table which holds an amount of information which I would use alongside other authorised people. I have implemented my own terms of security: You can only access the DB if your Windows Login user name is stored in the BE Input masks to...

Hi all, I have a log table, which is essentially a dumping ground of checks that I and others have completed. Each person has a set amount of checks to complete, there are three checks, Check 1, Check 2, Check 3. There must be three Checks of Check 1, two of Check 2, and 1 of Check 3. Please...

Hi all, I am having trouble with what I believe is bound columns. I have followed the tutorial listed here for 'Cascading Combo Boxes' - https://www.fmsinc.com/MicrosoftAccess/Forms/combo-boxes/cascading.html. Within the database itself, the tutorial given works a dream and causes me no...

Hi all, I am having a problem with parsing the array value to Froms!<arraryvaluehere>.dirty. Please see the code below: Public strListOfForms(0 To 2) As String strListOfForms(0) = "frmForm1" strListOfForms(1) = "frmForm2" strListOfForms(2) = "frmForm3" For i = 0 To 2 Debug.Print...

Hi all, I am trying to achieve the ability to navigate to another form with a single click, however I want it to go to the same record that it was in previously. For example: frmInformation has 500 records frmDiscipline has 500 records When I am on frmInformation (249th record) and press the...

Hi all, Has anyone encountered this particular issue before, and if so how did you resolve it? I have recently encrypted my Access BE DB. I used to use Excel to connect read only to the .accdb so that I could report on some statistics. I accomplished this by setting up a new Excel...

Hi all, I've had a bit on inactivity on my account, now when I have come back I cannot post a question in the General sub? It always redirects me to the login screen, which upon entering my details keeps looping. Didn't know where else to place this. Best regards.

All, I am now trying to tip toe into priviledges. For example, if the user has admin priviledges he/she can go into/see locked places of the Form. I have a table with all of my users set up. The table headings are as follows: Name-Email Address-Number-Priviledge Basically, on the form...

All, Could someone help me understand the following issue? Basically, I have copied the scrolling text example from this forum, slightly modified with a dlookup to the BE Database. The way I have everything set up is off of a main form, or what I call a 'Switchboard'. The switchboard has...

Hi all, I have 7 textboxes on a form, 6 - for data manipulation and another to display how many of those 6 filled out. The text boxes are called: txt_name through to txt_name_5 And the display is called: txt_count What I am trying to do is create a loop that will count how many of those...

All, I am having issue with the controls on my form. No so much an issue, rather than a question. When I select a table, and press the Form button it auto populates the form with the various controls etc. I have noticed that for example a text box will show the control source but with a...