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!

  • Congratulations strongm 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: *

  • Users: luismagally
  • Order by date
  1. luismagally

    SQL Update command

    I mean change existing values. I have a query which I display inside a subform, If I make changes to the values displayed, can I update a table with those values?
  2. luismagally

    Update syntax help

    Hi, I've got a some values in a couple of textboxes that I need to update in a specific point in a table (2 record updates, one after the other). I've got the IDs for the primary keywhere the insertion must be made. I need to update the values but don't know the right syntax of the SQL command...
  3. luismagally

    SQL Update command

    I need to update a table based on information obtained from a query which is being displayed in a subform. What is the correct syntax for the update query and if possible does any one know how to read the values of the fields in the query to perform the update or do I need to create a temporary...
  4. luismagally

    Need help to install new Exchange 2003

    As a rule, the exchange server should not be a Domain controller at any time. First test the installation in a test domain and then if successful then move the server into production. The exchange services rely much on Active Directory and on the AD DNS, make sure that the DNS for the AD is...
  5. luismagally

    CAL question, Not sure if I'm in right forum?

    I've been trying to get this question answered but there is no one who can really tell me for sure if this is true. Well, is it true that Windows XP Pro comes with an implicit CAL for connection to Windows 2003 Server or 2000 Server? So, if I bought a Windows 2003 Server with 5 CALs and have...
  6. luismagally

    Insert Into help

    Thanks, will try now...
  7. luismagally

    When Should I Worry about an Offline Defrag?

    Keep in mind that Exhcange 2003 Enterprise has no limitations in database size as to Exchange 2003 Standard which limits the database to 16GB. Also, as stated from Microsoft itself, to do an offline defrag, the space needed to run will be 110% of your current DB size so a 16GB DB will need 17.6...
  8. luismagally

    Insert Into help

    This is the code I've tried so far: insertSQL = "INSERT employeename.value, project_id1.value, discipline_a.value, date_a.value, hour_a1.value, date_a2.value, hour_a2.value, date_a3.value, hour_a3.value, date_a4.value, hour_a4.value, date_a5.value, hour_a5.value, date_a6.value, hour_a6.value...
  9. luismagally

    User authentication

    I'm running Exchange 2003 Enterprise SP1 with a Windows 2003 Srv Ent and GFI Mail Security. Sometimes, every 1 or two weeks, exchange will try to authenticate the users again when trying to connect to their mailboxes, eventhough the domain already authenticated them. I'm no completely sure...
  10. luismagally

    Insert Into help

    Hi, I'm trying to append some values to a table in access using the insert into sql statement, but keep geting syntax errors. The values to be appended come from value in a form: i.e. date1.value, hour1.value, etc. What is the correct syntax to append this values to a table in access, or do I...
  11. luismagally

    How to fill atext or combo box automatically

    I've got a timesheet table which records projects, hours and dates from employees working in any given project. When I select the project name, I want all related fields (customer name and project id) to fill automatically. This are my tables: timesheet projects clients id...
  12. luismagally

    Read values directly from table or query

    I'm trying to read a value into a variable or assign a value to a textbox from a table or query. I'm totally lost here. How do you run a query in VBA and assign a value to a variable (global for example) or how do I read a value directly from a table that is different from the one I've got...
  13. luismagally

    Fill 2 diff txt boxes from value of 1st

    Thanks a lot, so easy and yet so far away from my grasp. Thanks...
  14. luismagally

    Fill 2 diff txt boxes from value of 1st

    Hi, I've got a small problem and don't know how to solve this yet. I've got a combo box reading values from a query. The query reads 2 columns into it: COL_1 COL_2 val1 val2 val3 val4 . . . valx valy Besides the combo box is a text box on which I want to fill with...
  15. luismagally

    DHCP Authorisation.

    This might be a long shot, but this is what happen to me once. While running DHCP on an NT 4 Domain, if any DHCP server in that domain detected another DHCP server not authorized in the particular NT 4 domain, the NT 4 Server DHCP will shut down and give way to the other DHCP server. Sounds...
  16. luismagally

    DCHP Startup in Morning

    What do you do after reeiveing the 169.254.x.x, do you restart the PC or request a new IP. Just to be sure, if you can, connect another computer to that data port and chack if the same happens. Also, try to check out the status of the data cable and port; and for last, try changing your...
  17. luismagally

    failed dcpromo, got to be a DNS issue...

    Could you be a bit more specific as to which are the event viewer messages received. IP address configuration of 1st DC and 2nd DC. I have 14 servers running with windows 2k3 and windows 2k in a domain, and that installation error could come from an invalid IP configuration.
  18. luismagally

    DNS Domain name is same as domain fname for website...help!

    Hi, I've seen your problem before. I have a similar problem, but before trying to explain how to fix this in my own words, try this link. The solution is a split DNS and this guy really knows what he's talking about. http://www.isaserver.org/tutorials/You_Need_to_Create_a_Split_DNS.html
  19. luismagally

    DNS Domain name is same as domain fname for website...help!

    Hi, I've seen your problem before. I have a similar problem, but before trying to explain how to fix this in my own words, try this link. The solution is a split DNS and this guy really knows what he's talking about.
  20. luismagally

    Import part of txt table to DB

    Thanks for the reply, TIMEACT is the start, but I need only specific fields, like the date, nae, etc. ;__IMPORTED__ is where I would stop to read. Like this: TIMEACT 12/20/04 Warner Chilcott:OC's Area Solid Processing Module Castro Castro, Joel Engineering:Eng. CAD Work...

Part and Inventory Search

Back
Top