Recent content by SueBK

I have a table of issues (tblIssues). Each issue has legislation that it must be dealt under. Some issues relate to more than one piece of legislation. Some legislation deals with more than issue. Ideally, therefore, I'd like to have a separate table of legislation (tblLegislation). Where any...

I think this is a basic question, but I'm pretty much stumped - how do I attach code to the opening of the database? I have a form that opens on start up and I tried adding code to it's 'on open'. But I can't work out how to do it. I created a table called 'tblAvailable' with a yes/no field...

I leaped in with both feet; after testing in a dummy copy; and removed all my in-table lookups. Let's see how I go from here. Thanks for the encouragement.

If I need to take the backend of my database offline for changes, what's the best/easiest way to inform the users? Is there some code I can drop into the front end? I'm thinking a "on database open, if [available] in tblClose equals no, then open frmDatabaseOffLine". But I don't know a) if...

Taking deep breaths here, and trying to not hyperventilate. I copied my database. Removed the look-up criteria from all my table fields. Everything appears to still be working. Now, to move on to new forms/reports. Let me check I've got this straight: Say I've got tblAssessProjects. It has a...

So, let me get this straight. You're saying that if I convert all my lookup fields in my tables, everything else I've already designed is cool bananas? I don't have to change anything anywhere else?

Okay, my head is about to explode. I was taught to design my database using lookup fields in tables. I read that's a big no-no and the issues listed on http://access.mvps.org/access/lookupfields.htm are pretty clear. However, all very well in theory, and in practice if you're a seasoned...

"The fact that as textbox it returns the bound ID field (which is a number) suggests you have a lookup in the table itself, which is one of the BIG NoNo's in table design." I have picked this up from the forum; however, it's how I was taught, and I don't know how to design without it. If...

Is there an online tutorial somewhere explaining how to use the Access 2010 table settings (on the arrange toolbar) in reports? I've got the basics of stacked and tabular, but the auto-create often has a mix of the two and I can't quite work out how to do that myself.

Is it possible to hide the drop down arrow on a combo box on a form? I have a number of combo-box fields on my form that are locked against editing. I don't want to confuse people by having them look like they can change the contents. Currently I put little rectangles over the arrow, but...

Decided that the easiest way was to turn all my message boxes into tool tips. They (the users) have irritated me enough for me to run out of hand-holding patience. They can just wait 5 seconds for the tool tip to show up. However, I will stash away your assistance for another day.

I have 13 environmental elements (flora, fauna, water etc). The user assesses if the risk for each one for a project is high, medium, low (easy table - project, element, description of risk, risk level). A second report then has about 2 pages of management strategies (standard text; no...

Isskint - that is exactly what I was looking for. Thanks. I'm thinking that without user profile, I could simply have a checkbox on the form "Do you wish to see all the wonderfully helpful mesage that took me hours to program?" which could then run the same code behind each of my command buttons.

I have the code below, which opens a report. I have three message boxes - two to ask for information to be selected on the form; and one info box. I have exactly! the same code to open a form and it runs fine (I've checked them against each other letter by letter). However, this report code...

I have some users who (I think) possibly have a psycological block with databases. Therefore, everything is just too hard and confusing. To try and overcome their fear I've added messages boxes with OK/cancel to each of my command buttons that says what the button does. However, I can see that...