Threads Replies Last Post 396 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>   form code I tried to open a form with an event which give an error like below: 3146 DAO.Recordset ODBC--call failed. Can anyone please tell me what does this mean? Thanks. ... 2 07.09.2006 11:11:25 Find label associated with textbox Is there a way, in code, to determine the label that is associated with a specific text box, checkbox, combo box, etc.? The idea would be to loop through the controls in a form and be able to identify the label that is associated with one of these controls. Thanks for any help on this, Herb... 8 07.09.2006 11:09:24 Cannot save form field values using an Append Query This works on Access by using an Append Query and Setting the columns to Forms!frmForm1.Field1 for example. Now I am using SQL and Acess is an adp file, I cannot do this any more. How do I do this please? Thanks Ian... 5 07.09.2006 09:36:01 Combo boxes and search forms I have a bunch of combo boxes that are unbound and get their values from this type of query: In this particular example it takes the violator_ID and name from the violator's table and displays just the name. SELECT tbl_Violators.Violator_ID, [Violator's Last Name] & ", " & tbl_Violators![Violator's First Name] AS [Violator's Name] FROM tbl_Violators ORDER BY tbl_Violators.[Violator's Last N... 4 07.09.2006 05:20:12 Problem w/Sub Form Thanks in advance for your help. I have a form that with tabs on it. On one of the tabs I have a sub form. They're linked by employee id. When I set a value on a sub form and close the parent the next time I go to the parent record the sub values aren't there. If I right click on the parent form and select sort the child values suddenly appear. If I open the parent and select a valu... 2 07.09.2006 05:06:47 how to add an existing record to another table I've two forms in my DB and I want to update ID number in Form B automatically when I enter a new ID number in From A. How can I do it?... 2 07.09.2006 04:57:24 Can't get subform to show records for main form account. I tried to add a subform to my main form but can not get the subform to show only those records associated with the account on the main form. Instead it shows every record in the table. The main and sub are made of one table each. The two tables have a one-to-many relationship with the same data types. I haven't used Access in a while and can not remember how to fix this issue.... 2 07.09.2006 04:54:21 Record navigation and date problems Hello expert, Please help me with the following problems. I have spent ages to resolve them but no luck. I have two forms. (1) "Document Reception Input Form" is the main form. The search field Document ID is unbound combo box. The table is Documents. (2) "Document Reception Subform" is the sub form in tabular form. The linked field is DocID. The table is DocumentReception. Aft... 1 07.09.2006 04:04:32 Saving a subform Does anyone know how to save a record in a subform? I have a main form that displays a subform showing only one record. Since I can't navigate to another record to save it, I was wondering if there is a way to programmatically save it. Thanks a lot! Dan... 3 07.09.2006 03:24:02 Access Calendar Control Hello! I'm trying to create the pop-up calendar control with the toolbox in Acc97, but as I select the Calendar control and click on the form, I get the gpf error and kicks me out of access. Same thing happens on Acc2002. (also on Acc2002 when I select the calendar control in the toolbox, it displays calendar control 8.0) I do have the mscal.ocx in my computer. Thanks for you help Abe... 2 07.09.2006 02:18:45 Text box highlighting on focus Is it possible to disable the highlighting of the text value present within a textbox when moving focus to that textbox? Thanks, Dean S ... 2 07.09.2006 01:55:42 Find returnset sequence? Is it possible to specify the sequence of the rows returned from a Find dialog box? Thanks, Dean S ... 1 07.09.2006 00:30:48 calculation geomean in form using subform data in excel hi all I am trying to calculate the Geometric Mean from the filtered data in the subform(office 2000) in the text box in form.I am trying to transfer the subform data into excel sheet and then using excel formula to get GM.(as explained in book)I got this OLE automation code from book: Private Sub Form_Current() Dim R As Recordset, X1 As Object Set X1 = CreateObject("Excel.shee... 5 07.09.2006 00:09:53 Why won't the Option Group Wizard Work (Access 2003)? I'm doing some data entry forms in Access 2003. I wanted to set up an option group but the wizard won't start. All other wizards seem to work. My Office suite is fully updated, including the Jet Database update for the Sandbox issue. What do I need to do to get the Option Group Wizard to operate?... 3 07.09.2006 00:08:22 VBA You entered an expression which has no value I have setup a form and created a text box called ItemCode I have set the control source to be =OnHand([ProductID]) When I load the page with the following code I get the above error VBA You entered an expression which has no value. Can anyone help me out hear I nearly have no hair left!!! Function Onhand(VProductID As Variant, Optional vAsOfDate As Variant) As Long 'Purpose:... 10 06.09.2006 23:54:31 TimeIn TimeOut Database Hi everyone, I know this may sound like a simple question but I can't seem to wrap my head around how to do it. I have a very simple db that has two tables (Teachers & TimeCard). In the Teachers Table I have the fields: TeacherID (Number) [ID number given to the teacher by the school district] FirstName (Text) LastName (Text) In the TimeCard Table I have the fields: TimeCardID ... 1 06.09.2006 20:22:12 Restrict textbox for dropdown There is a textbox and a drop down. Once user enters any value in the textbox he has to select the option from drop down otherwise the cursor will not allow to move anywhere else accept the drop down and the textbox unless it delete the value from the textbox how to i do that needs help. Thank You. ... 2 06.09.2006 20:20:02 How do I lock/unlock fields in a form? I have a database with multiple forms that users are able to get into using a main menu with a drawdown option...most of the fields on the forms are "locked" so that I am not able to enter any data. Any idea how to "unlock" all or some of the fields?... 2 06.09.2006 19:28:46 Emailing through a form in access using VBA Hello, I am trying to email through a form using VBA and am having problems coding in the body of the text the first and last name off the form. Here is briefly what I want it to say. "Parking for (Here is where I want to put (Visitors first Name,Visitors Last Name) is confirmed. Please park in spaces 663-672 Thank You". If I just use the text it works fine but I am not sure how to code it t... 3 06.09.2006 19:14:43 Date Default Record to Record I have a date default set on Got focus for a series of critical date fields on a form. If Isnull(me.Ready_Date) Then me.Ready_Date.value = Date Cancel = True End If However when a user uses their mouse roller and moves from one record to another, and their cursor was on a date on the previous record the cursor stays on that date on the next record(s) and populates the field. How ... 2 06.09.2006 18:39:02 Need a petty cash balance sheet Is there a template for balancing a petty cash box.... 2 06.09.2006 18:25:02 Formularios Estou fazendo um trabalho com access para gerenciar um Livro Caixa, estou com campos de Entradas, saidas, saldo e saldo anterior.Meu problema é criar o saldo anterior.Preciso calcular esse campo, ele deve ter os mesmos dados do "saldo" do registro anterio.r Qual a expressão que devo calcular no campo "Saldo anterior" para obter esses dados??? -- Sergio... 2 06.09.2006 18:21:03 Copy Values between Text Boxes in Forms How do I get text box "B" to read the value entered into text box "A" while maintaining the control source of text box "B" as its field in the table? I want to copy the value from text box "A" to appear in text box "B" after the user leaves focus of text box "A". (The user can optionally change the data in text box "B" when the focus is there.) Values from both text boxes are added to thei... 4 06.09.2006 17:51:29 How to: OnClose run Make Table Query I have a form "Close" control. I have a Make Table Query that I would like to be run when the close control is clicked. I keep getting an error that and expected statment is missing, here is my code: Private Sub cmdCloseFile_Click() On Error GoTo Err_cmdCloseFile_Click DoCmd.SetWarnings (WarningsOn) Dim strSQL strSQL = "SELECT (tblFiles.[Project Name], tblFiles.[Projec... 3 06.09.2006 17:35:02 Re-usable search form In an Access form, I have a menu with the following options for a student database. Each option is a command button driven and has a corresponding form. Emergency Contact Info Personal Info Courses Enrolled What I would like to happen is: No matter which one I click, I will get to the same Search ID form, which prompts for an ID. And after the ID is entered, I would like to load the a... 2 06.09.2006 17:10:02 396 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>