Recent content by airhendrix13

Hi everyone! I want to create a start page that has a combo box containing all of my forms, and then when selected and a "Go" button is pushed, will open the form corresponding to the selection made in the combo box. How do I go about doing this? Thanks, Ryan

Hi, I am trying to make an asset management database. Currently I have several tables already set up that I would like to be organized into a form. Basically what I have in mind is a switchboard (already setup) that has the equipment type (balances, centrifuges, etc..) that when I click on one...

Hi, I need a text box that isn't editable that counts up by 1 every time the form is selected. For example, I am assigning a number to every item added to a table. Currently I have 300 items, so from now on, when this form is selected I want it to automatically assign a number to the added item...

Alright ill give that a shot tomarrow because my shift is done. Thans a whole bunch for your help and hopefully you can help me some more tomarrow. I added to your rep as a thank you.

ok so now i get this error Private Sub Combo26_AfterUpdate() Dim rs As Object Dim x As Integer x = cbo_Combo26 Set rs = Me.Recordset.Clone rs.FindFirst "[Tenantid] = " & x If rs.NoMatch Then MsgBox ("cannot find this tenant") <--------high lighted yellow Else Me.Bookmark = rs.Bookmark End If...

Ok that part now seems to be solved but now it high lights the "end if" in blue and shows the compile error message again. Private Sub Combo26_AfterUpdate() <-----this is high lighted in yellow Dim rs As Object Dim x As Integer x = cbo_Combo26 Set rs = Me.Recordset.Clone rs.FindFirst...

Heres the whole macro... Private Sub Combo26_AfterUpdate() Dim rs As Object Dim x As Integer If Not (IsNull(Me.cbo_Combo26)) Then x = cbo_Combo26 Set rs = Me.Recordset.Clone rs.FindFirst "[Tenantid] = " & x If rs.NoMatch Then MsgBox ("cannot find this tenant") Else Me.Bookmark = rs.Bookmark...

Ok I changed all the surname stuff to Combo26 like it said in my properties and I still get a "compiling error method or member not found" and this gets high lighted in blue ".cbo_Combo26" and this in yellow "Private Sub Combo26_AfterUpdate()"

I'm also Access retarded if you haven't noticed already. LOL

Okay for the name of the combo box do you mean the name that sits next to it on the form or what? Because if thats the case the name of it is RS Number and I get an error. Sorry guys to waste your time but this has been an issue for a while and i need to get it fixed.

Ok so I dumped the comma but now I have a new error! "run-time error '2465' Microsoft Access can't find the field "cbo_surname" refered to in your expression. JAARRRR! Thanks again.

Also "Dim rs As Object" is red, does that mean there is a problem with that at all?

Private Sub Combo26_AfterUpdate() This is the line of code that gets highlighted. If anybody knows of any ways to get my task accomplished without using additional macros that would be even better Thanks again guys

Hi, I want to try to get my combo box to update the rest of my text boxes. For example, I have Column A, B, and C in my combo box, when I select for example A, I want all the information for row A to show up in my text boxes. I have several columns in each row in my table and each column in the...

ok thanks a lot guys