Search results

You need to have a unique field in common between the 2 set of records. Usually it is an id that appears in both tables. Eg Table1 Table2 CompanyID CompanyID, ContactID The link to both set of records CompanyID, allows you to show the contacts details for that...

It's not clear, at least to me, what you are trying to do. I presume you have a form that contains data and you want to search for a particular record so that you can change some details of that record. Is that it, otherwise please expand on your needs? Dave

Ok, if you want to concatenate values and show the square brackets as well I would do the following: NewName:"["&[FieldName1]&" "&[FieldName2]&" "[OtherFieldNames]&"]" The "" contain alpha characters The & concatenates fields (do not use + in concatenations, Access can sometimes think you are...

why can't the user supply that value? Dave

use a DLookup to look at the answer in Word Answer then use an If...Then to allocate the grade in the form. Dave

do you mean hiding the database window? One way is: Tools===>StartUp and disable the check box labelled "Display Database Window" cheers Dave

hey Russ, did you know that your code will allow you to view up to 250 file names? What happens if you dir/subdir contains over that number of files? I discovered the solution to this problem only a few days ago, you have to write the file names into a temp table. The you can do anything with...

I found the cause, it's this bit of code on the OnCurrent event: 'If IsNull(Me![Related report]) Then 'OldDetailSize = Me.Detail.Height 'OldControlSize = Me![Related report].Height 'Me![Related report].Height = 0 'Me![Related report].Visible = False...

g'day, this is one of my old projects which, all of a sudden (dont'ya hate the 'all of a sudden' event?), gives me problems. I have subforms frmDocs and frmFiles in tab control pages which are linked to the main form, frmProject, by field ProjectId. Records in frmFiles are displayed properly...

Do you save the record first before opening the other form? Dave

1) Why do you have the square brackets within single quotes? 2) what do you use the plus sign? 3) are you trying to concatenate some fields or sum them? Dave

why do you want to hide them in the first place?

you cannot put a subform in a table! subforms are placed on forms. Dave

did you check out the requery command? Dave

lstField1 and lstField2 based on qry1 and qry2. Requiry lstField2 after selection in lstField1. Dave

what type of field is sbjID? Alpha or numeric? You are adding alpha characters to the end of sbjID. What you have is ok if sbjID is an alpha field but if this field is numeric you should have: sbjID + 9900011 (or whatever number is required to reach the total you want). Dave

Not sure I understand your set up properly but I think you are saying that you have a record in Works, linked to a record in Orders, and that when you update a field in Works you want that same value to be given to a field in Orders. Is that right? I am also presuming you are working with forms...

Hi Helen, I would add a checkbox in your table (ckInclude) with default set to Yes. Then in your table you can disable the checkbox for those people you do not want included in your mailing labels report. The query would have to have field ckInclude with criteria = Yes. Dave

A rough-and-ready schema. You will need at least 2 tables: 1) tblWheelchairs: UnitID (autonumber) and check boxes for each step of the overhaul. If a step can consists of more then 1 action then use a combo box. 2) tblCountries: UnitID (linked to UnitID in tblWheelchairs), cboCountries...

1) Add an ID field (usually autonumber) as the primary key in tblCompanies (eg CompID). 2) Add another autonumber key in tblLiabilities (eg RecID) as well as CompID. The first is to identify a unique record, the second to link the record in tblLiabilities to the relevant record in tblCompanies...