Search results for query: *

I have a continuous form that contains an unbound calculated control on each record. For the form, AllowAdditions=True so I get the * on the new empty record at the bottom of the form (which is what I want). The calculated control works properly for all the records in the continuous form...

I have a Form, say FormA, which has a subform, say subFormA. subFormA also has a subForm, say subFormB. When the user double clicks a control on subFormB, a popup form appears, say frmPopUp which shows all the fields on subFormB on one form without having to scroll left and right. When the...

Is there a way to determine the ADO Recordset field index number given a field name other than cycling through all the fields until your name matches one of the fields and then using that counter/index? That is can I easily find out that: RST(12) is the same as RST("FIELD NAME")...

I've created a progress meter form. In a Public Sub in the progress meter form I have the following code: Public Sub Progress(lngCurrent As Long, lngTotal As Long) 'Assumes box is 3.5" or 5040 twips wide Me.rectProgressBar.Width = 5040 * (lngCurrent / lngTotal) Me.Repaint End Sub Private...

I'm trying to open an ADO recordset of an Access table that is sorted/ordered by the Table's OrderBy property but I can't seem to find how to read a Table's OrderBy Property in ADO or ADOX. I can do it with DAO: dim db as dao.database dim tdf as dao.tabledef set db=Currentdb() set...

I've got an unbound combo box with 2 columns, state and store name. The combo box is sorted by the first column, state, and then the second column, store name. The bound column is the second column, store name. When the user selects an item from the combo box, I want the combo box control to...

I'm trying to open an ADO Recordset with the following: Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset Dim ProjectORGID As String Dim ProjectISNUMBER As Long ProjectORGID = "ZZZZDEMO" ProjectISNUMBER = 1 rst.Open "qrySelectedProjectCitations&quot...

I have a switchboard form that is being displayed at startup (Tools>Startup>Display Form/Page). I would like to be able to pop up a form on top of this startup switchboard to prompt the user to enter something while still letting them see the startup switchboard form. My problem is that I only...

My application starts with a Main Switchboard. Clicking a command button opens a form with a tab control. The second tab of the tab control contains a subform with an image control on it. My problem is that the OnCurrent event of this subform runs twice whenever the user moves between records...

I am creating a recordset from an SQL select statement. The SQL concatenates several fields together to form one long field: Citation. Some citations work out to be greater than 255 characters in length. The SQL statement works and the Citations in the recordset look fine except when the...

Hi, I have a table of literature citations/references. This table is linked to four other tables by the primary/foreign key relationship. The relationship between the citation/reference table and each of the other tables is 1:1. If a user deletes a reference, is there an easy way for Access...

I have a main form named: frmCitationPicker that contains a subform named: sfrmCitationDatasheet. There is a command button on the main form named: cmdAddNewCite. When this command button is clicked, it pops up another form named: sfrmCitations that allows the user to enter a new citation...

I'd like to restore the value of an unbound text box when I cancel its before update event. It appears Access leaves the errant value in the unbound text box after the event is cancelled. I'd like to set it back to its former value which I have stored in a public variable, not the errant...

I have an unbound listbox on a popup-dialog form that is populated with several hundred entries from a union query. The user can only select one record (Multiselect=None). Upon opening the form, I want to highlight (select) the user's previous entry at this screen with...

On a form, I have a tab control that has two pages (Main and Pictures). The second page contains a subform that displays pictures of the object described on the Main page of the tab control. The problem I'm noticing is that when I view the form or move from record to record the OnCurrent event...

I have a combo box with a table record source that contains a record such as: Maple (C) In the combo box drop down, it looks correct, but when you select Maple (C) or type it in, Access converts the (C) part to the copyright symbol and generates a not in list error message. How do I prevent...

Listboxes and comboboxes do not have built-in support (i.e. a horizontal scrollbar) for displaying text strings that exceed the visible area of the listbox or combobox. I have a series of long strings that I'd like to display in a listbox and allow the user to scroll to see the entire...

I have a form on which I want to change some of the control captions on the fly with VBA prior to opening it with OpenForm. It seems that I'm only able to change the control captions after the form has been opened. In another circumstance it doesn't work at all when I open the form with...

Hi, I'm using: Private Declare Function GetSaveFileName Lib "comdlg32.dll" Alias "GetSaveFileNameA" (pOpenfilename As W32_OPENFILENAME) As Boolean to get a file save dialog. The dialog form appears in the upper left corner of the screen. How does one center this? Is it...

Hi, I'm using: Private Declare Function GetSaveFileName Lib "comdlg32.dll" Alias "GetSaveFileNameA" (pOpenfilename As W32_OPENFILENAME) As Boolean to get a file save dialog. The dialog form appears in the upper left corner of the screen. How does one center this? Is it...