Search results

This is great information - thank you Bob!!

Ahhhhhh - thank you Bob! I was really starting to panic! I though the db was corrupted! I suppose I have to read up on what the special keys have to do with VB.

Hello, I am not sure what I did wrong. I have a stop on my vba code so I can step through it. The code is on the "current event" of a form. When I go to the form and run it, the code seems to work, but it does not stop at any of my break points. I think I may have accidentally changed...

Hi, I am using this code to hide the Ribben, DoCmd.ShowToolbar "Ribbon", acToolbarNo I have the code in the load event of a form. The issue is that when the user opens the database, they first have to enable content, which means the ribben is available - is there a better solution...

Bob - you are a true gentleman sir and a descendant of ancient, royal and conquering warriors :) Also, you are correct, I did mean OR and not AND since AND would have always returned 0 records. "OR" will be the one to return all records that begin with XX or AB. Thank you Bob!!!

Hi all, Again I am blighted my eroneous syntax. Can anyone help please? I simply would like to use the "LIKE" operator to select only Assets that begin with XX. I would also be grateful if someone could show me how to include an "AND"; this way I can have "LIKE" XX and LIKE AB"...

Bob and Ken - I can't express how grateful I am for the help in this post. I finally have form the way I would like it to work and I could not have done it without your help. You guys are awesome!!

okay Ken - so then there is no way to keep a previous filter and filter that recordset??

Hi Ken, Yes, both are unbound. I just assign the filter criteria to a string and filter the string using the value in the txtbox . . Me.Filter = strFilter Me.FilterOn = True

Hi all, I have a form with two txt boxes. On the Aflter Update event of the first text box, a filter is applies. On the after Update Event of the second Box, A filter is also applied. However, the filter for the second txtbox removes the filter for the first txtbox. What I am trying...

Bob - thank you! I will work on this tonight and let you know how it works! Thank you!

Hi, I am getting error "Property setting too long". I have around 200 criteria in the sample below? Is there a better way to do this? Thank you!! Me.Filter = "[Number] IN ('12345','552364', . . . . .

Please delete

Thank You Bob!!

Hi, I have the below sql in code. I've been tring to add a line where [building Number] is NOT NULL - but I can't seem to get it right. I created a query and tried to copy it - but my syntax is incorrect. I would be grateful for any help!! Thank you! Rem POPULATE BUILDING LIST BOX...

I think I understand Bob - is there a then to just copy what show in the navigation pane into a lable or txtbox? I am still learning - this is what I have been trying with - I know it is a mess . . Option Compare Database Dim Vcur As Variant Dim ORS As DAO.Recordset Private Sub...

Hello all, I have A form. I would like to have a textbox or label that tells you what record you are viewing out of how many records. In other words, I would like to duplicate exactly what is on the navigation at the bottom of the form. The reason I would like to do this is because I...

That's awesome! I didn't think of doing it that way. A thousand thanks Pbaldy! I am always grateful for the extra hints beyond the necessary help :)

Thank You very much Pbaldy - It appears the below works. Thanks!! If Not Me.txtOrderAmt = "" Then MyDcountI = DCount("[order_amt]", "Mytable", "[order_amt]" & " = " & Me.txtOrderAmt) MyOrderMCount = MyDcountI MyDsumI = DSum("[order_amt]", "Mytable"...

Hi all, I have this code at the "Form Current" Event. When a user activates a new record, I wanted to let them know how many times the value in txtOrderAmt appears in the column Order_amt, and also the sum of the values. So, if 300 is in txtOrderAmt at the current record, then count how...