Search results for query: *

Hi, I need to import a large .txt file into my SQL 2000 server, when i try using the wizard in Enterprise Manager i get an error when i reach the 7.5 million record mark. The error i get is the following: "Not enough storage is available to process this command" I have plenty of hard drive...

Thank you ehenschel, that article is very helpful, I have a sonicwall TZ 210, I'll see if there's anything i can do at that level as well. Take care, Rene

Hi, I have a visitor account in my domain and would like to prevent that user from accessing sites like Facebook, YouTube, eBay, etc.. is there a way to do that in group policy? Thank you in advance for your help. Best regards, Rene

Perfect! Thanks you so much!

Thanks, I replaced the HAVING line, but now i get a syntax error in union query message. what am i doing wrong?

Hi, I have the following query: (SELECT qryRegistrantEvents.[Confirmation#], qryRegistrantEvents.LastName, qryRegistrantEvents.FirstName, qryRegistrantEvents.Title, qryRegistrantEvents.Organization, qryRegistrantEvents.Affiliation, qryRegistrantEvents.Reg, qryRegistrantEvents.EventId...

I also have a similar question. My server ran our of space, so I copied all my .mdf and .ldf files to a NAS, I then mapped a drive on my SQL server to the folder on the NAS, but I need to know how to point my SQL 2000 server to the new location of the files. is that possible? Best Regards, Rene

Thanks to everyone for all the help. PHV's suggestion worked great. Best Regards, Rene

Still not working, I changed my code to: Dim strMsg strMsg = "This Table is full" If DCount("TableNo", "tblParticipants", "TableNo = '" & Me.TableNo & "'") = 10 Then MsgBox srrMsg, vbOKCancel End If Now I get an error that says "Run-time error '3464' Data Type mismatch in...

Thanks Randy, I don't know anything about programming, this is what my code looks like: Dim strMsg strMsg = "This Table is full" If DLookup("NbrGuests", "Participants", "TableNo = '" & Me.TableNo & "'") = 10 Then MsgBox srrMsg, vbOKCancel I get Run time error 2751 "The...

Hi, I'm developing a dinner registration form. One of the fields on the form is used for "Table number". I would like to write something that checks the number of guests seating at that table and if the number of guests has reached 10 return a message that says "This Table is Full". I'm also...

Perfect! Thank you and have a great weekend.

Thanks for all your help. I'm a little confused though. Here's what I have: When the form loads I've applied the following: Private Sub Form_Load() Me.RecordEntered.Value = Date End Sub --------------------------------------------- And on Current I have: Private Sub Form_Current() If...

Hello, I have a form with two date fields, they both have auto date stamp properties (Date()), so whenever the form is opened the fields get updated automatically to the current date on the PC. I would like to have one of the fields update only once (when the record is created) and if the...

Hello, I have a table that logs calls made to hour hotline. I have a table with the caller's information along with a field for date of the call and time of the call. I would like to design a query that tells me proximately how many calls are received per hour, per specified date. This would...

Hello, I have a split database application where users pull up records and do data entry on. I would like to write a piece of code that says that when the form loads the record that comes up is automatically locked so that no other users can bring up the same record. How do I accomplish this...

Thank you again for taking the time to reply to my messages. Sincerely, Rene

Borislav, Thanks again for your help, how can I display the number of yes and no groupped by city? I tried to figure it out from your previous post, but my sql is very weak. Rgds. Rene

Perfect. Thank you! Rgds. Rene

Hello, I have a table that contains a column for city and another column that contains yes and no data. How can I determine the percentages of yes and no and group them by city? Rgds. Rene