Search results

I would like to compact and repair from my FE, but would like to check if anyone else is using the BE first. DubaiDave

Hello, I have a MainForm whose purpose is to allow users to apply various filters on a SubForm and then generate a report etc. However, when the MainForm and SubForm first open, all records from the query are being displayed, which takes some time. How can I limit the the records initially...

I am using Lebans wonderful example of alternate colors for my continuous subform. However, I collapse and expand controls from a main form (setting height to zero) and need to update the subfrom backcolor because it stays at the original height. I think I need to update using: fbc.Create...

Hello All, My dB includes a very large number of comments made on documents. These are stored in a memo field. My form allows a User to search for a word or string of words in the memo field by typing these into a form textbox and then this is applied to a query: Like "*" &...

Apply Conditional Formatting to a subform by Check Box on Main Form Hi, I would like to apply Conditional Formatting to a SubForm if a CheckBox on my MainForm is selected. My SubForm resides on a tabbed sheet on my MainForm (although according to Labans, this makes no difference to its...

Hi, Have spent an hour on the web researching this and have got nowhere. I would like to know how, or even if you can, turn on or off a conditional format setting already set up for a subform. Scenario is I select a filter to a subform, apply it and at that time if a Check Box is true then...

Hi, I have been trying to work this out all day with no success at all. It is a bit hard to explain - Two tables: Book and Chapters Book has BookID + Name + Type Chapters has ChapterID + BookID + ChapterNo + No of Chapter Pages (Chapters are always incremented by one and start at 1) I...

I am importing a form field from Word which looks like this: 1/ Houses 2/ Trees 3/ Peanuts Once in the textbox it looks like this: 1/Houses(Little Square)2/ Trees(Little Square)3/ Peanuts. I have tried replacing the CR charactesr as follows: Haystack =...

Hello, I have a combo box with RowSource set to 'Table/Query'. The query has five fields, one of which is a concatination of two of the other query fields. eg Field 1 PersonID Field 2 David Field 3 Smith Field 4 = [David] & " " & [Smith] (David Smith) Column count is 4 Column widths is...

I would like to limit the number of selections a User may make in a Listbox to say 3. Is there a way? Could not find anything on Google or a search here. Cheers DubaiDave

Hi, Have been trawling the forums, but have had no luck.. I am using a combo with a filter to populate a subform. When I use a filter that retruns no records, the subform automatically enters a 'new record state' (Me.NewRecord = True). This causes some buttons on my form to wrongly...

Hi, I need some help on this one... How can I stop the the fields being selectable in a continuous form? When I open the attached form, the first field is always selected and spoils the effect of the form. I do not need to able to select the records. See screen shot. Dave

Hi, I have created the attached continuous subform. When I open this form, the first field is shaded grey and spoils effect of the form. How can I stop this happening? I don't need to be able to select records. Pleasde see the screen shot. David

It has taken me three days to try to embed a multi select list box into my already quite complex, but working query. I have a VBA routine that collects the selected values and places them in a text box txtTaskQuery on my form. A command button then requeries the form. The format of...

Hi, I have a form based on query. I want the form to open to show all records with the default ProjectID value (listed in another table). Then once the form is open, I want the user to be able change the ProjectID using a combo on the form. The combo loads with the default value. I...

Merry Christmas & hope you are anjoying your cold turkey sandwiches (I am). I have a query with one field that concatonates five other fields in the query, thus: RfiRef: "RFI" & "-" & [ProjectNo] & "-" & [TaskNo] & "-" & [RfiNo] & "-" & [RfiIssue]. RfiNo and RfiIssue are fomatted in thier...

Christmas Greetings All! I have a subform generated from a query and I would like to change the background colour of the a row (recordset) dependent on the value in one cell. How do I go about that? Dave

Hello, I have created a Query By Form. The results are in a Subform. I would like, on the same form, to bring up the record for the highlighted line in the subform. How do I go about doing that? Dave

With help from others on this board (thanks!) I have created a combo (1) whose RowSource is based on a query that uses the contents of another combo (2). It works when you open the form (combo 2 has a default value), but does not work if another combo 2 value is selected by the User. It...

Hi, I have a table with identical groups of records except for the IssueNo. Issue number increments for each instance of the record: TitleID.........Issue Title1...........001 Title1...........002 Title1...........003 Title2...........001 Title2...........002 How can I select...