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

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

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

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.

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?

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

I can't change any of the data on my form. It is connected to a table. I open the form from selecting an item from a List Box. Form property: Allow Edits: Yes Allow Deleteions: Yes Allow Additions: Yes Data Entry: No Recordset Type: Dynaset Record Locks: No Locks The selected record is...

Is it possible to display records from multiple tables in one List Box? The tables have the same field but different values and different ID.

My Code: strSQL = "INSERT INTO OldAccounts SELECT * FROM ActiveAccounts WHERE ID = " & MyID & " " DoCmd.RunSQL strSQL strSQL = "DELETE FROM ActiveAccounts WHERE ID = " & MyID & " " DoCmd.RunSQL strSQL Where MyID is auto number from ActiveAccounts. When I run this line, if the in the...

How can I disable the list box scroll bar through VB? There are scrollbars property for text boxes but I don't see any for List Box.

What's the VB code to move to the end of a filled text field? Me![Orders].SetFocus just highlights/selects the text in the textfield.

Is it possible to catch the value in a text field right after every key entered into the text field? It seems that the event for example, On Key Up, is too slow to and the text field gives me a null.

I have records that can be stored over multiple tables or all in one table. I was wondering if it would be faster to query over multiple tables or in one table. If it is over MULTIPLE tables, my application would know which table to query for it's data ( 100 records per table). If it is in...

I want certain data on a large List Box to stand out by highlighting the row or highlighting a specific text. How should I go about doing this? Any related info out there I can look at? Thank you.

I want the administrator to have a friendly user interface by having a drag and drop records from table to table. For example draging a regular customer and drop onto a membership customer table. Any features in MS Access I should take a look at about doing this?