Recent content by JoaquimM

I have a connection with my database now I want to run a select query to return the value of a field. I'm using a DAO connection, anyone have any ideas how to code this? Do i have to create a RecordSet variable?

Hi I'm trying to make a query i have in Access run when I open the file through VB. The query will run if I open the Access file using Access but when my VB code opens the file it won't run. Anyone know how I can force the query to run? Thanks

Hi Does anyone know why I'm having a problem opening an Access table in my VB code. The program runs fine when I try to open one table in my access file but won't run when I try to open a different table in the same file. The table that won't open is being populated by an append query that...

thanks ben I have to step away from this for a bit and do some other work but thanks for the help and if i have any more questions I'll post it here. thanks jack

No I'm new to VB so don't know all its capabilities. What would be an easier way to doing this?

m_cnADOConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=c:\projects\EASTERN SHORE\database\Sample.mdb") m_rstContacts.Open("Output", m_cnADOConnection, _ ADODB.CursorTypeEnum.adOpenDynamic, _...

My program has no problem opening the Access file, my problem is when I try to open one of the tables in the file I get an error that looks like this An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in test.exe Additional information: Invalid SQL statement...

Hi Anyone know how to make my program stop executing for a couple of seconds. I make my program open an Access file that automatically runs a query when opened and I want my program to pause to give the query time to run before trying to access a table in the file.

I have a query that I need to have run automatically at a certain time of day everyday. Anyone have any ideas on how I can do this? Would really appreciate the help