Search results

I know the navigation control exists for sub form - however, it doesn't show up on my sub form. And I know I shouldn't reinvent the wheel but lets say for aesthetic purposes is it possible to replicate in a label.

I have a main form [frmZone] and a sub form (single form) [fromZoneSub] linked master/child by [ZoneID] If there are, say, 5 related sub form records I'm trying to get a label [LabelCount] on the sub form to say "1 of 5" and as you click through the sub form for the label to change "2 of 5"...

Ah! the OR criteria that would work: between Forms![ReportForm]![BeginOrderDate] and Forms![ReportForm]![EndOrderDate] Or between Forms![ReportForm]![InterimOrderDate] and Forms![ReportForm]![PostOrderDate] To return records for both sets of dates.

I have a form [ReportForm] with two unbound text boxes to select a date range. [BeginOrderDate] & [EndOrderDate] These two boxes look up a query with the following expression: between Forms![ReportForm]![BeginOrderDate] and Forms![ReportForm]![EndOrderDate] However in my query I have several...

I have a simple query with this SQL SELECT [Copy Of QueryLevel1Sum].TotalStatus, [Copy Of QueryLevel1Sum]![TotalStatus]/100 & "%" AS Percentage FROM [Copy Of QueryLevel1Sum] GROUP BY [Copy Of QueryLevel1Sum].TotalStatus, [Copy Of QueryLevel1Sum]![TotalStatus]/100 & "%"; Which produces this...

Just out of interest how would you write a button's click event into a form's current record in vba? Private Sub Form_Current() Cmd1_Click Me.txtMail.Visible = True End Sub Is there a way of doing that?

Hi, I have a continuous form with a button 'Cmd1' & a textbox 'txtMail' which is set to visible no. When the user clicks Cmd1 - then txtMail becomes visible. I can do it using vba on the buttons click event but when it executes txtMail for all the records become visible. How do I use a...

Hi Plog, You're right - checked the datatype of ArcDate and its text. If I change the datatype to date - it should keep the current date format. I'll backup the database and give it a go. Thanks for your help plog

Hi all, Trying to run a query to sort through a field called [ArcDate] from oldest date to the newest. The date format of this column is day/month/yeah At present - I'm using the "Sort: Descending" in query design however it sorts out this column by day like this; 01/01/2010 02/01/2008...

Brilliant!! - thanks once again vbaInet for your invaluable help!

Hi. I have a continuous form with a bound checkbox [VAT] - I have an unbound textbox which I want to use to count how many checkboxes that are TRUE. I'm trying to use the =Count function but getting invalid syntax error messages. Could anyone advise the correct syntax to use as the control...

Hi vbaInet. Decided to change the hyperlink field to a plain text field. From there - created a button using the following code: Private Sub bOpenFile_Click() On Error GoTo Err_bOpen_Click Me.LinkField.SetFocus If IsNull(LinkField) Or LinkField = "" Then MsgBox "Please...

Hi vbaInet, The problem is - I'm using a button to open a browse dialog where I select a folder - once i've selected the folder I want, the pathway, i.e C:/My Documents/Project Folder gets displayed in a bound hyperlink field [LinkField] When I go to click on the hyperlink nothing happens...

Hi On my form is a browse button that lets a user choose a pathway to a particular folder - the pathway to that folder is then displayed in a bound hyperlink field. However the folder pathway is only showing in the hyperlinks "text to display" field and not in the hyperlinks "address" field...

Tarus - this works brilliantly thanks so much for your help on this.

Hi All, Strange question, I know, but just curious to know if it's possible to do it. In my query I have a column where I can concatenate two fields: ValidationReference: [City] & " " & "|" & " " & [Postocode] However, If I wanted to concatenate data in just one field, say, [Postcode], how...

yeah, thought so. Thanks anyway.

Hi All, I have label which is visible when a user clicks a button in a menu bar at the top of my form. However half the label disappears behind the subform - is there a way of getting the label to display over the subform. Thanks

ah!!!! Never thought of that - they are unbound - will make them bound to the table - -- thanks for your help!!!!!

Hi All, I've got a check box on a continuous form, yet when I click on it in in a record that has the focus it checks all the other check boxes in my form. Trouble is I lock it on the AfterUpdate event, which means when i click on another records they're all locked. Is there a way of simply...