Recent content by jenvandiver

I am collecting information on X and need to include information on points of contact. There are two types of contacts: technical and contractual. I have: tblContact Contact ID (autonumber) Contact Type ID Contact First Name Contact Last Name tblContactType Contact Type ID...

Well if you were willing to come I wouldn't stop you! Thanks again for all your help... I'm sure I'll need more as time goes by.

This is pretty simple, but what I do is either create a macro that opens a form and closes another, name it mcrOpenXCloseY, then in the form control button, set the OnClick property to that macro. Or you could do one macro to just close the form, then in your control button properties, set the...

Thanks - I appreciate the guidance, especially the list of options. I have considered the last option several times myself. Would you be interested in moving to Missouri? I need someone with advanced level programming skills!

Thanks. Just to make sure I understand... I need three tables: tblSystems, tblParagraphs, and a tblSysPar that includes only two fields: System ID and Paragraph ID? I have roughly 50 paragraphs, and at least that many systems. Some systems will be entered into the database new, so...

Hi, any help with this is appreciated. I have a table with paragraphs of language, each paragraph having its own ID. This table is the record source for a form which allows the user to choose all the paragraphs that apply to their system. My problem is how to link the paragraphs that are...

Thanks for the help. The macros I need to run automatically when the Excel workbook opens are macros within that document. The code I've seen so far seems to be running Access macros to call data for Excel. I've got the properties for my Excel template set to automatically run it's macros on...

I've coded a form button in Access to open an Excel template, which is supposed to automatically run a query for data on open, however when it opens using the button in Access, it doesn't automatically refresh the data and I have to manually do it. It works perfect if I double click directly on...

Thanks. It's working great at this point as far as opening my template, HOWEVER, I had created the template to run a database query on open, which is does if I open the template directly. But now that I'm opening it through Access, it won't automatically refresh the data. It opens up a new...

It's working now. This is the code I used... Private Sub CreateCommentsMatrix_Click() Dim lngRetval As Long Dim oApp As Object Dim strDoc As String lngRetval = MsgBox("Please wait..." & vbCrLf & "", vbOKOnly + vbInformation + vbDefaultButton1, "Creating Comments Matrix")...

I'm trying to code a button on a form in Access to open an Excel template. This is what I've got so far. It works as far as opening Excel, but it won't open the file. Private Sub CreateCommentsMatrix_Click() Dim lngRetval As Long Dim oApp As Object Dim strDoc As String...

This should help... In a blank Excel worksheet, go to Data, then Get External Data, then choose New Database Query. From the database list, choose MS Access Database. Click OK, then select your specific database and click OK. Make sure your database name does not contain any periods (.) other...

I have been working on something similar, importing data from Access tables into Excel. This is how I did it... In a blank Excel worksheet, go to Data, then Get External Data, then choose New Database Query. From the database list, choose MS Access Database. Click OK, then select your...

Thanks for your help. I have an Excel template that runs an automatic query on an Access table when opened, then reformats the information on another sheet in the workbook. From Access, I'm trying to code a button on a form that will automatically open this template. When you double click on...

Hi, any help on this is appreciated. I'm trying to open an Excel template from a form in access. If I hyperlink the template from a button, it goes directly to the original template without opening a document based on the template, which is the whole purpose! I've tried to code the language...