Search results

Ok I got kinda an idea how to go thru this. I'm sure I'm going to get many things wrong. I would first ; Dim rs As ADODB.Recordset, Then open the record set I want to change the amount to with; rs.Open "Table Name" Other options ( I have no idea how to filter with only certain records...

Shoot.. I hate to be a pain in the butt... It is giving the same discount to all the items... What's the best way to give a different discount to every item on the list? I'm sorry if I'm being too much trouble.

Ok this is weird. Out of no where it works! Modest, Thank you so much for your help. I'm just barely getting all this VB code but it is getting easier for me. I'm sureI will have more questions about doing other things but for now this works perfect.

Well, It's giving me an "There is an invalid use of the . (dot) or ! operator or invalid parentheses" I changed it to me.TXTclaimnumber and get the same error

Modest thank for your reply. Here is what I ended up with. Private Sub Toggle89_Click() On Error GoTo Toggle89_Click_Err Dim vbrResult As VbMsgBoxResult Dim RandomValue Dim Discount Dim strSQL As String vbrResult = MsgBox("Run Auto Quote? This cannot be undone!", vbQuestion...

Ok, I got it to work. Except it will only run correctly if I click on an item and then if I click on a different item it will give it the same discount. I was hoping to click on a button on the form and it would go thru all the items on the form and give it a random discount. Here is the code...

Whoa.. You guys are fast. I'll try that out too and see how it goes. You guys are really something. I feel kinda bad asking all these questions without really having anything to give back.

Hello all, I have a quesiton about using random numbers. I have a table for items in a database each with a price. I need to go thru and discount the price 10% to 15% randomly on each and put the new amount into a different field. I havn't the slightest idea how to do this. The closest I've...

Thanks for the reponse. I think I got a solution to my problem. I'll give it a try and post it here. I've been importing all of the excel data myself using import but I need to program a button to do that so the non computer users here can do it by pushing a button. Thank you guys all for your help.

I found code on the net for importing Excel to Access. The problem is it is code for the excel spreadsheet. I need it to be executed in access. So the following code in the spreadsheet of: Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _...

Wow, That was an amazing solution. Thank you so much for your help. I'm going to give it a try on a backup of the data base over the weekend. When I get some time. Thank you again. This forum is a life saver for me.

Thanks for the reply. I do not have it in the database anywhere. It is something I want to add. Thanks again.

Hi, I'll post the code I used to make a report move over to excel.. Private Sub Toggle110_Click() ' Declare All my Objects Dim rs As Recordset Dim rs1 As Recordset Dim intMaxCol As Integer Dim intMaxRow As Integer Dim qdfItem As QueryDef Dim qdfTitle As...

Hi Robert, Thanks for the reply. I thought about doing this. The only thing is I was hoping for a way to start at 1 for every new order. So If I was to add an autonumber field I to my order detail table it would start at 1 and keeping going. So say my second order I ever did the first item on it...

Hello, I use a database at work that I made. Unfortunatly, I did not add a field for numbering the items that a customer orders. When entering an order It is important to my customers to keep it in a certain order. how do I change it so it adds a numbering to all the past orders as well? I've...

Thanks, Here is the code I have in the events tab. Private Sub Combo36_AfterUpdate() Me.RecordsetClone.FindFirst "[lngInsID] = " & Me![Combo36] Me.Bookmark = Me.RecordsetClone.Bookmark End Sub Private Sub Combo36_GotFocus() Me!Combo34 = "" Me!Combo99 = "" Me!Combo108 = ""...

Ok, I have the same problem. I have two combo boxes one to do a search by ID and one by name. If I had two Recordsets with the same name on both only the first one will show up if I click the second one. My bound column is the ID in the search by name combo box.

Hello, I love this forum. Has helped me learn much. I have a button that populates an excel spreadsheet from data in two queries. It's working out great. However, Everyother time I try to use it I get a Method Cells of Object '_Global' Failed... I hit debug or end and then when I try the button...

I'm using Excel 2003 Yea, Still can't get it to work. Using Excel 2003 and access 2003.

Should I try a SQL Query in the code itself? Or just make a new one? Thank you for your help peter. Paul