Search results

That is what i ended up doing. Since i found out the format is always going to be the same, and im reading the numbers from a list. I simply put the whole number in there and used = '37-80525-0000' instead of like *80525* like i was originally trying to do. Its very strange that like and =...

This is highly frustrating. If i do this "WHERE (((dbo_View_TK_TicketInfo.LotNumber) = '37-80525-0000')) " It will return the lot number in excel but if i use "WHERE (((dbo_View_TK_TicketInfo.LotNumber) like '*80525*')) " Then it doesnt work. What is different about the Like statement that i am...

screw it i tried it anyhow, Yes it works without the Where statement. It stopped pulling in at 54,000 records The Lot number is stored in the database like this 37-80565-0000 hence the '*80565*' part of the statement. It has to be something to do with the number part. Even though it is...

There is no way im trying it without the Where statement, i would pull in way too many records, id fill the spreadsheet i think. I revised my previous post as you replied. The lotNum is stored as Text in access and String in Excel. I had that problem first with a data type mismatch error...

I have a spreadsheet, a ever gorwing complex spreadsheet. Anyhow, i have a query in access that is pulling data from a table. The database is returning results. But the query when i put it into excel, is simply not returning anything. I have it messageboxing me the sql query im passing to access...

Yea we tried recording a macro first, we do the clicks, but the part where we click DOEPRO etc simply doesnt show up in the macro :(

My boss is the one working on this and she said it seems like a step in the right direction she can see all the names of the subs and functions, but is unsure which one is the one she has to call. But she tried using the standard "call" function and it wouldn't work. Is there a different way...

My boss is using an addon, that is corporate, meaning the code is password protected. That she doesnt care about, she doesnt want to see the code, nor need to know how it does what it does. She just wants to be able to CALL it from her own scripts. Shes currently written macros to do what she...

I got it, sorry for wasting your time, you can delete this post if you like. I had to add a ' ' around the str number i was retrieving from the cell to make it sit in the sql correctly. Sub proSQLQuery1() Dim varConn As String Dim varSQL As String Dim strNum As String...

Ok i managed to get a SQL String to query my database, but im stuck... Something about my syntax and trying to use a variable in the sql string is messing it up. I setup my spreadsheet. I put the STR number in cell M2 and hit go. Im getting "General ODBC Error" Sub proSQLQuery1() Dim...

I have the worksheet setup through the data import to pull a query from a database and it works great. The problem is each time i run the sheet i have to go into access and change the number of the query i want to pull before i do the import. I have a feeling its with a sql string but im not...

Your a wizard...i knocked my head off the wall for an hour trying to figure out why it wouldnt work when everything "looked" right, but you are 100% right, i forgot to remove the ":" from the foldername. Thanks so much. Sometimes it just takes someone elses eyes to see it :)

I have a script doing a lot of things, but the last step is what im getting the problem on and its bugging the crap out of me. I pasted all the relevant code below. What is happening is on the last file copy, im getting a bad file name or number. If i copy and paste the direct path to the...

Got it! Not sure why but i found an exmaple online and modeled my filter line after it and it works great. Why do i need 3 quotes before and after the line? Me.Filter = "skid = """ & Me.txtSearch & """

changed the line to Me.Filter = "[Skid] LIKE *" & me!txtSearch & "*" Clicking the button doesnt do anything.

I have a form created. It displays all the records in the table. In the Form header i put a text box (txtSearch) with a button(btnFilter) next to it. People can type in the text box, then click the button to apply the filter Thats what i want to happen. Here is the button click code...

Well i must say i have to apologize. I tinkered with it all afternoon. Wasnt a problem in the code at all. It works fine. I managed to run a query on the database on the fields the code checks and one of them was somehow totally empty of info. Almost a whole blank record. Not sure what...

Sigh, how did you get it to do anything. I dimmed all those variables i copied in the error handler you wrote, i hit F8 and absolutely nothing happens, not even an hourglass its like i didnt even push a button. same thing if i hit the green arrow. Nothing. Sub autoupdate() Dim ThisDB As...

on a side note i will have to look into error handling. Programming is not my degree and im just doing for this job, but i pick things up so quickly i just cruise along till i hit a roadbump. Never used error handling in vba yet. But i like the idea and might use it soon after i research it a...

ARgh!! Like i said this was running before i started as is. Im not that familiar with access varaibles types. I had to get out of the database for a guy to run some queries and take a lunch break, i will return to this in an hour or so to see if i can shed some light for you on types if you...