Search results for query: *

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

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

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

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

I have a file exported from Quickbooks which I need to import to a table. The problem is that I need to delete or bypass the first column of the file as well as a variable number of rows in the file. From then I need to read the data by chunks into a table. Here is a sample of the data...