Search results

Paul, I tried using an unbound combo box, but I can't get it to 'run' the sub-form. I have a work around (little clumsy; and I'm sure a dozen people will shake their heads when they read it). I added a line to the close button code that reset the combobox to the first option. I'll continue to...

An attempt at explaining my database design is below, but essentially my question is: I have a combo box on a form that filters a subform. It works beautifully, but it changes a record in a related table to whatever the last chose in the combo box was. It's always the same record that it...

I'm having issues with text running off the right hand side of field boxes. Everything looks fine in report view and layout view, but in print view often the last three or four letters will be truncated. I've been mucking around with margins and padding (not really understanding which is what)...

I have two sets of data - a list of roads and a list of issues. For each road, each of the issues must be addressed. I have previously designed a database that had a table for each of the data sets, and used an update query (from memory) to create a third table that combined the two - creating...

What I'm trying to do: Region field has four records Area field has numerous records against each region (and confusingly, I've discovered, a couple of areas that occur in more than one region). Roads occur in an area. Activity on a road can be one of two options. SO: "repair works" (activity)...

I have a table that has four fields (plus others not relevant to this discussion): -region -area -road -activity I want to create a form that is filtered for a specific road. I can create a form with a combo box "choose from this list" and a button to open the filtered form. Rather than...

I was trying to avoid giving too much irrelevant information, but seem to have erred to far on the side of breviety. I have a table of projects (currently several hundred records). I have a static table of issues (~50 records). For each project we need to consider each issue - yes/no and why...

I didn't mean "not have to think" as in "turn off my brain completely", but rather being able to eliminate the colourful muttering and brain strain that accompanies the missing or misplaced comma or bracket that is so common when I'm coding. I have quite a reputation with my 'cell mates' for...

I found this tutorial that does exactly what I want: http://www.techrepublic.com/blog/howdoi/how-do-i-select-records-for-a-dynamic-label-report-in-access/168

This is a query that has baffled me for a while, but I find myself constantly wanting to use it for checking. I have two fields [a] and [b] (amongst others). What I want to see is: records for [a] = 'x' IF [b] = 'y', where x and y are not going to occur in the same record and also see [b] =...

Thank you. Wasn't really sure I understood what the link was telling me. "expression Required. An expression that returns one of the objects in the Applies To list." has me a little befuddled. However, I'm using: DoCmd.OpenForm "frmEmails", acNormal, "", "", , acNormal DoCmd.FindRecord...

Worked it out. Always the way; within minutes of posting. IIf([forms]![frmDepartmentSearch]![Check1]=No,-1,Is Null Or -1) OR not AND. DUH! Now to remember how to get the query to refresh every time the box is checked or unchecked.

I'm trying to filter a query from a form using an unbound checkbox. The user needs the option to 'show all' or 'exclude superseded'. The superseded field is yes/no. I'd like to avoid the triple state because I don't think it's very user friendly. I tried...

I want to set up a table to enable users to search for government department name, which change on a regular basis. I would like to include "successor" field (possibly a predecessor, but I'm not sure). My current fields are: DeptID (autonumber) Name Jurisdiction Abbreviation Current (yes/no)...

I would like to give users the option of selecting any records from a particular table ("I want this one, that one and those two") to print to a report. I'm thinking that process would be: * add a "include to print" yes/no field in the table * create a continous form against the table; allow...

Found an answer that works beautifully: http://www.access-programmers.co.uk/forums/showthread.php?t=188663 And I didn't even have to think - just copy and paste! Gotta love it.

I want to set up a very simple database with a series of unrelated tables, to keep information that we use on a daily basis at our finger tips. As an example of one of the tables, I want to track legislation. My table will have six fields: name, year, jurisdiction, abbreviation, link to online...

Just to clarify, because the more I search on Google the less I find. I always want to open to [EmailID] = 8. I'm almost at the point of creating a 2nd form with a filter set to "8"; but I'm sure this is so basic it should be able to be done with code.

Oh, my goodness. Something I've actually done and might be able to help with; instead of always being on the receiving end. The code I'm using for a similar situation is: 'After Update of checkbox check if checkbox is selected then show or hide subform If Me.CheckBox = -1 Then...

I have a database that produces a variety of reports stashed in a variety of tables. I also have a table in which I record standard email messages to accompany particular reports. On one of my forms for a specific report I'd like to put a command button that opens frmEmail to [EmailID] = 8...