Search results for query: *

I have a select statement that I am trying to open but it never makes it past the recordset open command. Here is the function that is causing me grief. Public Function DeptTimes() Dim rst As ADODB.Recordset Dim cnn As ADODB.Connection Set rst = New ADODB.Recordset Dim strSQL...

I have a grid with multiple bands that need to be sorted. When using rs.sort it is only sorting band 0 and I need to apply the same sort on all bands.

Could someone give me an idea of how I can round numbers to the nearest five in a select statement? Thank you, Any help would be appreciated.

This is my sql statement: stsql = "SELECT CO_NUMBER as CoNumber,CO_LN_NO as Line,COMP_WC as Parent,COMP_WC as Item, " & _ "ITEM_DESC as ItemDesc,QUANTITY as AuthorizedQuantity, COMP_PRICE as ListPrice, QUANTITY as OriginalQuantity FROM " & strKnzFSDataSQLPath & "FSExtract_HCPCFG WHERE CO_NUMBER...

I am using this code to find line breaks in a string of text retrieved from our ERP system and replacing it with a carriage return on my report. Dim strNotes As String Dim strFormatNotes As String Dim intEnterPos As Integer Dim i As Integer strNotes = Me.COLIN_XTXT ReDim strTemp(0) As...

I have this sql statement in a module strSQL = &quot;SELECT SUM (IVC_QTY * InvoiceUnitPrice)AS Sales&quot; strSQL = strSQL & &quot; FROM tblSalesDbMaster&quot; strSQL = strSQL & &quot; WHERE IVC_DATE >= &quot; & dteBegin strSQL = strSQL & &quot; AND IVC_DATE <= &quot; & dteEnd Set rst =...

I have a form that users enter order numbers in to find them. This form has only one field that the user can enter into. I would like to make it select everything in the field after the user enters the search criteria. I have tried setting the focus on this field and have also tried doing a...

I have an Access 97 report that I am trying to send via e-mail. If I send it as an .rtf file it will work, if I try to send a snapshot file it will not work. It doesn’t give any error messages, and appears to be working up until it starts outputting to the e-mail message. At this point instead...

I would want to give users the ability to select a record in a table with a combo box. Sounds simple enough but the twist is that it takes two fields to make the record unique. Maybe my question should be, is it possible to bind a combo box to two fields?

I have a pc running Win 95 that does not have any icons on the desktop. Icons like My Computer, Recycle Bin and Network Neighborhood are gone. Is there a setting that I can change that will show the icons? Thanks

I have a listbox populated with items that are in our catalog, and would like the user to be able to select one or many to use as criteria in a query. I have used code to create my criteria string eg. &quot;PB5&quot; or &quot;PB9&quot; or &quot;PB11&quot; and I have also taken the results of the...

I have a report which takes the date and time an order is scanned to a department, as the &quot;time in&quot; and date and time that it is scanned to the next department as the &quot;time out&quot;. Using the DateDiff function I get the amount of time an order was in a department. Unfortunately...

I am trying to find a record in a table using an SQL statement in code. Dim db As Database Dim rst As Recordset Dim strSQL As String Dim strDate As String Dim strTime As String strDate = &quot;#&quot; & Me.Indate & &quot;#&quot; strTime = &quot;#&quot; & Me.Intime & &quot;#&quot...

I am trying to set the focus to a control depending on user input. I am using me.controlname.setfocus to do this but it is not working. Any ideas? Thank you

I have created a form in Access 97 where I have used the month view control. This works fine on my computer and a couple of others, but appears to be a problem on a majority of workstations. Is this not a common control that is installed with Access? And if not can it be installed separately...

I am trying to search a table for a record based upon a variable I supply. Here is the code I am using; Dim strCust_ID As String Dim db As Database Dim rst As Recordset Dim strSQL As String Dim EQP As String Set db = CurrentDb Set rst =...

I am trying to install Windows 98 on a 486 pc. After formatting the hard disk and beginning the install it does the scandisk. This is where it pops up the message Error: PCI Read Configuration Error. This error can not be fixed by scandisk. It then cancels the setup. Anyone have any ideas? Thanks

I am running a query that is trying to get parameters from a form. It bases the selection criteria on the value of an option group. I believe it needs to include quotes to make it a valid criteria. This is the statement I am using...

I have a database that when I open it I want to open it exclusively. I have set the default open to exclusive in the options menu, but everytime I open the database from a shortcut or recently used file list, it opens in shared mode. If I go through the menu picks to get to my database it will...

I have a number representing a week, (1 thru 52) is it possible to get the actual date that the week starts and ends on?<br><br>Thanks