If you query only returns one record, you could do it this way:
Dim con as ADODB.connection
Dim rst as New ADODB.recordset
Dim strSQL as string
Set con = application.currentproject.connection
strSQL = "Your SQL"
With rst
.open strSQL, con, adopenstatic, adlockreadonly...
Hello,
Does anyone know how to access the SQL of a stored query using ADO?
The DAO way to do it is:
Dim DB As DAO.Database
Dim strSQL As String
Set DB = CurrentDB
DB.QueryDefs("Some_Query").SQL = strSQL
DB.Close
What's the ADO equivalent of this?
Thanks!
I've got the MailMerge working but I want it to run the merge and then automatically save the file.When I run the command
ActiveDocument.MailMerge.Destination = wdSendToNewDocument
how can I make the new document the active document so I can run the ActiveDocument.SaveAs command?
Thanks...
Hello,
I'm trying to write a subroutine that will update the usermodified field when a person clicks the save user button on a form. However, I keep getting the error: "Object variable or With block variable not set".
The table name is Users, the field I want to modify is UserModified, the...
It's been about 9 years since I programmed in C++ but try changing it to this:
/* This is a program i created by my self*/
#include <stdio.h>
main()
{
char person_fname[25];
int person_age;
/*long int my_age;*/
printf("This program will tell you if you are older or younger than the...
I used to have that motherboard running with two 1900+ MPs. I was so mad when my capacitors started leaking. I'm guessing from the photo that your board is doing fine?
I'm surprised they didn't go all the way by saying they were also coming out with a car that runs on tap water, a portable nuclear generator, a Mark VII transporter, and warp drive.
I had the same problem. To get mine to work I had to try to install the drivers, let Windows reboot, go into safe mode to complete the installation, and they boot into Windows normally. However, only the first tuner would work. I never could get both tuners to work. I tried my card in every PCI...
Who wants to bet that 6.8GHz chip probably performs like a 2 GHz A64?
I think that even if this PC is for real, we're not going to see it mass produced for a very long time, if ever.
Besides, who needs 1TB of RAM and why are they using Windows? Talk about wasting memory...
I remember going from a 12 Mhz 286 to a 20 Mhz 486 with 4 MB of RAM. Man, Ultima 7 played smooth on that!
History:
Coleco Adam
Commodore 64/128
Laser PAL 12 MHz 286
Packard Bell 20 MHz 486
Packard Bell 100 MHz Pentium
Gateway 450 MHz Pentium II
1.6 GHz Athlon XP (started building my...
Yeah, I got rid of the Plextor last night. I'm sending it back to newegg for a refund. It was actually corrupting everything I installed with it!
Right now, I have 3 SATA drives hooked to the Nvidia ports, a NEC drive hooked as master on IDE1, and a Pioneer drive hooked as master on IDE2...
What he means is that cheap power supplies often don't have good voltage regulation or sufficient amperage. Compare the specs on the Turbolink with the specs on a PC Power and Cooling or Antec or another good name power supply and you'll see what I mean.
I just heard back from Plextor and here is what they said:
Following are some of the things that users have used to fix this problem:
1. I disconnected the drive and reinstalled the motherboard chipset drivers. I rebooted a couple times and then reconnected the drive.
2. only...
I found this on another forum - it may help
I'm not sure if this applies to your situation because I'm not familliar with your motherboard, but my PX 716SA was crashing my system anytime a disc was inserted when connected to the nVidia SATA ports. Switching the connection to the silicon image...
I have almost the exact same system you do and I'm having the same problem. However, my problem only started once I added the Plextor drive. I've read that if you uninstall the Nvidia IDE driver the problem should go away. I'm going to try it tonight so I'll let you know how it goes.
Yes! Someone who has this working!
Yes, I have Plug and Play OS set to No in the BIOS and I have the IRQ resources set to auto.
When you say you have all the onboard stuff disabled, do you mean the IDE, onboard sound, firewire, USB 2.0, etc. as well?
Also, do you happen to have the...
Does anyone have these two components working together? I've tried it in every PCI slot and I can never get the second tuner to work. It always tries to share IRQ 18 with my graphics card. In fact, when I put in it PCI slot 1 or 3, I get stuck in a never-ending reboot loop. The system boots...
The rebate is valid from 8/29 to 9/4
Songs are at BuyMusic.com
http://www.buy.com/retail/product.asp?sku=10380059&loc=101&adid=17070&dcaid=17070
Also, follow the instructions in the next post