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 Chriss Miller 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: n1a2v3i3n
  • Content: Threads
  • Order by date
  1. n1a2v3i3n

    Data report

    Hi, I would like to close the database connection when i close the data report. I am using the following to call the data report to show the report. Private Sub Command5_Click() Dim st As String Dim good As String Dim a As Date, b As Date good = Chr(35) a = sdt1 b = edt2 str =...
  2. n1a2v3i3n

    Data Report

    I want to generate data report through a Query. I have used the following code Private Sub Command7_Click() Dim Adodc1 As New ADODB.Recordset Dim str As String Dim st As String Dim good As String Dim a, b As Date good = Chr(35) st = "EC11" a = Format(Date + 15, "dd/mm/yyyy") b = Format(Date +...
  3. n1a2v3i3n

    Display image in a image box from database

    I am trying to load image in a imagebox in the click event of a combobox I have used the below code: Private Sub cbvno_Click() Dim Adodc3 As New ADODB.Recordset Dim str3 As String Dim adoconn As New ADODB.Connection Dim rsImage As dao.Recordset Const conChunkSize = 8192 str3 =...
  4. n1a2v3i3n

    Password Protecting and limited access to a user

    Hi, I am trying to develop a application where i need to give limited user to some of the user and administrator with full access. I am using access as database. Could anyone tell me like how do i keep the user active through out the session until he logs out. OR Is there any other way that...
  5. n1a2v3i3n

    Date insertation using text box

    I have tried inserting date using Combobox (which was posted previously) Now i would like to use text box to insert date and then retrive baxk from the access database. I tried as follows: Dim Adodc1 As New ADODB.Recordset Dim str As String Dim da As Date Dim ans As String Dim d As String...
  6. n1a2v3i3n

    Date insertation Problem

    Hi, I am trying to input date to database using combobox. as follows dim d as date dim da as date da = c1 & "/" & c2 & "/" & c3 d = Format(CDate(da), "dd/mm/yy") With Adodc1 .AddNew MsgBox " Date " & d !daterem = Format(CDate(da), "dd/mm/yy") MsgBox "Date...
  7. n1a2v3i3n

    How to move record to previous HELP

    I want to display records from the database. I am trying to move from last to first. I have written the code as below: Private Sub cmdPrevious_Click() rs.MovePrevious If rs.BOF = True Then MsgBox "This is the First record.", vbExclamation, "Note it..." rs.MoveFirst...
  8. n1a2v3i3n

    Runtime error 91 Object vairable or with block variable not set

    I am writing a code to input image to a access datebase where in the path of the image is stored in the database. Below code gives me a runtime error 91 Object variable or with block variable not set. Private Sub cmdAddImage_Click() Dim objDB As Database Dim rsImage As New...

Part and Inventory Search

Back
Top