Search results for query: *

I am trying to stop the execution of code with a keypress. I seem to have runaway code and can not determine why. I need to be able to stop the code from executing by pressing a key during the execution. The ctrl-break does not work, so I want to use something similar to Basic's A$=inkey$. Any...

I am trying to open Internet Explorer from within MS Access using code. I have done the call to Explorer using Call Shell("""C:\Program Files\Internet Explorer\IEXPLORE.EXE""http://webaddress.com/Summary.aspx?PrntId=" & prntid & "&Language=1", vbMaximizedFocus) where prntid will tell explorer...

I am trying to make a pass through querie on the fly. I want to select a series of variable by either drop down box or typing in the filter in an input box and then make the SQL string that defines the pass through. The code snippet at the bottom works to some extent. But, when I open it, it...

I am trying to make a pass through querie on the fly. I want to select a series of variable by either drop down box or typing in the filter in an input box and then make the SQL string that defines the pass through. The following works to some extent. But, when I open it, it will not...

How do I prevent MSExplorer 6 from opening an excell links in an excell window within explorer? I want to have the link open in an Excell window outside of explorer. This happens also with powerpoint. I want to have the powerpoint open in powerpoint proper, not within another explorer window...

I have an issue which is the same as another users but the answer was not clear. I have a database in which I am trying to run some basic queries using the Now() feature. It used to work... ubt now it doesn't. The error I get is: Compile error. in query expression 'Now()' The other users...

I have been trying to retrieve Blob memo fields from an Oracle database – unsuccessfully, for some time. When I open the oracle database using Access I see ‘OLE object’ in the field, but cannot see the underlying text. I can see the underlying text using other software (TOAD) but that does not...

I just received a new computer and corporate had it set up to auto install everything upon boot up. When it came time to select my computers ID name, I did. It said that name already existed, kept on going asking a little more info and rebooted. When it came back up it asked me for my login...

When I double click on an Excell sheet's icon, it is opened up in another currently open Excell application. I want to be able to double click on an icon and have it spawn a new occurence of the Excell application... I want each Excell sheet to auto-open its own individual Excell window and...

When I click on a cell in Excel, the program doesn't recognize the release of the button. Only Excel does this, all the other software running acts fine. After clicking, the mouse drags a selection window all over the worksheet. Even if you take the pointer out of the window, excel still...

When I switch cd's in my drive, my WinXP Pro does not recognize the files on the new cd. Mostly... On the directory panel, it might change the directories, but the file panel does not update/refresh. I've tried using the refresh/F5, I've tried using the eject command via right click on the cd...

I have a database with a field that is set up as a hyperlink. That works fine. Now I want to extract part of that field using a query that strips off the filename, leaving only the directory. The field I created in the query is called goto. goto: (Left([path],(Len([path])-1-Len([filename])))...

I have the need to extract sub portions of a cell. The catch is that I need to get the portion according to what is in the cell. For example: If I have a path and file name in the cell \Directory1\directory2\anotherdirectory\filename.ext how do I get just the name of anotherdirectory, or...

Can anyone tell me how to get a full directory listing of a folder and its subfolders? I want the name, size, last modified, and creation date. I would like to be able to put the filename and the directory it is in into a table. Thanks, Tom

Can someone explain how to: Enter info in a form, Click on a button on that form, update the underlying record so that information can be processed that has just been enter, return control to the form for more info entry. I have a simple "punchclock" type form where I want to be...

I have two tables: Table 1 has a fields Description, Item_num, Indx_num Table 2 has Memo, Item_num, Indx_num I want to combine (concatenate?) all the Description records from Table 1 and put them into a memo field in Table 2 then replace Item_num and Indx_num in table 2 with the...

I posed this question and received a response that worked well... as far as it went. I should have included a little more. Let me start with the old question and add a little more to it. I have a pass through query that supplies data of the following format: Item Date...

I have a pass through query that supplies data of the following format: Item Date 1 Nov 3 1 Nov 6 1 Nov 4 2 Nov 3 2 Nov 2 2 Nov 7 I would like to know how I can pick the highest date for...