I'm attempting to connect to an Access 2000 database and am not sure how to construct the connection string and process a select query. Here is what I have so far.
Dim Conn as ADODB.Connection
Dim rstImport as ADODB.Recordset
Set Conn = New ADODB.Connection
Conn.Open "Provider= Microsoft...
Hi there. Does anyone know offhand if a user opening a database that's linked to a second database takes up a "slot" only in the original database or both original and linked?
I have a form that saves the results of filters to variables in increasilngly long SQL statements By clicking on a button in an option group initiates a docmd.applyfilter that uses the variables to reapply a filter. I've begun getting an error message that the "apply filter action was...
I've set up a command button to save a record on a data entry form. The problem is I get a validation rule error for a field about a default value. The field was required and was set to a default value, but I've remvoed those in table design. The error also occurs intermittently when I open the...
I'd like to attach a screen print of an Access form to an e-mail. Is there a way to accomplish a screen print in VBA, or an alternate method using cut-and-paste.
I'm using DoCmd.SendObject to send the e-mail, but can't use SendKeys to attach the image.
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.