Search results

ok I solved it in another method I put the original query as a subform and on Form_Load "If [sfQryrooms].Form!" place,room,bad=

label dont have Conditional Formatting i will have to do it on textbox

Can you check what I did here?

Thank you so much appreciating your effort But I need the procedure to be on Form_Load Without selecting a record in my db the code is wrong

haha first this end user is working on 27" screen an a powerful pc second i did some crazy stuff with access graphics this only small part of one room a needed to edit it sorry

my db is in other language il explain what i did. I built a room drawing took my original drawing and put it in the back of the form Next to each room is a list box that show the name and the bad number on the drawing i used labels as bads 1,2,3,4 ect' now if the number of the bad is in the list...

thank you so in words the code should be like "if listbox contain "1b" then background =...

I'm building a student dormitory drawing and the list box well show me the name and the label well show my Whether the bed is occupied or not

thank you my confuse its a label not a textbox any way i don't like to use Conditional Formatting access is not a graphical software

there are all kind of numbers 1,1a,1b,2 ect' your code is giving the "Else"

hi: i have a listbox 2 Column that get the value from a query in the form there is also textbox my vba code should change the background color of the textbox if some value exist in the listbox and if not set different background i have like a blank in my mind and i can't remember If...

hi: is it possible to print double sided 2 different report for now i'm putting the paper with one side printed and then print the report When the page is upside down my printer support Duplex Printing

thanks for the replay my Issue is more the permissions and user management so user's accounts will be managed from a server

hi: i have a workgroup with 5 ms access db(can grow) it's all LAN with 1GB there is 10 pc's(can grow) working on the DB. the backend tables are stored in one of the pc's my Q is i have to build a server no question about it my problem that i don't want Start messing around with windows server...

work great thank you

hi i have a form for insert students datiles on the form is failed name "studentid"(text failed) that have index what i need is when typing a new "id" the code well search if the "id" is already exists my code If IsNull(DLookup("[studentid]", "students", Me.studentid <> 0)) Then...

tnx Gasman Max(caredate) < = Date() that work

sorry The_Doc_Man but Not really understand you TGTDATE as a string what value to put "date()" ? DATEFLD is my date field ? = "caredate" MYTABLE ? the "caredate" field is inside table called "monynotes"

that was my Q' ok let's say i want to search between 2 dates #1.1.2000# to now date what is the closest date to now date

The closest date Without reference "y" "m" "d"