Search results

Hi guys I was wodering if somebody can give me a link to a post where its used the object in access ( with property let/property get stuff) and some link where multmedia is used. I need both for a project for my final exam and I didn't find by searching. Actualy, what it would be good is a...

If the two tables are linked, you should build a query based on those two tables. After this, you can bild the form with the wizard, based on this query.

funny I did what u said, it worked And it created the .mde But I still have access to the code and tables like in the mdb ain't that funny Thanks

I already compiled the code and eliminate the old one

Hi guys I am using Access XP and I am trying to make a MDE of a db, but when I try the part for MDE in tools is grey, so unusable. I convert the database to 2000 format, the MDE option is not gray anymore, it even (looks like) work, but when I open the result is a .mdb not an .mde. So not...

A man boards an airplane and takes his seat. As he settles in, he glances up and sees a most beautiful woman boarding the plane. He soon realizes she is heading straight towards his seat. A wave of nervous anticipation washes over him. Lo and behold, she takes the seat right beside his...

That's becauz they are za best (Frenchy pronunciation :D ) But, in order to take advantages of your sunday activity(if it's sunday too where you are), which would be the opposite of opening a form? Docmd.close?

Mile, isn't it Docmd.maximize ? You wrote it with an s

it worked with the iif, it didn't with the code. Better though Thanks

Hi there Once, Mile gave a very useful function, Timeconversion, that I paste in this message. I have a question about it: is it possible to prevent somehow that if I pass a null value as argument the function returns a null value, not an error? Here is the function: Public Function...

SELECT tblAgent.codeagent, tblAgent.nomag, tblDebitcredit.cumuldebit, tblDebitcredit.cumulcredit, tblAgent.heurecontrat FROM (tblAgent INNER JOIN tblDatesAgent ON tblAgent.codeagent = tblDatesAgent.codeagent) LEFT JOIN tblDebitcredit ON tblAgent.codeagent = tblDebitcredit.codeagent WHERE...

hello People Nice new house here huh question: I have a query that show data from two tables and uses a third table for a condition. It's a left join so that shows the results even though in the second table I don't have records. Now, when after 'WHERE' I add a condition like: and X NOT...

If I understood well your problem , try -- WHERE yourfield IS NOT NULL --as condition in the query, if you search the fields that have a value. If the fields are 0 by default, like you set that up in the table, your version should work too(if the fiels is number)

I have Office xp and I tried but it didn't work - it might be wrong what I've tried

You cannot use vba to change individual record colours on a continuous form ... said Rich Frustrating Thanks a lot

right away Rich

Actualy the form looks like this one that I send you now :-) Thanks for help

I forgot to tell you: it just colors everything in red or whatever colour I tell ...

thank you guys Dim lngRed As Long, lngYellow As Long, lngWhite As Long lngRed = RGB(255, 0, 0) lngBlack = RGB(0, 0, 0) lngYellow = RGB(255, 255, 0) lngWhite = RGB(255, 255, 255) If Weekday(me.dateplan) = 1 Then 'or vbmonday or something Me.dateplan.BackColor = lngYellow End If ain't work. I...