Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rene1024

    Help with a Bulk insert statement

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

    Group Policy Questions

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

    Group Policy Questions

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

    Join query question

    Perfect! Thanks you so much!
  5. Rene1024

    Join query question

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

    Join query question

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

    Moving User Databases

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

    Count with VBA

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

    Count with VBA

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

    Count with VBA

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

    Count with VBA

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

    Date Field question

    Perfect! Thank you and have a great weekend.
  13. Rene1024

    Date Field question

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

    Date Field question

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

    Would like to know the number of calls per hour

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

    Locking record when form loads

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

    Help with percentages query please

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

    Help with percentages query please

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

    Help with percentages query please

    Perfect. Thank you! Rgds. Rene
  20. Rene1024

    Help with percentages query please

    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

Part and Inventory Search

Back
Top