Search results

chrischris, "LIKE" should work for that. Example.. Titles.. Star Wars Star Trek Rudolph the Red-nosed Reindeer The Start of Something Big Filter/Query using Like *Star* Star Wars Star Trek The Start of Something Big

dcx693 hit it on the head. if you put "Like [Forms]![search]![List19]" in the related field's criteria it should work.

it's an expression. create a query with the desired fields you wish it to include, then in your date field's criteria area.. throw that in there. good luck.

the attached file works. yay. now what would you like done?

LOL. :eek:

Then lagbolt is correct. If you can post the file, it might help us help you. At any rate, we will need more detail on what additional changes you want done.

Are you referring to a MsgBox you created or one of the windows popup messages?

What do you need the database to do? I would love to help out but I am not as worthy as some other posters here. I also would have trouble finishing it by Tuesday. By the way, Welcome to Access World Forums. (:

Heh. No, it's adding to four fields. I needed help to figure out how to add to ADO rst. And it won't be adding the constant #12/31/2003# I just used it to narrow down bad code. The date will change pertaining to the current record ID. ... Which may be the next question if I can't figure it out...

Cool links, especially that first one. (the third didn't work for me.. *shrug*) in my march toward understanding ADO.. is there more than one way to edit a recordset in ADO? i am getting an error when i try to put examples of code i've seen on other posts..Fields("MyField") = "NewValue"...

ADO cursors i didn't know off-hand what the difference between these two statements were so i looked into it. if anyone else reviews this thread and is wondering the same thing, i found a suitable answer at the following link. http://www.adopenstatic.com/faq/jetcursortypes.asp

in the Format section of the text box, change the format to d mmm yyyy

dcx693 saves the day WOW! GREAT examples of the basic structures between DAO and ADO. i should be back on track tonight! i think i was mostly stuck on "Connection" in ADO. my prior experience makes me think of sockets or other kind of connections to non-related external sources. it's nice to...

Confused about the differences.. I'm trying to get a grip on ADO but I think I should have made sure I had a grasp of DAO first. :confused: Now even the simplest Sub Procedure isn't working in my database but it was working last week! All due to me trying to switch the code around to use ADO...

have you tried any of these? Forms.YourFormName.Refresh (VBA code) Me.Refresh (VBA code) Requery (Access Function) if the above does not help out.. what kind of data are you trying to synchronize? can you describe it a little further?

OLE object's once you have a table setup like the following example, any form browsing these fields will show it's appropriate picture. tblItems (table) Item (Text) Picture (OLE Object) checkout Northwind sample database's Categories form for an example. is that what you were thinking?

thank you both for your replies. also thanks for some of you readers doing the poll. :p that link is immense. 199 pages i believe i saw somewhere. be a tough read for me but probably my best source as of yet. thanks!

Left, Right, repeat? :-P well... since i am new to VBA-land, i do not know of any VBA methods or functions that do this. however, you could throw the two strings into a long do-while loop comparing each character to the other character. if you process it via a Right() and then process it via a...

hello.. just curious, why can't it be the record number? that's how one of my databases make a tracking/reference number. and the autonumber data type won't help?

being new to VBA, i recently had some questions about DAO & ADO differences. these thoughts are found in post #4 of the following thread: http://www.access-programmers.co.uk/forums/showthread.php?t=63117 (this thread was to start a poll since i didn't see how to add a poll to the above thread...