Recent content by jread

That did it! It's so strange that this was never a problem until Project 2007 was installed. Thank you both for your help :)

Size Mode on the Control = Clip Size of Image = 504 X 108 (pixels) Size in Control = 5.25" W x 1.125" H

I have an Access 2003 application that runs on various machines in my workgroup. The form has a "banner" image on the top that is linked remotely from a folder on the network. There is VBA code that changes the path of the banner image based on the current date. This has run perfectly fine...

Thank you :)

Hello, I am using Access 2003 and am trying to write a query to create a temporary table of records based on dates entered by the user. The records should be random and the selection should only return 30% of them. I think I have the basic logic outlined below, but I cannot figure out the...

Ooh, nice! Thanks :)

Thank you very much for your response. I tried the suggested format and ended up with my old friend, the "You canceled the previous operation." error message. Private Sub txtProjectNumber_AfterUpdate() Me.txtIDMT = DLookup("IDMT", "tblMaintTrack", "ProjectNumber=" & Me.txtProjectNumber)...

For the life of me, I cannot get this function to work. It either gives me "Invalid use of Null" or "You canceled this operation... blah blah" every time. I am just going to lay out what I'm trying to do and hopefully somebody can point me in the right direction. BTW, I am using Access 2003...

Yes, I completely agree with you that this is not the right thing to do. The problem is that I am redesigning a legacy Access application that was horribly designed and I'm kind of limited as to what I can do without risking the loss of information. The original was built this way and its...

One more question about this: Will "DoCmd.RunSQL Insert Into" automatically create a new record in the table it is writing to? If so, how would I then write a value (incremented key field) back to the table the form is bound to? This whole thing is complicated as hell. Basically, we have...

Excellent! Thank you very much for the help. So basically it is a programmatic update query?

This is more of a general question (before I start trying to figure out how to do this in VBA) but do you have to actually "open" a table to add a new record or search the records it contains? For instance, if I have a form that is bound to one table and I want to create new records in *other*...