Recent content by claytonjgordon

This is what I want to happen. The form opens and several fields are manual entry for the user. When its all filled out correctly, they hit a save type button that saves the form and sends it to the next level to continue. When it gets there, the status changes from "new" to "escalated" and...

I want a button to send an email with a button in it that adds the db to the user’s workspace and opens up a form in edit mode. I can create the email and I can create the button manually, but I can't seem to find out how to have that button created inside the email through automation i.e., not...

OK, never mind. I found this page with a link to updated drivers on the right. http://www-142.ibm.com/software/sw-lotus/products/product4.nsf/wdocs/notessqlhome creating a userid so I can download. Dominus Nihil (Master of Nothing)

Does anyone have a link to download the latest LotusNotes SQL driver for quering Lotus Notes tables via SQL through an ODBC connection? We updated to Notes7 and our old driver isn't working anymore and I can't seem to find the driver on notes.net Dominus Nihil (Master of Nothing)

I got it working but i didn't so much as fix it as it just started working. Still a bit of a mystery. I created a new form with the same fields and functionality without worring about making it pretty and linked it to the SQL back end then refreshed all the links for good measure. I then...

Joe at work, to answer your questions: It IS a SQL server for the backend. There is no query involved in this form (its a data entry form where the uses just add new records to the table), and the form does have the primary key which is an identity field. Its linked through an ODBC...

Oh, and thanks for your help and input. This one was driving me crazy and I was half expecting it to be something easy I've overlooked as it usually is. Dominus Nihil (Master of Nothing)

I'm leaning towards corruption, myself. I didn't transfer the db using a CD and I dont have allowadditions in the code anywhere, and I build the db from scratch. Plus, I'm fairly sure that it was working at one point and then stopped working. I'll try to recreate the form from scratch and...

Allow additions is correctly set to yes. And you are correct, it doesn't allow me to add a record. If there are more than one record in the table, i can go back and fort between them, but can't get to a new record via code, mouse wheel, or the record navigator. Any other ideas? This is...

I created a db with an access front end and three SQL back end tables. The users enter information into the access forms and its supposed to write to the SQL tables. On one form, this works perfectly: You hit a button on a menu form at it pulls up the data entry form as a new record. Private...

Ahhh, of course!!!! I didn't even think of that. Thank you very much. Dominus Nihil (Master of Nothing)

I also tried strDefaultLocation = Application.CurrentProject.Path & "\CCC SQL.mdb" Dominus Nihil (Master of Nothing)

I was able to get the transfer spreadsheet to work importanting an Excel spreadsheet to the SQL table off a button click from a form with hidden txtworkbook text field and 1stworkbooks list box fields, using the following code: Private Sub cmdPickFile_Click() On Error GoTo...

Is there a command that will provide you with the path of your database? I want to use the transfer spreedsheet command which requires that I provide the path of the file I'm transferring. The problem is that there are multiple front ends and the table is located on each front end. After the...

I'm an idiot, I got it to work with DoCmd.TransferSpreadsheet acImport, , "temp", Me!txtWorkbook, True Thank you for your help! Dominus Nihil (Master of Nothing)