Search results for query: *

Hey SunKing, I'm having this problem right now. What was your solution?

I have a report that is coming from a query called "PO Query". In the query there is multiple criteria: PODte Between #1/1/99# and #12/31/99# and PoNumber Between 100 and 1200051 I want to display the where clause of the sql statement in a textbox on my report. Is there an easy way...

I have a report that is coming from a query called "PO Query". In the query there is multiple criteria: PODte Between #1/1/99# and #12/31/99# and PoNumber Between 100 and 1200051 I want to display the where clause of the sql statement in a textbox on my report. Is there an easy way...

I have a report that is coming from a query called "PO Query". In the query there is multiple criteria: PODte Between #1/1/99# and #12/31/99# and PoNumber Between 100 and 1200051 I want to display the where clause of the sql statement in a textbox on my report. Is there an easy way...

I have two tables I'm working with: Table 1 looks like this: Vendor_Name InvNumber Store Number Inv_Amt Whirlpool Corp. 5001 450 2500.00 Cooper Tools 5002 609 3800.00 Cooper Tire 4500 501 8000.00 Amana 8011...

One way to copy your database to cd is to copy the actual database file. Usually I store all my database files in the mssql7 folder. Hope this helps.

I have a table that looks like this: record vnd_nbr vnd_name srtinvnbr inv_dte srtinvamt 1 101535821 TRAVELITE 82498 11/31/1999 824.98 2 101535821 TRAVELITE 85666 12/1/1998 500.01 3 101535821 TRAVELITE 65577 5/8/2001 5820.01 4 101535821...

I want my results to be: Vendor_Num Vendor_Name Invoice_Num Inv_Dte Inv_Amt 1 Tyco 10001 10/11/01 5000.00 1 Tyco 10010 11/11/01 6000.00 1 Tyco 10051 12/11/01 2500.00 56...

I don't want to sum the invoice amount. I just need to query out monthly payments for each vendor. If we have a payment on the 1st of every month, then I want to see all 12 payments for that year.

I was wondering if their was a way to query out monthly payments from a table. The table would look like this: Vendor_Num Vendor_Name Invoice_Num Inv_Dte Inv_Amt 1 Tyco 10001 10/11/01 5000.00 1 Tyco 10010 11/11/01 6000.00 1 Tyco...

When a user leaves his NT Workstation idle for a certain amount of time a message appears telling the user to unlock his workstation. How can I stop this message from popping up?

I have a cd with files with a .unl file extension. I have to transfer these files into Microsoft Access or MS SQL Server, but I don't know how to go about doing it. Any suggestions would be welcome.

I have a listbox with 2 columns. One column contains numeric data and the other contains text. I have over 100 records in the listbox. Searching through the listbox can be a pain. I want them to be able to type in a textbox the value their looking for and have it automatically selected in...