Search results for query: *

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...

Lovejoy, I am trying to come up with the same sort of solution. Have you found any answers on this yet? thanks, JennW

Here is my scenario: I have a project that was originally created in InterDev. I cant publish from InterDev because the project files seem to be missing, so I opened everything up in FrontPage. They all open fine. When I go to publish I get a server connection timeout. So I increased the...

My enduser was upgraded to OfficeXP including her Frontpage. She was able to open all her files ok, so she went ahead and published to the server I set up. After publishing with the XP no one can see the pages any longer. I upgraded the server extensions to FP2002. Now the MMC in IIS tells me...

I am trying to create a query that will consolidate fields of information into one alias field. For example: The alias field should be comprised of information that appears first in this order of fields. If there is data in DPS1, use that data..otherwise use the data in DPS2....otherwise use...

I am trying to make my command button open up a file in Microsoft Access. I know this must be pretty simple and I have tried multiple things in my private sub, but nothing seems to work. Is there a code somewhere that can help me? thanks for your patience and help. JennW