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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BSG75

  1. BSG75

    Creating a Log in for my VB Applicaiton

    the adologin is the adodc that i created to connect to the mircosoft access database. i named it adologin.
  2. BSG75

    Creating a Log in for my VB Applicaiton

    i keep getting a compiler error expected end sub Private Sub cmdOK_Click() Function EnterOk(strUserID As String, strPassword As String) As Boolean Dim bEnterOk As Boolean 'Use a connection object to your mdb Dim App_Cnn As adoLOGIN Set App_Cnn = New adoLOGIN With App_Cnn...
  3. BSG75

    Creating a Log in for my VB Applicaiton

    Do i put this information on the button for the log in or in the load form?
  4. BSG75

    Creating a Log in for my VB Applicaiton

    I will try it out and let you know what happens.
  5. BSG75

    Creating a Log in for my VB Applicaiton

    I have a Visual Basic application that many users are using over a network. I want to creat a form that opens first before the main application form and where the users have to enter in a specified id or password. I have created at MS database that holds the users id and the information i want...
  6. BSG75

    One to Many relationship

    Here is the SQL SELECT [Screen frozen].Number, [Screen frozen].Date, IIf(([Loan Center Contacted])=-1,"Loan Center Has Already Been Surveyed "," ") AS Alert, [Screen frozen].Interviewer, [Screen frozen].[Loan Center Number], [Loan Center].[Loan Center Name], [Loan Center].State, [Loan...
  7. BSG75

    One to Many relationship

    The error message is generated from from MS, and it is a Left outer join. The error is The Microsoft Jet Database engine cannot find a record in the table Loan Center with a key matching Field Loan center number. I have tried to change the join to a right join but i then get a message that the...
  8. BSG75

    One to Many relationship

    I have a database Ms2000 and i have several users that are using the databse over a network. The form is pulling from a Query. In one table(Loan Center) i have a primary key on Loan Center Number and i joined it with another table(Frozen Screen) that has the same field. I inputed a set of loan...
  9. BSG75

    Date Range

    I have an Access database and i am creating a VB program to pull the information into a form in the VB application, i want to be able to pull information based on a date range. I want to have a start date and end date. How do i create the form in vb to pull just the information between those...
  10. BSG75

    Creating a Shortcut on the Desktop

    Thanks it took me sometime but that Inno program works great.
  11. BSG75

    Creating a Shortcut on the Desktop

    I am using the package and deployment wizard. I will check on those other applications. So is there anyway to write code in the VB application that would allow me to put the shortcut onto the desktop.
  12. BSG75

    Creating a Shortcut on the Desktop

    I have a Vb application and when i package it to and deploy it to sever users it does not load a shorcut onto the desktop, I would like to know what the code would be to load the icon onto the desktop.
  13. BSG75

    Case Statement error.

    I put in the case statement and ran it with no errors, which is great, but it did not return any the text in the Priority column, I guess i can't use the case statement.
  14. BSG75

    Case Statement error.

    Thank you so much for your help gmmastros. My only problem is that i don't think i am communicating effectively what the problem is. The database is called Remedy Support and it is a SQL Database. A table in the database is called hpd helpdesk. This database is on a server and i just pull the...
  15. BSG75

    Case Statement error.

    Thanks gmmastros i will try it that way.
See more

Part and Inventory Search

Back
Top