Search results

Yes, bound to table

It sure is, that's what is confusing me

Hi All Having a bit of a brain block day. A form with a Combo Box on where users can select a Contractor by surname. Once selected the text box carries the Contractors first name, which all works well. But when I try and change the name in the TextBox it does not register in the tables...

Hi All Is there a better way of distinguishing whether a PC is 32Bit or 64Bit?? I am currently just using If statements that if a certain folder exists it must be 64bit else if not it must be 32bit?? Just seems a bit flaky. Gareth

Yep your right, I was just trying to save time. As the forms were changing I thought that if I changed the form it would automatically change the report, so that I wouldn't have to change stuff twice (If that makes sense) I have created two Sub Reports as you suggested and with a bit of...

Revised db attached. It throws up a few errors but still throws up the error. Use Badge Number 999 and run frmViewPermit Thanks alot GW

Yes still throwing up the error 'The expression you entered refers to an object that is closed or doesn't exisit'. There are no page breaks in the Details section of the report. I thought there were a couple behind the forms but alas I must of removed them.

When the Print Button is selected it fires rptViewPermit. rptViewPermit has four Sub Forms all link by PermitNumber. If the forms have data they print just fine, if not they just leave a blank space. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If...

Yep, the wife keeps telling me I don't listen! I have done what your have suggested but still the same error:mad:

Yes, sorry I couldn't find this 'Hasdata' property initially but have now Have tried Private Sub Report_Activate() If (Me.frmHotWorkView.Report.HasData) Then Me.Label97.Visible = False End If End Sub This is on the Main Report (rptViewPermit) Error now is...

OK My Main Report is called rptViewPermit, within that Report is a subreport called rptHotWorkView. Within rptHotworkView is a TextBox called 'PermitNumber' When rptViewPermit opens I want it to check to see if there is a value in PermitNumber, if there is then make a label on...

Both are set to Yes, and there are a couple of page breaks. The problem is that there simply isn't a record for one of the sub forms, so what I am trying now is on the sub report place a label with text, but make it not visible. Then If PermitNumber IsNull the make label visible or something...

Hi Everyone, I have a Report that consists of 4 Sub Reports (That fit onto one A4 print) and when printing if the sub reports have data to show then they print off without issue. But when the sub report does not have any data then the report just creates a blank space where the sub report...

Yes, I had already changed it to 'AfterUpdate'. Many Thanks anyway for the tip GW

Patrick, you are an absolute star, a big big star, a big big big star. I am forever in your debt. I never thought of that. Many Many Thanks my good fellow

Hi I have a combo box that has 4 hidden values, I would like one of these hidden values to be added to a field in a table. So I created a textbox with the control source pointing to the field and it's default value set to =[CompanyName].[Column](1) thinking it would place the value in the...

Hi Yep, I sure am

I'm looking but no bells are ringing. Just a combo box, not the whole form

Hi All On a Combo how can I stop users entering there own values?? I've done it before but simply cannot remember how?? Thanks

The current vba code i have listed brings back the latest date. So when we bring up the profile of a client, it shows the last time they visited. But if the client is involved in another visit and is not the 'Leader' there name will go in another field CustRef1, CustRef2, CustRef3 or CustRef4...