Search results for query: *

Our company is upgrading all user computers to Windows 10 with Office 2016. I have an Access database (mdb) that has code to open an Excel template (xltm), populate data, and then allow the user to save the file. The code worked fine on Windows 7 with Office 2010. Now, when the code opens the...

I have an Access 2003 mdb that I created for a client at least 10 years ago. They've asked for some updates and now I'm trying to make changes to the forms. After I began making changes, and saved those changes, the totals at the bottom of the subform (in the form footer) stopped working...

Ok, I've got a really weird issue here... I have code in an Access 2010 database that looks to see if an Excel file for a particular account exists, and if it does, it opens the existing file. If a file does not exist, a new one is created from a macro-enabled template. The original...

I have an Access subform which has totals in the footer. The calculated field should display the total premium for the displayed account. The subform has worked just fine until we moved to 2010. However, I have two employees using Citrix to access the database. When they view the form the...

I was helping someone add the final touches to a long process and ran into a strange problem with InStr. The long process included a macro which is filtering data raw data by client and copying the data to a new worksheet. On the new worksheet, a pivot table of the pasted raw data is created...

I've got an Excel 2007 workbook that has four data connections. Each of these is pulling data from an Access database. I have charts that are using the data. I recently modified one of the queries in the Access database, but now when I refresh the data, the spreadsheet does not reflect the...

I work mainly with Access and have been asked by a friend to help with a FileMaker Pro database file. The purpose of the FM db is to display items at a museum. The interface is already created but the client would like a "small" change. The user first searches for an item such a moccasins...

Perhaps this isn't complicated, but I certainly can't figure out how to make it happen. The data I have looks like the example below: NAME LINE POL# EXP DATE Customer A Auto XYZ123 2/29/2012 Customer A Prop ABC987 8/31/2012 Customer B Auto CTE456 3/31/2012 Customer...

I have a calendar which displays classes scheduled on each day of a given month. When I click on a day, I have a list box below the calendar that displays more details about each class scheduled on the selected day. I have 15 classrooms and I'd like to see all classrooms in the listbox, and if...

I am a newbie to SQL syntax and triggers. I have a website someone else developed where the users have a username that is the same as their password. These two values get set when the user registers for the site. I would prefer the user have the ability later to update their email and have...

I've searched this forum and others, and have tried what others have suggested, but I just cannot seem to get my code to work. I have a very simple table with four fields. AdminNewsID (autonumber) OwnerMsg (memo) OrderMsg (memo) EditDate (date/time) I have a page that displays the content...

I have an Access application that creates an Outlook email message and populates the message with the user's default signature. Recently my users created new standardized signatures with our new logo in it. When the emails are created from Access, the image does not appear and has a red x. If...

This is a strange problem and recently started occurring. I have a process for printing 2-3 reports from an Access 2003 database. The user clicks a button on a form and the desired reports are printed. Report A is a letter, Report B is an Access report and Report C is an invoice. Reports A...

(I am using Access 2007, WinXP Pro) I have a couple of reports that are output as a result of a search a user has made where a number of fields are available as filters. My code creates the filter, generates a temp table, and then displays the results to the user based on what resides in the...

(I am using Access 2007, WinXP Pro) I have a couple of reports that are output as a result of a search a user has made where a number of fields are available as filters. My code creates the filter, generates a temp table, and then displays the results to the user based on what resides in the...

I have a countdown script that I got from a book and it works great in IE. Firefox and Safari however do not. What do I need to do differently? the code in the head section: <script language="JavaScript"> <!-- hide script from old browsers now = new Date Uvote = new Date (now.getYear()...

I have been contacted by a "client of a client" regarding their website. The developers of their site closed shop three years ago and now they are having an issue with the admin section where they go to view credit card payments made by their clients. Here's the error...

I have read the other threads mentioning this same problem and am not sure the solution was really ever explained, other than to reinstall Windows XP. I have an Access 2002 application that is installed on a client machine using the Access Runtime. The program was working fine until they...

I have some code that is populating a combo box with locations and it is supposed to add "selected" to the option that was passed in the query string. However, the "selected" portion is not working. <% Dim rsLook Set rsLook = Server.CreateObject("ADODB.Recordset") sSQL = "SELECT...

I know there is probably an easy answer to this but I'm tired of spinning my wheels. I've got a frames page with the nav link on the right side that will determine the content of the center frame. When a user clicks the link "FAQ", the center frame will populate with faq.html. What I'd like...