Recent content by RonRegan

Post the code that you have, please.... Ron Independent Consultant Tampa Bay, Florida

Here's some code I found in help. <br><br>Sub CreateDatabaseX()<br><br>&nbsp;&nbsp;&nbsp;&nbsp;Dim wrkDefault As Workspace<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim dbsNew As Database<br>&nbsp;&nbsp;&nbsp;&nbsp;Dim prpLoop As Property<br><br>&nbsp;&nbsp;&nbsp;&nbsp;' Get default...

You have to surround text fields with quotes. I cant tell if UserID is text or numeric, so if its numeric, you dont need quotes, if its text you do.<br><br>SQL= &quot;SELECT LNK_NM, LNK_DSPL FROM EPIC_LINK WHERE LNK_USER = '&quot; & UserID&nbsp;&nbsp;&&nbsp;&nbsp;&quot;' AND LNK_NM = '&quot; &...

Okay, first: have you created two separate databases, one with the programs, forms, reports, etc and one for just the data? <br><br>In design mode, click on tools, options. Click the advanced tab. Select &quot;shared&quot; for mode.<br><br>hth<br><br>

Okay, you said you can write an append query. Yes, you can put this in a macro. Just create a new macro. Look for &quot;Open query&quot;, put your query name in the &quot;query name&quot; field. It even has a drop down list box to help you find your queries. You can have multiple queries run...

No, it isn't. Access isn't as flexible as Excel. <br> <br>

I have a table that contains the tables I want to relink. This table is bound to a form and when I click on the OK button this code is executed: (HTH)<br> <br> Private Sub cmdOK_Click()<br> ' Comments : read the tblConnect and re-establish connection<br> '<br> '***** this does NOT CREATE...

I'm not sure if it doesnt work of if I couldnt get it to work. If you look in help for Lotus or cc mail, there are instructions on using the dll for Lotus, instead of the dll for Outlook.<br> <br> I tried and didnt get it to work.