Search results

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 change the check field to: Name: strCheckNo2 Control Source: Check Check: IIf([active]=-1,[forms]![select shop new]![CheckNo],Null) All is OK Thanks for your help

Thank you for the references I inherited this database and customer just wanted to add the Check Number field to behave like the Stat field. Without redesigning this process from scratch, is there a way to get the Check field to behave like the Stat field populating the Check field with Check...

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

Thanks for your response My combo box is sorted OK If I create 3 records by selecting input from the combo box they display in the continuous subform as follows: CategoryCodeID 1 Road Saw 2 Blacktop Roller 3 Angle Dozer How can I sort the SubForm detail record to display as follows...

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

Before I run the query I performed this Function dbs.Execute "ALTER TABLE tblEmployeeSkills ADD COLUMN MemberID Long Integer;" dbs.Execute "CREATE INDEX MemberID On tblEmployeeSkills(MemberID);" After further review I re-linked the table tblEmployeeSkills and the Update query works

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

All is OK, Thanks for you help

Me![SSN].Undo Me.SSN.SetFocus Cancel = True Run-time error '2108' You must save the field before SetFocus method

I have the following code that works, however when I acknowledge "the SSN already on file" message the focus goes to the next field to the right. The record is not saved at this point so I can't use SetFocus, I want the focus to stay on SSN until a valid SSN is entered...

As always, thanks for the clinic

Thanks Mark & JDraw Both solutions worked, JDraw, after further review I had to add transaction_type_id = 1 to your code Dim lngMPID As Long lngMPID = DMax("tblMemPayment.id", "tblMemPayment", _ "tblMemPayment.employee_id =" & Me.EmployeeID & " And " & _...

This query works: SELECT Max(tblMemPayment.id) AS MaxOfid, tblMemPayment.employee_id from tblMemPayment GROUP BY tblMemPayment.employee_id HAVING (((tblMemPayment.employee_id)=1838)); I'm trying to move the SQL to a form and I'm getting: Run-time error '13': Type mismatch How can I adjust the...

I have the following query: SELECT Count(tblEmployee.id) AS [Count], tbllocal.ID AS LID, tbllocal.local_cd AS LCD, tbllocal.local_name AS LDE FROM tblEmployee LEFT JOIN tbllocal ON tblEmployee.local_id = tbllocal.ID GROUP BY tbllocal.ID, tbllocal.local_cd, tbllocal.local_name ORDER BY...

Call Eval(strAction) Thanks to theDBguy & HansV Eileen's Lounge

I have the following in Form and it works OK Call RunForm("frmProviderLookup", "", "Edit", "", "", "Normal", "Normal") I want to build a combo box with several different RunForm variations as follows: RunForm("frmProviderLookup", "", "Edit", "", "", "Normal", "Normal")...

I have a program.mdb with a customized menu bar from Database Creations When I open program.mdb in 2007 & 2010 the ribbon is disabled and the custom bar is displayed as it should be and all is OK When I open the same program.mdb in 2013 the ribbon is displayed and the custom bar is missing I...