Recent content by radink

Hey all, Im a little stuck here. I have a form Im using to run a query. The form has multiple text fields and check boxes. Everything works fine If I just select (any)one of the check boxes. If I check more than one, I get no results. (which is because no records have them both selected). So...

That worked! Awesome Thanks!! Now just to figure out the rest.

Hey all, Thanks for all of the help you have already given me. Here's another. What I'm trying to do it get a field, which is a combo box, to pop up a warning when someone tries to change it. I'm trying to keep people from unknowingly change the name field of the time sheet. I only want the...

Ansentry, I did. From all of the examples I had, none of them stated the need to change the amount of columns in the initial combobox. I though that column(3) was the column in the actual table, and not in the combobox. Thanks for your help!

I didn't have a separate table for the subform. I had all the data in one table. Once I fixed this, the problem went away.

Thanks for replying. I fixed it already. I had it all setup wrong. Thanks :)

Well, I've got my DB ready to go. Now what? I need to host it on our Win2003 server. How do clients use it? I think im getting more confused as I try to figure this out. We are a small company and I just want to be able to have everyone here use the database at the same time without too much...

Ansentry, They are 2 different problems if you read the full thread. One was about populating boxes from another and the other problem was blank lines being created.

Can anyone help me with this?

Sure thing! Here is the image: The top part is what it should look like. The bottom part is how it looks after a create a new record, and then go back to this one. You see that empty row gets inserted. This is really frustrating me. Any help would be greatly appreciated!

I have a subform with lines for each task. Ill fill it out and then hit the new record button (in the main form). When I click to go back to the previous record, a new line has been created at the top of the subform. Is this a known problem? I made the subform pretty straight forward, so I'm...

I think I narrowed it down to it being the Column(2) part, but in the table it is the column right next to the project name column. I've even tried going up to 12 and I get nothing. I'm stumped.

Thanks Ian! I'm trying to do this again with a 2nd box. SELECT ProjectList.ProjectNum, ProjectList.ProjectName, ProjectList.ProjectClient FROM ProjectList; Private Sub ProjectNumber_AfterUpdate() Me.ProjectName = Me.ProjectNumber.Column(1) Me.ProjectClient =...

I think I got it, thanks! Here's another problem. When I created a new record and fill out a row in the subform it's fine. However, if I switch to another record, and then back, a new row has been created at the top of the subform. Any ideas what's causing this? Thanks!!

Ah. That's what confused me. He said unbound, so I assumed you had to leave it unbound. Thanks!