Rick,
Thanks for your reply. I get only the error message noted above when I try to open the database -- no logon prompt.
In the secured.mdw report I find the following:
Workgroup Information File: \Secured.mdw
User Name: MyName
Workgroup ID: swtrial1
Groups:
Name: Admins
Group ID...
...learning to do! The end result is this error message when I try to open the secured version:
You do not have the necessary permissions to use the *:/*.mdb object. Have your system administrator or the person who created the object establish the appropriate permissions for you.
I've been...
Thanks for the reply. I thought dateserial relies upon the system date. I need to generate the date based on user input. Can you enlighten me further? Leslie Shippee
Information Analyst
I need to generate a date that is the last day of the month from a given, changeable start date based on two optional time periods, 18 or 36 months. That is, the start date is entered in one field, the number of months for the time period is in another. The third field would contain the last...
I have a series of reports based on queries in a database that accepts data input via a web form. The queries were designed with ascending sorts on selected fields.
SELECT tblRegistrations.ProjectNo, tblWorkshops.WkshpName, tblRegistrations.LastName, tblRegistrations.FirstName...
Erin,
You could try this. Open the report in design view and select the group header. Click the grouping and sorting button and look at the options in the bottom half. You can elect to keep a group together with just the first detail or with the entire group. If you choose first detail, the...
For drowland --
Thanks for the tip. I was able to get the query to run in the underlying database by changing to date(), but . . .
I am still getting the criteria mismatch error message when rerunning the database results
The results worked beautifully when I had the date field cast as a...
I have a database built from form fields in a web form which included a date field that was initially set to a text data type. I can sort with this field but can not perform calculations or use date/time functions. I want to construct a macro or delete query in the Access2000 database that...
Initial problem:
Have a database built from form fields in a web form which included a date field that was initially set to a text data type. I can sort with this field but can not perform calculations or use date/time functions. I want to construct a macro or delete query in the Access2000...
I've put the code below in a page on my site per the instructions BEFORE the <HTML> tage on the page:
<%
pagePassword = "<STRONG>cesaone</STRONG>"
passwordForm = "<STRONG>employeeswelcome.htm</STRONG>"
IF Session("pwfield") <> pagePassword THEN
IF...
Thanks Pete & Robert,
My host company is happy to set me up with additional pointers; however, they say they can't (won't?) have it point to a subdirectory of the site, only to the main page. Do I need a new host company or only to enlighten them to the possibilities? Have you had your host...
Adding to what Delorfra says, FP2000 has the nifty database results wizard (Insert, Database on the menu) which, if you don't have the database connection already set, will do that for you (the database must be imported to your site first). To do this, choose File, Import in FP2000 which will...
Has anyone heard of using a "phantom" or "dummy" url for a web site? If so, how does one accomplish this? This would be a "friendly" web address that connects to a longer, hard to remember url where the site actually lives. The site in question is not actually...
I have command buttons on a subform which progress through subsequent years of data on the subform -- i.e. the 1998-99 button shows data for 1998-99, the 1999-00 button shows data for 1999-00. At the suggestion of the person who created the buttons, I've tried adding a button for this year...
I can browse to the default homepage the provider has posted at the provided IP site, but my site is not yet uploaded because of this problem.
I am using frontpage components and need extensions -- need to use HTTP as far as I know.
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.