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

sacsadmin@sacsdistributors.com

Trendsetter, I have done as you suggested. I created a seperate form just with the Calendar on it named FrmCalendar. In the double click field of the Date text box I created an event procedure of DoCmd.OpenForm "FrmCalendar". How do I get the actual parameters passed back to the...

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

NOS: MS Windows NT 4.0 Service Pack 6.0 Steps: Control Panel > ODBC Data Source Administrator ODBC DSA > System DSN Tab > Add Create New Data Source > Select Pervasive ODBC Engine Data Source = Demo1 Description = Demo1 Database Name = ( ) This is where the list is showing all the past names...

RHill7, Thanks for the reply. However, I think my question has been mis-understood. I know that you can delete DSN records as stated in youre reply, but... When creating a new DSN Engine Setup from the ODBC administrator, In the ODBC Engine DSN Setup screen there is a section called...

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.

If we are talking about issues with counterpoint that provide good information to the forum I would stick to the forum. If we just want to general chat about CP I would rather do that thru email direct. Are you using dial-up (phone) or going over the internet for your remote sites?

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

How was the user conference? feel free to contact me about CounterPoint if you want. sacsadmin@sacsdistributors.com

onpnt: You are outstanding! I was getting close, maybe in a few days I would have been able to get it right after I finished the box of oval-teen and sent off for the secret decoder ring. Thanks.

I am trying to follow the logic of this. My understanding of an IF statements...If this is true do a, if this is false do b. So if I am already running a loop until EOF, where to I located the If statement. If I do as follows it won't display. My thought behind this is you do the loop if...

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

synapsevampire: This worked out great! Thanks for the Info.

Thanks for the info Morsing. I will play around with it and see what I can messup...err find! :-)

Touchscreen is the one feature we do not use. We don't really do any "true" retail registers. We do use POS though. What problems are you having with ticket mode? I am not attending the users conference this year. Timing was bad. I went last year and picked up quite a bit of good...

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.

YES! We have been using CounterPoint Since 1998. I just recently installed the CPWireless module. It is fantastic. I push several of their modules to the max with what we do. Would love to chat with you about all that is good and bad with this program. I have looked all over for a good...

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