Search results

Hi I really appreiciate your help on this but it still doesnt work... 1. I have gone to cmd black screen and it comes up with c:\windows\system32\cmd.32 as the path. 2. I type in regsrv32 mscomctl2.ocx 3. It comes up with the message saying "regsrv32 is not recognized as an internal...

Thanks for this... but ive put this file into the System32 folder... but it still doesnt work.. you say that i need to register tis.. but how do i register this file? Thanks

Hi All I have moved my Acces 2007 from my lapto to my Home PC. I can no longer use my DTPicker (Microsoft Date Time Picker) which looks like a combo box until you click it. Now that i have moved it i cant get the "No object found", how can i use this date time picker? Thanks

Thank you very much

Thanks for this John This not really what i wanted, but i what i really wanted to know was how to change the behaviour of the combobox, so where ever the user clicks on the combobox (whether its on the arrow, or the inside section, or the border, or whatever) then the drop down list will...

Hi All There are two ways to use a drop down box typically and i want to know how to do point 2 1) The first behaviour is if you click the arrow button, then it displays the values in the combobox to choose from which allows you to edit the content of the combobox, therefor it is not...

Guys, Thank you so much for this.. both solutions work fantastic... Thanks Again!

Hi All I have a listbox on my Form that is called lstEvents. What I want is to click the item in the list box and return the value of the first column for the item i have selected. The following code doesnt work with an On Click event on the list box but it does work for On Double Click...

Hi All The following code does not work on my Access 2007 Enterprise edition within a form i have Private Sub btnAssignLeads_Click() MsgBox Me.cbxAssignTo.Value End Sub when i click the button to execute the above code it does nothing... any idea why? Thanks

Many Thanks. It works great now!

Hi All Im trying to use this formula in a textbox on my form =DCount("[Area of SRM]","tb1lFull Client info","Area of SRM = 'RMP' ") "Area of SRM" = The field in the table "tb1lFull Client info" = The table that contains the field "Area of SRM = 'RMP' " = The condition It comes back with...

Hi all I have a form called "Form1". Within Form1 I have a tab control with 1 tab on it called "Tabs1". Within Tab1 I have another tab control on it with 1 "Tabs2". Within one of my tabs on Tab2 I have a subform called "sbFrm1" using a query as its data. the query is called "Query1"...

Hi All I have two listboxes List1 & List2. I have populated List1 with data. I then have a button that transfers what is selected from List1 into List2. Me.List2.AddItem Me.List1.ItemData(Me.List1.ItemsSelected(k)) It works fine with the expection if the item selected in List1 has a...

Hi All I have a form called 'Form1' and have a listbox within it called 'List1' Its populated with data. How can i determine how many items are in 'List1' using VBA? Thanks

Thanks for the suggestion. But can you explain the concept behind and MDE file? How can i restrict users from seeing tables and quesries? Thanks again

Hi All I understand the functions behind access security in terms of users and which groups they belong to. My only problem is this - Lets say when I log on as an Administrator then I would want to see all Tables, Queries. But lets say a user with only read only access logs on then I dont...

Hi All I have a microsoft Word Documents with Form controls on it. In order for the forms to work, the document needs to be protected in order for the controls to be locked down and usable. My problem is that when the form is protected, its not possible to insert bullet points, change text...

I have broken the link between my form and the table. So as it stands now it only has a link created with the code i posted earlier, but it still says fields not updatable. I there a problem with the textboxes its self? do i need to allow updating or something? Maybe its something to do with...

Thats great, I understand the concept. So now i have linked my form to table1. But I have like 30 fields on this table. Surely i can do a beforeUpdate and AfterUpdate for every field. What i really need is for the computer to know which field has been modified rather than writing if then...

Hi All I am trying to update some records on my form. The forms connect the fields in table 1 to the fields in my form. When i try to make modifcations to the fields on my form, it wont update the table thats its connected to. It says 'Fields cannot be updated' What is the problem...