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...
Make form read only
Did you find a reference to read only forms, because I cannot find any references either!
This is bound to have been answered before, but I have searched for this and either get zillions of results or none.
Can someone please point me to a suitable thread.
Thanks.
Using Dcount to not open blank form
Using DCount you can count the number of records in the table, by referencing the same query as you use in the forms recordsource. ie. Put this code behind the button which launches your form at present:
If Dcount("RecordIdNo","qryYourFormsUnderlyingQuery")...
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...
Does table exist in external db
How would I modify this code to test the existance of a table in another (external) database (eg. prior to attempting to import it)?
I've tried replacing .... Set db = CurrentDb() with .....
Set db = "C:\Test\abcdefg.mdb",
... but this results in a "Compile...
Job Done
Solid advice as ever - thank You, Pat.
I'm going with Dugantrain's solution for now, though I found that I had to add an extra pair of '........' around the field name as in :-
DoCmd.RunSQL "INSERT INTO Allfields (NameOfField) VALUES ('" & fld.Name & "')".
I'll try the add new...
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 =...
Argyle Janner,
It could be that your table is apprroaching the maximum number of characters per record.
The theoretical maximum is 2047 total, but I have noticed that on trying to export to another Access database that I had to reduce the record size to around 1500 characters. I have only...
Sorting and Grouping
SWEE,
I think you need to adjust one of the 'Sorting and Groupings' to Outlet Choice. At present you have two Sorts on PONumber.
This may not be the full solution but it should give you a start.
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...
String Crawling Thing now Driving beautifully
Thanks Mile-o,
I thought i had tried all the combinations, but hadn't got as far as this number of sets of ""s!!
DoCmd.OpenReport fred, acPreview, "", "[CentreNamed] = """ & Place1 & """" did the trick.
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" & "'"))...
Parameters
Is it actually permitted/posssible to use parameters in the query which Dmax/Dcount references?
Does my problem come down to how the [Parameters] are delimited , in some way?
Any further ideas greatly appreciated.
Thanks.
Thanks both, but I have just re-tried your suggestions (plus a number of other variants) and still get the message:
"The expression you entered as a query parameter produced this error: MyDatabaseName can't find the name 'Enter Passcode1' you entered in the expression."
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...
Still warning, still annoying
Firstly, Thanks for the coding update Mile-O. The code I had was generated by the wizard when I added a button to my form.
Secondly though, I still get the warnings showing even with this new code!
Any ideas? Thanks.
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...