Search results for query: *

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!!!! :)

I tried this but is bringing in the data that matches the first criteria only. Maybe you can help me further - I am probably doing something wrong. My program allows you to assign Tasks to 1 to 4 employees. The task name will be the same for each employee since it is a group project. They are...

Hello, I need to do a dlookup that brings back a value based on 2 different criteria Me.txtAssignedTo2 = DLookup("[AssignedTo]", "[tbl_ActionRegister]", "[Task] = " & [txtTask] & " AND [EmpNoforGroup] = " & [txtNo2]) But this is not working. Does anyone know how I can write this so that is...

I found the thread: thread702-255626 This should answer your questions and it doesn't stop in the middle.

Here is code I got here on Tek-tips, but unfortunatley I can't remember the keywords I typed in that brought me across this. I know you can reverse how the text is moving, but I don't remember how they wrote it. 'Put this code in the Form Timer & set to anywere between 100-250 - you can play...

from properties choose the path for the video.