Recent content by luismagally

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?

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

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

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

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

Thanks, will try now...

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

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

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

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

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

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

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

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

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