Search results for query: *

Ref thread690-1816512 I have a site where Avaya 9611 phones are intermittently experiencing a weird ring sound when called station to station or on inbound calls. It sounds like a gurgling noise. It lasts about 15 seconds and can't be interrupted by lifting the handset. The closed thread...

I'm getting error 3734 (The database has been placed in a state by user 'Admin' on 'SOLS-DC1' that prevents it from being opened or locked.) when two or more users attempt to simultaneously insert records into the same table in the backend database. Sometimes it's error -2147467259 with the...

You are right Pat. I got my hands on another MB and all is well. I had already flashed the MB firmware. Thanks again.

...entire database builds using SQL. If you just need a quick mod then use the DAO model. Here are a couple of examples. Hope this helps. '*****Add a field to a table************* Dim db As DAO.Database Dim fld As DAO.Field Dim tdf As DAO.TableDef Set db = Application.CurrentDb Set tdf =...

I searched around any saw nothing on this issue. I have an ML350 G4p box with 641 array controller and a full cage of 36gig drives on raid 5. During warm boots sometimes one or more of the disks will go offline. I have to power the box off and cold boot to get the array online again. I have...

Thanks again Pat. The 5.0.7 recut media was the answer. Also, this box is the only ML350 G4p in my rack. Apparently the 'p' model had some issues that were addressed in the later installation media.

patw, thanks for the reply. This is quite a head scratcher. I have tried the ciss driver from EFS 5.66, 5.68a, 5.770a and 5.790a. I got the 5.66 driver from the installation media for OS5.0.7. and used the EFS utility to create the diskette. I got the other versions from the HP website and...

I need some help with an installation of SCO Open Server 5.0.7 on an HP ML350 G4. The server has a 642 Controller that has a RAID 5 array configured. I am able to boot from the install CD and load BTLDs for ciss and ad160 (there is also an Adaptec 29160 that has a DAT drive attached). The...

...= conLCS strSQL = "" strSQL = "Select sTableName From tblLinkedTables ;" Set rstLCS = conLCS.Execute(strSQL) lngTotal = DCount("*", "tblLinkedTables") ' Open the progress form and set its properties DoCmd.OpenForm "frmProgress" sMessage = "Ready to link to ODBC tables" UpdateProgressMeter...

That immediate if is valid in the querey editor. You just don't have to work so hard to string it together.....drop the double quotes, the underscores and the ampersands. A good way to zero in on the correct syntax for this type of thing is to use the expression builder in the query builder...

Good question....No good answer why I have that statement....removing it fixes problem....Thanks.

If I use that exact same sql stmt with a datareader then I can bind it successfully to the grid: '-------------------------- Dim conLaundry As OleDbConnection Dim cmdLaundry As OleDbCommand Dim rdrLaundry As OleDbDataReader conLaundry = New...

I am having trouble binding a dataset table to a datagrid control. Here's the code that yields no rows in the grid. I'm sure that the dataset table contains data. '--------------------------------------------- strSQL = "SELECT tblBudget.lID, tblBudget.iMonth, tblBudget.lPounds, " _...

Duh! Thanks.

I'm trying to format a telephone number in vb/aspx page. I'm missing something. When I use: sGMTollFree = Format("8775555555", "(###)###-####") the function returns the format string (###)###-#### instead of the input string in the proper format (877)555-5555. Please reply if you can shed...

Well that's a little hairy to offer a good solution without the data but sometimes the use of a report table is the best solution when you need to sort at group levels but still need the detailed data. For example: In the report open event you could populate a report table with the results of...

Also can you paste the textbox calculation logic?

Can you paste the query text?

Have you considered adding a field to calculate this performance value into the report datasource query and grouping on it there?

I have read many threads and a FAQ on the subject of faxing Access reports but I still need to ask if anyone has overcome the problems that I am experiencing. I need to programatically control the fax process and have only seen two methods for this: 1) Using the Outlook model (I don't like...