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  >>   Combo box based on another combo box Hello all, I've read the Microsoft Office Online help at http://office.microsoft.com/en-us/assistance/HA011730581033.aspx, but I can't figure it out. I'm a "Newbie" at this. I have a Lease Management database with over 100 stores. Those stores are broken down into Regions and then districts. The main tables for this combo box are: tblstores (storeID, address, etc.) tblregions... 2 26.09.2006 14:25:02 How to Change or link tables from sub to parent form? I made a subform and for some reason linked the names from one table to the next. Now I am having trouble with duplicate names. How do I correct this and sync up to keep the correct data? Do I need to make a new subform? Do I need to change the tables? Here are my tables: TNewCases [ID] [claimantfirst] [ClaimantLast] [Date of Birth] +many more TRa... 2 26.09.2006 13:48:59 Dilemma for Key Field I have a database that I want to use to track corporate records. Others have determined that they want to use a key field that is a six character date (like 092006) followed by a four character number (like 0001). Is there a relatively painless way to get my form to "create" this key field based on the date and the next available number? Thanks in advance for any help. -- JW ... 5 26.09.2006 13:25:56 In forms; code entered how can automatically display related info I am creating a work database and we use codes for customer's and their information so I want to be able to enter a code that relates to a customer's name, address and postcode. When the code is entered or selected from a list (in a form) I want the related customer's information (name, address, postcode) to automatically appear beside the code and to be saved with the record once all t... 3 26.09.2006 12:52:01 not sure on query relationships? I did what was recommended below but am having an issue. How do I incorporate the delivydname(tried adding it as a primary key and get no records on the query) I believe this should be Client specific. I am having an issues with having the same yard numbers for different del yard NAMES Example: Prairie Material’s yard # 15(Delivydnum) is Addison(delivydName) Ozinga Concrete... 4 26.09.2006 12:44:37 validation rule, input mask? Hi, how can I make sure input in a text box would be like following: xxxx/nn where xxxx is a number and its number of digits (one digit or more) may vary and the nn is two digit string (number that may start with zero) thanx alek_mil... 2 26.09.2006 11:40:56 Email question I am using the below code to send a email. I currently change the default of the email to HTML and copy and paste the content of the subform in the body of the email. Is it possible to have the content of the subform automatically entered into the body of the email? Also, how can I have the email open in HTML format so that the data in the email is formated as in the subform. Thanks... 1 26.09.2006 03:41:02 Copied form won't allow data changes I made changes to a form on a copied version of my database, then deleted the form from the original db and copied the new form back to the original db. It now will not allow me to add/edit in the form. The form has a lock/unlock function and all the code is still there. Any help whould be appreiciated, Thanks. Ashley... 1 26.09.2006 03:11:01 on dirty i hav a field which is in subform. i'm named it as location. when user change the location and i want to know and i want the record to keep it in a table. i want to know when the user change the location n where they put the things now. what i can do? thanks!... 7 26.09.2006 01:58:02 copy a database Hello: I want to make a copy of the structure of an existing database. This database have linked tables and when i want to import the database without the data, always copy the data too. I don't know how i can acomplish to copy the database. Could somebody help me!!!. Please. Thanks ... 2 26.09.2006 01:33:57 Looking for calendar template Monday through Friday only I want to create a single calendar each month that shows only Monday, Tuesday, Wednesday, Thursday, and Friday. I want a template without weekends. I usually create my calendars through Microsoft Word Calendar Wizard, but there is no way to get rid of the Saturday and Sunday columns. ... 2 26.09.2006 01:32:08 Adding a new record to another table Hi experts, I have a form based on table1. By selecting the ProjNum from a combo box on this form, I need to add the selected ProjNum to another table (Table2). Table1 is the master table with all the projects and related info. the Supervisor wants to accomplish the following: 1. Enter the newly received project in Table1 2. By selecting this new Project from the Combo Box on the frm... 4 26.09.2006 01:27:31 Me.Refresh works sometimes??? Please help! Hey All, I have Me.Refresh in two places, the first example works but second does not and unless I rem it out the code won't compile. Can someone tell me why? Thanks, Gina Whipp 1st Example: This works... If IsNull(Me.txtNonConformanceID) Then DoCmd.SetWarnings False DoCmd.RunSQL "UPDATE tblGetAUPReferenceID SET tblGetAUPReferenceID.garAUPReferenceID = [garA... 10 25.09.2006 23:09:45 open form from a form with matching ID numbers and update table I have a data entry form with a command button to open another form to enter comments. The form opens as I programmed it with the matching customer ID; however the form is not updating my underlying table, though it updates the other keyed in info. What am I doing wrong??? Thanks. Trac... 4 25.09.2006 22:19:47 Strange sorting behaviour in forms Hi All - my turn to ASK a question. I have an application in which some of the forms contain a subform in datasheet view. It is set up so that users can hide/unhide columns they wish to see at any given time. They can also sort the data on any of the columns in the datasheet, using a custom menu bar, with the appropriate MS toolbar items for sorting and filtering. On occasion, ... 4 25.09.2006 21:59:23 Tranferring values from one form to another Hi, I am fairly new at using access and have been given the task of coming up with a timekeeping database for a large company. I have a daily timesheet in one form and a weekly timesheet in another. I would like the value for the total hours on a certain day to automatically show up in the weekly form for that day. I am baffled. Can someone please she some light? Thanks, Lynn... 3 25.09.2006 21:09:15 lookup column I cannot make the focus of the form stay the same... I have many pieces of equipment to attach to one technician... Every time I enter a piece of information the lookup column goes blank... how can I make it stay the same until I change it... 2 25.09.2006 21:07:41 suppress "#Name?" Is there a way to suppress this display when data is not yet available to a textbox? This shows prior to the user selecting a client and looks tacky. Thanks -- sam... 3 25.09.2006 21:03:48 field autofill based on another field I have a combo box that lists names of queries. Based on this combo box, I would like a text box to give me it's corresponding code. ie: query name is "number of buys" the text box should have a 1 in it. I have about 31 query names and corresponding numerical values. Thanks for any help you can provide.... 3 25.09.2006 20:11:02 Check boxes and forms I am new to access and databases in general, so forgive me if my questions seem elementary. I would like to create a form with a series of check boxes for questions for potential clients (i.e. Married ?, Children?, Pets ?, Languages?, etc). Selecting the box would then take the prospect to forms specific to their answers on the intake form. There may be 25 - 30 questions on the intake form... 3 25.09.2006 20:04:44 Parsing character separated string into individual components I have a field that was copied and pasted into an access database. This field needs to be separated into separate fields, which are separated by commas. I have searched and found an article on The Access Web authored by Dev Ashish and it appears to be exactly what I need. The problem is I am not sure where and how to implement this code. Can someone instruct me on the use of this cod... 3 25.09.2006 20:00:02 Exporting Queries Hello, Is it possible to use a command button in a form to 1. Run A query, and 2. Export the Query to an Excel file always saved in the same location and rewriting the old file? and do this with 1 click? Maybe I am trying to do to much? Thanks, James ... 2 25.09.2006 19:39:46 freeze panes in pivot form Is is possible to freeze columns when you are on a pivot form? Thanks... 1 25.09.2006 19:31:01 Test Post I have posted a few messages to this board but never seem to be able to find my post later on and/or view responses. This is a test post to see if there is something wrong. If you see this post and feel like helping out, please either send me an email or reply to the post. Return email is tom.pratt@fie-inc.com . Realize this is opening myself up to spam, but at least at that point I ... 1 25.09.2006 18:34:08 help please would anyone know why this doesnt work? strWhere = strWhere & "([processed_leave_date] = not null AND [date_exercised] = null) and " it's a line from a filter i've created...the rest work but i cant get this one to! i'm trying to create 2 criteria's for the filter but it's just returning a blank form! -- Message posted via http://www.accessmonster.com ... 4 25.09.2006 18:20:28 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  >>