Search results

Hi Report Masters, I'm using this code to suppress a subreport in a about 10 report. This is my issue. I need the same subreport to run when selected from a different form. How can this be done? Me.StewardShipKeyMatrix.Visible = False Me.PageBreak227.Visible = False

I have used the wizard to create a print button which prints the current record with this VBA code: DoCmd.OpenReport "CPM_Assignment_Detail", acViewPreview, WhereCondition:=" Id_Number = """ & Me.ID_Number & """" I have added a bit field to a form so that users can 'check' which records they...

Isladogs, I have also resolved this issue that way in the past and did not imagine that that would be an issue again. What, I mean is that I have several databases that use a bit on the sql side. I have set there default value to ((0)) not null and they work fine. In any event I deleted the bit...

Yes, I'm using the same ODBC driver that I've always used that works. And, I do have update rights but I have simple added it and done nothing more. In fact, I have removed it and I still get the same Write Conflict error.:eek:

Hi Table Masters, I'm using SQL 2008 R2 backend Linked DB. I just linked a new table into the objects Now, I'm getting a Write Conflict when I try to change anything in the existing tables. It is not currently part of any query it simple been linked in. Before linking it in everything worked...

What, I need is confirmation that the form was filled out when required. Something like a Boolean = 1 or yes the form has been filled out and so my validation code allows the user to print.

Hi Form Masters, I have a form that must be filled in under certain conditions. When the user selects the print button I have code that checks if it is required as follows: If Nz(Me.txtAmtCash.Value) >= 50000 Or Nz(Me.PledgeAmount.Value) >= 50000 Or Nz(Me.SPH_StewardShip.Value) = 1 Then MsgBox...

Hi MickJav, I made the attached table. Now how do, I set/use it in my code?

Hi Form Masters, I'm using the following code to disable a button on a form. Only the user in the code can use the button. I can foresee that this can become a disaster. Any suggestions on how to improve it? Private Sub Form_Load() If GetCurrUser = "Robert Semo" Or GetCurrUser = "Pass Rey" Or...

Follow-up question on this process. As, I mentioned in the post a form needs to be filled in if a record Amount is >= 100000 but the user may have filled in the form. So, the question is how can, I determine that the form was processed (filled in) only if it was not do I need the other code to...

Hi Form Masters, I have a form that has several payment methods that all go into a single backend database field called Amount. If a person pays by check the textbox is called txtcheck, if by cash it is txtCash ect there is textboxes wire, credit card and others. But, they all are bound to an...

I have to resurrect this issue since it is not resolved on my end. I hope that I can clearly explain the matter. I have a column that I have added to the table that allows NULL so when, I start all the rows in this table of about 150 rows has all NULL's. The purpose of the column is to mark a...

Follow-up question on this thread. This is the code now: Private Sub txtWriter_AfterUpdate() If Not IsNull(Me.txtWriter.Value) Then Me.TxtW.Visible = True Me.AuditWrite.Value = Now() Else Me.TxtW.Visible = False End If End Sub Now the mssql 2008 R2 table gets stamped once the user enters data...

It worked with the text box but oddly after making the first textbox I saw the other six table columns when I started typing Me. ect . Anyway it works. Thanks!

When, I use Me.AuditWriter = Now(), I get an error. Method or data member not found. AuditWriter is a field in the current Record Source and not a textbox.:eek:

Hi Table Masters, I want to add an audit feature to a table. I was thinking of putting it in the after update event code of the field. I have put code there to turn a labels visibility to on when that filed Not IsNull. This is the code: If Not IsNull(Me.txtWriter.Value) Then Me.TxtW.Visible =...

No not limited to two pages. There are two pages breaks so, two other reports print for a total of three pages. Nothing is set to grow on main report.

I thought of that since there is a page break before the sub report runs it will always be page 1.

Yes, the sub reports only have a Detail band but they are in the detail band of the main report proceeded by a page break control. So, the code : Reports!Gift_Rpt.Section(acPageHeader).Visible = False is suppressing the page header/footers every where including the main report. Is there a way to...

Hi GinaWhipp, I have added this vba code to the reports on format: Reports!Gift_Rpt.Section(acPageHeader).Visible = False I did the same for the footer. So, now I'm not getting header or footers any where. How can I limit this condition to the subreports and have the header/footer appear on...