Recent content by JennW

Jenny, I am not an expert by any means, but I did the same thing by creating a VB module. I then had it launch to my users by placing it on the servers, then creating a script file to execute it when they logged on. Its just a thought. Good luck JennW

I have several tables in my database. Lets call them tables red, white and blue. Based on information from table red a report is generated. The red table was created from a make-table query. Part of this make-table query was a criteria of a date range. What I am trying to do is have the...

Is there any way to have a database run an append or make table query and not give the users the option of choosing yes or no when asked? I would like for an unattended event to occur. When running the queries, I would like for them to automatically run without showing any information to the...

Kyle, (and everyone else that contributed) thank you soooo much! You just saved me hours of work and frustration. Did I ever tell you your my hero? :) thanks again! JennW

RSGB, I can share some issues I ran into with upgrading my databases from 97 to XP. All modules had to be recompiled and some references needed to be changed. Also, there was a problem where my end-users couldnt enter new data because they were being told there was a "write error&quot...

Kyle, your statements worked wonderfully with one exception. If the country only has one or two columns with numbers in them, the total is empty. How can I get it to count ALL numbers even if there is an empty field? Thanks for your help!!!! JennW

John, thanks, and I agree, it needs to be redesigned. However, there are already over thousands of records in this database that are seperated out this way. So now I have to figure out how to get the totals I need with the existing format. Is it even possible to get these totals? JennW

I have a table that looks something like this.... Country Silver Gold Bronze Total USA 3 USA 7 Russia 3 Canada 3 Russia 3 Canada 3 What I need is to create a total in the...

thank you Jean-Paul, but I tried this and it didnt work. Any other suggestions are appreciated! thanks! JennW

I have a table where I need to create totals of data that has been entered in a field. There are 3 fields. Name, Type, and Number Name Type Number Jones Regular 12 Smith Regular 1 Jones Regular 3 Jones...

This is for the end-users to access the Internet. But I have an idea that may or may not work. I am thinking that if I can create a script for their next login to run a VB app that sort of does the following: Replaces the existing path for their icon of IE on their desktop. The new path takes...

First off, I am pretty much a novice with web design so if you can help me, please bring it down a notch if you dont mind. I have a form which I can either use in HTML or as a .pdf. The intent of this form is to somehow show up on the users desktop the next time they execute their browser (IE)...

I am trying to have a very long form show up one page at a time using the navigation buttons. I have the properties of the form set to single form but that doesnt seem to make a difference. Is there a way to set the form so that only one page (created by pagebreaks) will view on screen at a...

I am trying to publish to my server using FrontPage 2002. When I get to my ASP pages I receive a message telling me that my server doesnt support ASP pages. However, when checking my IIS server, Frontpage 2002 server extensions have been installed. Am I missing a step here? thanks, Jenn

I am not proficient with SQL and have run into a problem that has me baffled. I upgraded an SQL database from 6.5 to 2000 and everything "appeared" to be working well. Then an enduser reported this error to me. Adding User... Microsoft OLE DB Provider for ODBC Drivers error...