Search results

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

if you all have access to the shared drive, look into splitting your database and giving each user their own front end. This should allow all users to enter data into the database directly

Can you post up a sample database? Id like to see some data and give it a try