Search results

Using all of the great information you have provided (thank you, btw!) I managed to get the names of the text box and both command buttons on the google page. Now, using the code below, I am able to capture what is in the text box: Private Sub Command2_Click() Dim myHTMLDoc As...

So far, that's getting me on the right track. I've got a sample db that has the web page loaded on a form, but my main hurdle is capturing what is entered in the webpage. For example, if my users were performing searches on Google, I'd want to be able to capture what they have typed in the...

Hey guys, I've been searching all over for a sample IE scrape and I came across one that works...kind of. This one pulls all of the pages HTML into a variable, which is great, but not exactly what I need. I need to be able to pull what information is selected in any combo boxes/typed in text...

Hey guys, Does anyone happen to know what ActiveX control to use to view .doc files in Access? Or if there is a better way to handle this, that'd work too. I've been searching around and got nothing. Thanks! **edit** You know, if I had spent just a few more minutes searching, I'd have come...

That's brilliant! I should've tried that first! Good call, thanks :)

Hey guys, I'm trying to make this new process require the least amount of manual intervention by having the user open 2 of the 10 databases used. The user would open databases 1 & 5, and the databases would open the next in succession (2-4, 6-10) in a new instance of Access. Problem is, when...

Great idea! I did just that, and it worked. I'll share the code as well. It wasn't a huge change either (thankfully!). Thanks a million!! Sub GetAddSep() Dim intPos As Integer Dim FullAdd As String Dim test As String Dim Bcity As String, Bstate As String, Bzip As String Dim strLeftPart As...

Hey guys, I've got a module that breaks up a line of an address to separate city, state, and zip. It works great on single word cities like Denver or Atlanta, but with two or more words (Green Bay, West Palm Beach, etc) it bombs out. Can anyone take a peek and see how this could be adjusted...

Hey guys, Quick question: I have a table (tbl1) that has names stored in the format "last, first mi" and a linked table (tbl2) that has other information I need, but the names are "first mi last" format. To have my query work, since it'll be based on name, I need to format tbl1 to match tbl2...

Hey guys, I'm trying to build a delete query that will remove records in my main table that match any stored in my history table. The problem is that I keep getting the following no matter how I try to build the thing: My gripe: No one else has this database, it's not open read only, and I...

Hey guys, I know this sounds simple to do, but here's what I'm trying to tackle: I have 15 (yes 15!) checkboxes on this spreadsheet. Boxes 1-3 belong to the same "family" and boxes 4-15 belong to a different "family". The user has to make a selection from both "families" in order to...

Better idea...Is there a way to look in a directory for all files of a certain extension? If that's possible, maybe I could just do that and import the files where the first 8 digits are todays date? Edit: Found this thread and ghudsons post is exactly what I needed (with minor updating...

Hey guys, I'm trying to import a series of .csv files into a table in my database daily. The only issue I'm having (so far!) is that my file names change daily, and it'd be pretty silly to go in and change the code everyday just to run the process. My file name would be something like...

Thanks guys, I took your advice....which lead to a massive overhaul of the design (for the better!) and i love it!

Hey guys, Is it possible to freeze panes at the top and bottom of a sheet? Example: my workbook has its header in cells A1:F1 and that's locked. My data is entered below, and the totals are displayed in B256:F256. Is there a way to keep my header AND my totals frozen so the only thing you...

Hey guys, I read somewhere that you can take control of an application tha is open with vba. For example, say I have IE open, and in my database, it calls for me to go to google. well, rather than have the user click a button to open a whole new instance of IE, I could just have my db go to...

Thanks for the quick response! I applied both solutions and it works. Now for a little tweaking and I'm set! Thanks a ton!!:D

Hey guys, I'm trying to run the module below, but this whole "SQL in VBA" thing is pretty foreign to me. Basically, I have a query that I need to run using a variable (TrNum). Rather than have the user manually change the variable and run the query, I have the TrNum in a table that the user...

Hi guys, I'm trying to compare "Table B" to "Table A" to see what records in "Table B' are not in "Table A" and delete them. "Table A" is a linked table thats updated daily from an external source, and "Table B" is a table populated by a query in which the user supplies an account number, and...

Wayne & Vonnie, thank you both for all of the help! I've got my project back on track and its thanks to you!