Search results

Run-time Error While Moving Field In Tabbed Forms I have a tabbed form Name: TabCtl0 I'm trying to move the value of Me.strOwnerName in the Permit Information tab to Me.strApplicant in the Applicant/Contractor tab Name: Permit Information Page Index: 0 Me.strOwnerName Name...

I Need Microsoft Access VBA code to display active mdb database Reference information in the Immediate Window Here's what I have: Sub ShowReferencesInImmediateWindow() Dim ref As Reference For Each ref In Application.CurrentDb.References Debug.Print ref.Name & " - " &...

How can I get an Access Navigation Panel, View By Details a One Liner showing, Name, Date Created, Date Modified and Object? In other words, on one line display the Object Name, Description, Date Created, Date Modified, and Object Type just we had in legacy Access 2000 Database Containers...

When I open a query using Access 2000 Runtime Switch, I open a query How can I select a query column and sort ascending and descending?

Using Windows 10 Word 2007 After several years with no problems, all of a sudden when I type: www.abc.com it gets formated as HYPERLINK {"http://www.abc.com"} It used to format as live underlined link www.abc.com When I open existing documents www.abc.com is formated as HYPERLINK...

Dim ProcAllowanceNew As Currency Dim EffectiveDate As Date The following code works OK if there are values in Column(13) & (14) ProcAllowanceNew = Nz(Me.[strVADA].Column(13)) EffectiveDate = Nz(Me.[strVADA].Column(14)) If Column(13) & (14) are empty I'm getting Run-time error...

I have a query Out of Work TT (query) that is not returning a record: 083-74-7222 Last 2 First 2 I attached a TestHelp.mdb database for your review Member Info (table) Last First MI SS# Last 1 First 1 E 054645589 Last 2 First 2 083747222 Last 3 First 3 J 093843090 Last 4 First 4 J 126820943...

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...

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...

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...

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 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...

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...

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...

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 just inherited a Access 2000 database Laux.mdb It is opened with the following shortcut: "C:\Program Files (x86)\Microsoft Office\Office\MSACCESS.EXE" "H:\Laux\Laux.mdb" /wrkgrp "H:\Laux\System.mdw" The System.mdw contains 10 Users and the following two Groups: Full Data Users Read-Only...

I'm trying to populate a field in a continuous sub form with a filed from the main form Find enclosed sample database IUOETest.mdb that demonstrates my issue Open Select Shop New Lookup Adam's Mark Hotel Note the first four records with Active field checked Enter Period Ending Date...

I have the following SubForm Continuous form with CategoryDescID Combo Box that allows me to add, change & delete records SubForm displays in the following sequence: CategoryCodeID 1 Road Saw 2 Blacktop Roller 3 Angle Dozer How can I sort the SubForm to display as follows...

Having a problem with Update query labeled NG, the other 2 querys work OK When I run the query in design View mode it shows 6938 records that match with no values in MemberID There are legitimate values in employee_id in both tables Fields are defined as follows for all tables employee_id...