Search results for query: *

I am really a novice at HTML code. I have been able to follow examples to set up an HTML form that allows the user to fill out the form and attach a file. The form contents and attachment send an email. All works great. However the person processing the request now tells me that they need to...

Hello - I have a very simple javascript to run a slide show and would like to add control buttons to allow for manual paging through each picture. I know there are a lot of scripts out there canned and ready to go, but I really like this one because I don't need to code a specific path for...

I have an unbound text box that looks up a Claim Number in a query and shows the appropriate record when go to another form. Need the VBA code to return a message box when does not find any Claim Number to match the one entered. I figured it would be code After Update. I have only found code...

Hello - I have an extract from the mainframe that I am using for a Word mail merge. I would like to convert the name field from all capital letters to proper case. I would also like to eliminate extra spaces between the first and last name. Is there a way I can do this in Word? Maybe with a...

Hello: Through this forum I found a slick way to include a date picker as an on open event for my reports to allow the user to choose a starting and ending date range. Works slick, thank you. In the report header I print the filter to alert the users that the report has filtered data...

Hello - I would like to set up a form to open in Data Entry (acNew) but also allow the user to use the record locator bar to scroll through the records already entered. Sounds like something Access would allow me to do, but I can't find how. Any Ideas?

Hello - I want to develop a form that would list the contents of a table, in this case a list of printed materials that can be ordered. I would like the user to place a check mark next to the items they want and indicate the date ordered. I would like the database to update a table with a...

Let me start by saying I did a really DUMB thing and I know it. I was messing with Access security on a database I am developing. Somehow I have turned on a feature that now requires a logon and password for all databases I try to open from my PC. The problem is, I don't have any passwords...

Hello - Although I am a 20+ year programmer, my knowledge of web development is minimal. I have been using the internet and trial and error to make basic changes to a site that my company had developed a couple of years ago. Is there a way to determine what programming tools were employed...

Greetings: Yesterday (with help from Tek tip!) I added functionality to an Access database to call some mail software from Pitney Bowes and proecesss process addresses in an Access table. The message box from this software indicates that I have 2 records with errors. If I look at the reports...

Hello - I need to run another application from a Macro. The command line to run this application is: "c:\program files\pitney bowes smartmailer\WPCM.EXE" -F:"C:\program files\pitney bowes smartmailer\envelope requests\daily scrub\scrub.dbf" I can use the run app action in my Access macro...

Hello we recently installed Exchange server 2003 after using Groupwise for many years. I have an application (WatchDirectory) running on a pc on the network that sends an automated e-mail to a list of about 60 people whenever a specific file changes. This application doesn't seem to work using...

I am attempting to follow the example in FAQ 705-537 to use shellExecute to sent an e-mail with an attachment from my Access 2003 database. This works fine unless I have an attachment. When I have an attachment I get the following message from Outlook: "Cannot start Microsoft Outlook. The...

Hello I got code from another thread to send an e-mail through Groupwise from VBA. The code was downloaded from here:http://www.mvps.org/access/modules/mdl0059.htm I added the following for blind copies: Dim bcpyRecTo(1, 0) As String . . . bcpyRecTo(0, 0) = "XXX@YYYY.com" . . . .RecBc =...

Hello - I am completely baffled by this, hope someone out there can help me. I have a database that has been around for a long, long time. Today I changed an existing query that drives a report, and one of the users (only one of them) can no longer get the report on her system. She...

Hello - I am having a problem with an Access 2000 database which is running on a PC using the Access runtime. The error is in a box labeled Microsoft Visual C++ Runtime Library. Here is the message: Program:...es\microsoft shared\access runtime\office10\msaccess.exe The application has...

I need to generate a unique customer number for our clients. (If someone has 3 records the customer number must be the same for all 3 records.) I have a table with all the basic customer information including Social Security number. Does anyone have some code that would encrypt the Social...

I recently spent about 4 months developing databases for a business unit to track their activities. The project has not yet been completed. However, before I throw more time at it I would like some sense of how often they are using what I've given them thus far. Is there any utility in Access...

I have an update query that sets a Y/N field to Y, and updates a date field with today's date. I now need to update another field with a value of 1,2 or 3. I need an equal number of 1's, 2's and 3's, so the random number function doesn't seem to be the answer. jcarmody