Search results

Thanks gemma, so my syntax is a test for true? If me.allowedits = True then .... else .... etc :) BTW working late? 16:40 here

Thanks for your reply Walter, What I am wanting to test I think, is if the form is open in acFormEdit or acFormAdd mode. not much of idea how to put the test together. lightray

Sorry if this has come up before, I have been chasing dozens of threads that are so close, I've still not got it!:o I have a form that is used in edit mode and add mode. When used in edit mode it has a combo box in the header that does the usual bookmark search in the after update event, and...

Sorry learner driver here! Just so I understand the answer to this thread, Me![Number] was a actually a text field, and the original code was saying, test it as an integer yes? lightray

autonumber should not be used as data entry fields. autonumber implies it numbers automatically, you can't enter it in. suggest you use another field for you customer number. lightray

Okay! Here's the sql for testing for Duplicates from a DB I have, you can adapt. SELECT tblEmployees.LastName, tblEmployees.FirstName, tblEmployees.EmployeeID, tblEmployees.HomePhone, tblEmployees.WorkPhone FROM tblEmployees WHERE (((tblEmployees.LastName) In (SELECT [LastName] FROM...

Click the New button, and use the find Duplicates Wizard;)

If you have ones that are never going to be used, why not base your form on a query?

check out the 'Flexible Query' at this site: http://www.utterangel.com/pages/access_downloads.aspx See if that helps. lightray

Okay! this was not mentioned ... So are saying, that if you add a new record to the tblPolicyData you want ColNo ( in tblCollectionData) to be set to 1? What will it normally be?

[txtOrderID] implies a label name. What is the name in the Control Source of the Data Tab of Properties? lightray

thought? why is this called PolID does it relate to another table? Set the value of ColNo to 1, if we can sort out what the PolID is:confused:

Okay, let's back up a bit, From the image you sent you arn't getting the drop down box yet? is that right? lightray

The thing that's really got me is that DailyALInc is the smallest of all the values and I'm subtracting everything from it?:confused:

From what I can gather you need another table if you want the polID to increment. tblCollectionData ColID - PK New table PolID - FK--------------------PK-PolID Autonumber Amount Method of Payment (6 records) ORDate ORNumber Not sure...

Sometimes when you cant get it, as the saying goes "a picture paints a thousand words. Hope you can make something of this.. Put together with suggestions from the previous posts, this is a version I think of what you want. lightray

Hi, Am looking for someone to talk about how Annual Leave might be calculated, given that an Employee can have a different entitlement over their employment with a company. Mainly interested in calc'ing a daily entitlement, and not getting involved in any Payroll side of things. Much...

What is you tables structure like? a subform implies two tables, which gets information related to the main form and linked by a common field. lightray

Strangely enough the 5 is a 5 Although I still haven't figured out the whys and wherefores of the Formula, switching it around has corrected the values. See enclosed image, both examples included. Any insights welcome;)

you need to Nz(Your formulas),0) to generate a zero response to no data lightray:)