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

I there anyway you can give me an example in code so that I amy be able to apply it into what I am doing? This is a small step to what I want to achieve: txtMyTextBox = "Pencil, .70" 'I want to this line to able to read from a query table. txtMyTextBox.ForeColor = ?? txtMyTextBox.FontName = ...

I could just use that code, but then I would not be able to display whats inside of the query, if I have to type it in. I thought that it would just be easier to display what is inside the query. I have to use the query since I would not be able to do much calculation in the table (Unitprice *...

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

Thank you very much. You would not believe all the kinds of stories I heard from other people on how to fix this problem. But you came through for me and very greatful.

Thank you very much. You would not believe all the kinds of stories I heard from other people on how to fix this problem. But you came through for me and very greatful.

Thank you very much. You would not believe all the kinds of stories I heard from other people on how to fix this problem. But you came through for me and very greatful.

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

Thanks very much for your advice. But I am not really dealing wiith too many forms. All I want is to just display the information of the table in the value of a textbox. Well maybe the only form would be the one that the buttons are on, and that is for the register keypad. So the use of a form...

Hi, It is me again. I am trying to make a program work like the features of a cash register. It must (1) put the dat into the "Transaction" table (2) Print that information out on screen(in this case the Textbox), have not quite figure out how to do that. And (3) in the event that there is...

I just have one problem though, and that is whenever I run the code I would get an error message:DoCmd.RunSQL "UPDATE Transactions SET UnitPrice = '" & strnumber & "', Autonumber = " & DMax("[TransactionID]", "Transactions") + 1 What do you suggest that I am doing wrong? If can get this code to...

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, It's me again. I loved the idea that you gave me in that zip file. But I wanted to go a little further. I wanted the program to read the last row in the table and display the data of the last row in the table in a textbox value just like what you showed me, but the only differnce is...

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

Thank you very much for your help;) James

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