Search results for query: *

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

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

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

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

That works. Thank you.

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.

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

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.

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

Thank you

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.

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

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.

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

How can I find out which tab is selected?

Thank you Golom

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

Still need help.

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

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