Search results

Where is the sample file at? I am working on the same issue right now.

IS there a way to show the scanner interface?

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

Now in retrospect the idea of a co-applicant table will not work. Each applicant also has a link to a income, expenses, credit table. Each of these tables are joined to the tblAppicant by the applicantid. But if I go the route of the tbApplicantco, then I will have to duplicate the income...

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

But now I came up with the issue that my linked SQL table has 257 columns in it, and i can only see the first 255 in Access. The last column is needed for an Update query but I can't see it. Any ideas?

I found the issue, one of the fields coming from the Datalink file was a text and the SQL table had the column defined as a float. thanks.

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 think it is closed: <group id="grpHome" label="Home"/>

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

Could the problem also be I am using the evaluation version of Office 2007 Evaluation Version?

Right now it is set to Enable macros under the Trust Center. But I am getting a little closer, the only macros that error are the ones that use SetValue in them. Is there something specific about this particular action that I am missing?

And I do think it is trusted because I know longer get the Trust Message on the Message Bar when I open it.

I can open the ACCDB and it runs the forms fine and it even rruns certain macros just fine. I am just a little confused why it doesn't run all the macros.

There is one at the folder level but not at the file level. Do I have something turned off maybe on XP side?

Yes, I did. All it gives me is the file sizes,location, mod, create dates and such.

Trust Issue I am running XP Home edition and when I right-click on the ACCDB I don't see any of the options that you mentioned.

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