Search:
Type: Posts; User: Clunietp
Search:
Search took 1.45 seconds.
-
Awesome, thanks Marco!
Tom
-
Thanks Marco, that information may come in use some day. Do you know if the same applies to ADO as well?
Tom
-
You have to use a query! If you don't want to create a query object, you can manually type in a SQL statement for the form's recordsource
-
Take your pick
http://google.yahoo.com/bin/query?p=Error+10050+Network+subsystem+failed&hc=0&hs=0
-
From that article:
Well, since MySQL is free and Oracle costs a bundle, and you are limited by cost, which one would you choose? :)
I suppose when they compared free databases, they found...
-
I would say the easiest way is after you populate the combo box with the locations, set the combobox.text = the first item in the combo box. Then call the combobox_click event, which will fire your...
-
Thanks Mongo, I do know better :)
I was considering using TRUNCATE TABLE but then the user would require admin privledges on the database, and I wasn't sure if that would be acceptable for IJ --...
-
I suppose you could use DAO/ODBC to read from an Excel sheet. I don't know if you will have similar problems or not to those in ADO. Additionally, if you don't mind making an app that is obsolete...
-
Do you have any other fields that will magically appear later or is this all of them? :)
The SQL statement took me about 20-30 minutes to create. If I break it down into smaller pieces and put...
-
-
Looks ok to me, but I would try it on an access database or something first, especially if it is important to your career :)
-
oh, ok, no problem!
assuming RS is an open recordset that holds the contactinfo data for that person. We'll keep it simple and not use any recordset functions (like seek/find/etc.)
...
-
Actually you can just download and install MDAC 2.0 from here onto your work PC (its free) and your app should work fine. VB not required
http://www.integrade.com/downloads/mdac.html
Tom
-
actually he could use the Application.CurrentProject.AllReports collection to enumerate through all of the reports in the database, open or not. If he wanted to manipulate the data source of the...
-
basically, use the replace function. Here's a small example for you
strSQL = "insert into mytable (myfield) values ('" & replace(strUserInputVariable, "'", "''") & "')"
-
Do you have VB installed on your Work PC?
-
No problem, best of luck
Tom
-
Thanks for the clarification, I now better understand what you need.
If I were to build it, I would retrieve a recordset of all contact info for a person when they click on the name. I would then...
-
I believe it would be your @PrimaryFieldName variable
-
Well, looks like you have this one wrapped up.
Wyoming county? So you must keep your computer in a barn? (or chicken coop?) :D :D just kidding. My grandma lives in North Java -- nice and wide...
-
what was wrong with this statement?
delete from Table1 where UniqueIdentifierField not in (Select UniqueIdentifierField from Table2)
just create a SQL statement like this using your parameters...
-
What do you need to do with the data that needs to be removed after you select it?
-
I hope this helps
http://msdn.microsoft.com/library/psdk/sql/ac_8_qd_14_3unn.htm
-
I've never heard of this being done, but the only (known) way you could do this is if the o/s already has ADO installed (for example, windows 2000 comes with ADO 2.5 preinstalled)
This probably...
-
Correct, but then you cannot programmatically manipulate the report object (you need the Access object model to do that) and you then have a dependancy on DAO (which is a pain to distribute)
-
You should have just said this in the first place :)
a simple SQL statement will do it
delete from Table1 where UniqueIdentifierField not in (Select UniqueIdentifierField from Table2)
This...
-
What database are you using?
I suppose you could cache the data locally be selecting all data from the contactinfo table for that particular person. If you keep this in a recordset you can use...
-
How is it as "powerful as oracle" if it does not support subqueries, stored procedures or db logging (to name a few features)?
-
Explictly declaring items in your code actually makes it process faster.
For example: declaring Language, EnableSessionState=False and Option Explicit speed up your output by approximately 5-10%...
-
How are you connecting to your database? Are you using a querystring somewhere, or maybe a data designer of some sort?
-
Well, it looks like you're up sh*ts creek without a paddle :D
SQL Server isn't letting me dynamically create the sql statement for the OPEN CURSOR procedure. Maybe we can try to accomplish your...
-
Have you tried anything like an Insert Into statement with a NOT EXISTS subquery? If you'd like to send me your database (a small, zipped version please) I'd be happy to see what I can do
...
-
Since your recordset is at module level scope, it will always point to the current record. You can then just use rs.MoveNext to point to the next record. Will this work for you?
-
Well why didn't you say so in the first place? :D
You can't call a SP and get its resulting recordset from another SP (you can do it with single return values though), so we have to create a...
-
The only way you can do this is to trap the error on the client
What part of WNY are you in BTW? I'm in Tonawanda. Small world :)
-
Do you know how to read a text file and/or use INSERT sql statements (or the AddNew method of a recordset)?
-
Use the PersonID and the value in the combo box to query your contactinfo table. This should retrieve the appropriate information
example
"select * from contactinfo where PersonID = " &...
-
Apparently not! I put your code in a SP called spu_Test and ran this code
Dim objcn As ADODB.Connection
Dim objrs As ADODB.Recordset
Set objcn = New ADODB.Connection
...
-
Per the MS Access help file, the Reports Collection contains a list of currently open reports. So we just have to open one first
Dim objAxs As Access.Application
Set objAxs = New...
-
Is this code in a stored procedure?
|
Click Here to Expand Forum to Full Width
|