Search results for query: *

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

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

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

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

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

I have as Access 2002 database that 2 days ago was only 1.2 MB in file size. But for some reason the past 2 days it is now 1.99 GB in size. I have checked all of the obvious places for changes such as records, queries, and duplication of tables. I have also run compact and repair, but nothing...

I have upgraded a database from Access 97 to XP. I have a backend with the tables and the frontend contains everything else. There are two users that can get into the database with no problem. I have one user that when I went to link the tables to the front-end it gave me this error. Could not...

When using the SQL Server Upgrade Wizard I have the option of excluding the Master database. I wanted to exclude this since there is one that exists in SQL 2000. Actually I got an error saying that the sp_help was an issue. After excluding the Master database I thought this would work. For some...

In trying to import a database from 6.5 to 2000 I find that the data has imported with no problem, however, some identities have not. In particular increment and seed values are not coming over. I used the DTS wizard in bringing the database over. Is there another way of importing the entire...

Can SQL 6.5 and version 7 live on the same server with no problem? I am looking at trying to update some of the current databases and have limited resources here. If I attempt to try, any guesses as to what may happen? thanks for your help. JennW

I remember there being a way to set a form so anyone who opens it will only see one page of the form at a time no matter what display settings they have. I cant for the life of me remember where it is though. My default view in the properties is Single Form but it still shows multiple pages at a...

I followed the advice to compile my Access 97 module in Access 2002 and started finding errors. My first one was that a variable was not defined (which seems to me if it was working in the previous version it should work now). In trying to figure out what it really wanted I went to use the F1...

My attempt to convert an Access 97 database to an Access 2002 database has resulted in an error stating that the database had not been saved in a compiled state. It also referenced a memory address error of all zeros. In looking at Microsofts site I "think" I understand this problem...