Search results

Where would I put that? What does it do?

Hi, How do I delete values in an array? I want to reuse that array but first I need to delete its values so I would start with Arr(0) rather than where I stopped off with the last loop at Arr(10) [assuming the last calculation inserted until Arr(9)] Here is my code: Set rst =...

It's working exactly the way I want it to work except it is taking a very long time to complete the process and return the values that I want. I was wondering if there's a way to reduce the amount of time? My first thought was that it's only taking that long because the tables are extremely long...

Thank you guys a lof for your advice and responses...I'm afraid I don't know how to do the ADO recordset. Any help would be much appreciated. Thanks again.

Figured it out! Here's a great source for anyone that ever gets stuck on this like I did! :) Hope it helps! http://stackoverflow.com/questions/4101739/sql-server-select-into-existing-table And here is my code (after the correction): Option Compare Database Option Explicit Sub...

Hi, I'm trying to put values into a temporary table for the user to view the work behind a returned calculated value. Here is my code: Sub SearchPartNumber_Entered() Dim txtPartNumber As Variant Dim rst As Recordset Dim rstt As Recordset Dim u As Variant Dim i As Integer Dim n As...

Some rows have duplicates. some don't. I want to return both but without the duplicates for Example: 11,2,5 11,4,7 12,3,9 12,6,8 12,3,9 Should return: 4 not 5 nor 3. Would the code below accomplish this? select RO.OrderNumber, RO.Item, RO.RepID from dbo_RepOrderItem RO groupby...

Also, how can I view the updated table? The one that is updated after the duplicates are deleted? Would that table be RepOrderItem? Is there a way to make it visible to the user after the code has gone through and the total calculation has been shown?

aren't both codes doing the same thing? returning unique, non-duplicate rows? Count is counting the number of rows that are unique? What's the last line of code doing? havingcount(RO.OrderNumber)=1 Thanks a lot David :)

The code is really long at this point and the only reason for that is because of my attempt at finding duplicates (OrderNumber + Item + RepID rows)...

I've been working on this since my previous posts, and this is what I have so far: Option Compare Database Option Explicit Sub SearchPartNumber_Entered() Dim txtPartNumber As Variant Dim rst As Recordset Dim rstt As Recordset Dim u As Variant Dim i As Integer Dim n As Integer Dim Arr() As...

Thank you so much for the reply CJ!! I will eventually need to count all of the RepID values in that column...and for the duplicate aspect. I should only delete a row if it has the same exact OrderNumber + Item + RepID as another row above it I've checked with some of my code and there are...

Is anyone able to help me with this? I would really appreciate it. Thanks.

Thank you :) I got it figured out. Congrats to your son on his internship!!

Hi, I have 2 tables and 1 query. Table dbo_RepOrderItem includes columns: RepId OrderNumber Item ShipDate SerialCardID Table tbl_LBP Sales Location Num includes columns: Location ID Rep Region Code What I've been doing so far through my code is working through a query...

when i get that error, it high lights: db.Execute strSqll, dbFailOnError

Okay. I took a look at the link you provided and I've edited what I've had to this: Dim strSqll As String Dim db As DAO.Database strSqll = ("INSERT INTO ResultsTable (Structure1, OrderNumber1, ItemNumber1) SELECT (Structure, OrderNumber, Item) FROM CalculateTotal WHERE...

Hi RX! Thank you for the reply! CalculateTotal is a query with 6 columns. I am only interested in 3 of them: OrderNumber, Structure, and Item. I want to transfer the results of these columns into table ResultsTable...not quite sure how to do that... I tried : Set rst =...

Hi, I would appreciate any help I can get on this...I keep getting this error: Run-time error '424': Object Required And it keeps highlighting this part of my code: Set rst = ("INSERT INTO ResultsTable(Structure1, OrderNumber1, ItemNumber1) SELECT (Structure, OrderNumber, Item) FROM...

Hi, I'm trying to put the results of my search into a table named ResultsTable and I'm getting the search results from a table named CalculateTotal. Below is my code: Set rst = CurrentDb.OpenRecordset(" INSERT INTO ResultsTable " _ & "SELECT * " _...