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  >>   Mainform / subform / popup form I have a main form frmCustomerSystems bases on a qry that combines all customer data and the often-referenced part of the system data. It has 5 tabs, 2 contain much of that necessary system data. (I have a button that allows input / view of the rest of the system info.) Two others have subforms linked to show the Builder and the Installer of the system. Those all work fine. My problem... 11 20.09.2006 15:50:47 Runtime error '3464' Hi all, I have a list box [List77] on a bound form and i would like to be able to click on the info in the list box and have the corosponding record show up in the form. The field on the form that I am trying to have the list box [List77] search is [TTS] which is a text field. When I click on the list box I get a "Runtime error '3464' Data type mismatch in criteria expression." The... 5 20.09.2006 15:11:36 Spreadsheet Hi everybody i'm using a Spreadsheet in a form to manage a schedule. My problem is that i want to manage the double-click on this Spreadsheet. How can i do this ?? thanks Cyril ... 2 20.09.2006 14:44:01 How do I obtain an existing value and pass it to a query I am working on a database in Access 2000 that lists clients (Companies) and learners for those clients. The Clients and learner data are in separate tables. The common link is the Company name. I would like to include a button on the Clients form whereby when pressed, the current company name is obtained and a query is run on the learner table to extract all learners sent by that compan... 3 20.09.2006 14:39:02 Specify Printer Hello, I have a database with a form that will be either printed or faxed (directly from the pc via windows fax manager). I was just wondering if it's possible to have 2 buttons on the form, one allowing to print from the printer, and the other to "print" to the fax wizard (fax is listed in my printer options). So the buttons would have to have onClick events, with underlying code telli... 3 20.09.2006 14:22:12 Pie Charts Hi everyone, I am trying to create a pie chart using a table with percentages. I am having a problem with the wizard. It will not allow me to add more that one feild from my table and then view it by record. I am trying to show a percent of a whole. If anyone can assist, that would be so great. Thanks, :) ... 1 20.09.2006 12:15:45 invalid control properties: control source no such field in field Having created an access database with all the fields some time ago, I now need to add additional fields but find the above error tagged onto the new field in design view and #Name? displayed in the form view. On looking at the properties, there is no new field name from the drop down list in the control source and I cannot see what the difference is in the properties of the older field... 2 20.09.2006 11:40:05 Tab control Hi I'm using Access 2002 SP3, is there any way to change the colour of the tab control on forms, so it isn't standard grey? TIA -- _______________________ Naz, London... 2 20.09.2006 11:25:46 auto complete stops working Access 2003. Auto complete was working with a combo box. After adding much functionality to a database I find that auto complete does not work on any combobox in any form. So I create a blank database and a simple test shows that auto complete works. When a form from the faulty database is imported in the test database, auto complete stops working on the test form. Even if the imported ... 4 20.09.2006 11:21:01 Stock Value Calculation I have the following code which gives me my stock quantity .... Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long 'Purpose: Return the quantity-on-hand for a product. 'Arguments: vProductID = the product to report on. ' vAsOfDate = the date at which quantity is to be calculated. ' If missing, all transactions a... 1 20.09.2006 10:13:43 Can't get a RecordCount in a subform I have used the basic code found on the forum to check a subform for records or not. This piece of test code shows me that I am getting the wrong answer. Private Sub cbxLastName_Exit(Cancel As Integer) Dim RecCount As Long RecCount = Forms(DeletebrokerSubForm).Form.RecordsetClone.RecordCount MsgBox RecCount If Forms(DeletebrokerSubForm).Form.RecordsetClone.RecordCount &l... 2 20.09.2006 08:20:20 Column fills with data I grabbed a mdb template for customers/workorders from MS. I am trying to modify the "workorder labor" form in design view to have the first field be a manually filled in dat, followed by start time, then finish time. I got the boxes to show up. The problem is that when I enter a date all the fields in that column are filled with the same information. I tried variations of using a ma... 2 20.09.2006 04:34:07 Form sort order I have a form which is based on a query. The query sorts the records on ID number. The form opens to someone's record who should not be first. It's the same person every time, and the records from 2 up look to be sorted correctly, but I do not know why it is coming up with the wrong initial person each time. The query is fine, it sorts them perfectly. There is no filter or sorting set on th... 1 20.09.2006 02:04:40 How get combo box to show the entire line of selected item? I have a combo box from which my user will select from a number of lines. Each line has seven columns. When one of the lines is selected my code runs in the Click event proc and does what it is supposed to and that all works fine. But what remains in the combo box after the user selects an item is just the text that was in one column (the bound column). I want the entire line, all 7 co... 2 20.09.2006 01:02:05 Macros with code Hi. How can I make a macro that executes a specified code? (I want to include some macros in a context shortcut menu, instead of using buttons in the form.) Thank you. Acores... 3 19.09.2006 23:32:50 Update second table from Subform Access 2002 XP SP2 304 records, 22 fields table 1 304 records, 16 fields table 2 linked on MemberID (text, 6C) I am looking for suggestions on the best way to do something. I have two tables In the first table I have a yes/no field (bill_this_cycle) In the second table I have 12 yes/no fields (months) If any one or more of the 12 yes/no in the second table are checked ... 1 19.09.2006 22:39:26 How to Test if a Record Exists Hi all, For the recordset associated with a form, how can I tell if a record is in the set... For example, if my primary key is pkID, how can I tell if the form that the user is looking at has pkID 15 in it's dataset? (Once again) I attempted to use for example: Me.pkID.SetFocus Me.FindRecord (15) And this works just fine as far as the UI is concerned... It will jump down and h... 3 19.09.2006 22:21:44 Hidding fields in form Hi every one:) I am not very familier in access and here is my problem. I have a form where i need to hide some fields when one fields content is selected.what formula will i use and also will that formula be under the field that i want to hide or the form it self? Can any one help please? -- JJ Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/acc... 3 19.09.2006 22:14:04 Switch between forms Hi. I have a form (frm_1) which allows me to open another one (frm_2). The first one (frm_1) is maximized and I want the second one (frm_2) to be with its original size (I did the «code DoCmd.Restore» on Open). However, every time I open the frm_2, the frm_1 (stays behind) restores its original size too. How can I avoid this? Thanks in advance. Acores... 6 19.09.2006 22:09:34 Find changes I have a form called client-form. All records are stored by clientID (ABCD, etc). I added a command button for find. When I click it, I see field "look in". That has my client-form and clientID. If it is clientID, it will work. Sometimes when I click it it shows client-form (grayed out) and will not work. Is there a better way to search for a record from a form? (Here is the code gener... 6 19.09.2006 21:51:27 Subform sintaxe Hi. Maybe this question is very easy to some of you... I have a subform 'subfrm_Correspondencia' in a main form 'frm_Obras' and they are linked by a field called 'Obra_ID'. The subform 'subfrm_Correspondencia' is a datasheet where the users enter values in a field called 'ID_ordem' (e.g. '1', '2', etc.). How can I define a variable 'ordem' which is equal to the value entered in the fiel... 3 19.09.2006 21:39:02 Before delete warning I have a popup form and I want to make a warning before the user can delete permanently a record. I already made a macro with a MsgBox with the message «Do you really want to delete this record?», and assigned that macro to the form OnDeleting event, but nothing happened and the record was simply deleted with no warnings. What am I doing wrong? Thank you in advance. Acores... 3 19.09.2006 21:31:01 On form, text box is limited to 255 characters! Help! I have a simple form with text boxes that are bound to a table. The fields in the table are "memo" and should allow a large amount of data to be displayed. For some reason, the text boxes are concatenating my data to 255 characters! What's going on????!!!... 14 19.09.2006 20:59:02 How to convert access form to an exe file? How to convert access form to an exe file?... 4 19.09.2006 19:41:25 how to update calculated date in form into table I have created database. One of the fields in the form computes age of client based on dob and date of referral. It computes this information in form but I also want this information to be recorded on an associated table. I am not sure how this is done. Any advice welcom. Thanks Pierce... 7 19.09.2006 19:38:24 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  >>