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!

  • Congratulations gkittelson 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. Fredgarner

    Relationships have disappeared

    When I go into the relationships window, all the relationship connecting lines have disappeared, though the tables and queries are still there. The rest of the database is behaing as normal, so the relationships obviously sitll exist- how do I show them again? Miss Fred Garner
  2. Fredgarner

    database does not allow 2 users

    All users have permissions to create and delete files and can do so unless I have the database open. Miss Fred Garner
  3. Fredgarner

    database does not allow 2 users

    The database is located on the network. I already know that it is not possible for one of the other users to open the database when I have it open and would like to know how to change their permissions. Miss Fred Garner
  4. Fredgarner

    database does not allow 2 users

    dhookom, I am not quite sure what you are saying- I wish for all users to be able to use the database at once. Best wishes, Fred Miss Fred Garner
  5. Fredgarner

    database does not allow 2 users

    When another netawork user tries to use my database created in Access 2003, the following messaage displays. The database has been placed in a state by user admin on machine DG02DC1J. This prevents it from being opened or locked'. Clicking 'Help' brings up the following: Error 3734: This...
  6. Fredgarner

    Show nothing in a calculated control

    Is it possible to make a calculated control blank if the total is zero? It is straightforward to do this if the field is Null. The calculation is =Sum([No of shares bought/sold]*[Current Price]) Miss Fred Garner
  7. Fredgarner

    Password only selected objects

    Is it possible to password protect only a couple of the forms, plus the reports and macros on my database? I would like the rest of the database to be easy to modify by others. Miss Fred Garner
  8. Fredgarner

    Method or data member not found

    I have now substituted the following code but still the combo box is not doing anything! The code is obviously not faulty- why on earth is the combo box not finding my record? Any ideas would be gratefully received! Private Sub Combo176_AfterUpdate() 'Moves Record Selector to record in...
  9. Fredgarner

    Method or data member not found

    i nowhave the following code and although no error message is coming up, nothing happens when I make a selection in the combo box. Private Sub Combo176_AfterUpdate() 'Moves Record Selector to record in subform that corresponds to the 'selection in this combo box. Dim varName As Integer...
  10. Fredgarner

    Method or data member not found

    Hi AceMan! The same error is still showing up. The code in the line you mention probably was wrong and should be correct now I have altered it as you suggested, but I still need to get the shareholders line correct. PH, I am not sure what you mean by the 'control name'? The subform's name is...
  11. Fredgarner

    Method or data member not found

    I have entered the following code in order to move to a record in my subform based on a selection in a combo box. The subform is called 'Shareholders' and the field name it is looking up is 'Account Designation'. Private Sub Combo176_AfterUpdate() 'Moves Record Selector to record in subform...
  12. Fredgarner

    search a subform

    Many thanks for your posts, Remou. Unfortunately I am still not able to do what I wanted. I think this may be because each of my main forms is linked to a different part of the subform by a shareholder number (so that only the accuotn designation relevant to the currently diplated contact are...
  13. Fredgarner

    search a subform

    From my form I am trying to use a combo box to find a specific name in my subform (called 'shareholders subform') within the 'account designation' field. Can anyone identify why the code below does not work? Private Sub Combo174_AfterUpdate() DoCmd.GoToControl "Shareholders subform" ' Find...
  14. Fredgarner

    Search for a subform field

    I have a form of investors and within that, a subform of all their different accounts. Is it possible to put a combo box in the main body of the form that looks up a field in the subform and navigates to it?
  15. Fredgarner

    command button- add new record

    On my switcboard I have a command button that allows the user to enter a new transaction on the 'Transactions (by contact)' form. The code reads thus: Private Sub Command13_Click() On Error GoTo Err_Command13_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...
  16. Fredgarner

    Command button code- print or preview a report

    Does anyone know why this code is making my reports print rather than preview? It is choosing from 3 reports, which are selected by option buttons. Option Compare Database ' Use database order for string comparisons. Option Explicit ' Requires variables to be declared before they are used...
  17. Fredgarner

    command button/option group code not executing properly

    Does anyone know why this is returning the error message 'Compile error: Variable not defined'? Option Compare Database ' Use database order for string comparisons. Option Explicit ' Requires variables to be declared before they are used. Private Sub Detail_Click() End Sub Private Sub...
  18. Fredgarner

    Command buttons and option group

    I would like to deisgn a form which gives the option of printing or previewing (ie 2 choices = 2 command buttons)a choice of 3 reports (ie 3 choices). I would like to be able to highlight the report I want to print by using 3 option buttons - I know how to create a command button that either...
  19. Fredgarner

    command button: display database window

    How can I make a command button that sends the user to the database window? I do not want to rely on F11 as some of the users will not be very computer-literate.
  20. Fredgarner

    command button: use option and command buttons together

    I would like to deisgn a form which gives the option of printing or previewing (ie 2 choices = 2 command buttons)a choice of 3 reports (ie 3 choices). I would like to be able to highlight the report I want to print by using 3 option buttons - I know how to create a command button that either...

Part and Inventory Search

Back
Top