Threads Replies Last Post 396 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Continous Forms (sub-form) I have the following code that resides within a Sub Form which is Continous: Private Sub Action_Taken_Click() If Me.Action_Taken.Value = True Then Me.cboAction.Visible = True MsgBox "Select an Action", vbInformation, "Action Required" Me.cboAction.SetFocus Else Me.cboAction.Visible = False End If End Sub The code runs fine; except for that when the Action_Taken is eithe... 4 21.09.2006 20:54:25 Combobox search I have 3 tables as follows TblAtty AttyID - Autonumber primary AttyLast AttyFirst AttyOffice TblPayoff AcctNbr - text primary Borrower payoffdate LoanType RequestingAttyOfficeID AttyAddress TblDischarge dischargeID - autonumber primary AcctNbr County Book AttyID AttyAddress I would like to create a form for the payoffs and a subform for discharges that each have a sear... 1 21.09.2006 19:42:42 Subforms - Selecting a record and calling up a separate form I would like to know if the following is possible: I have a form (Masterform A) and a subform (Subform B). In the subform (Subform B), there are records summarized. (For ex, instead of showing all 19 fields, I only show 3 to save space.) I would like the user to be able to select a record in the subform datasheet (Subform B), and select the record (Case id) in the subform by mouse cl... 1 21.09.2006 19:38:02 Counting how many times a button is pressed Hello All, I have a form that has a command button on it that prints a letter for the record that it is on. What the user wants is a report that shows how many times the button was clicked within a specified date range. I am thinking that I need to do an event on the ON Click for the button. But how do I do that? Do I need to have a seperate table to store the date and a number th... 4 21.09.2006 19:25:59 Populating row source type of combo box with query dependent upon form field I hope I can explain this thoroughly. I have a main form that shows sale unit data for a particular SaleUnitID. Within that form, I have a subform that allows the user to enter bid data into a bid table linked by SaleUnitID. I would like a combo box in the main form that, when dropped down, allows the user to pick the winning bidder from the bidders who have bid on the current SaleUnitID... 6 21.09.2006 19:21:23 email field access, how do I send email through Outlook I have an Access 2003 field "email address", How do I set it so when I click on the email field from the "FORM", it opens up Outlook 2003 new message email form so I can type a message or send an attachment.... 5 21.09.2006 19:19:59 Convert multiple cells into one string, with spaces between values I have a column of data. I need to concatenate it into one long string, with spaces between each value. The final; result is a search string, but the number of values is going to vary depending on the number of fails found. Meaning... Column A could be 10 rows, 20 rows, 75 rows, it varies depending on a specific starting point. =concatenate(A1," ",A2" ",A3) Will return the desired re... 4 21.09.2006 19:19:01 INSERT INTO statement from multiple forms Hi, This is what I have: 6 forms that have 5 - 6 text boxes or combo boxes on each form. These text boxes and combo boxes are currently Unbound but that can change if needed. I also have one table (tbl_information). This is what I want: I want the tbl_information to be populated after the user enters information in all of the text boxes on all 6 forms. I want this to happen at t... 3 21.09.2006 19:14:01 Toolbar buttons into forms I am wanting to put some of the toolbar buttons (find, Undo,etc.) into the form. Essentially it would be a customized toolbar, but I want them in the actual form and not in the toolbar. I don't want the whole toolbar because this is too much for some people to deal with. Dothey need to be command buttons and what code needs to be used? I would appreciate any help with this.Thanks, Eric... 3 21.09.2006 19:10:03 Automatically resize a tab control Hi all, I have a tab control that contains three subforms; each of which has been placed under a separate tab. Each subform is different in dramatically different in size than the next. Problem I'm having with this tab control is the size itself. Tab #1 has a very large subform on it, and hence, requires a lot a space. But Tab #2 is a fairly small subform. So when someone clicks ... 2 21.09.2006 19:03:56 Forms and Queries and Reports I want to have a form with the fields "start date" and "end date" and I would like to be able to enter the dates and hit a button on the form to bring up a report using the dates I entered. I know how to write the query and I know that I can have pop up boxes to enter the dates but would rather have a form. Any ideas?... 4 21.09.2006 18:05:31 combo box/command button used to open a report: How? I have a form with a combo box, based on a query showing the primary key (StudentKey) and the student’s name. The combo box is bound to the first column (StudentKey). The combo box is named “Key”. Column widths are 0”,1” I have a command button next to the combo box that I want to open a report to show only the data for the student selected. The report has the StudentKey f... 4 21.09.2006 17:23:02 query subform I can't upload this ..to big...please help.. -------------------------------------------------------------------------------- The original file is about 7.5 megs I did the compact and it brought it to about 7.2...I then zipped it and got it to around 2.2 megs... The upload here is 363kb ? Theres no way I can get it that small. Any suggestions ? I posted it at savefile.com it is 2.23 m... 1 21.09.2006 17:01:01 Reports How do I sum a subreport with two other totals that are in the order ID footer at the end of a report? ... 7 21.09.2006 15:41:01 Create a report from a form variable My form has a field that allows a number (1-99). I would like to pass that variable to create a report that includes every record that contains the variable. Thanks.... 3 21.09.2006 15:22:02 Time and Date field taking up too much room How can I split the Date and Time Field for data entry? I have it storing both in the table but it doesn't fit well on my form. Can I make 2 textboxes bound to this field and label one Date and the other Time? Using Access 2003 Thanks, Linda ... 8 21.09.2006 15:11:03 Validation of field I have a form with three combo boxes; Destination Denial Code Cancelation Code I want to validate if Denied is chosen for Destination that the Denial code is a Required Field, and if Canceled is chosen in Destination that the Cancelation code is required. How is the best way to handle this type of validation? Please Help. ... 1 21.09.2006 14:56:02 Before/AfterDelConfirm events not firing I would be very grateful if someone could help me troubleshoot this problem. When I add a new record, save it, then immediately delete it, the BeforeDelConfirm and AfterDelConfirm events DO NOT fire. In addition, the confirmation dialog does not appear, the record is merely deleted. When I add the record, navigate to another record, then navigate back to the new record, these events DO fi... 4 21.09.2006 14:42:25 Need to create HTML files from Forms I just upgraded from 97 to 2003. In 97 I could export 6 forms at once as an html page and the wizard would create an index page for them. I seem to be able to export only 1 page at a time with 2003, and obviously no index. Is there a trick to do this?... 1 21.09.2006 14:33:02 Form design and publishing I am currently trying to design an Access system where forms can be designed and published (i.e. sent to an e-mail address.) I cannot see the best way to achieve this without using a data access page so the recipient can view and update the form as if they where directly using the access system, (i.e. the form would look the same as if they where using the form in access!) Can anyone hel... 1 21.09.2006 14:19:01 form can't update after its underlying query's underlying table are splited I have a form D with its VBA code doing quotation. it is based on a query C which is then based on 2 tables A and B. Since table A is too big, and it contains data about 2 totally different material, i split it into 2 independant tables, A1 and A2. Then I updated the query C. The problem occured: the form D which is based on query C can not update recordset now. Can anyone one tell me... 1 21.09.2006 14:15:51 Navigating from a new record without required field filled I have a form where users enter data for a sale unit. If they click the Add New Record button, then want to navigate away from that new record without saving data, they get messages that tell them that SaleUnitID is a required field and they must enter something. I've been telling them to click Edit>Undo on the toolbar. I just want them to be able to navigate away from a new record if th... 4 21.09.2006 13:28:01 calendar control 11.0 I'm having a problem with my calendar control, that is, I can place the control on my form and it functions in design mode but I can not select any dates when I run the form. All references are there and the properity settings are: enabled - yes, locked - no please help... 1 21.09.2006 12:25:02 Find out affected column in Form_Dirty event Hi everybody, I'm trying to find out which column has been changed (or in which column the user has done the modification) in the form dirty event. But I can't find a way to do this? Can anyone help me? Any help appreciated. Thank you Michael ... 1 21.09.2006 11:16:30 Calendar field overlap I have a calendar popup on my form which pops over several fields however one field stays on top. How do I force the field into the background when the calendar pops up? thx... 1 21.09.2006 11:05:02 396 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>