Search results for query: *

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

Hi All- Let me first start by saying that this is my first foray into the world of VB.NET application programming, though I have over 10 years experience with VBScript/ASP/SQL Server programming. I've read what seems like a million posts on how to use a combobox's selected value as a parameter...

Remou, when I tried using the Load event in the master form, I could not get my code to recognize the controls on the subform, no matter how I referenced them, so I finally assumed that the Load event(and Current) were intrinsic to the form itself, and not controls within it. But...I was trying...

Hi- The AfterUpdate does thr trick, but as I said, I need it to occur when the form first loads IF there is a value in the modifier field.. Private Sub PrimaryDXL_AfterUpdate() ModPrimaryDXL.Requery ModPrimaryDXL.SetFocus End Sub Steve --------------------------------------- IF...

Hello all- I have a form with several subforms in it. One of them has a combo box which a doctor uses to select a medical diagnosis code. There is another combo box which is sometimes used to select a relevant diagnosis modifier. I have it coded so that when the AfterUpdate event occurs on the...

I realize this is several years later, but from the Tools Menu, choose Options...then choose the General Tab and specify what you want ALL reports default margins and layout to be- Steve --------------------------------------- IF WebApplicationProgrammer = True Then ElectronicSheepHerder = True...