Search results

Hi, is there anyone who can supply me with "Grier Summer Camp" database sample. I desperately need it to do some exercise for some class work. Thank you very much in advance :confused: . ~~~~~~~~...

Hi, I have this one problem that I am looking in a new light that may help me to solve it after all. Well I have been trying to display from table into a texbox and was not successful at doing so nor even successful getting the right answer from anyone. Now, I think it would be best if I could...

Hi, I have this interminable problem that never seem to go away. I know what I want to be done can be done since I know that I did it once before. Here is the thing, and is is quite simple, I want to be able to display in text the data in a table as the information is being placed in the...

Hi, here is the thing. I have this Access program that I am working on that is suppose to delete the selected item in the list box when every I click the delete button. When the delete button is clicked the item in the list box on top would be deleted and not the one that is already...

Hi, I have bee plague with this problem for months now and my head is about to explode. All I want is to be able to update the last line in a table list. But here is the catch, It must be done at the click of a button at anytime during the construction of the list. Here is a sample of the code...

Hi, I have a problem that does not seem to vanish. I am trying to update the last record in a table with autonumber using Max function. How should I go about doing that? this is my code that I am working with. Private Sub Return_Click() Dim strnumber As String Text34.Value =...

I have come with this code, but it can only work on 2002 version of Access. The version I have is 2000. This is the code: Dim intRecordID as Long, rst as ADODB.recordset Dim strsql as string intRecordID = me.list0 Set rst = New ADODB.Recordset With rst .activeconnection = currentproject...

Hi, Is there anyone who can help me with this problem? I am at my wits end trying to figure out how to make the query code update the last line inthe table database. This is the code that I used: Private Sub Return_Click() Dim strnumber As String Text34.Value = Val(ClipBoard_GetData) strnumber...

Hi, Is there anyone who can help me to modify this code so that it would delete a "Selecte Item" off a listbox. Private Sub Command2_Click() On Error GoTo Err_cmdDelete_Click DoCmd.RunCommand acCmdDeleteRecord Exit_cmdDelete_Click: Exit Sub Me.List0.Requery Err_cmdDelete_Click...

Hi, Is there anyone out there who can help me with this problem? I am simply trying to display data from a table into a Texbox value. Using of course a query. This is what I have come up with so far: Me.Text1 = Me.Text1 & "YourValue" & vbCrLf I tried typing in the name of the fields and...

Hi, I want to develop this code to select and move the selection in a list box one at a time. Is there anyone out there who can help me with this? This is the code that I am working one: Private Sub Command5_Click() With Me!lstClientSelect For x = 0 To .ListCount - 1 Code for...

Hi, Its me again. After looking far and wide, I came up with this code: Private Sub Command2_Click() Dim Conn As Connection Dim rst As Recordset Dim strSQL As String Set Conn = Text0.Value strSQL = "SELECT FirstName, LastName FROM Employees WHERE EmployeeID " & "' & EmployeeID & '" rst.Open...

Hi everyone, I have search far and wide for a anwer that I know is very simple, and relates to Microsoft Access. All I need is to have an Onclick event in a Access database form object button to (1) place data in a table and (2) print what has been place into the table in a...