Recent content by zapzip

Perfect- thanks for your help.

Is there a way to change the color of a Tab Control background. Is it also [possible to change the color of a tab that is selected?

Thanks Aceman1 Your suggestions sparked a relook at the query where I found a Or And conflict that was the problem. I did as did as you suggested change the event to afterupdate and created text boxes. The query could not digest your sample code and the "#" constructions are not necessary...

Thank you for pointing me in the right direction. I created 2 hidden combo boxes on my Form F_FindReplace for the start & end dates cboHiddenStartDate cboHiddenEndDate I then OnExit of cboRangeDate created a series of If’s for example if Custom dates is selected then the start & end dates...

I have a form with a combo box with following values i. Custom date (select a range from to) ii. All dates iii. All to date iv. Current month v. Current year vi. Current Fiscal year vii. Month to date viii. Year to date ix. Fiscal year to date x. Previous month xi. Previous year xii. Previous...

That is really cool. My form has over 27 pages of info- it is a bit much to digest. Is there so alternative scheme for documenting?

Forms can quickly get very complicated with queries, code, error handling, column sizing and number, etc. How can one document all these details making future changes and trouble shooting easier.

Hello Remou- Thank you for your response & suggestions. You certainly saved me a bunch of time trying to find a non existing solution. I like the conditional formating approach & will try it. Currently my defaulkt values may be contributing to confusing the users. I requery AfterUpdate...

Hello- I have a form with several subforms. The subforms allow for entering more than one record. The problem is that as soon as a record input is started the next record is also shown (with all defaults shown). This is confusing to my users. Is there a way to suppress the Next reord...

Thanks for your response. Right([PN],3) is what I wanted. What I am trying to achieve is to set the Default value from a calculated field but to allow overrides.

Hi- I have a table (L_RR) that I would like a field (called Abbrev) default value set to the right 3 characters of another field called PN. I have tried using expression builder but get errors. Example: Left ([PN], 3) Example: Left (tables!L_RR!PN,3) Can this be done in table? thanks for...

Hello- I can't get the reference right in VB code a field in a query. Anyone can help? I have a Form F_Deposit Slip with a subform FSc_AvialableForDeposit whose Source Object is Query.Q_DepositAvialable. The query has a number of fields including M_FundPaid.FundPaidSelForDeposit (a Yes/No...

Opps found you can go back & thank for a valuable post so no need for the "hello

I found the error! It was the extra quotes around "Me!cboRentRollMonth.value" replaced with simply cboRentRollMonth & no quotes. Thanks again MajP. I have been working this a long time & really appreciated your help. Please post a "hello" so I can give you a well deserved star.

Thanks for your reply. I think I am close to getting this handled. Here are my latest symptoms. I am not passing the cbo value to the funciton. If I do a debug.print cboRentRollMonth or debug.print Me!cboRentRollMonth.value at the NotInList event it returns 90 in both cases. However, if I...