Over 1 million tech questions and answers.

Solved: Access Forms - Changing Text Box to Drop Down

Q: Solved: Access Forms - Changing Text Box to Drop Down

Hi all. I am sure this is a fairly basic question which shows a lack of understanding of how Access works, so if its stupid, I apologize in advance...

I used the form builder to create a new input form for data. There is one selection for "Manager", which defaults to a text box that you can navigate with the arrows on the bottom of the sub-form, which has the manager id (primary key), the date, and the return associated with it. It works as intended, but the text box won't work long term.

I expect to have a decent number of managers, so I'd like to make that a drop down box so the user can select it, not have to scroll through one by one. I changed it to a combo box, and specified the query to populate the box. When I select a different manager than the default, I get an error which says, "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

I think its trying to create a new manager with the selected name from the combo box, but it won't allow duplicates (which it shouldn't). What am I missing conceptually here?

RELEVANCY SCORE 200
Preferred Solution: Solved: Access Forms - Changing Text Box to Drop Down

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Access Forms - Changing Text Box to Drop Down

Read other 16 answers
RELEVANCY SCORE 80.4

I have created a form using the Wizard.
I selected thirteen fileds from one table
And thirteen from another table
After I spent a lot of time developing the form, I found out I needed another field.
I added a new field to the one table, but now how do I create a Bound Box to this field in my form?
When I try to use the Field list button all I get is the original twenty six fields to choose from.
Maybe there is a way but How do you add more fields to the field list?
 

A:Solved: Access/Adding Bound Text Boxes to Forms

Read other 9 answers
RELEVANCY SCORE 72.4

I am using Access 2003 and would like to be able to change the text colour of one field in a sub form according to the content of another field. Does anyone know of any code that would allow me to do this?
 

A:Solved: Changing Text Colour in An Access Sub Form

Read other 14 answers
RELEVANCY SCORE 72.4

Hi All,

I am working on a special event that happens every year. I have the entrants for this event in a 2010 Access database table.
Some of the entrants are judged and some are not. Those that aren't judged get a "0" entered in there "judging category" field.

In previous years, my boss would take the information from the tables and dump them into Excel. She would then manually change the "0" into the text "Not Judged" and then make an Excel report to give to the judges.

She was so impressed with my other Access reports that she wants to skip the Excel dump and have me make an Access report for the judges, However, she still wants the non-judged entrants to show up on the reports we give the judges as "Not Judged". I have books that tell me how to write all kinds of numerical expressions, but none that tell me how to convert a number to a text message.

Please, if someone knows how to do this, let me know the steps, and if you do it in the query or in the report based on that query.

Thanks in advance,
 

A:Solved: 2010 Access help changing a number into text

Read other 14 answers
RELEVANCY SCORE 72.4

I'm still working on that event.

Here's a variation on the Judging category problem.

I have another report to run with two different categories: Equestrian and Other which now appear in the reports as 2 and 3 respectively. It would be much more useful to the people having to stage these entrants as "Eqtn" and "Othr" (space limitations)

I am wondering if I can use a variation on the expression I used to change the "0"s in the judging categories to "NOT Judged"

That expression was: IIf([judging category] = 0, "not judged", [judging category])

I am wondering if I used something like IIf([Class] = 2, "Eqtn", [Class] = 3, "Othr"])

Would this work?

Thanks,
Sara
 

A:Solved: Access 2010 New Changing number into two different Text.

Read other 16 answers
RELEVANCY SCORE 71.6

I am creating a report that lists entrant cancellations for an annual event. The cancellations field is currently a Yes/No checkbox called "Cancelled". I would like the report I generate to actually say "CANCELLED" as opposed to "Yes" . Would the Expression for this be:

IIf([Cancelled] = Yes, "CANCELLED", [Cancelled])

or would it be different because the cancellation field is a Yes/No checkbox?

Thanks,

Sara
 

A:Solved: Access 2010 Changing Yes/No Check box to text in Report

Read other 10 answers
RELEVANCY SCORE 65.6

I use a common file in the blank type form for business applications. I can scan the document and save as jpg file,etc. What I need to do is add answers in the blank areas of the form, not change the existing for,, but add responses, etc. in the lined blank areas of the form and save it online. Sounds pretty common, ....rather than print the form out, then add the responses by hand, I would like to do it via software, etc. HOW? READ NEXT RESPONSE< might make this a little clearer...thanks again.
 

A:Solved: Adding text to scanned forms.

Read other 12 answers
RELEVANCY SCORE 63.6

I'm having exactly the same problem. I want to insert data into the text form field, but I do NOT want the text in the document to move out as I type. I want the data to fit in the underlined space I've provided, without bumping out the characters outside of the form field area. It's been suggested I use the "fixed column width" but that isnt an option I have available. I have Windows XP Professional version 2002, using Windows 2003. No one has been able to answer this question, so maybe the answer is a different application needs to be used, if so, which one?Thanks.
 

A:Inserting text in Word doc using Forms toolbar-text keeps moving as I type

Read other 7 answers
RELEVANCY SCORE 63.2

Hey guys,

So I'm making a field which is a drop down list based off another table where I enter the drop down values into. I was just wondering whether or not it's possible to have a drop down menu WITHIN a drop down menu.

Example: The user has to select from multiple departments, and some departments have multiple sub-departments.

Please Enter Department:

Main Department
Main Department
Main Department
- Sub-Department
- Sub-Department
- Sub-Department
Main Department
Main Department
- Sub-Department
- Sub-Department
Main Department
Something to that extent would be perfect. I'm just wondering if this is possible or not.

Thanks in advance,
Greg
 

A:Solved: Access 2003 Drop Down in Drop Down

Read other 6 answers
RELEVANCY SCORE 62

Mentors,
In my access database have a field that defined as date from the table. my users want the field as a choice either a date or text words .Can that possible?
 

A:Solved: drop box between a date and text?

Read other 8 answers
RELEVANCY SCORE 60

I have a form I am trying to not go to a new record until certain fields have data entered by user. I have the following code, but whenever I use Access's New Button (at bottom of form), it will still go to a new record without data entry in the desired fields. These fields can not be required in the bable because it's based on a selection.
Example If user selects "House", only certain fields need to be entered, if user selects "Condo" only certain fields need to be entered. This is just an example. Below is the actual code I have so far. ----Thanks to all who can help me!!!

Private Sub Form_AfterUpdate()
Dim strUserInput

If Me.Contract_Type = "House" Then
If IsNull(Me.ITB_No) Then

strUserInput = InputBox("Please enter ITB number")

'Check to see if there is any entry made to input box, or if
'cancel button is pressed. If no entry made then exit sub.

If strUserInput = "" Or strUserInput = Empty Then
MsgBox "No Input Provided", vbInformation, "Data Required!"
DoCmd.GoToControl "ITB_No"

Exit Sub
End If

'If input entered, continue
'If input not entered, give message and exit sub

If strUserInput Is Not Null Then
Me.ITB_No = strUserInput

Else
MsgBox "You MUST enter a number", _
vbOKOnly, "Important Information!"
Exit Sub
End If
End If
End If

End Sub
 

A:Solved: Access 03 - VBA, Forms

Read other 6 answers
RELEVANCY SCORE 60

Hi,

I need a bit of help as I have no idea how to go about even starting this. I would like to have a drop down box (which is the part I can do), but then depending on what was selected from that box, I would like to have another drop down box appear if a certain something was picked from the first. Is it possible to do this in just SQL? Can somebody point me in the right direction? ...OBP?
 

A:Solved: Access Forms

Read other 16 answers
RELEVANCY SCORE 60

Hi

I am new to access and am designing a database for staff that have varies degrees of computing knowledge.

I have the structure of the database in place and am now creating form for the users to input information. I want the new to be blank everytime a user opens it, though at the moment the forms display the first record of the corresponding table.

I really need to default of the forms to be blank as I don't want staff over writing the data.

You help is appreciated thanks.
 

A:Solved: Ms Access Forms

You will want to go into the form's property sheet. Try double-clicking on the "Form Selector" which is the little box in the top left-hand corner of the screen. In the "Data" tab within the property sheet set "Data Entry" to use by double-clicking on the "No."

Have you looked into making a switchboard which is an interface that allows them have all of the forms, reports, queries etc that you want them to see?
 

Read other 2 answers
RELEVANCY SCORE 60

Hi all

This is my first post on here, so please be gentle!

I am a relative newcomer to Access 97 (which we still use at work), and have created a form which includes customer records. However, what I have now been asked to do is beyond me. One of the fields can be either empty or populated. I have been asked to ensure that if the field is empty it cannot be amended, but if it is populated, it can be changed if necessary (but not to an empty field). I currently have it set up as an enabled/unlocked text box, so it can be amended whether empty or populated.

Is there any way of doing what I have been asked? If you know the answer, please treat me like I'm an idiot and make it very simple to understand!!!

Many thanks for taking the time to read this.

Regards

Ed
 

A:Solved: Access 97 forms

Ed, welcome to the Forum.
About the only way to do this is with VBA code.
So the first place to work with is the "On Current Event Procxedure" of the Form.
With the Form in Design View click on the Events Tab, then on the "On Current" event and then select Procedure from the drop down that appears.
3 small dots should also appear, click on those to open the VBA Editor at the correct Event and type in
if isnull(me.fieldname) then me.fieldname.enabled = False

Where fieldname is the name of the field that you want disabled when it is Blank.
The VBA editor should offer the control names after you type in me. and as you type in the other characters jump to those available with those letters.
See if you can get that to work.
 

Read other 2 answers
RELEVANCY SCORE 59.2

Hi there,

I have a subform within a form that contains a field with the control source =[PurchaseOrderNumber] & [PartNumber] which basically puts two fields together to create a barcode. I would like for this value to be saved into a field in a table.

Does anyone know how I would go about doing this? I have searched for solutions & have found none.

Please let me know. Thanks!
 

A:Solved: Access 2010 Forms

Read other 6 answers
RELEVANCY SCORE 59.2

I think the solution to my problem is fairly simple, but I can't seem to find it in any forums on the web(probably because I don't have the lingo down).

So here we go: I've created a parking pass database for our organization. The primary key is attached to a 6-digit parking pass number. I want to create a search tool so our parking guys can enter the parking pass number and retrieve the corresponding form. The form has a nicer layout than the table, so I want to retrieve the form, which contains car description, owner, address, etc.

Is this possible?

Thanks in advance, you guys and gals are very helpful
 

A:Solved: Search through forms in Access

Read other 15 answers
RELEVANCY SCORE 59.2

I have a very basic one table database in Access 2002, which users only use as a store for data. They view the database from a form and perform searches ad hoc using the form filter. I would like to enable them to produce a report of the filtered information to be printed as required. How would I go about this?

I imagine it will be some sort of command button, but none from the wizard seem to suit so if I have to write the code....where do I start? I can do code but no idea on the structure of it to achieve this.

Thanks in advance!
 

A:Solved: Access Reports from Forms

Read other 16 answers
RELEVANCY SCORE 59.2

Can someone please tell me how to I create a form that will have a check list for safety procedure? This form will need to be able to allow a new record but save the old record. I am adding a safety checklist in access 2010 for my job and I need to know how to do this. Thanks
 

A:Solved: Access 2010 forms

Read other 6 answers
RELEVANCY SCORE 59.2

I need to require that certain fields in a form be populated before a user can move on to the next record in that form.

I included the following formula in the BeforeUpdate property for the form:
=IIf(IsNull([Combo40]),MsgBox("Please select a value for SAP Adjustment required"))

I've tested this formula and it works. The problem I have is when I click OK on the message box the form advances to the next record. I would like to keep the same record visible that prompted the message.

Can anyone advise how I do that? Is there something wrong with my formula or do I need to do something else?

Thanks!
 

A:Solved: Access 2003 Forms

How are you inserting the data? With a button click, or moving off the last field? If your using a button, I would use the Click event. Test each field's text box/combo box/etc to see if they contain data AND the proper type of data (IE you expect Alpha characters in a test box and someone tries to enter numbers). Once all your conditions are met, then and only then do you add the data to your table. Otherwise, move the focus back to the control that needs data.

IF your inserting data by moving off the last field, try using the before insert event Do your checking here. You might also check out the On Dirty event (either use the on-line help or do a google search).
 

Read other 1 answers
RELEVANCY SCORE 59.2

Hi,
I have this problem and can not see that it has come up before on here.

I have a form. When I click a command button, a report opens. When I close the report, the form reappears but it is NOT maximized. Is there a way that I can make sure the form remains at maximized size even when the report closes?

I use docmd.maximze when the form and the report opens. When the report closes, I use docmd.restore in the close event.

I can get around it by placing an openform part in the report close event but I need to use the same report in various forms and do not want to do this.

Can anyone help?

Thanks
Simon
 

A:Solved: Access Forms Maximize

Simon, some things to check, ensure that the form property modal is not set to yes, that the Control Box and Max/Min Buttons are set to yes.
I also use the Maximise command in the Autoexec Macro after opening the first form.
 

Read other 3 answers
RELEVANCY SCORE 59.2

Hi,

I'm hoping for some advice on Access application architecture.

I'm modifying an application in Access 2003 on XP. I have a form that's bound to a (linked SQL Server) table and I want to alter the way the form stores modified data - specifically, I want it to call a stored procedure in the DB instead of automagically altering the underlying data through the binding mechanism.

I tried binding the form to a SELECT query instead of the table, hoping that this would break the binding for storing the data as well, but it did not.

So, what is the best way to change the form so that it reads the data from the table but requires action (either an UPDATE or call to a stored procedure) to update the DB? Currently, even if I comment out the "DoCmd.DoMenuItem ... acSaveRecord", on the forms save button, the record still gets updated.

Thanks in advance for any help you can give me.

I'm a reasonably experienced developer, incidentally, but this is the first time I've delved into Access.

Regards,
Bob
 

A:Solved: Access forms binding

Read other 16 answers
RELEVANCY SCORE 59.2

I have a problem with Access. I am trying to add a command button to a form that opens another form filtered for 2 fields from the original form. I can get it to filter for one field inthe wizard but how do I get it to filter for 2.

Also how do I open a subform with a command button and have it ready at a new record with a certain number in one of the entry fields...

Am I making any sense??

Steven
 

A:(Solved) Help with forms in Access 2000

To have two conditions in the Where clause, use the word AND. For example:

"[Field1] = " & [Field1] & " And [Field2] = " & [field2]

IMPORTANT! Remember the space before the word AND or it might not work. (It might attatch the word to the comparison data from before instead of leaving it as it's own word.)

If you want to open a subform with a command button, I would reccomend setting the Visible property of the Subform Control to false by default. The following code should be put in the Click event of the Command Button:

<BLOCKQUOTE><font size="1" face="Verdana, Arial">code:</font><HR><pre>
Private Sub NameOfCommandButton_Click()

With NameOfSubformControl
.Visible = True
.form.recordset.addnew
.form!NameOfTextBoxOnSubform = ValueYouWantToGiveIt
End With

End Sub
[/code]

That should do the trick.

Good Luck!
 

Read other 2 answers
RELEVANCY SCORE 59.2

I have a comments field, but when I press enter, it goes to the next field. How can I change it so that, when I press enter, it goes to the next row in that field?

I also want to know if I have a field with two different states listed, how can I select one by pressing enter?

Thanks.
 

A:Solved: Microsoft Access - Forms

Read other 8 answers
RELEVANCY SCORE 58.8

Help!

I'm creating an on-line form in Word 97 which has drop-down lists.

My problem is that Word limits the list to 25 entries, and I need approximately 70 entries!!

Any help whatever to work around this (or change this internally) will be SO VERY MUCH appreciated!

Tom
 

A:Word 97 drop-down lists in on-line forms

I'm thinking that a dropdown list of 70+ entries will not even be visible in the size of the average monitor. Perhaps you can break these items down into some kind of categories, even if it's A-F, G-R, T-Z?

Consider using Excel for this form too because Excel will let you do data validation within a cell: list, and select a range of cells to list.
 

Read other 2 answers
RELEVANCY SCORE 58.8

I have a Contact Management database built in Access, and am wondering how I can let the user hyperlink to a contact's website from a Form. I have "Contact Website" as a field. I've figured out the smarttab to send them to Outlook from the Contact's e-mail, but not so much luck on the www. address.

I'm a relative newbie to Access, so this may be a simple one, I don't know. Inserting hyperlinks in Excel or Word seems much easier!

Thanks!

 

A:Solved: Access Forms - Inserting Web Hyperlink

Just choose Hyperlink as the data for your table field.
 

Read other 2 answers
RELEVANCY SCORE 58.8

Hi to All!

Is there a code that will give me the record number and total number of records in a form?

I want to create a control that shows the record # of the total records. I don't want to use the controls Access provides at the bottom of the form.

Thanks to All who can help!
 

Read other answers
RELEVANCY SCORE 58.8

Hi,

This is my first post here and is quite new in Access. I have searched for various sources of information but I still do not quite get it. I came upon this forum by chance, and hope that you guys can help to solve some of my doubts.

1. Say, there are these 3 tables - Inspector (One who do the inspecting), Audited_Form (The form used to audit operators), Flight_Audited (Flight which they audit on)and Operator (One who are being audited).

Hence;
Under Inspector, the fields are InspectedID, Name.

Under Audited_Form, the fields are FormID, InspectedID, OperatorID, Organisation, Date, Time, Questions, ...etc

Under Flight_Audited, the fields are FlightID, Flight_Details, Date, OperatorID
(Both the "date" in the above 2 tables are the dates the inspector do the auditing)

Under Operator, the fields are OperatorID, Name, Organisation

1 inspector can used many forms to audit on 1 operator. 1 operator can be associated with many flights.
(I hope I did not make you guys confused, will try to make a print screen asap as the database file is not with me currently)

In this situation, does the ID serves any purpose other than as a unique key? For example, if my supervisor now keying information, does he need to look up for which inspector is which ID?

2. If i were to create a form for easy keying of information, how to input multiple tables? I've looked up the web, and it actually mentioned about subform. I tried, but I failed.

How do I create a form that when... Read more

A:Solved: Various Questions about Relationships and Forms in Access

Read other 16 answers
RELEVANCY SCORE 58.8

I saw some past threads about creating search/filtering forms in Access 2010, but I'm still having some trouble.

My database has several tables which I've combined in a union query, and I'd like to create a form that will basically search a user name and show me all of the records associated with that name in a subform. So far, I've got an option box for user name, but the subform only shows me a list of all users, not just the one chosen in the option box.

How do I get the subform to list only those records associated with the selected name?

Thank you very much for your help!
 

A:Solved: Search Forms in Access 2010

Read other 12 answers
RELEVANCY SCORE 58.8

Hiya

Finally trying to do something for work, and one thing I was thinking about for ages is a database.

So, created one in Access 2010 (at home). It has a table1, and then two forms.

Only been working on it today, and very new to Access, so its trial and error time for me

Anyway, most of the Text Boxes I think are okay being unbound, as each form has its own entries.

However, there is one that I would like linked. Its one like a certain number you designate for a particular item (not a sequential number).

As there are two forms, can you easily link one form to the other, for the one field?

The box is Text7 on the form I would like Text23 from the first form I would like to be linked.

Looked at Control Source, typed Text23, went to View Form View, and then tapped some numbers into Text23 on the 1st form. Didn't seem to work, so I bet I'm missing something very simple
I can grab screenshots, but the pc I'm doing it on has issues, so cannot go onto webpages (using a laptop to type this).

Thanks

eddie
 

A:Solved: Access 2010 - Linking 2 forms together

Read other 7 answers
RELEVANCY SCORE 58.8

I'm sure this is pretty simple but I can' seem to get it to work. Here's what I have....

Main Form is where the data entry occurs. really can't be used to search records

Form 1 - is a variation of Main form but is queried to return only certain criteria. IE... only pull records that are missing data.

Form 2 - allows searches of all records in the database.

Currently when I open a form they stay open, so they are not refreshing. So would it be better to somehow have each form close when I change forms or somehow do an event with requery? There are many fields that have to be updated from either just making a change to a record or adding a new record once all three forms are open.....

Any thoughts?
 

A:Solved: Access Event to Update Forms

I am not sure that you need 3 forms to do this.
 

Read other 3 answers
RELEVANCY SCORE 58.8

I have experienced this recently in several databaes. A single form will suddenly quit opening. If I click a menu button or if I open to the forms list and click on it there, it won't open and the whole database pulses like it is wanting to give me an error message. I find that if I open the form in design mode then switch to form mode only will I be able to use it. I have closed and reopened the program, I have created new buttons, and tried renaming the forms but the problem persists.
 

A:Solved: Access 2010, forms won't open

Read other 8 answers
RELEVANCY SCORE 58.8

I have developed a simple Access application for sharing on our network. My computer has a screen resolution of 1400x1050 while others are 1028x768 causing my forms to "overflow" their screens. I like my forms for those of us with 1400 resolution and can make tabbed forms for those with 1024.

My data is in a back end and users access it via a front end.

My question is what is the best way to handle this? For example, I could write another front end (called "front end 1024") and have users with 1024 screens access the data via that or I could include them in the same front end and have users choose each time. Alternatively, is there a way for Access to know which forms to use for each person? Note that right now I do not have any security or users identifying who they are to log in so I'm not sure the application "knows" who is logged in.
Thanks.
Dennis
 

A:Solved: MS Access Forms and Screen Resolution

Read other 6 answers
RELEVANCY SCORE 58.4

In our transcription business we type hundreds of memos in a month's time.

I want to create a drop-down list (intended for validation) so my typists can select 1 of 15 names instead of manually typing each author's name each time.

I followed instructions in Word Help to create a drop-down list in a template but I can't find out how to get the drop down list to appear for use in the template. Any help would be greatly appreciated. This is my first time using this forum.
 

A:Word: drop-down list to fill in memo forms

Read other 8 answers
RELEVANCY SCORE 58

Hello

Using continuous forms, I will see a series of my records, stacked one on top of the next. Is it possible to devise a way to highlight areas on ANY record related to values in the record.

Example.

Two records (R1, R2), if a date field in R1 is less than 30 days away from Now(), then show a flag (maybe image.visible=yes) only for that record.

Meantime, R2 does not need to show the flag because the rule applied does not evalute as true.

I don't think this is do-able - you guys may know otherwise?

Thanks

Chris
 

A:Solved: Access 2003 - Use of Color in Continuous Forms

Read other 6 answers
RELEVANCY SCORE 58

Hi,

I'm trying to format checkboxes (and textboxes and combo boxes - both of which I can do), in an Access 2013 form, so that they are effectively highlighted when they receive the focus.

Text and combo boxes are easy beacuse I can just change the .backcolor format, which is what I want but checkboxes don't have that property, what can I do to get the same effect with them (not that changing any of the colour properties seems to actually make any difference)?

Many thanks,

Richard
 

A:Solved: Access forms - checkbox control formatting

As you have found you can't manipulate it directly.
So you could manipulate it's Label or you could do the following.
Reduce the Check Box's Border so that it just surrounds the check box.
Add a Rectangle around the checkbox, send it to the back.
Using VBA change the colour of the rectangle's background when the checkbox is clicked or gets focus.
 

Read other 2 answers
RELEVANCY SCORE 58

Here's my problem. I'm creating an evaluation form. I have a parent form that captures the Project Information data, then 5 subforms, each containing the same set of fields (Requirement, Score, Comment etc), but geared around 5 different categories (5 phases of the project which each have their own requirements(questions).
My problem is when I create records in 2 child forms, the next time I open the form for that parent record, I see all the child records copied under each of the 2 child forms.
An evaluation is rarely completed in one sitting, so I need the records to be kept divided in the form view.
I have used 1 table to hold all the child records, and used queries to divide them for the child forms. So I am assuming the problem is that all the children live in the same table.
I tried creating separate tables for each of the 5 categories, but then I can't get the relationships to work between the parent form and the child records.
Can you suggest a table/form/query structure that might solve my issue? I can upload my file if needed.
 

A:Solved: Parent and Child forms in Access 2010

Read other 8 answers
RELEVANCY SCORE 58

1) Using If [Field2] = 0 Then Exit Sub
[Field3] = [Field1] / ([Field2] * [Field2])
as an After Update event procedure on Field1 and Field2, Field3 is not being updated as data is changed in Field1 or Field2 - but only updates once I have gone to the Next record, then back again.
(What I have done above works perfectly on another database, which is why I can't figure this out. i.e. enter data to Field1 and tab - Field3 is updated, same for Field2.)

2) In this database, I have Date Of Birth entries. I would like to automatically display the current age for each entry on the input form. So I will have Name, Surname, Date Of Birth, Current Age - with Current Age being calculated automatically.

Assistance always appreciated.
 

A:Solved: Access Forms - Event Procedure and Age from Date

1) It appears that I had a different event procedure running along side this which was causing havock, working fine now.

2) On Entry Event Function:
If [DOB]=0 The Exit Sub
Age=Year(Now())-Year([DOB])

--- All working well ---
 

Read other 1 answers
RELEVANCY SCORE 57.6

My Form access a Query to retrieve 3 fields from 2 tables :

SELECT tblA.X, tblB.Y, tblB.Z
FROM tblA LEFT JOIN tblB ON tblA.X = tblB.X

There are lots of rows being retrieved.

My Form has X set up in a combi box.
I wish to select the downarrow for X to select any row,
and then for Y and Z to redisplay the corresponding values.

Eg : if the 1st row displayed is X1 Y1 and Z1, and I scroll down to row 20,
I want to see X20 Y20 and Z20.
But at the moment, I get X20 Y1 and Z1.

I suspect I will need to build an On Change Event Procedure for X,
to force Y & Z to be displayed, but I do not know how.
Many thanks in advance
 

A:Solved: Access Forms: redisplay fields after selection from a dropdown

Read other 6 answers
RELEVANCY SCORE 57.6

I was losing track of things on my website, so I thought a data base would be very helpful. I've set out to learn Access, but I'm still a beginner and I'm stuck on 3 things so far.

I have set up and related several tables including:
website pages (title, description, date written, etc.) auto number primary key
graphics (file name, size, description) file name primary key
keywords (word, stat1, stat2, stat3) word primary key

I've also set up junction tables since the website pages table has a many to many relationship with both graphics and keywords.

Question 1: How do I make a form that has multiple sub-forms?

I tried to use the wizard to make a data entry form. I wanted a form with multiple sub-forms.
If I enter the fields from 2 tables, I can easily make a form with a sub-form. If I enter fields from all 3 tables, the wizard acts completely differently and I can't figure out how to do sub-forms.

Question 2: How can I make a combo box that will cover multiple fields at once?

I fill the graphics table as I make the graphics. I wanted to use a combo box so I could choose an existing graphic OR add a new one. The combo box works fine for the file name.
The problem:
I want it to auto fill the size and description if I choose an existing file name OR allow me to enter size & description if I enter a new file name.

Question 3: How can I handle many to many relationships between records within one table?

I want to track links from each page to ... Read more

A:Solved: Access 2003 Data Entry Forms - beginner needs help please

Read other 16 answers
RELEVANCY SCORE 57.6

Hey everybody

Okay, been playing around with our Access Database here.

I was wondering if there is a way to hide certain elements on a form, when a button is clicked to view the form?

For example, I have a form called newHireForm, that is shown when you click on a button on the switchboard. Now, I also have a form called recruitingContactForm, which has a lot of the same information that newHireForm has, except it has different dates, and a few different fields.

Now, I figured I could just have one central form called newAgentsForm, for instance. Then on my switchboard have a button for seeing New Hire, and then a button on the switchboard that lets me see Recruits Contact. Is there a way to let certain fields be visible, while others are not based on what button I press on the switchboard?

I hope I was pretty clear with explaining. It's hard to put in words exactly what I want to do.

Thanks
 

A:Solved: Access 2003 - Hiding Parts of Forms/Fields

Read other 8 answers
RELEVANCY SCORE 57.6

I have a database with approximately 15 tables and forms. There is a form created for every table. When a form is updated, I want the other forms with the same fields to also automatically update without having to re-enter the information in a different form. Is this possible? Please advise.

Thanks,
Tonya
 

A:Solved: Access 2007: Forms for Data Entry-Update

Read other 8 answers
RELEVANCY SCORE 56.4

I recently purchased a laptop and I cannot figure out how to adjust some of the settings. For example, when you're on a website where you fill out information boxes such as name, address, email, etc. the boxes are so light that they don't show up. I have to hit tab just to find them. Even on this page right below title: the actual box does not show up. How do I fix this?!
 

A:Text boxes on forms

Read other 6 answers
RELEVANCY SCORE 56

I have the following data:

1/1/05
2/1/05
3/1/05
Each of the cells is formatted as a date, and is a value.
What I would like to do (and what could be done under Lotus) is to record a macro that puts the ' in front of 1/1/05 and makes it a value. I realize there are other ways to do this, but the functionality of adding a character before a value is what I am looking for.

Functionally, I record this macro with these keystrokes:

F2 Home ' Enter

which results in this code:

ActiveCell.FormulaR1C1 = "'1/1/2005"
Range("A3").Select

If I run this macro, it changes the cells underneath to 1/1/05, instead of keeping their date. Where am I going wrong here and how can I make this work?

Thanks!
 

A:Solved: Excel and VB: Changing cell value to text with macro

Read other 16 answers
RELEVANCY SCORE 55.6

in my 50-page template... i want the applicant to be able to type in name and other information ONCE in form fields on the first page, and have it repeat itself on every other page. i've scoured the web for bookmarks, cross-references, etc. with no success. helllp meee pleeease...!
~melias
 

A:text automatically copied into forms

Okee doke.

Test this out, girlfriend.

Open a new document.
Insert a form field.
Hit Ctrl-Enter 4 times.
Hit Insert-Cross Ref, to a bookmark, *BOOKMARK TEXT*.

Ctrl-home.
Protect form.
Type a name in the form field.
Hit Ctrl-End to see your cross reference.

If it does not display, go to print preview and back or hit Ctrl-a, then F9. Either of these actions *updates* the fields in your doc.

Work? Let me know!

PS: Melias, if you are having difficulties, do NOT hesitate to send your file. All in the strictest of confidence.
 

Read other 3 answers
RELEVANCY SCORE 55.6

We use Outlook 2007 in our office. About two weeks ago, all of the emails I have been sending to the boss have been arriving in her Inbox as Plain Text. This morning she didn't receive the new staff member's email contact info I attached to a group message...everyone else in the office received my message in HTML, with the attachment, no problem.
I did some surfing this afternoon...found suggestions to check Email Settings under Trust Centre in Outlook...not the problem. Also found some allusions to AVG being the problem, checked those settings, again...not the problem.We need to get this sorted ASAP.
Thanks very much for your help!
 

A:Solved: Outlook suddenly changing HTML to plain text

More surfing last night found this...

Open the Contacts folder in Outlook. Double-click the contact you want to change.
Double-click the contact's email address.
Uncheck "Send plain text only" in the "Internet Format" box. Press "OK."

When I got to work this morning and looked, sure enough...Send Plain Text only had somehow gotten checked. I unchecked it, sent a test message and all is good again.

Bizarre!!
 

Read other 1 answers
RELEVANCY SCORE 55.2

Hello there,

Having a really strange problem with Windows 7 x64.

On dialog boxes, and other programs, the text is invisible, and tabs are showing tiny with no text (see picture)

http://i43.tinypic.com/10iigc6.jpg

Any ideas?

Cheers,
Lee

A:Very strange - dialog boxes and other forms no text?

Welcome lpuk123.

First thing that comes to my mind, is 'this is odd...'.

Before this occurred, did you just change something? New hardware, software? Windows Updates? Anti-virus scan?

----

If you start your system in safe mode, does it still happen?
* To start in safe mode, when your computer is starting up, keep pressing F8 until a set of options appear, then select Safe Mode.

----

Have you tried changing your 'theme', to see if that has any affect?
* To change theme:
> - Right click on the desktop and select "Personalize" (if you cannot see this because of your problem, then it should be the last open at the end of the list, so just select the bottom one).
> - A new window should appear with a bunch of selectable themes.

Try using another Aero Theme. If that has the same problem, try a 'Basic and High Contrast Theme', such as Windows Classic.

----

If this has just occurred, you could try using System Restore and restore back to a point before you had this problem, it might solve it.

Read other 1 answers