Search results for query: *

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

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

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

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

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

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

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

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