Search results for query: *

Oh yeah this has been a real good lesson. I am fairly new to access as you had guessed. I had some training in it and was half decent at one time but haven't used it in eons and there is definitely some rust... :) I was able to use the bound/unbound idea on one of my simpler forms and it worked...

Wow you guys have been a ton of help. Thanks again for all of this info. Larry I just emailed you so you can send me that sample db, I would love to get it. I have a ton of controls on this form.. is there any code that will lock them all in one go?

If one were to unbind the controls on the form what would the SQL look like to add a record to the table. I just forget how that SQL looks. Thanks again for all of your help. :)

Well that sucks... :) thanks for the info though.

I'm trying to force users to hit save in order to save a record but if they scroll or even close the form altogether any info they had typed in is saved. Any ideas why this is happening? Thanks in advance for your help.

I'll post the situation anyway in case someone else can push me over the top. I have 3 combos and 3 lists on one form. The user would selct a Division(cboDivision) and a Team(cboTeam) which would populate a listbox(lstTechName) from a Table(tblTechName). They would then select a month(cboMonth)...

Just finished work for the day but I will post when I get home. If you're not around then Jim I'll thank you now for your help and if you get a chance you can get back to me later. You da man. :)

I may be confusing you but I think you want me to put this into the query builder of the third listbox? This is the box that I want to populate with the techs who are in the first box but not in the second. I did try it in the third box but it didn't produce any results but it also didn't give...

I can't seem to get that code to work. I don't know if I'm putting in the values correctly or not but I think I'm close. What I'm trying now is to run an SQL statement on an event. It looks something like this : SQL = "Select Distinct(TechName) From tblTech where Team = '" & strTeam &...

Thanks for replying ancb but I'm afraid that didn't work either. I have no idea why this won't work. Like I said earlier it worked at one point and I really haven't changed any on teh on form load info.. Gotta love access... lol

You have been a great help today Jim. This would probably work but the info contained in both of the first two listboxes doesn't populate until the user selects something on the form. When I try to set the row source of the third list box to what you gave me it gives me an error on form load...

I have three list boxes. One contains all the names in a table. The second contains all the names that have an entry in another table. I want the third listbox to display the names that are left over. So essentially I want to subtract the second list box from the first and put those names into...

The cmdsave.enabled = true is just there b/c it is false on form load and they have to be able to save a record if they edit it. I am using access 2000. Thanks again.

Thanks for getting back to me. The edit button shouldn't even be a factor here as it won't come into play until it is pressed but here is the code. Private Sub cmdEdit_Click() Me.AllowEdits = True cmdSave.Enabled = True DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70...

When I open a form I want the user to have to hit an edit button in order to be able to edit the info displayed. In the form load I've put me.allowedits = false and in the properties of the form I've set allow edits to no. It did work right at one time but when I open the form now I can change...

That was it... God I feel like an idiot... lol

Thanks so much for all your help guys. I was able to determine the problem. I was assigning what was returned to mytextbox.text. When I tried assigning it to mytextbox.value it worked fine. Thanks again for the help.

This is no doubt an easy one. I'm trying to set a list box's row source to what I'm returning from an SQL statement. The where criteria is a check box. What I'm wondering is what do I put into the SQL statement to see if that field has a check. What I have is this strSQL = "Select...

Yes that would be it exactly. Could you maybe add some detail as to how I could achieve that? I'm sorry if this is something easy to do... I haven't used access in a while and am very rusty. Thanks again Robert you are a great help.

Thanks for responding Robert. That's basically how it is set up. All the fields are bound. The thing is this form has a ton or records in it and I want to be able to return a specific record for a specific individual for a specific month. I figured I could run the SQL to save time scrolling...