General
in [Access]
|
if duplicate goto record access 2003 Main form is called f018ContrPerfEmissGua has the fields UnitNo(number) and ckGEN(yes/No ckbox) subform is called f018ContrPerfEmissGuaDetails (linked by ContrPerfEmissGuaID) User will select the unitNo, and check ckGEN(if it is a GEN) from the main form When the user tries to enter data into the... 11 May 2010 19:03
Format In table A I have Paid_Amount which is stored as currency. In table B I have Membership which is stored as a number long integer. In the query I have PMPM:([Paid_Amount]/[Membership]) The query runs fine, but the data is a long number. I then changed it to say PMPM:FormatCurrency([Paid_Amount]/[Membership])... 11 May 2010 15:41
label and currency textbox I have a label with a textbox directly underneath it. The are aligned to the right. The textbox contains a currency amount and yet they do not display aligned. How can I make the last character of the label line up with the last decimal of a currency value? Thanks for your help. ... 12 May 2010 11:23
Convert db to accde Hi there, I am working in Access 2007 and have recently converted a front-end to accde. When opening this new accde db though, none of my code can be run (all linked to command buttons on menus with click() event). Am I missing something or could there be another reason? Thank you in advance, ... 11 May 2010 14:33
how do i turn on overtype in microsoft access how do i turn on overtype in microsoft access ... 11 May 2010 19:03
Access 2007 Graphs I am trying to create a graph that has two colums for two types of data. Basically I want: Column 1 Column 2 Column 3 Column 4 Row Heading Column Heading Value Value I am wanting a line graph with two lines (one for column 3 and one for column 4), but Access does no... 13 May 2010 00:45
App in 2003 in a 2000 environment I have my program in 2003 and a customer wants to include it in his program which uses 2000. Possible? Can they both run on the same PC? They use diffent runtimes. Comments welcome. Ed -- The Lottery Works! better with us. ... 11 May 2010 16:48
VBA needed to delete corrupt records from MsysObjects I have a form that will not open in normal or design mode and there are 2 Form_~TMPCLP######## objects in my VBA Project window, and there are 2 Objects with the same name in the MsysObjects table of type 32678 which means they are forms. I expect that if I am able to delete these I might be able to salvage my... 11 May 2010 16:48
Need Help... I have project update form based on parameter query. In the query ProjectEngineer Criteria field, I put ( Like [forms]![formfind]![combo1] ) . The record source of query is TblProject and fields are ProjectEng,….etc. The row source of combo1 of Formfind is a query as SELECT [Employees Extended].ID, [Employees... 12 May 2010 08:03 |