Recent content by sebell

Hello all. I have a script that has settings for DB Username, DB Password, DB Name, and Table Name. I noticed that on some of my programs, they also ask for DB Host. This one does not. My website is hosted. Is there a way to add this functionality, or am I missing something in the code? I...

I actually just thought of that. I hope it works, thank you.

Hello, I am wanting to vlookup based on 2 fields, but don't know if it is possible. For example I have worksheet A that I am wanting to perform the vlookup in for Columns A & B My named range is in Worksheet B for columns A, B, & C I want to match up Columns A & B in both worksheets and grab...

Worked great. Thank you. It is a lot of code, but at least the page is going to look better. Thank you both for your help. Sherry

Didn't see your last message, unfortunatley I only know VBA for Access and Excel which is why it is above my head. Maybe I should learn it instead.

Hello, I have code on labels that when moused over one lable it opens up another subset of lables to choose from. In addition, it changes the font from blue to yellow when moused over and makes sure that every other label remains blue. The problem is that there is an abundance of flickering...

Hello, I am trying to create a trouble shooting database where if someone types in a sentence, the database can pick up on key words and bring back all criteria with that or those key words. In other words, I have a text box txtQuestion which the user types in the question. When the user...

I'm sorry, I thought I was posting this question in an Access form discussion forum. COBOl is way over my head. I'll post a this question again in the Access form discussion forum. Thanks anyhow.

I am using a Microsoft Access to create this.

Hello, I am trying to create a trouble shooting database where if someone types in a sentence, the database can pick up on key words and bring back all criteria with that or those key words. In other words, I have a text box txtQuestion which the user types in the question. When the user...

Gary, That worked great!! :) Thank you, Sherry

I have a form reading from a query. If there is no data in the query I get a run-time error 2427 - 'You entered an expression that has no value.' Is there any way to check for data before opening up the form and if there is none bring up a msgbox? Thank you in advance for your help, Sherry

When I opt to email someone from a form this was I currently have coded. Emp1 = DLookup("[Email]", "[tbl_EmployeeName]", "[EmployeeName] = [txtAssignedTo]") file = DLookup("[File]", "[tbl_EmployeeName]", "[EmployeeName] = [txtAssignedTo]") DoCmd.SendObject acReport...

When I opt to email someone from a form this was I currently have coded. Emp1 = DLookup("[Email]", "[tbl_EmployeeName]", "[EmployeeName] = [txtAssignedTo]") file = DLookup("[File]", "[tbl_EmployeeName]", "[EmployeeName] = [txtAssignedTo]") DoCmd.SendObject acReport...

Thank you both so much for your help. IT WORKS!!!! :)