Recent content by ImLost

There could be multiple victims, but each victim would have a unique identifier - [System ID] to the database and a case number to the human user. I do have it set up that each child has a system administered identifier, though, so that could work. I'm setting up the base forms now, but won't...

I have another form opening from a button, so I've gotten that part down. DoCmd.OpenForm...I was playing with that and got stuck a bit with the OpenArgs string to get it just right, but found a method that worked. I didn't like the popup window, so it opens in a normal window. Now I'm more...

I'm sorry if this has been posted before. My internet speed is dismal today, which makes searching the forums difficult...many searches are coming back with a lovely error screen thanks to timing out. But, I digress... I have a database setup with one main table consisting of two fields - one...

You guys are awesome as always. Thank you, thank you, thank you! The Union Query worked perfectly.

Hindsight is 20/20. This was rush job, with a lot of pressure from the client to get it done as quickly as possible. I needed certain things to work certain in ways, so seperate tables seemed the best way to do it. I pretty much put it in according to the paperwork that was given to me and...

Hello Ladies and Gents - I am always appreciative of your help and hope you can help me out of this hole I've gotten myself into. I have six seperate, unrelated tables (with correlating forms) pertaining to police data, and need to create a search field on a form on which the officer can enter...

Thanks. I tipped your scales. ^_-

Thank you. In working through it, I realized what was wrong. My query order was a bit off and the bound column should have been 1 not 2. Thanks for helping with the brain storm and saving my monitor from going through my window. ^_^

Okay - hopefully I give you what you need. There are two tables - 1. Contact - has two fields - a primary key set to autonumber for the ID# (Type ID) and a text field for the contact type. 2. Outcome - has three fields - a primary key set to autonumber for the ID# (Outcome ID), a number...

Hello - I have two combo boxes on a form, with the second set to pull up different lists depending on what is entered in the first box. To set this up, in Access 2003, I used one table to set up the Agencies with an ID# and then used another table to use that unique ID to indicate specific...

Thank you guys - this solved the problem I've been having and made it so much easier.

Clicked on your scales. Thanks again for offering your assistance!

I found a workable solution by using the setvalue option in Macros. It actually works better than I had hoped, because I can set multiple values this way with the click of one button. My only problem will be if someone ever hits the button again and the original values have changed. ^_-...

The button thing didn't work. It worked like a label and didn't give me data I could work with. As far as changing the data to see if it works, I have a few set up that I can work with without worrying about messing up the originals. Short of manually re-entering the data on this form, I'm...

You got it. That's my problem and I haven't had any luck with originalvalue, oldvalue, or cancelupdate. I think I understand what you're telling me to do, but I don't know how to do the append or create sub-job thing. I'll give the button a go and see what happens.