Search results

Run-time error 3251 - Operation is not supported for this type of Object rs.Index = " I have a working Access 2010 IUOE.mdb that contains table, queries, forms, reports, etc I split the database into IUOE_Fe.mdb (queries, forms, reports, etc) and IUOE_Be.mdb (tables) I have a form that is...

Thank you both, works great

I have the following hard coded query that returns all the members that have 25 years of service Field: Years: DateDiff("yyyy",[17 Init Date],Now()) Criteria: 25 How can I change it so the query will prompt the user to enter the date (Now) I want to calculate to?

I have the following Sub that works OK in Access 2000 However when I run the same Sub in Access 2007 I get the following error on the .Send command: Run-time '287': Application-defined or object-defined error I have a reference to: Microsoft Outlook 12.0 Object Library 'Send Email through...

After further review I found the following which I followed verbatim and tweaked Top Margin to 0.8 and Bottom Margin to 0.2 to meet my needs Print a page with 3 evenly spaced mailing slips http://allenbrowne.com/ser-54.html Many thanks to Allen Browne

I'm trying to print three record per page on 8 1/2 by 11 paper stock The paper stock is pre-printed with three pre-printed membership cards per page and I have to print the input detail records in the approiate fields in the form What is the best way to setup/create a report that prints on a...

After further review, found this at Allen Browne website 'Omit the last argument for Access 2000 and earlier. See note 4. DoCmd.OpenReport strDoc, acViewPreview, WhereCondition:=strWhere, OpenArgs:=strDescrip 4. For Access 2000 and earlier, drop the OpenArgs:=strDescrip from the...

This works: DoCmd.OpenReport Me.QueryName, acViewPreview Why am I getting Compile Error, named argument not found on the following? DoCmd.OpenReport Me.QueryName, acViewPreview, OpenArgs:="Member Info Export"

I see says the blind man, I should have of known that, Thank you

I have a query with a Like Criteria = Like "*doz*" and the query returns records Ok When I replace the Like Criteria with the following Like and with doz in my form filed SkillAbbrev it returns no records Like "*[forms]![frmMember Info_Out_Of_Work_List]![SkillAbbrev]*" Form Name...

Thanks for the solution that worked How about the syntax to add the following to dtmDateCreate Format mm/dd/yyyy Input Mask 90/90/99;0;_ Caption Create Required Yes Indexed Yes dbs.TableDefs("Customers").Fields("dtmDateCreate").Format = "mm/dd/yyyy)" Returns Compile error: Method or data...

I'm getting following error message on following Alter command: Run-time error '3293': Syntax error in Alter Table statement dbs.Execute "ALTER TABLE Customers ADD COLUMN dtmDateCreate DATE DEFAULT Date();" Also, what is the syntax to add the following to the Alter statement? Format...

Thanks for the info

Thanks for the references. Is there a quick way to disable System.mdw to copy the database to my development system for modifications then back to the customer site?

This is a Control Source This finally got it: =DLookUp("[Description]","[dues transaction codes master]","[Trans Code] = " & [Forms]![frmMaster Dues Payments_WDOE_Sub_Form]![Trans Code]) Thanks for your help, I've been bitten by DLookup before

Thanks for the bracket help and the Reference Chart I'm referring to a control on Sub 1 and I am on Sub 1 using Me!ControlName =DLookUp("[Description]","[dues transaction codes master]","[Trans Code] = '" & [Me]![Trans Code] & "'") The above DLookup is returning #Name?

What is wrong with this Form Control Dlookup command using string method? =DLookup("[Description]", "[dues transaction codes master]", "[Tran Code] = '" & Forms]![frmMaster Dues Payments_WDOE_Sub_Form]![Tran Code] & "'") Error Message: The expression you entered contains invalid syntax You...

This worked Total=nz([trans code2 amt],0)+nz([trans code3 amt],0) Thank you

TC is a unbound Combo Box, when operator enters TC the Description and Amount is pulled from the Combo Box into unbound fields as follows: TC Description Amount 42 Hats 8 32 Pins 5 Total 85 Total=nz([trans code2 amt])+nz([trans code3 amt]) My Total should be 13 Why is Total concatenating...

I did the split as described above and all seems to be OK Thanks for your help