Search results

How do I get it to fire though it doesnt seem to fire at all LOL

I have a form that has a field on it that someone enters data in after its entered I want it to fire the vb along with it. I'm using hte on_Change but it fires on the first character they enter. I dont want to use the after_Update even though it works because that means that the curser has to...

I have the attached report and I want a user to be able to open this report and it will show them the date range selected. I'm not sure of the best way to do this but I thought just adding the Start date and End Date on the top of the report would be the easiest way but from reading different...

Maybe Best Way to Go Maybe the best way to go is when I insert the MemberID in the table that I insert the First and Last Name at the same time then when I query its already there..

I have attached a small db that has 1 query with several fields.. Here is what I'm looking to do. In the Query there is the following fields: SignINMemberID GuestOfMember SignInDateTime AllowedEntry Now all these are derived from tdatMemberSignIn. What I want to do is show the name that...

I actually have that code and it works great you are right. You sparked what I needed to do thank You. I needed to build a query and reference that instead of the table ty for the push I was stuck.. The most simple answer is always the one we don't look for..

I don't use Switchboards as I like to make custom Menu's using blank forms and adding buttons out of curiosity why are you using the Generic Switchboard?

I'm not really sure this vb stuff is new to me LOL I added that and it gave me expected end of statement.

Ok I tried that and got Runtime Error 424 Object Required.... Hmmm

I have this code on a form that i enter a "WeekStart" date in a text box and a "WeekEnd" Date that looks at table tdatPurchases on change. I'm trying to get it to place the results of the sum of chkAmt in the table in the text box "GrossPurchases" I get an error: Runtime Error 3061 To Few...

Good Afternoon everyone... I have attached a basic form so maybe someone can help me out and I can get the concept and build upon it in my actual database. In the form fdatMemberLookup I want to be abel to enter the MemberID and click Search. It will then search a table and show the records...

Duhh I knew i forgot to change something.. Thanks.. That fixed it by changing th bound to 2 in th eproperties of the combo...

When I run this command on the Receive Inventory it inserts into the table the Primary Key instead of the Item Name.. When I select the item on the form it shows the Item Name so why wouldn’t it insert that? The order of the table the Combo Box looks in is “PrimaryKeyID” “Item” Private Sub...

In the table that stores the check Numbers make the Check Number the Primary Key or int he properties of that field in the table set it to Duplicates "NO"

I have never tried this one before so I need a good boost on this one to even get started.. Heres what I want to do. This looks long and complex but its really simple to say and I think that it should be simple to do for someone who actually knows what they are doing in code LOL.. ANy Help...

Go to the properties of the textbox on the form. Go to the Data Tab and select the "...". This should open a Expression Builder. Find the Query and field you want this field to represent.

TY TO ALL OF YOU for your help.. If it hadnt been for each of you I wouldn't have gotten where I'am to start the insertion method of this form..

THAT WAS IT "" Ling... Thank YOu I can now go get the super glue and sweep my hair up.. LOL.. Private Sub CheckSun_AfterUpdate() If CheckSun = True And PayScale = "Salary" Then SundayPay = PayRate Me.TotalPayCheck = CDbl(SundayPay) + CDbl(MondayPay) +...

Your right hmm but where should I put it LOL.. Hmm guessing game LOL.. When I moved it to the end it gave me the $50.00 but only when CheckSun = False LOL...

I agree this should be right before End Sub