Recent content by bill37

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...

Thanks. Is there a way to prevent a user from opening the linked database directly if it's already opened through the link?

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.