Search results

Sorry forgot to say that. Form is bound to TblViolation Data and text box has it's control source set to ARNumber, Missed my control source. Works Beautifully now. Thanks

I have a DB with TblInspector and TblViolation Data. Here is what I am having trouble with. On my form I have a combo box named Inspector and a text box named ARNumber. What I would like to have happen is anytime that I select John Doe from combo box Inspector it pulls his ARNumber from...

JHB, Thanks for the response, I am going to attach an image to this post and please let me know if I'm getting close. I didn't even think of making a query do the work.

:mad:I have a form in which I would like to save some information into a table. This is the first time that I've dealt with multiple tables. I can get half of the form correct and everything is good there. I just can't get the other half of my form, which is looking to store information in a...

Plog, Thank you for all your help. I've done some readon and have setup the junction table. Now I just have to work out the control source problem I am having. Thank you once again for all your help.

Plog, Thank you for that, I had no Idea it would get that in depth, ofcourse this might be beginner stuff as well, as for me this is the first i've heard of a junction table. I've read the link you attached, I did see the name Cross-Tab in there. I do know that there is a query called that...

Plog and Access, Thank you for all the insight. As you can probably tell, I'm very new to multiple tables. I will definately see what I can do to make my DB more "friendly". As for the 1 to 1 relationship, I totally agree with you, however I can't seem to setup the relationship 1 to many. Also...

Here is a picture of my relationship table setup. Hopefully you can make use of it. I'm not able to visit that site, the company I work for has that one blocked. Any other sites you can think of that might help me out? Many thanks.

Hi everyone, I've been having this problem and I think it has something to do with my relationships between my tables. I will attach my DB so you can see what I mean. Open up the Tracking form to see what I mean. On my main form it gives me errors in my text boxes, I have, atleast to the best...

I will attach my DB that I am currently working on, however please keep in mind that I have only been working on this for about the last day. As for having the same information input in exactly the same time and time again is a little crucial for what we are wanting the DB to do. It is going...

Pat, Agreed, I probably wasn't being all that clear earlier. Ultimately what I would like to do is to have the user hit a button which would take them to another form. On that form, I think I'm needing check boxes here, but I could be mistaken. There are going to be multiple fields that I...

Sorry meant to put putting instead of pulling Here is my situation, I have a form that I want to bring up and then in that form have multiple multiple check box's that I can check and then based upon what I check I would like to be able to store that info in a separate table. My problem is...

I just want to shrink the data within the column that I have is all. Trying to get to some sort of input mask after that, first step, atleast what I think is to do away with all the extra info in the column.

Thank you so much. I didn't even think of trying to phrase it that way. Works Beautifully, little on the sluggish side. But I'll take it. Thanks once again.

I'm halfway there with this, In my macro where the "Where Condition" I would like to string together 3 things that are not equal to the text and then spit out everything else on my report. EX. [Location] not equal to "home", not equal to [work] etc. I know the not equal is <> how do I...

Wayne, Where would you suggest I put the code at? I put it onload on the main form, however it came back syntax error and highlighted Select Mid etc. etc. Sounds like it might be a little easier to manually correct the column. Thanks once again.

Here is what I have put in =DCount( ,[violation data],[criteria]) tried both "*" and as you see it, also have removed criteria from the end. Here is how it happens step by step. Input my range of dates upon hitting switchboard button, then asks me for parameter value on both "*" as well as...

Sorry about the confusion, really early in the morning for me when I posted it. Yes I have 1 table with multiple columns, the one column that I would like to "shrink" down is our inspector field, essentially the data listed below. Smith John SSN 123-45-5678 Doe, John Social Security Number...

Having a little bit getting it up and running. When I try to execute the report it asks me for Violation Data as well as criteria. I've tried deleting criteria, still no luck. Here is what I have done. On my report I've made a text box and the control source of the text box is as follows...

Here is what I have. I have one record that has around 1,600 entries in the database. The entries look like this: Smith John SSN 123-45-5678 Doe, John Social Security Number 123-44-5567 etc. etc. etc. I would liketo go to this: Smith, John Doe, John Ignoring all the other information...