Search results

Can you assign a custom icon to a MAF file?

In the current db Im working on I needed to work a expression on 4 fields: datein, timein, dateout, timeout to figure out if they were gone... I had a confusing mess of a query. I really just needed to know if I could add the datein/timein fields without it screwing up the actual time they...

This field is really confusing me. I have a couple questions. Please correct me if I am wrong. Access stores date and time information in a 8 digit 'floating' number with a decimal. Left side of decimal represtents days past some wierd 1880 date, and right side represents the time portion, as a...

No luck with that, sorry I just get compile errors etc. I dont think I am understanding what you mean by "Value in list box:", you refering to the row source information for the lstOut box? It seems to be pulling in the information from the qrySignOut but just pulling the wrong record. I have a...

you lost me here... so put msgbox "Value in listbox: " & Me.[lstOut].Value after you set your string The link should work now, btw haha

Thanks modest, I tried both those statements and Im getting a error on this line now Me.RecordsetClone.FindFirst strSearch Its just highlighted in yellow, doesnt tell me much heheSignin -If you want to take a closer look :)

I am defiantly new at all this. Any input on better ways etc to do this I am more than open to. This is about a learning project for me. Thanks for taking a look.

Im am having some difficulties with the correct record being called into my form. Attached is a .gif file of my set up. Basically when someone signs out they are listed in the currently out box (using various < > Null statements in a query), and when you click thier name in that box it should...

http://aas-fw.com/signin030505.mdb I have a sign in type database I have been learning on. In this database I have a currently out box that list people that are currently out. I would like to expand this even further by making people who are coming back 'today' highlight with a yellow...

Thanks for the reply DALeffler. Im confused about this line of code and Im getting a error in my script with it (User define type not defined) rs.FindFirst "EmpName = " & Me.OutList & '"' I am very novice at vb, and access for that matter. Trying to expand my knowledge, could you explain what...

I have a form that my users sign out on with thier name, dateout, timeout, datein, timein, reason... Also on this form I have a list box that runs a query to show people currently out of the office. I am trying to make the form populate the sign out information of a person when you double click...

Hello, I am new at working with access and I am trying to create a signin/signout type database that keeps track of when employee's leave and return to the workplace. I have created the DB fairly well, implimented a calandar into it to pick the dates leaveing and returning etc. My problem is now...