Search results

Eh?..... If you have a check box to indicate that the file is confidential, why do you need to store repetitive text, which performs the same function, in your table ?

Ok. The RecordSource of the Text box should be set to: =[ComputerName].Value (ME! not necessary) The combo box should have its bound column set to 2, but the computer name (presumably column 1) should be displayed in the combo box (i.e. it should have a column width great enough for it...

What is the Name of your ComboBox? Not ComputerName , surely?

sorry to butt in, but... May I suggest that there's probably an error in your SQL string?In general, the string doesn't need all the brackets as it does in the QBE grid, or the final semicolon. They don't prevent the query from working but they just confuse things. Before the RUN SQL...

1) Is CompCycle a bound field? 2) Why not make the text box an unbound field and have an expression like =Me!MyCombo.MyColumn as the Recordsource, rather than triggering an event on opening the form?

I got this working, so the code is OK (on Access97 at least). You do have to modify the code to reflect your own field names in the detail section and make sure to include the Global variable in the module. Why isn't it working for you? What errors are you getting?

No, I was wondering why it wouldn't work with a query, which is why I was interested to see the code. I can't think of an obvious cause for the subforms to play any part if you are searching the parent.

A combo box can be made to scroll down as characters are entered, so a few hundred records don't present any problem. But if you don't want to go that way, there's no point in pursuing that line. I'm not sure what your reference to "canned search function "means. To search a field using...

Yes Katie, you will be able to manipulate the data just as you wish if you construct your tables properly. The basic structure has to be correct though. I would take up Hayley's generous offer, because you are obviously feeling your way at the moment and lack the expertise to proceed with...

Why not just use a combo box?

If isNull(Me!STAA1) Then.... is the correct syntax

What code are you using to perform the search ?

I agree with the last respondent. You don't need to worry about getting things in the right order at table level. You can bring all members of a family together by having a shared family ID field and sorting by FamilyID and then by Last Name, First Name in a query. You then use a form based on...

It's not easy to help you, since we don't know the details. It sounds as if you need to run an update query on some of your records, rather than an append query. Can you be more explicit please.

Please post the query, not just the tables involved in it...

To import: DoCmd.TransferDatabase acImport, "Dbase 5.0", "C:\Temp", acTable, TableName1, TableName2 where Tablename1 is the source table and Tablename2 is the destination. Export : Same, but acExport instead of acImport

Append queries should work, so why isn't it happening? The situation can't be as straightforward as you suggest, perhaps. Zip up the files and email them to me and I'll see if I can solve your problem.

Do you mean that it is prompting you to enter a parameter value and then not using that value? Sounds like a misspelling of one of your field names...

The reason it works is that a string expression is specified in the syntax, so you have to include quotes in the expression.

in reply to the original post: Dim stDocName As String Dim stSQL As String stSQL = "[DFee Number]=Forms![school information update]![Dfee Number]" stDocName = "ICT Status Print Page 3" DoCmd.OpenReport stDocName, acPreview, , stSQL the above code opens the report...