Recent content by embryo

When you say "I have built a form that is used to show the data stored in that table", do you mean you built a form in Access, or is it a form on an HTML page? Using VBScript on an ASP page, you could get the code to render as it would appear in the email, while retaining the actual coded...

I also noticed that while it is refreshing itself, in the status bar of the form window, it says "Calculating..." Steve --------------------------------------- IF WebApplicationProgrammer = True Then ElectronicSheepHerder = True End If

The easiest way to go is to create an ODBC SQL Server connection on your PC, then refer to it from within the connection properties of your ADP. Else, just type in the IP address of the remote SQL server...and probably need to specify the port (default is 1433), like: 123.456.789;1433 Then...

I have a similar application. I put an onclick event onto my "Search" command button which executes this code and populates a big combobox with the results.. This might get ytou started: Private Sub btn_OK_Click() On Error GoTo btn_OK_Err Dim strWhere As String Dim strAnd As String Dim...

You say "when the user opens up a datasheet view"...of a table or a view? What happens if you scroll down to the next to last record, then arrow down to the last...does it still error? I once had a similar issue with a view in that I'd go to the last record, but it was actually going one...

I should also mention that the subform does the same thing when I change to single form as the default view.... Steve --------------------------------------- IF WebApplicationProgrammer = True Then ElectronicSheepHerder = True End If

Hello- I have a situation that really has me stumped. I have a form used to display contacts, and to view the calls made to this contact, a command button is clicked that loads a new modal form for viewing and inputting call information. This form includes a subform that lists the calls in...

Cool, thanks Boris...I'm no longer clueless! Steve --------------------------------------- IF WebApplicationProgrammer = True Then ElectronicSheepHerder = True End If

I want to create a stored procedure that will select all columns from one row of table 1 and insert them as a new record into table 2 of a different database that is located on the same SQL server. I'm sure I could use the Query designer in my Access ADP to accomplish my goal, however I cannot...

Wow...thanks man, that did the trick! Have a great day! Steve --------------------------------------- IF WebApplicationProgrammer = True Then ElectronicSheepHerder = True End If

pwise: Hmmm...I initially tried to use a subquery, but couldn't get past a multitude of ADO errors saying that each of the fields weren't part of the aggregegate expression or included in the group by clause... Got the same error just now using your code, but then added those fields into an...

Hello- I'm trying to write a view whose recordset will be the RowSource for a big combo box that essentially displays a user's search results. I've done this before, but am now having trouble. Ideally, the combobox will display an account name, ID number, client name, reference number, last...

doh!...I reallized earlier today that I didn't really even need that selectedindexchanged event except for the debugging to see what ID was being passed...I put a messagebox on the button's event to see it...works a charm. Thanks a bunch! Steve Steve ---------------------------------------...

Hi again- Still no cigar.. When I did that, it complained about the "Provider" keyword in my connectionstring, so instead of oledb, I switched it from this: Dim conn As New OleDb.OleDbConnection("Provider=sqloledb;Data Source=myconnectionstringremovedforsecuritypurposes")...

Hi Jebenson- When I copy in your code, I get a warning that "Type SqlDataAdapter is not defined" Thanks, Steve Steve --------------------------------------- IF WebApplicationProgrammer = True Then ElectronicSheepHerder = True End If