Search results

Ok, I've replaced all the «+»'s with «&»'s. I tried to replace the «,» that are not between «"» with «;» and I get a syntax error. Do all of these need to be replaced? If I keep all the «,»'s I get results, but they're not correct. In some cases I'll get 2 names next to each other...

Hi Newman, Thanks for responding so quickly. I'm getting "Syntax Error (comma)" when I go to view the query. In my query field I have: Name: IIf(IsNull([MidInitial]) And IsNull([Salutation]),[LName]+", "+[FName],(IIf(IsNull([MidInitial]),[Salutation]+", "+[LName]+"...

Hi there, There's a lot of info in the forums on combining fields, but I could find anything to help me out with my specific problem. I have 4 fields: [FirstName], [LastName], [MidInitial], & [Salutation]. I need to combined these into 1 field for a report so it shows. ex: Doe, John, J...

I haven't been able to load MS 9.0 Object Library. Is there a trick to this? Can I download it? Thanks for your response.

How do I replace Reference "MS 10.0 Object Library" with "MS 9.0 Object Library"? I need to do this for my code to work. Any help would be appreciate. Thank you, Full Williams

I guess I should have mentioned that I'm not using a calendar control in my database. Sorry about that. The error occurs when the code is looking for a parameter off a form. It works fine on my computer which has Windows 2000 Professional, but not on a computer with XP. I think the...

Hi there, I have a problem with my database when I copy it onto another computer. In the database that's on my computer (Access 2000, Windows2000 Professional) I have some code that adds a list from one List box to another: Member's --->> Inivited Members. When I copy the database onto...

Similar Problem Hi there, I have a problem with my database when I copy it onto another computer. In the database that's on my computer (Access 2000, Windows2000 Professional) I have some code that adds a list from one box to another: Member's to Inivited Members. When I copy to another...

Hi, I'm doing the same function in 2 databases. The first database I created I used DAO. The second one I thought I would try using ADO. For some reason the database is running much slower with the ADO. Basically what I'm doing is adding Members to a Meeting. I have 2 list boxes one on...

Drevlin, Awesome! Yeah, Ctl-Tab is fine. Good advice on not using Alt-Tab. Thanks for your help, Full Williams

Drevlin , Thanks, that works great! Is there a way to use the Alt key too? For example: Private Sub Text1_KeyDown(KeyCode As Integer, Alt As Integer) 'If your in Text1 and you press -- Alt+Tab If Alt= 1 And KeyCode = 9 Then Me.Text5.SetFocus End If End Sub My form is continuous so I...

Drevlin, Thanks. That works fine except for when I try to go back up the tab order using shift-tab. Anyway to for the code to read that I've pressed shift and want to backwards in the tab order? Thanks, Full Williams

Hi, I have a form that has controls in the header and detail. Is there a way that I can combine their tab orders so they are not separate? Right now I can only tab in the Header. If I set the focus on current to the first tab in the detail I am not able to tab up to the header. Any help...

I figured it out. It was my spacing with the the " & _ at the end of each line.

Hi, Could somebody tell me what's wrong with this sql statement. I copied the sql from a query and I keep getting this error: "The Select statement includes a reserved word or an argument name that is mispelled or missing, or the Punctuation is incorrect" Here's the statement...

Not sure if this is the best way to do this, but it will probably work. Add "All Clients" to your combo box. Create a new report w/o the criteria so it shows all clients. When "All Clients" is selected have the new report run instead of the old. Hope this helps, Full Williams

Adrianna, Thanks for your help. I think you're right about the relationships. I haven't solved it yet, but it this feature wasn't asked and I'm falling a bit behind on the project so it's going to have to wait until the end if I have time. Thanks for helping me though. Take care, Full...

Thanks for the quick replys. The refresh OnChange event worked fine as far as only being able to select employees that work for the Agency selected. Now I'm having a problem with all the Employees changing depending on the Agency selected. I probably should have mentioned this earlier, but my...

Hi there, I have a subform that I'm using and on it I have a combo box (cmbAgencyID) where I select an agency. So what I want to be able to do is select an employee based on the agency chosen in another combo box (cmbEmployee). So each agency has a say 5-6 employees working for them. I've...

Howlsta, Works great. Thanks for your help and quick respone.