Search results

Hi there hopefully people are still looking at this post?? I think I have sorted the change color by date issue, but in doing that I've stubbled upon another problem, the form that shows this data and is set as a continuous form, problem being is that whatever the first record is, it changes the...

Thanks Simon, will dive in and see what I can get going!! here some more info vbainet Basically I am creating a brand new database from a existing one that was created, the service contract never worked on the old one so they were working of a excel sheet, so all the data will be put in...

Afternoon People, I am creating a database but i am having a problem in that I have a Service Contract form that I want to color code the dates depending on some expressions, I.E I have a "ACplanned Date" (text box) and a "ACComleted Date" (text box), what I want to do is when a date is...

Good Afternoon, is there a way to transfer data between to active form, here's the problem I have a form called "create job" with a order number in it, if you click a check box a new form opens where it should create a invoice number and automatically have the order number in if from the...

right started to do this (which I regret now), but I was wondering if there is anyway of doing a select case statement so that if the text in a text box matches in code then the colour of a image changes to show it highlighted on the "map" form. I got it working with Private sub...

hello, I would like to have a set of images spread out over a form (say a map for computer location) I want to be able to select a certain record and it to show up on the "map" I have tried many different things like drawing a rectangle over the computer image and it to change width and colour...

cheers mate, having a little play now :-) will let you know how it goes and think I'll have a better understanding after my VBA training this week.

sorry, basically peoples Ideas on the easiest way to achive this if possible, I have created the Floor Plans as .jpg but problem being is that they don't have the computers on the plan so need to insert them (guessing using object frame?) and using VBA to highlight them? like I say I have...

Hello, I work in a college and I have completed Access 2007 level 1-4 and about to complete the VBA course, Basically what I want is to create is a form with floor plans of my college where you can click on a computer and it will show you they machine name/location etc in a sub query and also be...