Search results for query: *

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...

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 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)...

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...

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...

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...

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...

Hello All, History: I have a database that opens very slowly. It takes easily between 45-60 seconds to open. I have stepped through the program and found exactly what command is causing the problem. The form "ECD Splash Screen" is designated as the form to display in the start up options...

Hello all, I have the following code which executes when each person opens the database. It is located in the "On Open" event of the splash screen that first appears when opening. Because we are a 24/7 operation and the information in the database is CRITICAL, I have built redundancy into the...

Hello All, I have the following code: If FSO.FileExists(strServerPath) = True Then Call pfECDServerReLink End If If FSO.FileExists(strServerPath) = False Then If FSO.FileExists(strMCUPath) = True Then Call pfMCUReLink End If If FSO.FileExists(strMCUPath) = False Then...

Hello all, I am attempting to do something I have never done before and was wondering if any of you wonderful people had some suggestions. Here is what I am trying to do; the employees are looking at their work schedule for that shift in a web browser which auto refreshes every 60 seconds...

Hello all, Through VBA I would like to save only one sheet from an Excel workbook as a single file web page. I can save the entire workbook but haven't figured out how to save only the one sheet. Any help would be greatly appreciated. Thanks, Bob

I am attempting to refine/re-build an if statement in excel VBA. I have not done a lot of date and time comparisons. When the user clicks the button, Excel need to evaluate the following: Note: the cell F2 contains a date only, not a time. Is the current date & time between 2330 hours on F2...

Hello All, This question is not about database design but does have to do with Microsoft Access and was hoping someone might be able to point me in the right direction. I am looking for a free In-Out Status Board database. Our old program crapped out finally and before I spent the time to...

I am creating a stats report in the report footer. I am looking to count the number of times the platoon field is not filled in along with if the complaint was founded or unfounded. Here is what I have in the control source for the text field. =Count(IIf([Founded/Unfounded]="Founded" And...

Ok, I am admit it. I am totally stumpted. I have a report which lists all complaints received for a user defined period of time. For each complaint there can be an infinite number of employees involved. I therefore have a subreport that lists all the employees involved for each complaint...

I have been searching the forums and internet for a way to copy a specific range of cells and paste them into the body of an e-mail using Lotus Notes. I have the following code which appears to do everything (including the copy) but will not paste the cells into the body...

I am attempting to do a tricky update, so here is my best explanation of what I am attempting to do. In one table I have a bunch of questions broken down into categories (a field indicates the category number), in another table I have the responses (one-to-many relationship). If person A...