Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mygmat123
  • Content: Threads
  • Order by date
  1. mygmat123

    Parse elements in string with limits

    I have a string that I need to parse based on the number of elements. Using the string.... string="a,abc,car,bread,number,the,word,world,never,before" I would want to parse the string into three items per parsed string, then display. the end result would be.... msgbox("a,abc,car")...
  2. mygmat123

    dbDriverNoPrompt with no DSN problem

    I have a problem trying to link my access table using VB I can connect using the below connection string .... Driver={SQL Server};SERVER=MYSERVER;UID=MYUSERNAME;PWD=myPASSWORD;DATABASE=myDATABASE; WHEN I USE.... Set dbsODBC = OpenDatabase("",False, False, strConnect) BUT IF I try...
  3. mygmat123

    online backup though dsl

    I just ordered Small business server 2003 and I need a backup solution to backup the delta's(changes) to a remote server also with Small business server 2003 through a dsl line. What is the best/least expensive way to backup just the changes of the exchange server and SQL server to my remote...
  4. mygmat123

    remote procedure call failed(PLEASE HELP)

    I get an error when I try to run this send an email with the following code. PLEASE HELP. This was working perfectly them all of a sudden it stopped and I get this error. What is causing this error? MESSAGE: runtime error: -2147023170 '(800706be)' Automation error The remote procedure call...
  5. mygmat123

    filter Rss/atom feeds (need help)

    I'm looking for a rss/atom filter which I can use to set criteria for the rss I list on my site. for example: I have a rss news feed, I would like to use a url with critera that I can then use to filter the newsfeed. example url...
  6. mygmat123

    function only runs once

    I have a function that I've written: getpercent(variable1,variable2) When I try to use the function, it seems to run once, but then uses the same return value for all other cells cell A1= =getpercent(1,2) returns "0.03" which is correct.. but if I use it in another cell cell A3=...
  7. mygmat123

    run Macro from different Database file?

    How can I run a macro from VB that is in another database file that I have. example: I have two databases. DBfile1 and dbfile2 I would like to open dbfile1 run code that executes a macro in dbfile2. Is this possible? Thank you
  8. mygmat123

    run function in different MS access database file

    I need to run a function from another database file I have, the function returns a value. What would be the code that wuld reference the file/module/function? Thank you
  9. mygmat123

    can not find input table or query

    I'm having trouble with this SQL. SELECT table1.* FROM table1 LEFT JOIN [SELECT * FROM table2 WHERE field1="12345"] AS alais2 ON table1.field2=alais2.field3; When I run this with no join it works fine, but when I add a left join, I get the error..... "The Microsoft jet database engine...
  10. mygmat123

    automate exiting of Outlook

    I would like to write code to quit OUTLOOK that is opened manually, then backup the .pst file. Is this possible? What would the code look like? Thank you in advance!
  11. mygmat123

    PHP results not showing up, what going on?

    <html> <head> <title> My first php page</title> </head> <body> <h1>Firstdb PHP results</h1> <?php @ $db=mysql_pconnect('localhost','root',''); if (!$db) { echo 'Error could not connect to database'; exit; } //check if connection works if (DB::iserror($db)) { echo $db->getmessage()...
  12. mygmat123

    HARD? SQL with min(abs(sum of value),abs(sum of value2)) as fieldname?

    I have a table MYTABLE Field1 field2 field3 abc 2 200 abc 2 100 abc 2 -180 bnm 3 -500 bnm 3 450 bnm 3 30 zxc 2 250 zxc 2 -200 zxc...
  13. mygmat123

    Too few parameters. Expected 4 (runtime error '3061')

    I get... "Too few parameters. Expected 4 (runtime error '3061')" error when I run my query through VBA using the currectDB.execute mySQL command. But if I run the same exact query through the GUI interface in access it runs fine. Whats is going on? Thanks you in advance.
  14. mygmat123

    autonumber with starting from DMAX value

    I have the following SQL.... MYQUERY1 SELECT [mydate],[value], nz(DMax("group_number","mytable2","[value]='" & [value] & "' and " & "([mydate])Between #" & [mydate]-8 & "# AND #" & [mydate] & "#"),DMax("group_number","mytable2")+1) AS GROUP_ID FROM MYTABLE1; I'm trying to get the groupID to...

Part and Inventory Search

Back
Top