Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MJD1
  • Order by date
  1. MJD1

    How to search entire DB for 16 digit string

    hi, does anyone know how to search en entire db for 16 digit number strings? need an audit system to ensure that credit cards aren't being recorded in a db. thanks
  2. MJD1

    vba OnChange using if me.text0 ...onchange...then

    hi, trying to use the Onchange in a vba statement but haven't been able to figure it out. I also search but couldn't find the solution. essentially, here's what i'd like to achieve: if me.text0.onchange = true then do this.. else do that end if thanks Martin
  3. MJD1

    Query using sql with several WHERE conditions

    ok, problem fixed by doing this "And from_dc_number IN " & "(" & Me.Text6 & " )" thanks for your help and guidance!! martin
  4. MJD1

    Query using sql with several WHERE conditions

    Thanks, I removed the = sign but still getting the error message. the me.text6 contains the string of numbers seperated by a comma, which is in a table, with the field formatted as text. (524, 1003, 1004, 1006, 1007, 1014, 1051, 1052, 1053, 1071, 1072, 1073, 1074, 1075, 1106, 1107, 1180, 1181...
  5. MJD1

    Query using sql with several WHERE conditions

    hi, thanks so much. following your recommendation, I modified the code with the below, but i'm getting a syntax error. I created a dc_number table that I have Text6 (which is combobox). I have it retreive the dc_name and dc_numbers. it's bound to column 2. The DC_number field in the table is...
  6. MJD1

    Query using sql with several WHERE conditions

    hi, need a bit more guidance. The below works..except that the "And masterboltracker.claim_new =" & 1 & _" isn't being executed. the output should only be 1 record, however, all 20 test records continue to show. I'm not getting any error messages and the ""Where masterboltracker.completed =" &...
  7. MJD1

    Query using sql with several WHERE conditions

    Thanks. So obvious..
  8. MJD1

    Query using sql with several WHERE conditions

    hi all, need some help with something I haven't used in the past. I need to use vba to pass a query which contains two conditions. Here's what I have so for but it doesn't work. I can't see where i've gone wrong so hoping to get so help. I need to pull all records where the field "Claim_New"...
  9. MJD1

    Excel Forms - userform to view and edit data

    well, it seems that I was able to figure this one out as well. turns out the column in the data2 table didn't match the formatting. just changed it to Text and it worked. martin
  10. MJD1

    Excel Forms - userform to view and edit data

    alright, one last bit of help. it seems I made a mistake with the below code, it Returns at the Query line "Unable to get the Vlookup property of the Worksheet Function class". not sure where I'm going wrong, I've used very similar vlookup syntax elsewhere and it worked. Please help! Private...
  11. MJD1

    Excel Forms - userform to view and edit data

    ok, got most of it all figured, thanks for helping with the direction. I just need to figure out how to filter my listbox with a couple of pull down list.
  12. MJD1

    Excel Forms - userform to view and edit data

    hi, this is what I have on the Lisbox_click. It fetches the data and shows it in the text boxes. Now i need to figure out how to edit the data in the text boxes. for exemple, if I need to modify a person's last name, I'd like to be able to simply click the box and write the correct name and...
  13. MJD1

    Excel Forms - userform to view and edit data

    hi, well...I've been researching your lead, but this newby to excel vba can't figure out :( can you provide an example? thanks martin
  14. MJD1

    Excel Forms - userform to view and edit data

    hi, no I plan on having a all the fields from the worksheet Data. I just wanted to start one field to understand how to do it. thanks martin
  15. MJD1

    Excel Forms - userform to view and edit data

    hi, so I've got a lisbox populating with my Sheet"Data". What I'd like is for when I click on a record, it looks up the values in the Data sheet and populates the text boxes. this is what I have but doesn't work, I'm pretty sure it's a typo but can't see it. Thanks for helping in advance...
  16. MJD1

    Excel Forms - userform to view and edit data

    sure. the workbook is to keep track of investigations. I have a sheet named "Data" which has about 40 fields, some auto-calculate information such as case number, age, tenure, vlookup to specific lists in a seperate sheet named "parameters", ect. I created a userform to enter the data to make...
  17. MJD1

    Excel Forms - userform to view and edit data

    hi, I'm looking for some help and direction to create a user form that allows me a search criteria and then retreives the information from a sheet named Data. I've tried the built in Form function but didn't like because of the formatting it provides and the fact that I can't have more then 32...
  18. MJD1

    setting focus back to MS access

    hi PHV, tried different variations of AppActivate and I just can't get it to work! any other suggestions? thanks
  19. MJD1

    setting focus back to MS access

    hi, I have an access aplication that when opened it first opens an agreement window. When the "I agree" button is selected, it runs several codes, to eventually open the main working form. one of the codes is opening Outlook and when this happens, the focus is set on outlook. How do I get the...
  20. MJD1

    Passthrough query from access to oracle

    Thanks for the help, very appreciated! martin

Part and Inventory Search

Back
Top