Search results

I have a bound form, Frm, bound to tblMain. I have a combo box, Cbo, bound by column(0), a foreign key, to tblMain. The Cbo's RowSource comes from table tblCbo, and populates 2 columns on the form: tblCbo.ID, tblCbo.Desc. First column, tblCbo.ID is hidden. What I'm trying to do is output...

I thought this would be pretty simple, but I cannot figure out how and wasn't able find the solution here or anyway. I have a source form. (I can resort to having a Table with OLE Object if I must, but prefer not to.) On this source form I wish to include different things such as company...

I have an Access database that I have running on the server. I've compiled it made it into an MDE file. When I run it, everything appears to be working fine. I created my own log-in form. However, when I split it, I will often get this error when clicking on the log in form: The...

I have an Access front-end linked to an Oracle (7.3) database. I can run a report that is generated by a query I have saved. However, when I open the query itself, I get the "ODBC--Call failed" error. I set the ODBC TimeOut in the query's property to 0 and I set the ODBC's QueryTimeOut...

I have developed an Access application as a front-end to an Oracle back-end. I'm trying to create an MDE file with the Access MDB file but it hangs every single time until I manually force it to close. (The MDB file has been "compacted & repaired", and the coding successfully compiles.) Has...

Error opening query recordset that references control object I have a several saved queries that are hierarchically dependent. In one of my forms I need to access one of the queries. Set rs = db.OpenRecordset("qryCTI_Unbilled") But I get an error: Run-time error '3601': Too few parameters...

I have a saved query (a view) from which I would like to navigate through in its entirety as a recordset. This query is built off of other saved queries. The saved query is called "qryCTI". There are a few queries to which it is dependent upon, but the one that it is directly tied to is...

This seems like a straight forward function but I don't quite know how to call the current date function in the Access SQL query. SELECT * FROM table WHERE sysdate BETWEEN '4/30/02' AND '5/1/03' (sysdate: the current date function (Oracle current date)) TIA, D

What is the way to select a check box in an option group by VBA? I'm not sure what property to use. I have a form with a combo box of 100 items on it, and an option group with 100 checkboxes. I am trying to synchronize the two, i.e., when an item in the combo box is selected, the appropriate...

Is it possible to code the form window's X Close button in the upper right hand corner? I want the user to have the normal windows control but I wish to enforce some background code to properly code the form like I have with a cmdClose button on the form. I'm wondering if it's possible to...

I have several forms which contain a set of controls I need to manipulate in VBA. The set of controls are located on the main form (forms that do not have a subform), and on the subform of another form (2 other forms actually). I need to create a public procedure that will modify the...

I have combobox for which I wish to select a value based on an designated index integer N. I tried the following code but it says that I am not using the ListIndex property correctly. Me.cboPosition.ListIndex = N This works for my listbox; I'm trying to get the same effect...

I know Access VBA does not support Array Ojects, so as an alternative, I created a set of 100 checkboxes naming them with number suffix (chk1 - chk100). I have code to synchronize those 100 checkboxes to 100 rows of a listbox. On one of the forms that I used this on, the listbox is single...

What I am trying to do is assign values to form controls via a public sub procedure called on by a form. So in testing this is what I have done: The first msgbox returns the formname. The second msgbox returns the the value in cboPosition The third msgbox I am attempting to get the same...

Okay, this should be simple, but I don't have much experience using class modules. I tried browsing around for an answer, but I think my level of expertise (or lack thereof) on this matter would make it as easy to find here as the needle in the haystack. I have several different forms that...

This should be a simple one but I can't quite figure it out: I'm trying to make the label.caption vertical. When I set the vertical property to Yes, it displays it as if the label is rotated 90 degress clockwise (the beginning of the text is on the top, the top of the words is on the right, the...

I have two main forms referring to one subform. I want that particular subform's combobox to detect which main form it is running under with a series of if statements to perform a function. I tried the Private Sub Form_GotFocus() >>global variable = current form name EndSub but it doesn't...

Access2000 crashes on value asgn; Error: "Method 'Value' of object '_Textbox' failed" I have this add data form. When I click on the add button it runs a series of DoCmd.RunSQL commands to make the additions. It's developed in Access 2002 as a 2000 file. It runs fine on Access 2002, but on...

I have two main forms referring to one subform. I want that particular subform's combobox to detect which main form it is running under with a series of if statements to perform a function. Is there a simple way of the subform knowing which main form its running under? Or if I have another...

I have an Edit form that allows the user to move the location of a record. When the record is moved by press of a command button, the VBA code simply runs an Update query to change the ID of the record referring to a different location. Then I would like to refresh the form by this line at...