Search results

I am trying to create a form with a datasheet subform. The datasheet is based on the tblMaterial: MaterialID WorkorderID PartID Description UnitCost Quantity Notes The PartID is a lookup to tblMaterial which contains the following fields: PartID PartCode PartName UnitCost Notes I would like...

I have a table called form called Appointment Detail which has a Merge to Outlook which is suppose to take the current appointment record and merge into Outlook 2007. The following is the code behind the merge button: Private Sub cmdMergeToOutlook_Click() On Error GoTo Add_Err 'Save record...

I am trying to properly design a table with the following structure: tblLoan (Main Table) LoanID LoanDescription tblApplicant (Primary Applicant) ApplicantID LoanID FirstName LastName . tblApplicantCo (Co-Applicants) ApplicantCoID LoanID FirstName LastName Business...

I have a bit of a quandry. I have a maco that uses SetTempVar to set the CurrentUserID so I can filter on records for that user. This is the macro: Condition Action Arguments Not IsNull([cboCurrentStaff]) SetTempVar CurrentUserID, [cboCurrentStaff] Close ,,Prompt OpenForm Home, Form, , , ...

I am using Access as the frontend and I need to insert records into a SQL table with an identity column. I keep getting the following error: You cannot record your changes because a value you entered violates the settings defined for this table or list ( for example , a value less than the...

I have the following code that does seems to work right: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="tabMain" label="CRSTHA Manager"> </tab> </tabs> </ribbon> </customUI> But when I try to add a button with...

I have moved a Access 2007 database from on computer to another and now I am receiving a 'The SetValue' macro action cannot be executed in disable mode.' I have Trusted the path where the database now resides and enabled macros but still receive this error. It was working fine on the original...

Using Access 2007, I have a form with a unbound control that uses an expression to calculate a total: =[TxtReimburseTotal]+[txtElectTotal]+[txtEducationTotal]+[txtTravelTotal]+[txtMiscTotal] as the control source. I need to take this value and update a bound textbox which controlsource is set to...