Search results

  1. E

    SQL/VBA Code

    Thanks a lot RX. I will give it another shot and i'll let you know. You were very helpful.
  2. E

    SQL/VBA Code

    Sorry i'm spamming this page, but i should also add that everything works before the structure search and after the structure search (for the most part). the only thing that is messing up the result is the structure search...
  3. E

    SQL/VBA Code

    a strucute in my example DB (where the code worked perfectly!) looks like this: ECX29-U2-N3-D7 A structure from the real data (where it does not work) looks like this: GSX1-A2-B9-C56-D2-E1-F1-J1-9A1-9C1-9D1-9E18 They look exactly the same! except maybe one is longer than the other. but...
  4. E

    SQL/VBA Code

    Also the main problem that's making me go insane is that in the example DB, when i searched for structure using this line of code: For Each varCode In x varCode = Replace(varCode, "-", "*") u = varCode MsgBox varCode Set dbs = CurrentDb()...
  5. E

    SQL/VBA Code

    At this point i'm thinking if it's even possible to find the structure values in linked tables...i would assume it's possible but by the way i've been testing this, nothing seems to work. do you have any ideas? I will take a look at the code you sent me right now and see if it can be helpful...
  6. E

    SQL/VBA Code

    yea. I know. that's because I was working on an example DB...right now i'm working on the company's real data (which wouldn't have been possible to send over). Thing is my code found the structure values in the example data but when I put the same exact code in the real DB it's not finding...
  7. E

    Hi, if you have any time, can you please help me with this...

    Hi, if you have any time, can you please help me with this: http://www.access-programmers.co.uk/...99#post1268599 I have to present my DB tomorrow and I am super stuck. I don't know what I am doing wrong...Thank you
  8. E

    SQL and VBA Insert Null for Unfound Date

    Hey RX...I actually had to start over bc there were way to many problems http://www.access-programmers.co.uk/forums/showthread.php?p=1268599#post1268599 I really hope you can help. I'm really stuck...
  9. E

    SQL/VBA Code

    I really need you guys' help on this...I have no idea what the problem is with my code. I have 3 tables, 2 of them are related the other one is not because there's modification involved and bla bla. just ignore table 1. But what is supposed to happen is that user inputs a part number, that part...
  10. E

    Returning values into a query or a table

    Oh. Please ignore the comments. Some of them are incorrect due to how often I kept changing my code...
  11. E

    Returning values into a query or a table

    Option Compare Database Option Explicit Sub SearchPartNumber_Entered() Dim txtPartNumber As Variant Dim Arr() As String 'declaration of variable Dim i As Integer 'declaration of variable Dim x As Variant 'declaration of variable Dim rst As Recordset 'declaration of variable Dim u As Variant Dim...
  12. E

    Returning values into a query or a table

    yupp I do. It compiles just fine over on my DB but it keeps saying no associated values exist in the table when I know there are at least 20...
  13. E

    Returning values into a query or a table

    No really. It's not causing a problem. Let's ignore table 1. I am now looking for a value in the query and I want the query to return all of the columns for that value as well as calculate the rows for 2 of the columns in that query. Does that make more sense? Thank you for your responses.
  14. E

    Returning values into a query or a table

    There is no table problem for me to fix.
  15. E

    Returning values into a query or a table

    My code looks like this so far: txtPartNumber = InputBox("Enter Part Number:") If Not IsNull(txtPartNumber) Then If DCount("ChildProductNbr", "dbo_ProductStructure", "[ChildProductNbr] Like '*" & txtPartNumber & "*'") > 0 Then MsgBox "Part Number Found!" Set rst =...
  16. E

    Returning values into a query or a table

    Hi, I'm not sure if this is possible but what I am trying to do with pretty much create a search query through code. So what's happening exactly is that the user enters a part number and expects to get 2 values: total orders and total items associated with the part number he/she entered. I have...
  17. E

    SQL and VBA Insert Null for Unfound Date

    Thank a lot RX. That's not really what I'm stuck on right now though...the dates are pretty much set in stone. The form I'll worry about at the very end (if I need to worry about it at all). What I am stuck on is seeing if what my code is doing is even right...and I can check that by returning...
  18. E

    SQL and VBA Insert Null for Unfound Date

    Table 1 does not relate to any of the other tables. It has to be left alone. Thus I created a relationship between table 2 and table 3 but left table 1 in code so I could look up it's values later on in the created query (b/w table 2 and 3). Everything seems to be working just fine but I need to...
  19. E

    sql in vba line of code error

    Ok. Thanks. Figured it out! :D Supposed to look like this: Set rst = CurrentDb.OpenRecordset( _ "Select * from CalculateTotal WHERE ((Structure) Like'*" & u & "*')AND (((ShipDate) BETWEEN #09/30/2001# AND #10/01/2012#)) ")
  20. E

    SQL and VBA Insert Null for Unfound Date

    Okay. Here is my DB. I had to comment a lot of the code out to start coding with a query rather than with multiple arrays.
Back
Top Bottom