Search results

Hey guys, Is there a way to prevent a link from opening in a new window in an embedded ActiveX web browser control? I'm trying to make a "desktop" app so to speak, where we can access a webpage we use on a regular basis all in one program. It's not a huge problem to keep IE open with access...

Hey all, I have two reports that need printing, one showing the full record ID, the other showing the first 5 digits. I'm basing the reports off of the same query, and what I would like to do is something like the following pseudo-code: do until rst.eof Print report A for record 1 Print...

Hey guys, I'm trying to print a document from a web browser control in my form, but I need to lay a label or textbox over it with todays date. Example: I've searched Google for "car parts". I now need to print the results page with todays date in the top right corner. Is there a way to link...

Hey everyone, I'm stuck on getting data into a table. I'm importing data into a recordset and there is a date field which is optional in some cases. When passing that date from the source table to the destination table, I get "type mismatch" for an error when a blank value is passed. Now, is...

Hey guys, Is there any way to resize an ActiveX web browser control on a form with vba? I've got my form resizing using the module floating around the internet by Jamie Czernik, and that works great, but it doesn't resize my web browser. I also tried Me.WebBrowser0.Width = 17775...

Hey guys, Is there any way of coding something to be X amount of spaces long without having to insert all of the spaces? For example, I need to insert 400 spaces at the end of a file per an issue with the tool that uses the file. Currently, I'm manually inserting the spaces, but there has to...

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

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

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

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

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

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

Hey guys, I'm trying to build a cancel option into my database that would stop whatever code is being worked "dead in its tracks" so to speak. I've searched for examples, but nothing relevant appears in the searches. Any ideas how I could pull this off??

Hey guys, I'm trying to edit a spreadsheet that may or may not be missing data from an extraction we perform here. Basically, we take the data from our 2 job sites and compare them. However, there is the rare occasion that Site2 uses Site1's server, creating the misconception that no work was...