Search results for query: *

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)

...As String = "C:\") As String On Error Resume Next Dim OpenFile As OPENFILENAME Dim lReturn As Long Dim sFilter As String sFilter = "Excel files (*.xls)" & Chr(0) & "*.xls" With OpenFile .lStructSize = Len(OpenFile) .hwndOwner = Application.hWndAccessApp .lpstrFilter = sFilter...

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)

The steps you put above are working great, but I can't seem to get the transfer spreadsheet to work. Even if I don't use the variables and hardcode the data in the command directly, it doesn't do anything. DoCmd.TransferSpreadsheet acImport, , "temp", "C:\Documents and...

Thank you very much for the information and code examples. It will take me awhile at my level to try to get this to work. So far I got the 'find Excel location' part to work. I'll let you know how it goes. Dominus Nihil (Master of Nothing)

That successfully triggers the import tool; do you know of a way to automate the answers to the various steps after selecting the file? I would want it to: select the first tab in the spreedsheet Select first column contains column headings In an existing table (and provide table name) and...

I built a database on access that uses a SQL server for the back end tables. That part works great but the business group wants to add a new feature that allows them to append records onto one of the tables from Excel spreadsheets. I'm thinking of doing this in two parts. 1) import the...

Thank you so much. That was it, I was leaving out the signle quotes around the last part of the criteria: "[USERID] = '" & Me!TempID & "'") That was driving me crazy!!! Thanks again! Dominus Nihil (Master of Nothing)