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

    References Problem

    Hi Not sure whether this is your problem but I've had similar. If you reference a dll and you have more then one copy of this dll on your system then the app uses the first it finds in the registry. I had serious problems because moving the dll was not being caught and updated, consequently...
  2. saltecho

    Filtering with use of datasheet

    Hi, I think this may be what you are looking for: In the datasheet form put this code in the Declarations section: Option Compare Database Option Explicit Private WithEvents m_form As Form In the datasheet form put this code in the close button On_Click Event It supposes that the datasheet...
  3. saltecho

    Subforms Out of Synch

    Hi A couple of things strike me here. If I had to navigate using the nav buttons through 72 records I think I might have a sense of humour failure pretty quickly. Why not populate a combo or listbox with the choices from the filter? Secondly, what is the record locking set to? With 'no...
  4. saltecho

    Changing textbox colors on continuous forms

    Hi Yes you can do it but you have to cheat. For the text box you want to change the color of create 2 (You can figure the other one once you can do this). Name the text boxes something like txtRed and txtBlue. Make them identical and transparent but with red and blue Forecolor. Now set the...
  5. saltecho

    Printing current record probelm

    Hi Had a similar problem recently and the best answer to this is to create a report that looks just like your form. Create a query that has a parameter against the key field that looks something like [Forms]![MyForm]![MyControl] Make the query the datasource of your report and off the button...
  6. saltecho

    Difference between variant and string

    Hi I think Jeff may have missed a vital point. In VB if you use a variable VB treats it as a Variant from square 1 but in VBA there is a vast difference between a string and a variant even after the sheer size allocated. Most VB programmers I've seen use only variants and VB doesn't have a...
  7. saltecho

    Data from Outlook to Access

    Hi I think you need to rethink the problem. Why not get them to put the data into an Excel file and attach the file to an e-mail? Importing is then no problem. I often use Excel for reports because the user can then send the file to everyone and anyone they need to. It works in reverse too.
  8. saltecho

    Why does access stop asking for a password

    What Ann says is good. Your users are joining your user group by default rather than joining for the duration of the session. Is the Admin user required to use a password? Do you have a clever user? If the default Workgroup is your group there is no need to login if the Admin user doesnt...
  9. saltecho

    Function to remove double spaces and strange characters

    Hi Aydan The best way to remove typos is to prevent the user from entering them! I always make the user select from a list if at all possible, select from an Option Group select from anywhere but don't let them type unless it isn't important. With thought and careful design almost all user...
  10. saltecho

    form populated by a combo box

    Hi Have you tried to edit the data in the query that is the source of your form, presuming it is a query. Remember that some queries, because they rely on joins and filters, cannot be edited. If that is not the case then perhaps the properties of your form, allowEdits, AllowAdditions are set...
  11. saltecho

    VBA Code to Select all objects on a form

    Bill Both the methods posted are the way to go but I have added my own way of doing it. I decide which controls are going to be shown under which circumstances then I prefix the name of them with something like "set1_", "set2" etc. Then I can say: Dim ctl as Control For...
  12. saltecho

    Creating a form to do one calculation!!!

    You don't need Access you need a notebook
  13. saltecho

    Adding Data to Combo Box

    Hi this looks a bit complicated but really its easy. You add one bit of the code to your combo box On Not in List event and put the other in a Module (don't forget Option Explicit at head of module). This will tell the user the item is not in the list and allow them to add it. Text in the...
  14. saltecho

    Allow Edits query

    In the AfterUpdate event of the control containing the field which is your switch add the following: Me.AllowEdits = False This will turn off editing for the current form. if you want to just turn off that field then you have to move the focus to another control then lock the first control...

Part and Inventory Search

Back
Top