Just to add (for anyone with a similar problem) I found another solution.
If I add a new command button with the wizard enabled, it gives me the option to "Save Current Record" whereby I can add additional commands after to the onclick function.
Sorry for troubling everyone over a stupid...
First I'd like to say that your answer worked beautifully.
In reply to your question, the form for record entry is bound to the only table in the DB. After entering data in the fields, a cmdButton opens a second form that should have certain fields populated with the info from the new record...
I searched for this term and didn't find anything, but I might be phrasing it wrong also.
I'm looking for the code (primarily for a command button) that saves the information entered in the current form to the DB/table as a new record without the user being forced to close the form and reopen...
I searched previous threads and found nothing, although I'm not sure if I even searched for the correct terms. I'm a total novice at Access developing. Anyway, here's what happened:
I have 2 forms- 1 inputs and displays general records from my table. The second displays specific fields from a...
What about on your index page using a meta-refresh with a value of "0" to automatically redirect them to the SSL side? PayPal does this and it's pretty smooth.
What type of audit are you using? Is it possible to submit an identical index page on the SSL side to the auditor, while leaving the...
I should add for clarity that the "action" page used is the same page I'm starting from. Should I change this so that the entry/search page isn't the .ASP page executing? Would this fix my problem?
Jim Schuuz
{ F1 = my.friend
}
Do you mean that when you save the page in FrontPage as a relative link but then reopen the page it mysteriously turned into a static link?
Relative hyperlinks such as the one you gave as an example <a href="lfbook.asp"> are turned static to the website you are on by the webserver and browser...
Version of Access this one user has? (Verify it from machine to machine from the Help>About dialog to be safe.) Anything other than 2000 or what every other user has will cause this behavior.
Jim Schuuz
{ F1 = my.friend
}
Have you checked for the presence of a HOSTS file in other directories?
Have you imported the entries in your HOSTS file yet?
What OS are you using?
Jim Schuuz
{ F1 = my.friend
}
Anytime you use IE to d/l a file it stores the file in the IE cache, then "copies" it to the d/l location you specified. It does not delete it from the cache. If you manually clear your cache, the download is still resident in your memory. If you clear the IE cache, and do a cold (power off)...
Macromedia (as do most companies) offers substantial discounts to genuine 501(c)3 non-profits. I'm sure as many people will agree as will disagree though that it is the "friendliest".
Personally I would stick with Front Page, since you're currently all Microsoft to this point and MS seems to...
What my problem is: The text records in my dBASE DB are case sensitive, and I can't change that. Therefore I have tried to make sure all data is in UPPER CASE for uniformity of queries. Customers use an .ASP page to check for pertinent records, but they aren't returned non-casematching lookups...
I am realizing that everyone's (very helpful) suggestions are meant for use by executing the SQL query directly on the page, which I think is the reason why I haven't had any success in spite of everyone's wonderful assistance thus far. My problem is that I am attempting to use FP's data results...
I'm taking a stab in the dark here by guessing you want an .ASP page that will allow a query to your email when out of the office (or not at home)?
If so, look into any of the remote desktop programs available like PC anyWhere or http://gotomypc.com
When Outlook is open, the database is...
...from a subdirectory with few files in it. Maybe if you tried changing the time-out values per connection on the webserver, just a thought.
*NOTE* When creating a new page using the File>New>Page command, choosing 'Save' calls the 'Save As' command anyhow, so you would still be correct that...
UCASE hasn't worked either.
Once I solve the problem with the search finding all upper and lowercase records, I will spend time looking for a utility that will convert any lowercase letters to upper in the DB.
It is a dBASE database with the BDE.
Other things to note: I have complete control...
OK, I tried 2 different uses of UCASE and the webserver crashed both times. If anyone can give me an example on how to apply it to the following (abbreviated but working) code I would appreciate it!
SELECT Ord.REFERENCE,
Cust.EMAIL,
FROM Ord
INNER JOIN Cust
ON Ord.CUSTNUM = Cust.CUSTNUM
WHERE...
Yes, that's one of the possible solutions I'm willing to use. About 95% of the data was entered in upper case for continuity, but some human involvement has obviously led to mistakes. (Not mine LOL)
I have not tried UCASE. I will get the syntax for it and try it shortly, and post the results...
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.