Recent content by TJLearn

Hi, I'm having a problem with my INSERT statement when the name on a text box is including a single quotation mark. The name is O'Kelly My insert statement is: Dim sql AS string sql = "insert into LoanAgent " sql = sql & "(LName) values " sql = sql & "('" & txt.LName & "')" Any help is...

Hi all, Is there a way to search for records with the following IDs? 1. ID starts by an Apostrophe Example: 'CDE-123 2. ID are Asterisks Example: *** 3. ID ENDS with an Ampersand Example: 12-456& I am using access project 2000 links to sql 7.0. I have a form and search for IDs from a...

Hi Everyone, I have been thinking and searching for a way to make an access application to open maximum on the screen but still very stuck. I am requested to resolve this. The problem is when I a user open an application, it opens maximum by default. However, when the user drags an edge of...

Hi, I can't figure out how to make it work. I need your help. I am using Access Project. The problem I have right now is my search combo box doesn't show all borrowers because the number of Borrowers exceeds the maximun number that can be displayed on the combo box. Is there a way to make...

Hi Ben, Your statement works! Thank you so much.

Hi Eupher and OhioSteve, Thanks a lot for your imputs that help me make it work already.

Hi Mike, I only want to run once. If Status = 1, pick up FundingDate, and if status = 2, then pick up CancelDate. Your stored procedure works, but sometime it happens that other programmers go into the tblLoans table in the backend and mess it up. They will fill out both the FundingDate and...

Hi Mike, Thank you so much for your quick help. I really appreciated and happy Hollidays to you, too!!!. Your answer works great. I just found out 1 more case that we also have cancelled loans. In the tblLoans table, I have a field called CancelDate and another field to identifies if...

Hi Everyone, Can anyone please help me with some coding for my update problem. I am in a rush and not so good about it. Thanks! I have 2 tables: tblLoans and tblStates as below: tblLoans: LoanNum FundingDate State PlannedDate 1 1/1/02 CA 2...

Hi Everyone, Can anyone please help me with some coding for my update problem. I am in a rush and not so good about it. Thanks! I have 2 tables: tblLoans and tblStates as below: tblLoans: LoanNum FundingDate State PlannedDate 1 1/1/02 CA 2...

Hi Eupher, Yes, 4/4/01 is a typo, it should be 5/4/01. Thanks for letting me know. The records now should be like: RecordID StartDate EndDate 1 1/1/01 5/4/01 2 5/5/01 8/10/01 3 8/11/01...

Hello, Can anyone help me out please. I have some records as below: RecordID StartDate EndDate 1 1/1/01 4/4/01 2 5/5/01 8/10/01 3 8/11/01 11/10/03 4 11/11/03...