Search results for query: *

When my front end opens, it first looks to see if it can see the back end file on the network (If FSO.FileExists(strServerPath) = True). If it does (true) then it makes sure that the tables are linked to that source. If it does not see the back end on the primary server, it looks for a back...

Hi Duane, Unfortunately I am unfamiliar with first how to test to make sure the front end sees the SQL backend. And second once it does see it again, to programmatically (VBA) re-coonect the tables to the SQL back end. I do this currently for my Microsoft Access backend but that is simple. I...

Background: I have a Access database. When I open it currently it tests to make sure (via VBA) it sees the back-end mdb data file. If it doesn't, it connects to and relinks the tables to an alternate back-end mdb data file (a local copy). Because we rely on this database for critical...

Hello, I am using Microsoft Excel 2010. I have two workbooks with the same columns. Workbook A has 1169 records and Workbook B has 1127 records. I want to identify the records that are missing in Workbook B from Workbook A. Unfortunately there are no unique keys to only compare one column...

Hello All, I am using Microsoft Access 2010. I have a database that is using a frontend/backend configuration. I am using the code below to relink the tables. We have two different sites on two different networks. I have user level security and am using a mdw security file. Whenever I push...

Majp, That is exactly what I needed. Thanks, Bob

Hello All, I am using Microsoft Access 2010. I have set it up so when the user clicks on the "Print" button for a record, it shows them a preview of the report. Unfortunately, they also need the ability to copy parts of the content for use (paste) in other applications (usually either Word or...

Hi combo, I'm sorry but I do not understand the first part of your response. Can you explain further? The second part about hiding the submit button is not an option. There are many more things that are happening in the background that it is checking whent the button is clicked. Thanks, Bob

Hi Skip and combo, I have a form control group box with two form control option buttons within it (the user is to select yes or no). The option buttons are bound to a cell so it I can test to see if there is something selected. When the user attempts to submit the spreadsheet (by clicking on...

Hi All, I have a spread sheet with some VBA code behind it. The code primarily is checking to make sure the spread sheet is filled out. I have option buttons located within a group box. One of the things I check is to make sure one of the option buttons have been selected (no problem there)...

Thank you everyone for your responses. Zeglar that worked perfectly, you get a star.

Here is what I attempting to do, to help you understand my coding: * I save the file to a new folder using the saveas method (combining three cells to make the name). * I verify the file saved to the new folder as expected. * I verify the file exists in the old folder as expected (it currently...

Hi again MakeItSo, I created a button with the javascript you recommended but it did not work. I tried to save the PDF to the local computer first just to see if it would do it before I tried to tackle saving it to a network folder. I have been doing some research and found some reference to...

Hi spamjim, Yes, the form is only being used within our department. I would love for them to go to a database set up but management is resistant at this point. At least by saving the PDFs to the server it will save at least one whole tree. It is amazing just how much paper we use just with...

We have a PDF form we are currently using. Once it is filled out, it is printed but not saved online. We would like to go green so I would like to add two pieces of functionality to it in one button. Unfortunately I do not have any experience doing this with Javascript. I would create the...

You are an absolute genius (sp?). Works perfectly now. Thank you so much!!!

Hi Skip [medal], That is exactly what I was looking for. Do you know if there is a way to have it always open to the correct folder? Or can that be just part of the FileFilter? Bob

I have been using the following VB code successfully to send an e-mail via Lotus Notes with the current Excel spreadsheet as an attachment. Now I need to be able to send a second attachment in the e-mail but I need the user to have a dialog box open so they are able to choose the file to send...

kjv1611, Thanks. That is what I was looking for. I do have another question though. Only the first question appears even though there are spaces for each question created in the query. I checked the testing table and the query that creates the space for answers created a record for each...

Hello, I have developed a questionaire for a group of our employees to use for testing a new product we will be purchasing. There are several parts to the product so I have made questions for each part of the product they are evaluating. The main form allows them to choose the part of the...