Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TJLearn
  • Content: Threads
  • Order by date
  1. TJLearn

    Saving Names with Single Quotation Mark Problem

    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...
  2. TJLearn

    Searching For Apostrophe, Asterisk, Ampersand

    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...
  3. TJLearn

    Always Maximize An application When It First Open

    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...
  4. TJLearn

    Limitation On Combo Box

    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...
  5. TJLearn

    Updating Date Between A Date Range

    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...
  6. TJLearn

    Updating Dates Within A Date Range

    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...
  7. TJLearn

    Make Sure All Date Ranges Are Consecutive

    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...

Part and Inventory Search

Back
Top