Search results

I believe I am using If - then - else when in VBA; I tried using iif in the expression builder and there i got it to work correctly with the above 95, I just couldn't get any of the ranges in there... for vba it's been looking similar to: If ([txtwarrantyavg] >= 0.95) Then Me.Text12 =...

Hi All!, I have a database that's very basic. There is one table that has every field that I need to collect. I have a user form to collect this data. I also have a report that shows the scores recorded. I have a text box that shows the higher of two values in two different fields. (Quiz...

Well actually I do have a related question. I have 4 unbound boxes (week 1,2,3, &4) in my report so that the user can type in how many working days we had that week. I then want to add these text boxes together in another unbound box and include this in yet another calculation. My goal is to...

Thanks Mr.Ziggins! Your code worked perfectly. Whew. Thanks again!

Hi All, I am a newbie to Access 2010 and so far I have learned a LOT, partially to the help of you fine folks . I have built a database, and created a few forms to gather the data. My next task is the reports section which I truly know NOTHING about . Background: I work on a team of 8 that...

Wow. I am somewhat embarrased that I had to ask about something so simple. :rolleyes: This worked perfectly. Thanks very much PBaldy!

Hi Chaz, I just came across this forum and I am having trouble doing what you stated you had no problem with. My form is exactly like you say a continuous form that mimicks an "excel" type view. I need to conditionally change each "cell" to turn gray if it says 1001. I would appreciate any...