Search results

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!

I'm trying to make a simple DB that we can enter our time for working on projects. So far I have a Form with the employees name and the date in it. Then below that is a subform with the project number, name, client name, and hours. I want to use this whole "sheet" for one days worth of work...

In what field do you put that? I tried in default Value, but it doesn't update. Thanks!

Hey all. I'm trying to get a combo box to populate the box next to it. Basically pick a project number in the 1st box and have the project name show up in the second box. I have it working, but the problem is that when it puts in the name of the project, it fills the whole column with that...