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!

Search results for query: *

  1. Tommy408

    Problem Ctrl-C Ctrl-V in MS Acess Form

    I have a form with Text Boxes containing first, last name, and text information. I often have have to copy and paste them somewhere else. But the clipboard keep showing "Item not Collected: Format not supported by Office Clipboard." Sometimes it works on the first ctrl-c/ctrl-v and stop...
  2. Tommy408

    Problem Copy Paste Form Text Box

    No asterisks. Simple text box won't let me copy/paste at all. A message appear saying "Item not Collected: Format not supported by Office Clipboard." I store information such as email address that is quickest to import with copy paste into another form such as Outlook instead of looking at the...
  3. Tommy408

    Problem Copy Paste Form Text Box

    I have a form with Text Boxes containing logins and passwords. I often have have to copy and paste them somewhere else. But the clipboard keep showing "Item not Collected: Format not supported by Office Clipboard." Sometimes it works on the first ctrl-c/ctrl-v and stop working on the second...
  4. Tommy408

    Run time error '2004'

    When I run this code: DoCmd.OpenForm "Contacts", , , "[ID] =" & Me.ID, acFormEdit, acWindowNormal I keep getting the Run time error '2004' "There isn't enough memmory to perform this operation. Close uneeded programs and try this operation again." I have 1 gig of memory, rebooted, run the...
  5. Tommy408

    Selected Item in Subform Datasheet

    That works. Thank you.
  6. Tommy408

    Selected Item in Subform Datasheet

    It doesn't work. I probably wasn't clear. The datasheet is on a Form B. And Form A contain Form B as a subform. I need to get the ID of the selected item on the datasheet.
  7. Tommy408

    Selected Item in Subform Datasheet

    How can I get the selected item in a datasheet of a subform? I've tried: DoCmd.OpenForm "Contacts", , , "[ID] = [Forms]![Search Customers]![Search Customers Subform]![SubformControlName]", acFormEdit, acWindowNormal
  8. Tommy408

    SQL Keyword LIMIT in Access

    Is there a keyword for Access SQL like LIMIT? I need to select ONE specific record in a table. Like the 2nd record or 3rd record independent from ID primary key because I don't know what they are.
  9. Tommy408

    SQL Help

    I need help with a couple of things... -Find the number of records in a table. I've tried: "SELECT COUNT(ID) FROM Warnings" But I don't know how to set it to an integer variable in VBA. Something like NumberOfID = "SELECT COUNT(ID) FROM Warnings" ? -How do you specify record source of a...
  10. Tommy408

    Programmatically create List Box

    Thank you
  11. Tommy408

    Programmatically create List Box

    Is it possible to programmatically create List Box? Press a button, List Box created? I can do visible true/false, but the list box still take room in the form if it's already created.
  12. Tommy408

    Wheel mouse scrolling in Text Box

    Nevermind. http://p2p.wrox.com/topic.asp?TOPIC_ID=30999&SearchTerms=mouse,wheel
  13. Tommy408

    Wheel mouse scrolling in Text Box

    How do I disable the record scrolling from wheel mouse in a text box? I have text in the text box with side scroll bar and I'd like to use the wheel mouse to scroll down to the bottom of the text box instead of going to next record.
  14. Tommy408

    Need help with this Access code

    I'm writing a universal function for A LOT of similar buttons on different tab. The buttons is depended on the tab. So instead of for example: If Me!TabControlName.Value = 0 Then If Me!ToggleButton1.Value = True Then Do Something End If If Me!ToggleButton2.Value = True Then...
  15. Tommy408

    Which Tab is Selected Tab Control

    How can I find out which tab is selected?
  16. Tommy408

    Check If Record Exist

    Thank you Golom
  17. Tommy408

    Check If Record Exist

    Is there a way to check if an ID in a table exist with using ADO?
  18. Tommy408

    Field Input problem

    Still need help.
  19. Tommy408

    Field Input problem

    Correction: Text Box 1 control Source on Form A: Name Text Box 2 control Source on Form A: Category
  20. Tommy408

    Field Input problem

    Form A Record Source: SELECT ID, Name, Category FROM ActiveAccounts UNION SELECT ID, Name,Category FROM OldAccounts; The text box control source on Form A: Opened Date I'm gathering data from two tables into a List Box on Form B. I got Form A to show the data when I select an Item on the...

Part and Inventory Search

Back
Top