Search results

In your date field in the query enter into the criteria: Between #12/1/2004# And #2/2/2005# This will filter and only show stuff between 12/1/2004 to 2/2/2005. **FYI, it isn't good practice to use date for a field name. There are certain reserved words that access uses that should not be...

Thank you for your replies. I'm looking into the possibility of Jet engine mismatches and will try to get approval to split the database as recommended.

After the query is run can you do a DoCmd.Requery on the subform If that doesn't work then try DoCmd.Refresh Not sure if that's what you're looking for but that might help.

I've been having trouble finding an answer. Our office shares an Access 2000 database on an win98 machine. Most everyone in the office has been upgraded to winxp and office 2003 pro. The database is not split on the win98 machine and to my knowledge everyone just has a shortcut to the db on...

"It's raining men."

I have a program on one of my databases that was set to run weekly. For example, in order to do this I created a form and on the form's On_Load property I wrote code that checked the computer's date/time to see if it was Monday 7:00AM. If this was true then execute code; otherwise exit the...

while eating tofu

I went ahead and just wrote the code so that I just open and close the text file a ton of times when I loop throuhg the code. I'm sure it's not very efficient but it takes no more than several seconds to run. Of course I'd like to write it better, but for all pratical purposes it does work...

I'm really retarded I guess. I understand how to manuvere within an access table via the commands: .movefirst .movelast .movenext .moveprevious etc What I don't know how to do is manuever through a text file very well. All I know to do is the "Line Input #1, String" command which moves you...

I'm not familiar with what you're talking about. Never used ADO....just DAO.

I've been trying to search for an answer but haven't had any luck. What I'm trying to to is loop through a text file but not sure what the correct syntax is to do so. I've worked down through a text file like such: open "c:\textfile.txt" for input as #1 do until EOF (1) Line Input #1, a...

most poisonous animals

lacy underwear while

duke of earl

Shoot! I thought #4 was square root of Pi. :p

This is especially for Jon98548, KenHigg, CavScout and the rest of our fine upstanding Southerns on the board. :D Engineering EXAM Many folks up north think that folks from the south are not so bright. We would like any of the so-called smart-aleck Yankees to take this exam administered by...

Actually, I was being a smart-ass with the whole "VOTE BUSH" thing under my name. I was curious how long it would take before someone would say something about that? :D I don't plan to vote for Bush but I can't say I'm all that excited about the alternative either. :(

Well, I suppose it's not exactly the kinda thing a girl would pickup on in finishing school, but I've known quite a few girls over the years who aren't afraid to drop a load and then give a play by play account of the size, shape, smell etc of the whole experience. Call me crazy but I think...

I'm a little confused by what your saying, but if you link the front end to the tables in the back end then anything you do to the linked tables in the front end will essentially do the same to the back end. One way to look at it is that the front end linked tables is a "shortcut" to the...

Vehicle Identification Number