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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

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

    more newbie combobox blues...

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

    combo boxes and events

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

    combo boxes and events

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

    combo boxes and events

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

    Print on Legal Paper- Everytime

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

Part and Inventory Search

Back
Top