Search results

Hi CBrighton - yet its run-time environment to replace an installed copy of MS Access - you can download it from the Microsoft site. IT prefer doing this - saves them money. http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13911 Says its a snapshot viewer? Doesn't look like...

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

Solved it - realised I had Open Explicit in the general declaration of the forms module - deleted it and it works!

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

If you open access 2007 - download sample templates - there's one called contact management - which has a search function - Go to design view and looked at the macros behind the "searchgo" and "searchclear" buttons - You can import them into your own database and customise as you see fit...

thanks bob - i'll give what you suggest a go.

FrmStatus (singleform) and UserSub (singleform) are child/master link StatusID but the DocID from MainForm FrmUser (continuous form) and DocID in the UserSub pull their data from the same recordsource - tblUsers The Mainform FrmStatus is based on a query of tblUser and tblStatus - it is locked...

Hi Bob I made an error - the code I pasted is wrong. I got the code the wrong way round DoCmd.OpenForm "FrmStatus", , , "DocID = " & Me.UserSub.Form!DocID - is not what I'm trying to do. So that on my Mainform – when I hit the button it will open FrmStatus where both DocID on Mainform and...

the DocID is numeric.. I've also realised that the form i'm trying to open [FrmStatus] - has a subform [UserSub] and the DocID field is in that subform. So from my MainForm under the click even on button - i used this code to test - DoCmd.OpenForm "FrmStatus", , , "DocID = " &...

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

actually BigJohn's reference to the treeview blogspot was the site I was thinking off -

Brilliant - thanks boblarson and spikepl.

I've attached a collection of different treeview db's I gathered from my travels around the internet researching how to do treeviews - None of them are mine - they were made by others - hope you find them educational. There is one really good treeview tutorial site - I don't have the URL on...

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