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

sneuberg, I looked at this further and I now know how to set up a composite key and I've been able to expand it further. This time including SoftwareInformation. So I have the relationships currently set up that it goes SiteInformation - SoftwareInformation - DatabaseInformation. I reckon...

Ah, okay, I was doing it totally differently - the SiteID of DatabaseUsernames was looking towards SiteID of SiteInformation instead of SiteID of DatabaseInformation, I believe I done everything else the same though. Going to study this tomorrow in depth to fully understand it and how you have...

The relationships are now as follows: SiteInformation.SiteID PK - PK/FK DatabaseInformation.SiteID SiteInformation.SiteID PK - PK/FK DatabaseUsernames.SiteID DatabaseInformation.DatabaseName PK - PK/FK DatabaseUsernames.DatabaseName Which gives me an intermediate relationship type with no...

That's brilliant and is exactly what I want. Just need to redesign what I've been rocking for a little while now. Say for talks sake I wish to extend this out to a third table (for example recording usernames that have access to a database) using the design you just mentioned, would I design...

Huh. Never knew that. So even if each individual site has the same database name its perfectly acceptable, however when adding a database of the same name it flags it as a duplicate?

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

Indeed it does! Not sure what I changed, but after about 30 minutes of trying different things, it now works. Thanks!

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

So, for ease of explaining: I have attached an example database. Open Person/Car query (one person to many cars) Add a new record, select PersonID 3 - First Name and Last Name populates Open Person/License query (one person to one license) Add a new record, select PersonID 3 - First Name and...

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 Galaxiom, What do you recommend in regards to avoiding this?

So, whatever this is whether it is indeed a bug or not I have confirmed exists in Access 2010 on Windows 7 64bit. In terms of potential work arounds: Clunky - add an unbound, hidden text box ontop of the existing text box. When the procedure is meant to be ran unhide and bring the value into...

I am far from confused. I fully understand that my end users cannot and they do not have access to the VBA Editor nor Design View of any form. I have developed a procedure which changes a text box value whilst the form is in AllowEdits = False. Once my procedure is ran, the text box is then...

Thanks for your input Galaxiom! Basically what I am trying to achieve is to change a textbox value on the form whilst allowedits is false, but once the textbox is changed programmatically the control will still remain uneditable to the end user. Do you have any examples, or point me in the...

I don't think you quite understand. Regardless of whether or not I use runtime, the same issue will ensue because the process that I am running is similar to the one outlined in my first post - I am using code to modify a text box value which then somehow allows the control to be edited...