Search results

Correction, if the database window is closed, it seems to work as well. Only when it is open and displaying a page other than the tables page... Very frustrating, any help would be appreciated. Thanks, josh

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

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

That was it!! Thank you thank you thank you... Josh

Now, after trying to make Myint a String, i get the message "Invalid Column Name 'Myint'"

Well, here is my code now: Private Sub Command32_Click() Dim strSQL As String Dim var As String Dim Myint As Integer Myint = Forms![emailopenonedoctor]![Combo52].Value ' the box that the user uses to select the resource number strSQL = "SELECT [doctoremail].RESOURCE, [doctoremail].MRN INTO...

Hi Rob, Thank you for your suggestion, I had actually already tried that and it did not work. Can you please explain to me what a "parameter query" is? Thanks, Josh

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

Yes, that is exactly what I need to do. But I would like the user to select the person they want to be in the query using a combo box called "select person". Any chance you could post the code you would use to do the queries that you mentioned? I so much appreciate your help. Thank you. Josh

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

Thank you so much for your interest. Let me try this a different way. I have the data: ID NAME 1 JOE 1 DAVID 2 GEORGE 2 GARY 2 RONALD 3 JEFF and I need a table that is like this: ID NAME1 NAME2 NAME3 1 JOE DAVID 2 GEORGE GARY RONALD 3 JEFF Does that make...

It's actually needs to be automated and therefore in code. The C & D are variables that are created once the data is transposed... Thanks for your help. Josh

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.