Is there a way to position in a listbox using more than one character... in other words, I would like to start typing out a word and have the listbox positioned based on ALL of the characters that have been typed, not just the first character... similar to the way it works for a combo box.
After having the user populate fields on a form, I would like to allow the user to click on a button that would merge the data from the fields on the form with a Microsoft Word Template, save the updated Word document to a predetermined path and name, then open up a new e-mail (email address is...
Using Access 2000 and Outlook 2000
I am trying to create a new task in Outlook from within Access. I have it working if Outlook is already open. Can anyone share with me the code that will check to see if Outlook is open, and if not, open Outlook in order to create the new task?
Thanks!
I have four products on a form where the user will enter the prices for products. If they input a comma with the price (when the price > 999.99), the resulting form list sees the extra comma as a delimeter and my results are messed up:
My list entries look like the following:
PRICE equals...
I am trying to populate a subform in my form using a make-query based on the value selected in a combo box on the form. When the value selected in the combo box changes, I want to change the data in the subform. I am then allowing the user to select or deselect individual records on the...
Can anyone give me ideas on editing tools I can use to allow users to enter content in one or more textareas on a form and give them the ability to apply a nice format to the content?
I know about ewebeditpro and activedit. Are there others?
Thanks!
I have a simple search string being passed from a form that can contain multiple words separated by spaces.... "word1 word2 word3".
Can anyone give me ideas on the simplest way to create a stored procedure that will select any records in a table (table1) where a specific column...
Can anybody tell me what I am doing wrong here? I am trying to create a simple popup. It works fine in IE, but not in Netscape 4.72. In Netscape it is giving me the error "The parameter is incorrect".
Following is the code I am using:
Code for the driver:
<html>
<head>...
I have a shopping cart checkout form with multiple image submit buttons on it including "update count", "calculate shipping" and "finalize order". My problem is... what is the best way to hold onto the checkout form values such as name, address, email address...
Is there an easy way to reattach CDX files to the free tables in my database?
I am trying to convert the data from the tables in a previous version of our application into the newly formatted tables in our new application. What I have done is copied the DBF files from the old application...
What is wrong with this code? I know it something basic, but I cannot figure it out? I am just trying to figure out how to pass a field value from one form to another. In this case when the button for TestForm0 is clicked, the program opens up TestForm1. I am trying to get TestForm1 to...
I am trying to set and pass a local parameter from a form to a program that runs an SQL / report.
Click Event Code
parm1 = ThisForm.formvar1.Value
parm2 = ThisForm.formvar2.Value
parm3 = ThisForm.formvar3.Value
DO procedure1 WITH parm1, parm2, parm3
Program Code
PROCEDURE procedure1...
I have a form that collects user input to be used for producing a report. When the "Print" button is clicked, I want to call an external program to print the requested report. How do I pass parameters to and receive parameters in the print program?
[code]
** Call report program from...
Why am I getting a "File is not open" error? The following code inserts 1 record into the dave_test table but when it hits the endscan command, it gives me the error. I am trying to get it to loop through cursor4???
Thanks!
use next_nbr in 2
use dave_test1 in 3
select * from...
I am creating very simple reports that are populated by cursors. My problem is that when there are no records in the cursor, the report does not execute. I need the report to print with a message such as "No Records Found".
I know it is a simple concept, but I can't seem to find an...
I am trying to update a column in FileA (field1) with a column from FileB (field1) where the key fields, field2 and field3, match.
The program is updating the field, but with blanks instead of the value from fileB.field1.
Any ideas on what I am doing wrong?
Thanks!
UPDATE fileA;
SET...
Can anyone tell me what I am doing wrong with this basic Update SQL statement?
It seems like a pretty simple problem. I am trying to update a column in FileA (field1) with a column from FileB (field1) where the key fields, field2 and field3, match.
What am I missing?
Thanks!
UPDATE FileA ...
Can someone please point out where I am going wrong in this basic SQL statement? In FoxPro 6.0, I am trying to write a simple query program. When I run the following SQL, I am getting an error that reads "SQL: Subquery is invalid".
select *;
from cont_det;
where cont_det.contract in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.