Search results

Ok So Changed it to this and it recognizes the both of them.. But on the Commission one the "SunCom" value is $200 and the Payrate is .25 why is it giving me .25 in the "SundayPay" instead of $50.00? Private Sub CheckSun_AfterUpdate() If CheckSun = True Then If PayType =...

I'm stumped for some reason and cant seem to get this to work... Maybe someone can help me out and give me a boost so I can get going again... I have this and it works perfectly:Private Sub CheckSun_AfterUpdate() If CheckSun = True And PayType = Salary Then rs.SundayPay = PayRate...

You think since I'm using this on form it would process faster if I did this query as a strsql in the form versus using a query? I'm beggining to think so especially since its calculated based on selection of a checkbox..

I'm trying to show the day in a query "monday or whatever the day s on correspondence to a date in the same query named "SALEDATE". I have tried using several ways but cant figure it out.. Can someone please help me out here with a boost?

OK Now I feel silly.. THE ANSWER IS "End Sub"

Hey another rock in the road dangit.. I need to end my code after txtsearch2.setfocus so I can enter another ID and I'm at a stump... '<___________START ENTRY FOR GUEST OF MEMBER IS YES_________> If Response = vbYes Then ' User chose Yes. txtsearch2.Visible = True...

Why dont you add a third text box (UNBOUND) and enter =[txthomesold]-[txthomeinvnumber] Then use this box to actually for whatever you want the number for.

OK So the Receiving ABove works fine. I then used the same code changing the table it writes to but now it doesnt work in this form.. It is the same setup basicaly. It gives an error "Item Not Found In Collection" I have checked everything and dont seem to see anything wrong here either.. It...

I figured it out.. Thanks for your help.. You cant use docmd.gotnewrecord, , acnew in a form not bound to a table duh.... You have to use after the insert code "me.textboxname = "" "" when a simple text box on a form is used. Also ty for the heads up on the close button being attached to...

TY very much it works very well. Any idea how come the "docmd.gotorecord, ,acnew" doesnt work when you click the save to clear the form to be ready for the new entry?

That didnt seem to change nothing.. Still got the same error..

Maybe someone else know how to do this I surely dont LOL.. But may I suggest trying to build a table of possible matches and make the field a lookup (not bound to list).. Maybe you can fnd a list of words or names or last names on the internet to fill this table with... Just a thought...

I hae attached a database. If you open form fdatrecinventory and fill in the date, select item, enter Qty in first field and selct Liter for example it fills in all fields. In the VDCode it should insert the Date, Item, QtyInserted, Cost into table tdatInventoryRec. Problem is I get an error...

TY I found the error.. In my Combo Box I was only showing the first two columns not all Columns therefore reulting in the combo box didnt recognize th column I wanted.

TY as this works but I forgot to mention the ID column. So I tried changing the (1) to (2) and got blank value even though a value exists, then changed to (3), (4) etc and I only get blank valuesas well... I know the second column value is 1 and the 2nd is 3 etc... If I leae it 1 as u declared...

How can I show a value in a text box that corresponds with what is selcted in a combo box. I have a table that has two columns tdatMeasurements MeasurmentType ActualMeasurement On a form I place a Combo box Called "Combo4" and I add a text Box called "Text18". Now...

*temp Disregard Changing form error*Form VB Code Multiply Qty on Insert Hey I resolved the other issue with scanning in Members (managed to write the code) and have it working but maybe you can help me out here I'm lost on how to handle this or write it in vb... I have a table tdatMeasurements...

Does the company have other databases? Like a database for employees where the Employee information is already stored? A database where Projects already stored? (Probably not since you are wanting this application...) Here is what I would suggest if you have nothing above... Create...

Heres another one for you that maybe you can simplify... What if I had a "ApplicationDate" text Field and a "RenewedDate" and I wanted it to compare those and see if one of them is greater than June 1st of the previous year. For example today is 02/07/2008 and either the "ApplicationDate" or...

TY that works perfectly and much simpler...