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!

  • Congratulations gkittelson 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: BSG75
  • Order by date
  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.
  16. BSG75

    Case Statement error.

    I put this into my statement and did not get any errors, but when i run the program and in the column labled priority it still shows 1 and does not display Low or High I am trying to get it to change the numbers 0-4 to Low, medium, high, urgent. there is no table in the that has value...
  17. BSG75

    Case Statement error.

    I am trying to run a case statement in a select statement. i am trying to do Case Priority when priority =1 then 'low', but it is not working in keep getting incorrect syntax error messages on kewords like Case and then on the '=' sign. The select statement is as follows any help on this issue...
  18. BSG75

    Changing information in a datagrid to show text not numbers.

    SELECT Case Priority = 0 then 'Low' end HPD_HelpDesk.Submitted_By, DateAdd(s,HPD_HelpDesk.Assign_Time,'12/31/1969 18:00:00 PM') as Ticket_Assigned_Time, HPD_HelpDesk.Case_ID_, HPD_HelpDesk.SubItem, HPD_HelpDesk.Assigned_To_Individual_, HPD_HelpDesk.Priority FROM REMEDY_SUPPORT.dbo.HPD_HelpDesk "...
  19. BSG75

    Changing information in a datagrid to show text not numbers.

    No i just tried it and it tells me that it do incorrect syntax near (=).
  20. BSG75

    Changing information in a datagrid to show text not numbers.

    I was using the select statement this way: CASE dbo.HPD_HelpDesk.Priority WHEN '0' THEN 'Low' WHEN '1' THEN 'Medium' WHEN '2' THEN 'High' WHEN '3' THEN 'Urgent' WHEN '4' THEN ' ' END AS Priority, when i did this it did not recognize the (') it turned everyting into comments.

Part and Inventory Search

Back
Top