Search results for query: *

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?

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

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

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

hello- I have 2 cascaded combo boxes on a form that I would like to add a new record to using Not In List event. I have searched & found several Not in LIst Event Handlers but none that seem to handle cascaded combo boxes. Would greatly appreciate anyone would knows of a source or could...

Hello- I am stuck on a reort with a subreport that has 3 columns (columns set at 2" width and 2" Height. The report displays the subreport with columns with height necessary to accomodate the number of text box records in the recordset. Any ideas how to fix this? I have gone around & round...

Hi- Need some ideas. I have a form with two sub forms populated by queries. The user moves records from the first (by using Yes/No field) to the second. This is working fine but I would like to prevent more than 10 records in the 2nd form. Any suggestions appreciate. Change. Remember...

Hi all- I have been struggling combo boxes for days and would appreciate any ideas. The first combo box lists sites and the second Leases. What I am after is after selecting a site that only the leases for that site are dispalyed in the second cbo. Form Record Source is M_ReceiptSlip Site...

Hi all- Help! I have a report (with query as record source) and a subrpeort (also with a second query). When prints get as many DUPLICATE shhets as there are records in subreport. I have tried SELECT DISTINCTROW to no help. Any ideas? Thanks--

I have a report with numerous subreports. The subreports only have data sometimes (a single dollar amount and a description). The report is laid out as a spread sheet with all the sub reports in the same column. How can I have the report not take up a blank row when there is no data in some...

Hello- I am trying to generate a BaNK dEPOSIT SLIP. I have set up a header with the deposit date, and the totals for currency and coins. The Detail section has 2 list boxes for List of checks and Amounts. I have scaned a form and embedded the gif file in Report object. The problem is that...

Hi - I am stuck. I have a report with a header with several text boxes and 2 text boxes in the detail section. The header works fine but the detail section produces 12 records and then moves the balance of the records to page 2. There is plenty of room on page one but I can not get it to...