Search results

  1. I

    Create and delete table: refresh?? HELP!

    Hi, A very wierd thing is now happening. When I create a table using the following code: Myint = Me![Combo52] strSQL = "SELECT [doctoremail].RESOURCE, [doctoremail].MRN, [doctoremail].D_FNAME, [doctoremail].D_LNAME, [doctoremail].P_FNAME, [doctoremail].P_LNAME INTO [Tbl_AttachPatients] FROM...
  2. I

    Refreshing The Database

    Hi, When I create a table using the following code: Myint = Me![Combo52] strSQL = "SELECT [doctoremail].RESOURCE, [doctoremail].MRN, [doctoremail].D_FNAME, [doctoremail].D_LNAME, [doctoremail].P_FNAME, [doctoremail].P_LNAME INTO [Tbl_AttachPatients] FROM [doctoremail] WHERE...
  3. I

    Make Table with WHERE clause - HELP!

    Hello everyone, I am racking my brains with this one: I am creating a query/table with the following code: Private Sub Command32_Click() Dim strSQL As String Dim var As String strSQL = "SELECT [doctoremail].RESOURCE, [doctoremail].MRN INTO [Tbl_AttachPatients] FROM [doctoremail] WHERE...
  4. I

    Make a Table

    hello all, I have a table like this: Name NUM Date Joe 1 12/2 Joe 2 11/1 Steve 4 7/4 Steve 8 8/9 Steve 3 3/2 Alison 1 12/1 And I want to export only the records related to "Joe" to a new table called "NewTable"...
  5. I

    Transpose a table

    I have the following table in access A B 1 1 1 2 2 3 2 4 2 5 3 6 and would like to write code to make it look like: A B C D 1 1 2 2 3 4 5 3 6 Can anyone help please? Thanks.
Back
Top Bottom