Search results for query: *

Is there a way to set the start week in a query that is filtered by week? Example: Our fiscal year starts on February 01, not on January 01. So I need week 1 to be started on February 01. Also, is there a way to control the formatting. On my report is shows the week output as a number of...

Using Microsoft Access 2000 I have the following: Database: Trailer Inventory Table: Tbl_TrailerNo Field: TID (AutoNumber, PrimaryKey) Field: TrailerNo (Number) Table: Tbl_DateDetails Field: DID (AutoNumber, PrimaryKey) Field: TrailerNo (Number, ForeinKey) Field: TDD (Date)...

When creating a new ODBC Engine DSN, I get the error: "The database name must be unique. The specified name already exists. Please specify another database name." The drop down list is getting rather long and I would like to recycle some of the names. Does this make sense?

What is the forums best recommendation for development software. I need to develop an inventory tracking put away retrieval system, but want to utilize either Palm OS wireless or Pocket PC.

I have a form with a submit button. When the user clicks the button it calls page.asp, which opens in a blank window. This all works fine, but I want to be able to control the browser size depending on the amount of data returned from the asp query. for example, I do not want a toolbar, but...

Currently I have the code listed below. When the query runs the ASP code produces the correct output if there is a record match, if there is not, it just generates a blank screeen. How do you get a screen to display "no records found in search" instead of the empty screen. Is this...

Just a general question: How would a person setup the DNS domains in a test lab? Example: I want to build the root "." DNS server, a .com .org DNS server, and then a client DNS server. This is strictly for learning and "fun". Thanks for your time.

OK I have looked in all the threads for the past month and did not find a question similar to this one. I will try to keep it simple. I have composed an Access Database that mimics a silent auction. The clients bids are timestamped as they are placed in the database. The timestamp is output...

I am using a program called CounterPoint which uses a pervasive 2000i database. I am also using Crystal 8.0 developers edition. The date field in the database contains date data but I believe is in string format (ex. 20030218). The select query is setup for the user to select a (string)date...

Situation: I have a website hosted on an ISP's server. However, they are only a unix shop and will not allow me to run asp. But, they have given me a static IP address and a url that points to my internal webserver which is running WIN2K Server and IIS 5.0. I have a default.asp page running...

This is a simple project really. I have a table that will be uploaded to a webserver once a week. The table simple contains two fields field one: bidnumber field two: lot number. I would like the client to enter in the bidnumber in a search box and query against the table and only output lot...

Software: Using Access 2000 on Windows 2000 service pack 3, running a System DSN to a Pervasive ODBC Client Interface. The Access database is linking to tables in the Pervasive Server. I am trying to run a parameter query with the table tixhsthdr on the field ticketdate. The table requires...

I have two fields Description1 and Description2 pulled from a linked table using a query in Access 2000. This query is used to generate a report. Description1 and Description2 are 25 character long fields in the linked table. I cannot modify the properties of the linked table. Some of the...