How do I control a text box via another combo box

I have read through dsome o the other answers and I just can't seem to get it. I have a table called employee information. Within that table are two fields. Retail Title and Retail Incentive. I have a form with a combo box for the the Retail Title. This field looks to a table called Retial titles which is two fields...Title and Incentive What I want to do is have it so when I choose a title in the form it populates the incentive in another text box. The combo box column count = 2 What should by settings be for my text box?(That of course if I should be using a text

Form Subform DLookup

Team, I have a Form / Subform (with tabs) On the Subform, I want to: 1. Sum values located on the Form to values located on the Subform. 2. Be able to add a new record for a subsequent Change Order. The latest attempt has been to display the sum is: Private Sub txt_Change_Order_Current_Agreement_Value_AfterUpdate() Me!txt_Change_Order_Current_Agreement_Value = DLookup("ZPCM_Agreement_Value", "ZPCM", "ZPCM_ID=" & Me!txt_ZPCM_ID) End Sub It appears that the sum and the adding of a new record are mutually exclusive. Is my assumption correct? --- Thanks for your time.

Default font for forms in Access 2007

How do you set a default font for a form or a report in Access 2007?. Mine is always Calibri 11. Changing each time is tedious. I have looked at several "solutions", (one here from 2004). None of which even faintly describe what I see. My copy of 2007 is recent, downloaded 6 weeks ago. I am using W7 64 bit.

SubForm, or something Else?

I have Chosen (big Grin) to utilize the new Multivalued fields option offered in Access 2007. But, as always, I get started very excited, but am unable to finish... Not sure how to design my Form - but it would be a Main Form Sub Form With ChurchID (as Main) and a Subform with PositionTitle1 (Non-repeating) (Indented) MinisterName1 (Indented) MinisterName2 (Indented) MinisterName3 PositionTitle2 (Non-repeating) (Indented) MinisterName1 (Indented) MinisterName2 (Indented) MinisterName3 I'm totally confused as to how to proceed... Can anyone assist? Here is my Query (easy

Criteria for check numbers only

Access 2007, Vista SP2 Ultimate I have a check register in which I enter both the umbers of checks I write and the debit card POS entries. I need to be able to separate out the checks from the debit entries. I have the criteria for the query to separate out the POS transactions in a query: Like 'DBT*' Or Like 'DBT*' But, I am having a hard time figuring out what criteria I need to separate out the check numbers (such as 123, or 371) from the 'DBT' entries in that field for the check number query. Any suggestions would be much appreciated. Jan :)

this code doesn't work fully

I am trying to create a login box for an Access 2007 database using some VB8 code I found: Private Sub CreateAcc_Click() Dim username As String username = Text23 If Text23 = "" Then MsgBox "Enter a Username !" Else If Text25 = "" Then MsgBox "Enter a Password !" Else Open app.Path & "\Accounts\Users\" + username + ".txt" For Output As #1 Print #1, Text23 Print #1, Text25 Close #1 End If End If End Sub It runs up to the line 'Open app.path etc, then get a runtime error 424, Object required. What would t

Hide ribbon event not working

I'm terrible with VBA so this might be something really simple. In Access 2007, I have a startup form with this event on load: Private Sub Form_Load() DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide DoCmd.ShowToolbar "Ribbon", acToolbarNo End Sub and this on close: Private Sub Form_Close() DoCmd.SelectObject acTable, , True DoCmd.ShowToolbar "Ribbon", acToolbarYes End Sub I've also tried the first event as on open and there is no apparent difference in functionality. I got the code from searching for ways to hide the ribbon and navigation pane. Thes

Tab Order

In Access 2003, I have a continuous form, with several text boxes, 4 of which are user editable, and 4 check boxes. Everything works as it is supposes to, except when I tab through a record, if a change is made in either a check box or text box, when tab is pressed again, the focus goes to the first field of the first record, rather than the next field in the current record, or in the case of the last field of a record, the next record, as I would expect. It's probably a simple setting I'm missing, but I've not run into this issue before, so any thoughts are appreciated.

status validation help

Hello, I need some help coding this one... I have 3 fields in a form Amount, Date, and Status. If the user inputs an Amount then they must enter a "Date" in order for the database to accept a Complete "Status". The Status field has several drop down choices, Open, Pending, Complete, etc. Any help would be greatly appriciated!! Thanks, ~Gabe

Need from to replicate itself as a blank for each time it is opene

I have created a database to track demographic information for our surgical patients. The simple information entry works great (name, address, surgeon, date of surgery etc..). The staff now wants to add the followup portion into the database. They call the patient one day after surgery, one week after surgery and one month after surgery asking the same questions each time they call. I created a form with all of the questions they ask with check boxes and a comment field as well as a field that will automaticly input todays date. What the staff want is to not write over the data

Lebans MouseWheelOff code

I've dowloaded Steven Lebans MouseWheelOff sample db in hopes of using the code in my db. However, when I try to open it, Access gives the following message: Microsoft Access cannot open this file. This file is located outside your intranet or on an untrused site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location. Not sure how to resolve this since it already IS on my machine. Any ideas on how to get around this?

Graphical problems with forms in AC 2007

I have an Access application which I run both on AC 2003 and AC 2007. It works OK on AC 2003, but on AC 2007 the forms get sometime "garbled". Please see here: http://www.caspit.biz/images/03062010_025718.jpg -- OK http://www.caspit.biz/images/03062010_025833.jpg -- "Garbled" Dror dror at caspit dot biz

Date query

This is a multi-part message in MIME format. ------=_NextPart_000_06C4_01CB0295.E90C4830 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am using a census database to enter data from the 1901 UK census. To = calculate the year born the input age is subtracted from 1901. However, = when a child under one year old is enter, obviously an error shows. =20 What do I need to do to show 1901 when a child's age under one year is = entered. The age field can hold three numbers and one letter (h =3D = hours, d=3Ddays, w=3Dweeks, m=3

Skip pattern based on text box value

Hi, I have a text control. People will be typing either words or numbers into it. If they type 99 I want to skip down several questions. Here's the condition for my macro: [Forms]![frmFB213]![FB215]=99 The action is 'Go to control' and the control name points to question FB229. I've put my macro in the AfterUpdate section, but nothing is happening. I'm suspecting this is because the answer is free-text. All my skip patterns based on combo boxes are working well. I've tried putting single and double quotes around the 99, I've tried using the "Like" feature with 99 in and not in quo

Conditional Formatting

I have a form in datasheet view that i need to be able to change only a few fields to different colors, bold or highlight if different checkboxes are checked or dates are null. I've tried to do the conditional formatting on the main menu but if more than one criteria is recognized it only returns the first criteria. Can anyone tell me how I can get this to work. -- Alison

Unbound text box calculation

Thanks in advance for the assist. My mind went numb... What must I do to have an unbound field only perform the calculation for the current open record that I am working in and not show data in a new records same unbound field when I go to the next record entry? I have an unbound text box on a form - call it Box C. In it's properties control source I have a calculation (i.e. =text box A input / text box B input) that I wish to show within the form prior to moving to the next record. I then wish this field to recalculate or return null (if box A and/or B are empty). Box C will

specifying which subdatasheet in Access 2003

In Access 2003, I have a form with four distinct subforms. When I open the main form in datasheet view, the first subform is available as a subdatasheet. 1) How do a specify a different subform to be used as the subdatasheet? 2) The subform originally opens in form view when the subdatasheet is expanded and it appears. Is there a way to have it appear in datasheet view instead? Thanks.

Employee time punch form

I have a table containing two fields - Employee_ID and Time_Stamp. I've already created a form that scans in Employee_IDs; and once any Employee_ID is scanned in, the ID and scanned time is recorded to the table. In addition to what it already does, the form needs to populate the employee's punch time records for the current week. For example: (current date and time is Wednesday 9:02 am) (Form view before update) Employee ID: ___________________ (Form view after update) Employee ID: 1001 (Scanned) ------------------------------------- Employee ID: 1001 Mon: 9:00 am Mon:

Multi Value Combo Boxes

Hello: One of the new features of Access 2007 (sometimes criticized) is the ability to create a table field as "Allow Multiple Values" using the Lookup Wizard when specifying the data type. This shows the values with a checkbox and allows the user to select multiple items (i.e. select CA, OR, WA as states in which a business resides). I was hoping to just define a table field as Text and then create the "Allow Multiple Values" when creating a combo-box on the form. The form wizard does not seem to create the same objects as when doing it in table design mode. So, unless

BoundColumn property

Can someone please explain in layman terms, the purpose of BoundColumn in ComboBox in terms of viewing two columns when dropped down and storing one value in the table and displaying different value in the form? I want to be able to see two columns in drop down mode, column 1 value stored in table and column 2 value displayed in form data view.

Using the second column of a lookup field in row source

I'm working on a form on a database in which I need to do a lookup on one combo box that contains two columns, and a followup combo box requires that I match something in the second column. So, basically, if I have Box A, which looks up a BoxA_ID column (column 1) and a BoxA_Value (column 2) column, I'd like to create a statement in Box B where I'm trying to match a value with the BoxA_Value column. Can anyone help me here?

How to use dynamic query in Access 2007 Form?

Dear Friends, I have a table named "class_grades" and with the fields of "First Name", "Last Name", "Age", "Math", "Physics", "Computer" and "State". I would like to build an Access form with dynamic query... 1. For the age and state, it's "drop_down select" 2. For the Math, Physics and Computer, I can enter the number and click an arrow button (to match the number with +/- 10%), then it will show all the matched list. All these "keyin" and "results" should be shown in the form (form + sub-form?) I am sincerely looking for your help to guide me how to implement it. Thank you very

read/write for some users, read only form others

I have a database at work which I built in Access 2007, but then had to save it as a Access 2003 mdb format. The database was then placed on a NAS server and split. The front end was then placed on local users PC's, some of which have Access 2003. I now want to restrict write access to some users and only allow 2 users to do that, while all can have read access. How can I achieve this situation and what is the best or easiest way of doing so. Thanks

checking for existing record

Hi Tom, I'm still having trouble with this. In your reply you have " & me.myCasenumberControlName". My control is a text box called Case Number. I've entered it as "myCaseNumber", "my [Case Number]", Case_Number and [Case Number]. None are working. I get a compile error message - Expected: End of Statement. Please help. "Tom van Stiphout" wrote: > On Sat, 22 May 2010 22:32:01 -0700, mbparks > <mbparks@discussions.microsoft.com> wrote: > > I'm assuming you meant "move to the record with the correct > casenumber". This is accomplished with the bookmark technique: > wit

Missing files

Last year I had to have an MS software engineer based in Houston fix problems with my Access 2007. One thing she discovered was that my copy of Office 2007 did not contain the files DAO1 and DAO2 which are required to make the automation and forms processes work properly in Access. Does anyone know how I can obtain these files as the lady who helped me before is no longer available?