Search results

Update on this... Well I blew my knee again the first soccer game back after rehab... couldn't believe it.... If anyone is reading this and going through the same thing.. TAKE YOUR TIME and rehab the hell out of your knee. Surgery again tomorrow and I'll be taking my time with this one!

you can do this using a dlookup and using the value from the combobox on the main form..

one too many

it sounded like

Check out this post and see if it helps you http://www.access-programmers.co.uk/forums/showthread.php?t=95696

It's Friday... have one!

ok, so its not an actual field in the table then. Try DaysLate: iif(([DateRented] +5)-[DateReturned] <0, 0, ([DateRented] +5)-[DateReturned] ) if duedate is the name of a field on your form, the previous entry I had would work... Are you sure the name of the field is dueDate?

is duedate a field in your table?

use an iif statement DaysLate: iif([DueDate]-[DateReturned] <0, 0, [DueDate]-[DateReturned] )

Ah Laptop.... hmmm.... no way i know of besides turning the laptop on its side... :eek:

I know you probably thought of this, but instead of looking for a new ocx, What if you turn the camera on its side? Is the picture too long then?

y-front wearing masked

im sorry, i didnt see you wanted it on a report.. you can do it in the on format event of the report

You can do this with an if statement in vb using the .visible property of the textboxes Something like if status="green" then textbox1.visible=false textbox2.visible=false else textbox1.visible=true textbox2.visible=true end if Oh and you can put it in the oncurrent event of the form

You can do this using the button wizard.. no need for macros

he was confused

full and happy

Same here, not to the 97 part, but ive steered away from them. I am starting to see the light when using them for certain things though... ie make table queries on startup etc...

do setwarnings = No before running the queries and setwarnings = yes afterwards

There are many articles out there about splitting your database Heres one http://www.databasedev.co.uk/split_a_database.html