Search results

Does anyone know what determines, on a combo box, setting a property so that the selection does NOT jump to the NEW first letter eneterd, but rather filters along the list via 1st and 2nd letter typed? As an example: FORM a:Type C ... get Cabbage, then Type H get Ham Form...

I have a form with my own navigation buttons on it. Using the 'built in' access navs might be better, but I need to do it this way to include extra code on the buttons. What code do i add, to prevent the buttons overrunning the end of the file? Something like.. If tblMailLog.EoF is true then...

Something so simple yet I am just not getting it!!! I want to pull the field names from my table ,tblQ17, and list them in a single column table I have ready, called Allfields. (Field name is NameOfField) Code is ... Sub TestThis() Dim rst As DAO.Recordset Dim fld As DAO.Field Set rst =...

Is it possible to control how a report preview opens up? I want to be able to make my report preview open in normal (not zoomed) mode, but cannot find an appropriate control. Any ideas? Thanks.

I need to send reports attached to e-mails from an access2000 db. I have used the sendobject code to do this. This is fine when the report contains data, but when there is no data to report, the email loop I have set up stalls at the first empty report. :confused: If I run the report on its...

I am having problems with placement of delimiters around the criteria part of the 2 expressions below:- Place1 = "CCYP" ....CCYP is an OrgName listed in tblkOrgEmailAddresses (1) ' WORKS OK fred = (DLast("ReportName", "tblkOrgEmailAddresses", "OrgName = '" & "CCYP" & "'"))...

I am using DCount to 'grab' a value resulting from running a query. If DCount("[PassCodeResult]", "[PassCodeQuery]",[PassCodeResult]="Fail") > 0 Then ....etc PassCodeQuery's SQL is : SELECT [Enter Passcode1] AS PassCodeResult FROM Table1; Works fine, but my query needs to contain parameters...

I have a delete button on my form (command270), which removes a record from table A. Table A is related to table B with referential integrity, cascade delete and cascade update applied. When I click on the delete button I firstly set warnings false, but I still get a message to warn me...

I am using the code RecordSetClone = "NPDAllRemovals" , to change the source of records (ie I want to point at table NPDAllRemovals, now) to pull up to a form. When I do this I get: 'RunTime error 3251 - Operation is not supported for this type of object'. The 'recordsetclone pointer'needs to...

I make a selection on a form to choose the source of the data (ie I set the form's Record Source depending on the selection combo)- to one of three tables. I select this source then go to a combobox to choose a particular record. I use the recordsetclone structure to pull through a particular...

I have a 'dynamic' form which can be linked to 1 of 3 tables, the active one being chosen from a combo cboSourceChoice. The tables are called NPD,NPDy,NPDz. On the form I have another combo Called Combo2, which I use to select the record to display in the form. In the Row Source I am trying to...

I've been wanting to use the same form to query three similar tables. I have managed to achieve the Record Source part... (see link http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=59283) Now, I need to select records from the chosen source table. Basically I need to...

OK the first part i can do (ie Bring up data via either combo box).. For example i want to be able to select a person by their name or by their code number. I am using recordsetclone statement to pull up the data at present.... But how do I get the second combo box to display the 'matching'...

NOT Cascaded - Bring up data via either of 2 combo boxes OK the first part i can do (ie Bring up data via either combo box).. For example i want to be able to select a person by their name or by their code number. I am using recordsetclone statement to pull up the data at present.... But how...

I have been trying to use the No Data Event, initially with success. If my report contains No Data, then it does not display anything on screen and I can organise a "No data" message to confirm this. Fine. However, I want to have the option of displaying/printing the blank report for...

Acc97 and Acc2k icons: How can i prevent acc2k and acc97 'association icons' from becoming mixed up. I have both 97 and 2k installed happily on my (work) PC, except that if I double click on a file in explorer say or a desktop shortcut, the .mdb attempts to open up in whichever version was...

I have written a small database in Access for a friend, and want to install it on their PC. They don't have Access installed, so is there a way I can 'wrap it up' so that they can use the database without having to buy and install the software, etc. Cheers.

I am adding data via a form. When I try to add a non-unique number I get an error message saying 'non-unique' etc. OK, so if a non-unique number is detected I want to put up a message box to the user and then delete the erroneous record. I have written some code to do this on detection of an...

Is it possible to force the field type in the table resulting from a query? Reason: Access2000 keeps giving me tables with field type = Binary!...according to MicroSoft this field type does not exist!! These binary fields appear to be generated when the resulting data is 'mixed' eg. "Q3...

Its a long one!.... (because i've had to do a workaround to get this far), but anyway, how do i indicate line continuation? Any ideas [This message has been edited by st3ve (edited 01-22-2002).]