Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by embryo

  1. embryo

    Need help showing HTML text in form.

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

    subform in datasheet view keeps refreshing!?!

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

    "HELP", I need your assistance on how to share MS Access projeect

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

    Find list of records from search of multiple fields in Access DB

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

    MS Access 2007 closes and errors when clicking on las record

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

    subform in datasheet view keeps refreshing!?!

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

    subform in datasheet view keeps refreshing!?!

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

    select from one table/insert into another in different db/same server

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

    select from one table/insert into another in different db/same server

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

    combining views to populate combobox

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

    combining views to populate combobox

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

    combining views to populate combobox

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

    more newbie combobox blues...

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

    more newbie combobox blues...

    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")...
  15. embryo

    more newbie combobox blues...

    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
See more

Part and Inventory Search

Back
Top