Search results for query: *

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

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

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

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

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

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 =" &...

Thanks. So obvious..

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

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

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

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.

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

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

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

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

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

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

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

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

Thanks for the help, very appreciated! martin