Search results

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

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

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

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

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

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

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

Hi Just a general query - My small access db (A2007) is ready to be used by 10 people - each will be using the database via access viewer - I haven't tested it in Access viewer yet but just wanted a heads up before I do. is there a likelihood of any problems with macros or vba if it is used in...

Hi All I've got this bit of code behind a button: If Me.ProgressFlow = "No" And Me.Status = "Draft" Then StrA = [Protocol2] DoCmd.GoToRecord , , acNewRec Me.Protocol2.Value = StrA Me.Status = "Pre-Approved" End If I tested it out in a demo db where it worked just fine before I copied over...

Hi all I have a master/child link between my mainform and a continuous subform - the subform has a check box control which is ticked by the user when an action in that record is resolved. What I'm trying to do is enable a button on my mainform only when ALL the records in my subform are True...

Hi All, I've got a text box on my main form [txtuser] which displayers the user's name. I have a subform [SetupUsersSub00] - with a combo box [Person] on the OnLoad event I want the value of [txtuser] to insert into [Person]. The code I'm using is...

Hi all, Using A2007 - when creating buttons using the command button wizard it does so using macros - whereas in A2003 it used to do it in VBA. I prefered it that way! So is there a way of getting the wizard in A2207 to do it in VBA instead of macros. Thanks for any info.

Hi, My form [FrmMsg] is a continuous form - I have a check box - when the user clicks on it the fields in that record are disabled - effectively meaning job done. However, it means I don't need those records loaded when the user opens the form next. is there a way on the forms On load event...

Hi - scratching around for a solution I have a button on my MainForm - On click - if [textbox] on MainForm = "Live" then open [Form1] where DocID of MainForm is equal to DocID on [Form 1] But if [textbox] on MainForm = "Postponed" then open [Form2] where DocID on MainForm is equal to DocID on...

Hi, I have two textboxes [AssignedText] and [OwnerText] if both have the same name , i.e the owner of the project has assigned himself the task then I want to enable [WorkButton] But if [AssignedText] and [OwnerText] have different names, i,e the Owner has assigned the task to someone else...

Hi all I'm getting a bit confused with syntax - I have a [MainForm] with a [SubForm] I'm trying to get [Button1] to be visible on the [MainForm] when user clicks on a [TextBox] in [SubForm]. Can anyone advise on the code I would use for that? Thanks

Hi all, I have a continous subform (frmB) on a main form (frmA) (Main form is unbound - has a navigation bar) I'm trying to open the subform (frmB) to a new record each time the Mainform (frmA) is opened. On the Load event of the Main form (frmA), I have: Me.[frmB].SetFocus Docmd.GoToRecord...