Hi,
I am working with a Gantt Chart in MS Project. In the chart area, there is a task that is suppose to end at some date (6/2008). I would like to draw the "complete through" bar (black bar) to extend past the blue-coloured bar. i.e. move the black bar past 9/2008. Can someone explain how...
My background's limited to Java... so I'm not familiar how to link with MySQL. I know there are packages to link with MS Office (i.e. Apache POI). Is this a req. or is there some workaround - i.e. using the javax.sound.* package? tx
I've looked over the Internet, through Sun's APIs, and it appears there's more than one way to do it... but I couldn't get any to work :P
I'm using the SwingSet API... if someone could help me on how to play a basic WAV or MP3, that'd be great. Thank you!
Hi, The page is local-based and it has a "search-type" form allowing one to login via entry of a username and password. The web pages I want to automate printing via VBA require logging in at the original page. I was wondering if I could somehow "fill" in the fields using VBA and also login...
Is it possible to access web pages that are password-protected, using VBA? With the user/password data, I plan to perform some activities such as printing pages.
Thanks,
Techno1X
No, it's a String, I checked.
Is it possible that other portions of code could affect a single "On Error" statement? Note that *none* of the "On Error" statements work in my case.
On the top I declared:
Option Compare Database
Option Base 1
I've tried that; however, I just want the program to ignore the statement if it reaches an error. Hence "resume next".
One thing I did was use the trapping object with an empty inside block: i.e.
If Err.Number <> 0 Then
End If
But it still gives an error at:
"dbOne.TableDefs.Delete...
Hi,
I can't get the following error checking methods to function properly. In these, the compiler jumps past the statement as if it was never there..
1. Trying to delete a table:
On Error Resume Next
dbOne.TableDefs.Delete tblFun
2.Append the new table to database
On Error Resume Next...
I get this error "Run time error 3125" when trying to append a table: it says I used an invalid name.
However, I followed the rules properly, so see this snippet:
CODE:
"Dim dbOne as Database
Dim tblOne As New DAO.TableDef
strName = "temp_Name"
Set tblOne = dbOne.CreateTableDef(strName)
(5)...
Situation:
I have a large list of various MS Excel formulas which are written as "String" format in an Access table. For example, the SUM function (SUM(field1,field2)), although the list of formulas is very large and they already include the data fields which need to be calculated on (see...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.