Threads Replies Last Post 396 Pages: <<  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  46  >>   How do I link forms from related tables in Access? I create 5 forms form related 1 to many related tables in MS Access. I need to keep the forms together. How can I do This_... 2 06.09.2006 17:04:56 Checking for Errors Hi Pleeease help! i have a table called Teaching_Subject. It is made up of details regarding the subject e.g. teacher name etc and a subform. the subform is called Teaching_measure. It shows the dates to and from that the subject is being taught. On another form, teaching_options - the user is required to enter a Date and select a Teaching Subject (this is a combo box - coming from t... 2 06.09.2006 17:02:02 Bug in MS Access 2003 subform events do not fire I have Access 2003 with a Windows based server and XP Professional on the client. I have a main form with no bound recordset. The main form contains four subforms. All the subforms are bound forms. The main form has some combo boxes that are used to control the subforms. On the main form is an unbound text box that is populated by the the choice on the combo box. The subforms use m... 15 06.09.2006 16:58:01 Checkboxes in Subform Hello All: I have a incident table, action_taken table and incident_action_taken table. incident table ------------------- iid(PK) name desc action_taken table ------------------------- aid(PK) name desc incident_action_taken ------------------------------- id(PK) aid iid I have a main form and a sub form. Main form shows incident table and subform shows incident_actio... 1 06.09.2006 14:58:14 =?utf-8?B?Q29ycnVwdCBSZWNvcmQgLSBBbm90aGVyIExhbmd1YWdlIEFwcGVhcnMg3Y3pkqzdjemSrN2N?= When our network goes down and Access is unexpectedly closed some form field values change to symbols and another language. The data source is a query with two tables; Table 1= Person, Table 2 = Activity. The issue always happens with the Activity table. Here is an example: 㘱摁番瑳牥 Not sure how else to explain the issue. Any suggestions? Thank you, Sandy -- Message po... 1 06.09.2006 13:16:15 Subform Problems Good day, I have a table with the field OrderID that is a primary key linked to other tables with one to many relationships. I generate a query based on these subforms and it does not display the information unless I go through each subfrom and press enter which makes a record. Basically I donot want to have the user to do this all the time if they feel like skippping a subform. Any ... 4 06.09.2006 12:53:03 Desperate for help......Would like to automate text entry... Just to start off, I know nothing about coding, so I am definitely trying to find a way to do this using expressions or macros because I only have a few days to finish this project (before I leave for another job) and I'm wondering if what I want to do is even possible at this point. So, here's what I want to do: I am attempting to set up a new form for easier data entry into my firm's... 3 06.09.2006 12:45:02 Embedded subforms and data-entry on M:M relationships I have a question around using forms to display and add/edit data which is organised in a complex relationship.. The database is for a call centre, and controls which type of caller has access to specific account activities, and messages that will be displayed for the allowed/denied access. The table Activities has fields Activity_ID (PK), Activity_Name. The table Caller_Role has f... 2 06.09.2006 11:08:01 Calculating workays between two dates Hi, I am using the first function on this website: http://www.mvps.org/access/datetime/date0006.htm Is there a way to keep from getting #error if one of the 2 dates are missing? The user may fill in the closing date later. Thanks, James ... 2 06.09.2006 10:57:12 Working days I have a field that updates upon the checking of a tick box. A further field is linked to the updated one which is basically 3 days after the updated box. Is it possible to make this update 3 working days after, rather than a simple Date()+3. Many Thanks, Matt... 7 06.09.2006 10:19:02 Limit on entries in combo box Hi guys I have a combo box that is populated with a simple query which selects client ids from a table. However, as of last week the newer client ids are not being populated to the combo box. So i am thinking that the combo box has reached its limit for number of entries it can display. Anyone know if there is a limit and what it is? We are using Access 97 still and the current amount of... 3 06.09.2006 08:55:16 Tax rate changes by date I have a simple database for issuing purchase orders. I have a table & form for the main PO and then another table/subform for the individual items on the PO. I have 2 fields for the taxes in our Province - Provincial Sales Tax (PST) and our federal Goods & Services Tax (GST). These are logical fields if the taxes apply to the PO item. Our GST just changed on July 1st, and there is r... 2 06.09.2006 08:52:25 alter table in access code How can I issue an "alter table" command in a code in Access 97 ? THanks. ... 3 06.09.2006 06:46:26 Store SubForm Information I have employees who changes names, departments, job titles, when I update the main table (SdDirectory) with the new information all the pass and future records incorporate the new information. My queries are incorrect for information related to any of specific field. If I use a sub form to pull information from tables that information might change, I want to design a new data base to b... 1 06.09.2006 04:26:01 Create record on form open. Hello all. I have a Invoice form that retrieves data from a previously opened Accounts form. The Invoice number field on the Invoice form is used to track which charges belong to that invoice via a query, so before you can start adding any charges to the invoice, it's record has to be created otherwise you have a charge that belongs to null invoice. The only problem is that the Date ... 1 06.09.2006 01:01:01 Command Button Failure... For some reason when I try to creat a command button on my form it gives a beep and displays the following message: "Object variable or with block variable not set" It also doesn't allow me to continue, so I'm stuck until I figure out what's wrong... Any ideas? Thanks! ... 4 05.09.2006 23:31:52 Import form (*.frm) from a VBA project? Hello, Beginner Access user here. I made a form in a Excel VBA project and exported it to a .frm file. Is there a way to import it into an Access database as a "regular" form (not a form in VBA project)? Thank you. - Kelie ... 1 05.09.2006 23:27:44 Report field does not grow I am creating a report which groups steel and plastic components for an item and prints the those components in two lists. I may have have up to 25 items associated with the steel or plastic and I am building a comma separated list in the report from query data. When the report prints, I get only a single row of data for each component whether or not it fills more than one row. When I expa... 2 05.09.2006 22:53:10 Masking Question I have a form that I need to have it show and print a number that starts with a "0". the number is 064278 I trred to use a mask with "999999" but it did not word. Any Ideas. ... 2 05.09.2006 21:48:01 Continuously updated subform from query I am creating an invoices database where the charges on each invoice are recorded in a table of thier own. To display these charges I have a subform on the Invoices form that is linked to a query that displays all of the charges for X Invoice number. I can successfully add charges to the table via a seperate form accessed via command button, but the charges subform on the Invoice form ... 1 05.09.2006 21:31:02 Preventing Additional New Records On a form I have set to Data Entry and Additions "Yes", I am having a problem with users scrolling to a new record, before they have completed the record they are entering. They are doing this either by using the scroll wheel on their mouse or page down on their keyboard as best I can tell. What is the best way to prevent the addition of more that one record without unbound controls and ... 3 05.09.2006 19:46:55 Values in a new option box I have a form I have been using and added a new field to the table the form is bound to. I added the new field to the form using an option box. However, when i view the form in an "edit" mode (Data Entry = No), the records which were added prior to adding this new field are "checked", (even though they are not checked in the table). How can I have the option box "unchecked" on the for... 4 05.09.2006 19:46:02 Customize navigation toolbar? My user does not want the 'next' button on the navigation toolbar to position on a new record. Is there a way to gray out this button when I'm positioned on the last record? Thanks for any help.... 4 05.09.2006 19:36:02 Help with button code - email I have create a form and a button to send emails. The button has the following code behind it comes back with an Error. The Field that contain the email address is "email1". The Error message I get is, RunTime Error 7980 The HyperlinkAdresss or HyperlinksubAddress property is read-only for this Hyperlink. When I do a debug the line below with the "***" is highlighted. I have u... 1 05.09.2006 18:52:43 Subform Problem changing Form OrderBy I'm really stumped by this problem... I created a Form1 with Query1 and the OrderBy was set to Date1, I presume because Query1 had such a sort. I added to Form1 a subForm, Form2, with: LinkMasterFields = LNameH LinkChildFields = LName and it worked fine. I decided to change the OrderBy for Form1 to LNameH. When I made the change, the subForm would not display any records. I c... 1 05.09.2006 18:43:19 396 Pages: <<  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  46  >>