Threads Replies Last Post 363 Pages: <<  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  >>   List box will not change when with record I have a list box on my main form. The values in the list box have an id that links to the main form id. But when i click on the next records from the main form, the list box does not change to show the lists that are for that id. the list table has the id and the main form table have the id. what am i doing wrong. I tried to change the query of the list table to : Forms!frmMain!codeI... 2 07.09.2006 19:02:18 Forms and subforms Hi Folks. I am trying to use a form with a subform to create an invoice management system. I am trying to make the main form Read Only as it contains the invoice number and customer info. While the subform will be the editable line items. I have designed both and i like what i see but the exectution is confusing me. I need to find a method of directing the user around this form. Current... 2 07.09.2006 19:00:33 Search text/memo field Hi All! Thanking anyone for a reply. A 2003 I wish to search a text/memo field for the name "Peters". Is this possible? Thanking anyone for a reply Regards Peter ... 4 07.09.2006 18:11:01 Forms and subforms Hi Folks. I am trying to use a form with a subform to create an invoice management system. I am trying to make the main form Read Only as it contains the invoice number and customer info. While the subform will be the editable line items. I have designed both and i like what i see but the exectution is confusing me. I need to find a method of directing the user around this form. Current... 1 07.09.2006 18:06:17 If...Then...Else Good Afternoon! I have a form that will pull up several reports. On the left side of the form I have an option group with 3 options and on the right side of the form I have 3 buttons. The user chooses an option (Children, teachers, Aides) and will click a button on the right side of the for to pull up a specific report (attendance, classes, paperwork). Each combination pulls up a diff... 4 07.09.2006 17:11:01 Codingn when no records in a subform I have a form with a subform that displays more information about the record. This relationship is a one to one master child relationship, but on occasion there is no child so nothing gets displayed in the subform. My problem is that I have an on current event procedure that runs through a bunch of if/if else statements, one of these refrences an object in the subform, if there is no da... 3 07.09.2006 17:03:01 Upgrade from Access 97 to 2003 Hello: We are about to upgrade from Access 97 to 2003. Are there any common problems that we should anticipate? For example, I have a database that uses the DAO library 3.51. Will there be any issues with this after the upgrade. How about validation rules. My rules were not created via the After Update event of controls or forms. Will I have to re-do them? Thanks, Jade.... 3 07.09.2006 15:01:01 select subform records to add to table and report Help!!! I started designing a database to allow the user to enter purchase orders. Here's what I'm really trying to do: I have a main form (frmPO) which is bound to a table (tblPO). This form just includes miscellaneous customer information. It also includes a field called "ModelNumber". I have a subform (sbfrmOptions) which is bound to a query (qryOptions). The list of options c... 4 07.09.2006 14:33:58 selected Hi, I've got form with master slave subforms. After refresh (so some fields get their current values) selected rows are changed ( first rows in both subforms become selected). I dont want that to happen, I want old rows to remain selected. How can I avoid selection change? thanx alek_mil... 2 07.09.2006 14:16:08 Conditional Formatting on Continuous Form I have a continous form and need to display a text box with red text according to the results of another text box. I have done this using conditional formatting but it only works when on the current record. I want the text to be displayed when the form opens if any of the records meet the criteria. Can this be done? Any help is appreciated. Thanks Regards Sonya... 4 07.09.2006 14:02:06 2 questions 1. Say I have a field called 'Account_No' (main form), and in another table one called 'Under_Account' (another form). Account_No is an autonumber (no dups) and Under_Account is just a Long Integer (Dups allowed). Is there any way when I click on the 'Add Record' button (wizard generated), that I can force the form to keep the same 'Under_Account' value WHILE creating a new record? ... 3 07.09.2006 11:43:39 bound vs unbound fields When giving users the option to modify information in a table, is it better to have the fields on the form bound to the underlying table or to use unbound fields and then add/modify the data on the click of a 'update' button? Is there a preferred way of doing this in the programming world?? Thanks!... 13 07.09.2006 11:26:13 Check Boxes in Word Form I am trying to create a form that has check boxes. When the check box is checked I want it to put the figure in the total column. i.e., if you check this box it put the figure 100.00 into the total column. Does anyone know how I formulate this in the total column? The box and total column are in a table in Word, in a form. I will appreciate any help thanks ... 2 07.09.2006 11:20:58 Validation of Field Hi everyone, I am working on a credit card receiving screen and wanted to know if there was a way to run a date verification against a text field? I am capturing the expiration date in a text field as I need the format to be mmyy for processing purposes and need the "0" to stay in the field if say the month is 05 (May) - I would now like to add a check to make sure the expiration date ... 4 07.09.2006 04:45:22 Syntax problem with Dlookup I have a string variable for my SQL statement. In the statement I have a dlookup function (which is a frustrating thing to deal with I must say!) and a left function. I've tried all combinations of single quotes, double quotes, brackets no brackets etc. I'm getting a 2465 error "......can't find the field "|" ......" There is no "|" in my statement. I have a listbox with a query SQ... 3 07.09.2006 00:28:01 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 Not in List event and a new form design question Hi All, I have a combo box that lists names, and when the not in list event is fired, I open a form to add all of the required data for that entry. The problem is that I'm not sure how to handle a user 'cancelling' (or closing) the form without adding the new data. Originally I didn't have any thoughts about this, but I realized when I tried to cancel/close without adding the new entry t... 4 06.09.2006 23:34:24 Run Code I have what is probably a silly question. Is there a way to run code that applies to form1 from form2? I have a delete button in form1 that has a lot of code in it that is specific to form1 like me.controlname = "test" etc. I have a button in form2 that opens form1 to the last record. Now I need a way to run the same code that's in the delete button on form1 without needing to click ... 4 06.09.2006 22:46:11 Back Mouse Button Hello All, Is there a way to capture the use of the back and forward mouse buttons on the Intellimouse or four button mouse? Thanks, Brian... 1 06.09.2006 21:55:02 Ctl Reference I'm trying to set the values on one form ApplyDiscountSelect to another form DiscountApply, but I keepgetting an Object Error. Dim Ctl As Control DoCmd.Close acform,"ApplyDiscountSelect" For Each Ctl In Forms!ApplyDiscount.Control If Forms!ApplyDiscount.Ctl.Tag = 2 Then Forms!ApplyDiscount.Ctl.Visible = False ElseIf Forms!ApplyDiscount.Ctl.Tag = 3 Then Form... 5 06.09.2006 21:03:38 How to disable menu items? Is it possible to disable menu items like Tables, Queries, Edit, View so that users cannot open it? Thank you, -Me... 7 06.09.2006 20:36:02 Extremely simple form needs filtering My form is ultra simple -- but then, be patient with me -- I am a VFP programmer, not an Access programmer, so I understand relational DATA, but not how to tie it together in Access <g>! Here it is: Combo box, based on a table, Company (6 records -- that's right SIX!) CompanyID AutoNum Company Text SubForm containing Listbox based on a table Payload (3 records -- in ca... 8 06.09.2006 19:49:28 Bug?... Load Event Executes Twice, Open Event Does Not Execute... I am opening a form using "DoCmd.OpenForm" from a command button's click event within another open form. The form I am opening is unbound (no record source) and is simply an input form (one textbox and one combo box) for a couple pieces of missing information that the user will supply. I noticed something odd happening with the form so I introduced a msgbox prompt into the open and loa... 5 06.09.2006 18:15:02 WHERE clause in SQL I have a form that imports data and was working fine until I added another criteria to the WHERE clause. Originally I had: strDetailSQL = strDetailSQL + " WHERE (((Project.JobNumber)=Forms! frmImportNewProject!NewProject));" I then changed to: strItemSQL = strItemSQL + " WHERE (((Project.JobNumber)=[Forms]! [frmImportNewProject]![NewProject]) AND ((Bid.BidStatus)="Awarded"));" I keep ... 5 06.09.2006 17:14:01 Why am I losing vertical slider on a form I open as a dialog? I need to open a form as a modal dialog so im using the following code: DoCmd.OpenForm "Ducali_DataEntry", acNormal, , , , acDialog However when I do this the form no longer has the vertical slider which I have to have. If I remove the acDialog attribute the form no longer opens modally and the code doesnt pause. Any suggestions? Thanks in advance... 2 06.09.2006 16:21:54 363 Pages: <<  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  >>