Search results

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.

I don't think I explained it right. I'm sorry for the confusion. I have a form and on this form I have three unbound text boxes. I used the control sources to equal specific date boxes on another form so that I can calculate data within a date specific time frame using bound text boxes on this...

I don't have the cascades turned on. It's more about keeping the original value of the text boxes in question than about the relationships, I just wasn't sure what info to provide. I'm researching the OriginalValue or OldValue, and cancelupdate methods, hoping something like that will help...

Hello All! Thanks again for all your help over the years. I have another issue that I hope you can help with. I have a form that is linked as the many in a one-to-many relationship. On this form, I've used text boxes to link back to a subform of the main form in the relationship. So far...

Yeah, I figured it out and edited my post just before you replied. It was the typo. I think the space is just the result of copying and pasting to the thread because it's not really there. Thanks again and please have a laugh at my expense. I appreciate that you guys took the time to try...

Do you know why it works for the one but not the other? EDITED - Duh, I feel so stupid. I looked and looked and looked at the codes over and over and still missed the typo. When I changed "28" to "26," I left an 8 in there. Now that it's out, it's working. Gees. Thanks for your help tho...