Search results

>The query may have prompted for a value. No - it picked up all the name and address fields of the current record, without any prompt or user input. >Or, they may have run a make table query with just the data they wanted >to merge and merged from the table. No - and I know that because I did...

Any Idea how i did this before???? (I know you're not a mind reader!) but I did have the clients working for a LONG time with a standard letter template that had the address and salutation fields set up to merge from the current record on the input form. So when they are looking at a...

I wrote a query called "qyCurrentConstituent" It selects contents of the current record from the open constituent form. (ie "fname: forms![fmConstituent]![person first name]" etc) (SQL looks like this: "SELECT [forms]![persons form]![person salutation] AS Sal, [forms]![persons form]![person...

There is no option to save here, and the password is not sticking.

I have inherited a database that used data from an external data source using ODBC linked tables. The users need to change the password on the external database, but the guy that wrote this db embedded this password in the Access db. I found it specified in record for the link table in the...

It was not memory, I;d been using ocx file from W2K machine. Took one from a W98 machine (even though it had a newer date!) and this worked. Thanks for your suggestions.

Gave a user a link to an Access2000 DB she will share from the NW. Found the Date Pick control (DTPicker) necessary for this db was not on her PC (Win98 SE). Investigated this control and found it is part of MSComCt2.ocx Copied this file to her PC and registered it using regsvr32.exe and it...

you can't open a form with a query - you'll need to do it using a macro. Macro's are very easy. The macro could run the query then open the form. You can put a button somewhere (a switchboard or another form) which runs the macro.

1. In design mode, you can set both these field to "visible = No" in the format properties. I assume that GuestID Is a autonumber field. 2. The issue really sounds like it comes down to relationships. The underlying tables should have at minimum the following fields: Guest table: GuestID...

>1. I have a main form called Household and a subform called >Applicants. In the main form I have a field called NumOfApp. I >would like NumOfApp to be automatically filled depending on >how many people applied in the Applicants form (subform). 1. To put a summary in your main form you need...