I am trying to create a fool proof "import" button that will import data from an excel file that will be located on a shared drive. This file can be updated by users - but I don't want them to have to manually import the data to the database. I also do not want to link the table - since it will likely be a table that is often deleted and replaced.
So i need VB code that will enable a button to import the table - and overwrite...
scolivas
Last Activity: Mar 5 '10, 10:48 PM
Joined: Oct 12 '06
Location:
-
I am very green at this Java - where exactly would I put this code? - I have tried dictating what the height and width would be - but it hasn't worked yet.
...Code:<a onmouseover="MAINIMG('393LOGI5')" href="http://i157.photobucket.com/albums/t58/olivas_enterprises/393LOGI5.jpg" alt="OLIVAS ENTERPRISES" width = "182" height = "151"> <img border="0" -
That is totally awesome! Thanks! I love this site! I learn so much from it! Thank you!...Leave a comment:
-
so even though each of these pictures is going into a different location - I can still just have the one function? How do i tell it where I want it in one function?
I really don't understand the madness behind java coding - it is all very foriegn to me - I figured out how to maniuplate the code I originally had by trial and error - in no way did I know what I was doing, I just got lucky. I can do some basic and midlevel html -...Leave a comment:
-
MouseOver Image sizes????
Is there a (Simple) way to make the image produced by the mouseover command - to be a specific size? I have several different pictures - and depending on what it is the size can vary alot - is there anyway to make the mouseover command dictate that the image is 50% of its original size - so that it automatically adjusts to each picture being displayed?
Example of what I mean about the pictures:
... -
That sounds like a good idea - but I have modified this code from somewhere else and really don't know how to "code" it myself. I just changed names so that it related to what I was doing.
If you can assist me in figuring out how to actually write the code that would be great.
Basically on the mouse over event I want the image that is mousedover to change and then I want another image to appear just below....Leave a comment:
-
Can A Mouseover Do More Than One Thing?
Hi, wanted to know if there was a way to make a mouseover command perform 2 tasks?
I want it to change the image that is being mouseovered and I also want another image to appear in anoter location on the page.
I can make it do one or the other but not both - can this be done?
Here is what I have so far...
...Code:<body> <script language="javascript">
-
Nevermind - persistance has paid off - I found it! Thanks though.Leave a comment:
-
Help with Mouseover and mouseoff please
Hi, I was wondering if there is a way to "unMouseOve r"?
I have the following script that does the mouse over - but I want the image to go back to the original when the mouse leaves the area.
...Code:<body> <script language="javascript"> function ShowPic1(sImage) { sImage = "http://i157.photobucket.com/albums/t58/olivas_enterprises/" + -
I am not sure why there is a Str function either -
What I am doing is I have a form that opens that allows me to input data to a table based on the Carton# entered.
So when I open the form - there is a list box that is highlighted and waiting for entry or I can select from the list box - but I type faster than I scroll...so i would rather type it in. The list box "select" feature still works fine, but the...Leave a comment:
-
Urgent Help Needed - Migrated to access 2007 and now my db's are broke!?!
Help! I just upgraded from 0ffice 2003 to Office 2007 and when I opened one of my DB's its broke!
Seems
<code>
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Cl one
rs.FindFirst "[Carton#] = " & Str(Nz(Me![List2], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
</code>
is... -
Thanks! I will give it a shot!...Leave a comment:
-
Making a query based on radio button selections
I would like to make a form that creates a query.
I know that I could make a query for each radio button instance but that would take forever!
So basically what i have is 10 Fields in a query But the user may only need say 5 of them. Is there a way to "select/unselect" the "visible" check box in the query based on the radio buttons selected on the form?
sql for query is as follows:... -
Thanks! I'll Check it out!...Leave a comment:
-
Enable Macros automatically but only in a scheduled event
I make and run macros all the time - now I need to schedule some reports to refresh from my machine round the clock. Problem is in order for the macros that do all my refreshing won't run unless I do one of 2 things - either reduce my security settings to low or actually click the button "enable macros".
If i re-set the security settings - I cannot get to the macro's to edit them if need be (they automatically close the... -
Hi, thanks for the info. I do infact want the whole application to close. We have these reports sitting on a desktop and on a scheduler - so they run every hour. When they are finished refreshing - they close so the next one can run. Problem we are having is if one gets stuck due to an ODBC error - the application won't quit - and the next inline doesn't get to run. (or at least that is how it seems to be working) The other ones try to open...Leave a comment:
-
so i put your code in under Myerrorhandler? instead of my code?...Leave a comment:
-
vba Error handler for Excel - make it close on error
Hi, I asked yesterday about this - but maybe my title was bad. No one responded.
I have a refreshable Excel Spreadsheet that pulls data from an Access Database on the server. The server has been a pain lately - and not letting anything finish and causing lots of time outs.
I want to put an error handler into my vba macro that will force the application to quit if any errors occur.
I am thinking it is... -
Can you force an error's description into an active cell using vba?
I am wanting to let viewers know why a refreshable spreadsheet did not refresh. Often times its an ODBC time out error - I put an error handler into the macro that runs the refresh - so that it will select a specific worksheet, specific cell and put the current date in. I would also like to have the error message that pops up when there is a problem to populate the cell next to the date...how do i do this?
I am basically trying...
No activity results to display
Leave a comment: