Over 1 million tech questions and answers.

Lock certain fields in MS Word form?

Q: Lock certain fields in MS Word form?

Okay, I thought I had this figured out yesterday, but I guess I didn't. I was using continuous section breaks in the form to try and solve the problem. The only problem with this method, though, is that Word seems to only allow one break per line, which means the most precise I could get this way was to place a break at the beginning of the line I want to leave editable and then another break at the beginning of the following line. This won't work for me because it will still allow someone to use the enter key to create a new line in the editable part of the form, thus pushing everything below it down and changing the layout of the form. So, is there a way to get more precise when it comes to locking areas of the document around certain fields? Sorry if my post is a little confusing. Any help would be greatly appreciated.

RELEVANCY SCORE 200
Preferred Solution: Lock certain fields in MS Word form?

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: Lock certain fields in MS Word form?

Could you e-mail me the form so I can take a look at it please? Have you locked the form as well so the user cannot edit it?

Read other 2 answers
RELEVANCY SCORE 104

Is there a way to lock certain fields in a Microsoft Word form while keeping others editable?
 

A:Solved: Lock certain fields in Word form?

Got it.
 

Read other 1 answers
RELEVANCY SCORE 84.4

Hi guys,

I have an ASUS computer running Windows 7. In the last few weeks, I started having problems with the NUM LOCK keys intermittently not working in form fields. The NUM LOCK light is on, and if I use the pad in the URL field, for example, it works fine, or in a Word document. But sometimes I will be in a form where I need to fill in a phone number, etc., and when I go to use the number keys, the work like the arrow keys instead. The NUM LOCK light is still on, and if I immediately, on the same page, go up to the URL bar and try them, the numerals work, but back in a form field, and nothing.

I was using the ASUS keyboard that came with the computer, so I tried updating the driver - no result.

I took my husband's HP keyboard, and I have the same problem, so it seems there is some issue from a software or Windows standpoint causing the problem.

Interestingly, if I go into Control panel, Ease of Access, Change How Your Keyboard Works and change NOTHING but then close that window out, the num lock keys will begin working in the forms...for awhile. But then it goes right back. It seems just the act of going into the screen that alters your keyboard is enough to make it start working for a bit, which makes no sense, I realize.

For the record, in that screen, "turn on mouse keys" is not checked. In fact, nothing is checked.

Any ideas??? I am not super computer savvy as far as altering reg keys, etc., so if you can give specific instructions to try if you ... Read more

A:Num lock working intermittently in form fields

Wow, I've posted this in more than one tech forum and no one seems to have an answer. I now leave the "make the keyboard easier to use" window open, and just the act of going in, changing something around and unchanging it, then hitting "apply" makes the num lock pad work for at least an hour or so and then it stops again. No one??
 

Read other 2 answers
RELEVANCY SCORE 80

I've created a form in Word that users fillout and print. Is there a way to make certain fields required?
 

A:Word Form - Required Fields

Read other 9 answers
RELEVANCY SCORE 80

I am trying to create a form with required fields for a document at work. I was able to use code provided by Anne Troy to easily do this. However, I just have one additional question to complete a modification I had. Basically, on certain questions, I want the form to verify that the "Next" field is completed. So that if on question 7a "Yes" is selected from a drop down box, then question 7b must be answered. Here is an excerpt with the IF statements...
For Each fld In ReqFields
If Trim(fld.Result) = "" Then
MsgBox "You must complete " & fld.Range.Bookmarks(1).Name & " before you can print.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
If Trim(fld.Result) = "Select..." Then
MsgBox "You must select an answer for " & fld.Range.Bookmarks(1).Name & " before you can print.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
If Trim(fld.Result) = "Yes" And "NextField" = "" Then
MsgBox "You selected 'Yes' for " & fld.Range.Bookmarks(1).Name & "." & vbNewLine & "Please answer Question 'b' after " & fld.Range.Bookmarks(1).Name & " before printing.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
Next fld
End Sub
 

A:Word Form - Required Fields

See if this helps?
http://pcnorb.blogspot.com/2008/04/word-and-vba-forms.html
 

Read other 3 answers
RELEVANCY SCORE 80

Hello everyone,

I'm new to the TechSupport Forums, so I'd like to start out by saying hello to everyone! I need some help with a (possibly) unanswerable inquiry.

I have created a protected document with form fields for users to enter information. When they hit enter, I would like for the document to go to the next form field rather than do a hard return. Is there a way to do this? Any help anyone can provide would be great!

Read other answers
RELEVANCY SCORE 80

I am trying to fill in a weekly dates using a form field start date.
It is setup as such:

Start Date: ________ (user enters date here in format ddMMMYY)
This is setup as a Text form field, set to date, with calculate on exit checked and bookmark as DateField.

Later in the document, I have a weekly calendar that I want to fill in the dates for Mon - Fri based on Monday as the start date from above.
I have been using the insert>Quick Parts>Field but cannot figure out the calculations even after multiple guides and searches.
I am able to reference the bookmark and repeat the date for Monday, but cannot figure out how to set Tue-Fri dates.

Please give me the exact code to put in if possible.
I could figure it out using VBA but want to do this without macros if possible.

Thanks
 

A:Solved: Form Fields in MS Word

Read other 6 answers
RELEVANCY SCORE 79.2

I would like to create forms in PDF...What I would like to do instead of creating the text fields in PDF is create them in Word placing a tag on the cell and when convert PDF will capture the text box. Is this possible with any plug-in even. I called Adophe and they informed me plug-ins are available for this but I could not find any.

We currently have forms on the web in HTML which I am converting to word the cell fields are carried over all I would need to is format the document the way we want it and rename the cells...The reason why I do not want to do it PDF is becuase I have approx. 100 forms and I know at some point they will be modified I would have to re-create the entire form in PDF where as in word it would be easier to re-create then I could just create a PDF and have it completed.
 

A:Convert word cell tag to PDF form fields (How can do this?)

Hiya and welcome

Looking here:

http://www.pdfzone.com/bguide/product/SearchResults.asp

There is Acropad, but you have to join to look at the actual program, but this is where you can get it:

http://www.acropad.com/

It may not be exatcly what you're after, as you said Word.

Also, there is this:

http://www.planetpdf.com/tools.asp?webpageid=550&TBToolID=1976

http://www.go2pdf.com/product.html

It may take a bit of playing with the plugins, to see which one will work, but the one above mentions this:

You may convert Microsoft Word, Excel, PowerPoint, Access documents into PDF formats, convert AutoCAD file into PDF, convert image formats to PDF, convert plain text file to PDFClick to expand...

Thats for Go2pdf, so you may want to look at that first.

Regards

eddie
 

Read other 3 answers
RELEVANCY SCORE 78.4

Hi,

I'm working with form fields in Word 2003 and I was wondering if it were possible to create a form field with a line extending to the maximum length of characters allowed? For example:

Name:_________________________________

Where the underline is the form field. I know that MS shows them using tables to create a kind of pseudo line but I was hoping for something more...elegant? One that would be incorporated right with the form field.

Thanks for all your help!

JFresh
 

A:Solved: WORD 2003: FORM FIELDS question

Read other 6 answers
RELEVANCY SCORE 78.4

Hi,
I'm completely new to vba and trying to modify a code I found here but failed.
While the original code exports cell data (1 row only) from excel into the form fields of a Word document, I tried to modify the code to work for multiple rows, one after the other.
My code works for the first row and generate a word file as supposed, but immediately stoped with an error message "Runtime Error -2147417848 (80010108), "The Object Invoked Has Disconnected from Its Clients"
Could anyone help me modify the code so that it works please? Thanks a lot!
I'm using 2003 excel and word.
P.S. I know this can be easily done by mail merge but I would like to use Word form for further process.

Code:
Option Explicit
'Requires reference to Microsoft Word (11.0) Object Library
Sub Copy_Cells_To_Word_Document()
Dim rng As Range
Dim row As Range
Dim wdApp As Word.Application
Dim wdDoc As Word.Document

Set rng = Range("A2:E4")
Set wdApp = New Word.Application
Set wdDoc = wdApp.Documents.Open(Filename:="C:\Desktop\file.doc", ReadOnly:=False)
wdApp.Visible = True

For Each row In rng.Rows
Copy_Cell_To_Form_Field wdDoc, Range("D" & ActiveCell.row).Value, "Surname"
Copy_Cell_To_Form_Field wdDoc, Range("E" & ActiveCell.row).Value, "Forenames"
Copy_Cell_To_Form_Field wdDoc, Range("B" & ActiveCell.row).Value, "Ref"

wdDoc.SaveAs ("C:\... Read more

A:import excel data into word form fields

Read other 6 answers
RELEVANCY SCORE 78.4

I don't know if this is possible.

I do know it isn't possible to insert a form field into a field code.

The functionality I'm trying to achieve is something like this:

{ SET _Check1 { FORMCHECKBOX } }​
Then, further down the document:

{ REF _Check1 { FORMCHECKBOX } }​
In other words, I want to use bookmarks with form fields. Can it be done?

chris.
 

A:Solved: Merging form fields in Word 2000

Read other 7 answers
RELEVANCY SCORE 78.4

I am using similar code to this thread:
http://forums.techguy.org/business-applications/175786-word-form-required-fields.html
but instead of required on print, I have fields to be required before saving and printing.

To accomplish on save I used the same code except for the Title line of code:
Public Sub wordApp_DocumentBeforeSave(ByVal Doc As Document, SaveAsUI As Boolean, Cancel As Boolean)Click to expand...

I am using a 2003 Word Document Template.

My question is, I have a custom calendar userform that seems to break the field requiremens whenever the calendar pops up (I have a macro set to run on entry on certain date fields).

Is there any way to work around this? I can post up some sample code as necessary.

Thanks for your help =)
 

Read other answers
RELEVANCY SCORE 78.4

I have created a form in MS Word 2007. I used the form fields and have locked the form. When the user fills out the form it is saved and sent to someone to review, edit and/or comment. The receiving party unlocks the form and adds comments however, is not able to use track changes in the form fields. Do you know of a way that they can use track changes within a form field?
 

Read other answers
RELEVANCY SCORE 78

The State of Florida is using an MS Word Document as a test document that can have answers placed in it. Some "Computer expert" unlocked it so that everything moved with 'tab', or 'space' or 'answer' entry. How are the fields supposed to be designed so you can Lock some fields (questions), but allow entry in others(your answers)?

How can anyone change that function in a state form?
 

A:Word -- Lock some fields, allow entry in others

Read other 6 answers
RELEVANCY SCORE 77.6

I'm trying to set up a letter with fields in it for people to complete without editing the rest of the letter. I already did the developer tab and figured that out and I understand about restricting permissions. What I can NOT figure out is HOW to "jump" from one field to another! Tab doesn't work - F11 which I see all over the internet doesn't work, what does?

Back in the day I used to create "jump codes" and do the browsenext feature to jump from one part of the document to another, but now nothing works.

Anybody have any suggestions short of a programming code?

Thanks!
 

Read other answers
RELEVANCY SCORE 77.6

I have seen the other posts on how to do this and I'm off to a good start I think.

I just need some help to customize this for my form. The center of the form has 6 check boxes, and I just need to include the one checked reason in column P, and then one of the 3 explanations if there is anything filled in there.

Also, for some reason with this code, when I try to import multiple files it puts them all on row 2.

Would someone mind taking a look to see if you can help.

Thanks
 

A:Importing Word Form Fields to Excel, and choosing the columns

In it's current form the user can select multiple values from the set of checkboxes. Is there any particular reason why you are using checkboxes instead of option buttons that would limit the user to one selection?

Rollin
 

Read other 2 answers
RELEVANCY SCORE 77.6

Good evening,

was trying to find a piece of VBA code online for the following problem, found pieces for some single aspects, but cannot make it work. Have excel and word 2013.

I have a excel spreadsheets which is my master database. Every row (90 in total) lists one data set with up to 40 columns, but I will not need all informations. The first colum has a checkbox which I would like to use to chose which data set to work on to populate the word doc (working with multiple ticked would be great as well).

In addition I have multiple word documents, where I added text form fields which should then be filled with the informations from the excel sheet (I will not need all 40 columns for every word doc).

The code needs:

(1) To open the correct word document

(2) Fill in automatically the present date at a defined location in the word doc styled Jan 31st, 2018 with the correct st, nd or th.

(3) Fill in the specified data in the text form fields

(4) One column in my spreadsheet is a drop down menu, is there a difference if this content is transfered to the text form field?

(5) Some of the cells in the excel may be empty, how to make sure the transfer is not hicking-up?

(6) Save for every data set ticked a document (word and pdf) in a distinct location with some information from the data set contained in the name of the file.

I would be so greatful, If one of you can help here, guess for you this is done in a split of a minute...

Greetings
S.
 

Read other answers
RELEVANCY SCORE 77.6

Hi

I am trying to make a simple form. Everything is going fine in terms of functionality, layout, and design. My problem is that part of my form requires whoever is filling it out to type in a large body of text (3-5 sentences). The default grey background is alright when there is a zipcode or first name but on a paragraph it is really distracting. Is there a way to turn off the grey background? If you need more information just ask.
 

A:Is there a way to remove the grey background to form fields in Word 2003.

While I now use Word 2007, which has the command in a different place, in your case (and my memory) it is under Word - Tools - Options.

Look for a check box for field shading and uncheck it.

And Welcome to TSG!
 

Read other 2 answers
RELEVANCY SCORE 77.6

Hi ,
I am new to this forum, Can any one help me in fromatting the form fields of word 2003 after protecting the form. My requirement is user should be able to change the font, color etc of the fields in document. Once i click on protect form button its disabling all the formatting controls..

Thanks in advance.
 

A:Formatting form fields in Word 2003 in protected mode

Here's something to look at: http://www.techrepublic.com/blog/ms...-in-a-word-table-using-a-text-form-field/5266

You need to add exceptions to the protection.

Also, this would get more attention in the Business Apps section. Maybe PM a mod and they can move it for you.
 

Read other 1 answers
RELEVANCY SCORE 76.8

I am working on a user form in Microsoft Word 2002 and have been having problems saving it as an html format. I am currently trying to save it as "Filtered HTML" using VBA. I have the same problems however even if I try to save it as unfiltered HTML.

Anyway, it is a protected form with various types of form fields. When saving as html, the text box form fields show up fine, but the other types of fields (drop-down and check-box) do not show up.

If anyone has any ideas about why this is occuring or possible solutions, I would greatly appreciate the help. Thanks!!
 

A:Word 2002 - problems saving form fields as html format

If you are saving it as a webpage, then why do you not make it into a web driven form.
 

Read other 2 answers
RELEVANCY SCORE 72.4

I am building a form in Word 97 for our Company's inspectors to submit their report data in. The top half of the form is basically a table with Text Form Fields for data such as "Client", "Vendor", "Job #", etc. while the bottom half is an open text area where the inspectors report details of each job.

The form format has worked very well for the less computer literate members of the team as they do not have to worry about any formatting issues and simply tab from spot to spot and enter their information. Otherwise, they normally get all tangled up with table margins, etc and end up changing things and we lose the standardized appearance of the document. Unfortunately, the more advanced members of our team find the form format to be limiting to work in (formatting options, cut & paste, spell-check, etc. not available).

What I am hoping to be able to do is lock the top portion of the document and leave the bottom portion where they enter their "free-text" reports un-locked so they can use any features they need here. Is there any way this can be done? Should I be doing this in an altogether different way than forms in Word?

Thank-you in advance for any help you may offer!
WildSpirit in Alberta.
 

A:Help with a Word form - Can I lock only PART of it???

Read other 11 answers
RELEVANCY SCORE 66.8

I am trying to create links to specific locations with each document between two documents. The document names will change. I can update the current name of the other document by creating a custom property called "otherDoc". I have solved most problems, however, I am unable to insert a field into the address of the link (to make the link dynamic) without utilizing the showfieldcodes command (which is very memory and time consuming since the documents I am working on are very large). Below is my code. I was wondering if there is any way to set the address as a field? Or somehow input an address and it would be understood by word to be field.
Sub link_to_other()

'pastes hyperlink to the other document
Selection.PasteSpecial Link:=True, DataType:=wdPasteHyperlink, Placement:= _
wdInLine, DisplayAsIcon:=False

'selects the hyperlink that was just inserted
Set myField = Selection.PreviousField

'creates variables
Dim temp_address As String
Dim temp_subaddress As String

'sets variables
temp_address = ActiveDocument.CustomDocumentProperties("otherDoc").Value & ".doc"
temp_subaddress = Selection.Range.Hyperlinks(1).SubAddress

'changes the hyperlink the the dynamic value
Set SCut = ActiveDocument.Hyperlinks.Add( _
Anchor:=Selection.Range, _
Address:=temp_address, SubAddress:=temp_subaddress)
End Sub

 

Read other answers
RELEVANCY SCORE 61.2

Hi all,

Was wondering if its possible using CGI or Javascript to fill in FormA and click on link to FormB and have certain fields pre-filled in FormB with information from FormA? (i.e. Name, Address, etc.) Thanks.
 

A:Form Fields

Absolutely....passing variables from one form to another.
 

Read other 2 answers
RELEVANCY SCORE 61.2

I am using Windows 2003 with Access 2003. I have a main form that uses fields from a table that I would call the Master table, and this form has several tab pages in it. In this form the 2nd tabbed page uses a subform which displays data from a different table (I call it the Job Number table). I have linked these two tables with a one to many relationship. One of the fields in the Job Number table is named "Contract Amount". So each job record in the Job Number table tracks a separate Contract Amount value, but it is linked to the Master table through the one to many relationship. My goal is to sum all of the the Contract Amount values for each linked Master record and display that amount on my 1st tab.

I have created a subform that uses a sumquery which sums the Contract Amounts from the Job Number table. I tested the subform and the sum feature against the live data, and it does perform correctly. I then added that subform into my main form on the first tabbed page along with other fields on the same tab page. These other fields come from the Master table. In the Data Entry view, I can see a box where the subform should display, but the data doesn't display. What can I do to force the subform to display data along side the other fields from the Master Table?

Thanks in advance for your help.
 

A:Display subform in a main form with other fields from main form

Read other 6 answers
RELEVANCY SCORE 60.8

Hi
I am creating a form on word 2003 with Text Form Fields. At several points throughout the form the same information needs to be entered (eg: name). Does anyone know if there is a way to make it so that if you enter the date into the first 'name' text form field it will automatically put the same information into the other text form fields labelled name?
Thanks
 

A:text form fields

Read other 6 answers
RELEVANCY SCORE 60.8

Is there a way to set forms up in Excel like Word? When I have the form toolbar open, the Text Form Field icon is grayed out. Thanks for the help!
 

A:Excel Form Fields

There's no Text Form Field icon on Excel's Forms toolbar, it's an EditBox button. It's greyed out because it can't be used on a worksheet, only on a UserForm (custom dialog box).

There are ways you can get Excel to jump to various cells for user input, it depends on exactly what you want to do.

Example:
Click on A3, hold down CTRL, click on A5, A7, A9, A1. Release CTRL. Select Format -- Cells -- Protection, uncheck "Locked", click OK. Protect the worksheet (Tools menu), then you can tab around the sheet in that order (starting with A1).

HTH,
Andy
 

Read other 1 answers
RELEVANCY SCORE 60.8

I have a word document that I am creating Drop down fields in forms tool bar. My problem is that I have to have some of the words be italicized and other's not. I know you can italicize all or none of the words but is there a way to italicize some of the words and leave the others in regular text form?
P.S. I've also tried to use Autotextlist but I can only get two options to come up and I have three options. ???? Help!!!
 

A:Drop Down Form Fields

Sorry, fatso.
The answer is no.
If you need it badly, this CAN be done in Excel.
 

Read other 1 answers
RELEVANCY SCORE 60.8

Hi there, I've created a form on this form I've got a tab control(consisting out of page1 & page2) with multiple option buttons, text & combo boxes on these 2 pages.

When the user enters his data or selects his options and then click on the submit button I want that data to go to my table (already created with the exact fields).

I also need to create a counter for several fields ex. I've got a field college, campus and race.....now they would like to know how many females in college A with campus C there are.

Thank you,
 

A:From fields on form to table

What program are you using?
 

Read other 2 answers
RELEVANCY SCORE 60.8

I know how to use the Text Form Fields for templates in Windows XP but I have now upgraded to Windows 7 Professional and can't find this feature - is it still available in Windows 7?
 

A:Text form fields

Templates in what application?
 

Read other 2 answers
RELEVANCY SCORE 60

Hello Group,

Suddenly I am unable to type into form fields.

I have to trick it by writing the text in an e-mail, copying that, then right-click and paste into the form field - even to login here I had to do that - nothing happens when I try to type into the field.

Environment: Windows 7 Home Premium
Asus PC

Hope someone can help. Thanks for looking in.

seekinganswers
 

A:Suddenly can't type into form fields

Problem partially solved. Still have no clue as to why I could not type into form fields, even logons, google ... but a simple re-boot and now I can enter text into form fields. However, sporadically I lose control of positioning - sometimes the arrows stop working, and sometimes I cannot change position in the form by moving the cursor. What is going on?
Thanks for looking in. seekinganswers
 

Read other 3 answers
RELEVANCY SCORE 60

I've looked for this and people don't seem to have the problem. I have a form that populates a single database. on enter a new refreshed form is presented to the user - but now my user has requested that 3 fields on the form not clear. She wants to be able update them if needed, but generally they will not be changed during a batch of input, after she has entered them the first time. How do I STOP them clearing?
 

A:Access form clears all fields

Read other 6 answers
RELEVANCY SCORE 60

Is it possible for a user to choose a field in a combo box that somehow is connected with another field that they don't choose? I need this "not choosen" field to populate in a table.

The reason I want this is because the "not choosen" field is not known to the user, but need for linking
different tables together.

Example: Have a field Description and Customer Part ID. The user knows the Description and that's what they choose, they do not know the Customer Part ID, but need that for linking tables together.

Do not know Virtual Basic very well, so is there a way just with the combo box wizard or a query? Need as simple as possible.

Thanks!
 

A:Combo Box in Form multi fields

Read other 8 answers
RELEVANCY SCORE 60

Ever since I upgraded to IE 6 I have had an incredibly slow response when filling in form fields. For example, let's say I'm going to log into a message board like this one to post a message. I fill in the username, hit tab to the password field or click in the cursor on the password field, and it takes anywhere from 10 seconds to a minute before the cursor shows up in the new field.

On top of this, during the wait I cannot access any other browser window I may have open at the time. I can access other programs (like, say Microsoft Word), but my browsing is virtually halted during that time.

Has anyone encountered anything like this? It happens regardless of how many browser windows I have open, and started only after I upgraded to IE 6.

Thanks,

Zach
 

A:IE 6- Slooooow response on form fields

Try closing down some of the applications in the background. IE6 is pretty bloated, as is most Microsoft apps, so try shutting a few of them down.

Alternatively, Opera opens it's browser windows in itself by default, meaning that you don't have to have numerous instances of the same program open at the same time.
 

Read other 3 answers
RELEVANCY SCORE 60

I need 3 fields created (2 of these are almost identical):
1. a field that automatically populates the e-mail address of the person filling out the form (it reads their mailbox name somehow).
2. a button that allows me to click to pull up the Outlook Global Address list and choose a name that is then populated into a custom field (I cannot attach the "To" button control in the field properties because I am already using the "To" button on this form for another purpose).
3. another field just like the one above except that it would be independent (choosing from the global for #2 would not affect what I choose from the global in #3).

Make sense?

Background: I am using an Outlook Mail form - I think I need VB for this part but don't know what to type. Any help you can offer would be welcome.
 

Read other answers
RELEVANCY SCORE 60

Hi All,

Quick one - trying to create a data entry/ edit form that has 3 years worth of dates in it. I.e. 2016, 2017, 2018

Project Name| Project Manager |
Jan 16 effort
Feb 16 effort
March 16 effort
April 16 effort
May 16 effort
June 16 effort
and so on....

Some projects will go into other years and what I'm trying to get to is a form that has a button that can cycle through to the next year rather than creating 3 separate forms with a button that will just take you to the next form... can it be done? If so, can anyone tell me how?
 

A:Create Form that Cycles through fields

Read other 9 answers
RELEVANCY SCORE 60

I have 4 number fields that is formatted to currency with 2 decimal places. When I key in a dollar amount it is rounding the numbers. How do I get it to not round up or down?
 

A:Solved: Number fields within a FORM

Read other 6 answers
RELEVANCY SCORE 60

I have an MS Access FORM which presents 2 fields from a table

X is data type YES/NO, and Y is data type TEXT.

I would like my Form to always display X, but only to display Y if X is YES.

I know I can right click on Y, then Properties > Format > Visible : No, but this isnít sufficient.
I can also right click on X, then Properties > All > After Update which takes me into V B.

Can anyone help this layman who doesnít know anything about V B ?

Many thanks in advance....
 

A:Conditionally hiding fields in a form

In the Form's On current event procedure and the X Field's After Update event procedure enter

if me.X = -1 then
me.Y.visible = true
else
me.Y.visible = false
end if
 

Read other 3 answers
RELEVANCY SCORE 60

I have created a form in table format. Is there a way to change the tab order from top to bottom instead of left to right?
 

A:Form in Table w/Fields - Tab Order

In Datasheet View (table format), each row represents a record. The only way that you could use the tab key to move from one record to the next would be to disable the Tab Stop property of all the controls on the subform, then set the subform's Cycle property to All Records. Bear in mind, this will prevent you from tabbing into any other field than the first field in your subform, so you'd have to manually focus (i.e., click) on a control in order to edit its data.

Why exactly do you want to do this?

chris.
 

Read other 3 answers
RELEVANCY SCORE 60

i have laboriously figured out (with help from this forum) how to make the text and numbers entered into my forms repeat throughout the document. however, if i type a space in the field, such as between first and last names, the second word shows up as bold everywhere else in the document. what's the fix?
~melias
 

A:first & last names in text form fields

Read other 7 answers
RELEVANCY SCORE 59.2

My church asked me to create a db. I'm a newbie but I figured I give it a shot. Since then, I've been pulling my hair out.

I'm using Access 2000 on M$XP. The Church Stewardship Secretary (CSS) is responsible for logging in each person's activities choices, and there are many activities to choose from. One may choose to be in the Adult Choir, be an Eucharist Mininister at 8 and 11:15, and volunteer to do electrical work.

I am trying to create a FORM with multiple yes/no choices and comment boxes so that the CSS can input each person's record. This "Masterform" will view current records and will update as new records are entered.

Step 1: Instead of using one ENORMOUS table, I subdivided the data onto 11 or 12 catergories. (BIG MISTAKE!!!)

1-Members (lastName, firstName, Phone)=TEXT (ChurchID=TEXT= PRIMARY KEY)

I linked the choices using a Church ID primary key----> I decided to use the first 3 letters of the first and last name for a primary key: Michael Jordan= micjor

The rest of the tables went as followed:
2-EM's
3-Greeters
4-Music Ministry...

And so on ... Tables beginning from 2 had each record beginning with the ChurchID and yes/no columns. Usually each table had a comments text column as well. NOTE: Only those whom had selected a choice on the table would have their ChurchID and record appear on the table.

STEP 2: I created a one-to-one relationship from the Members Table to the other tables. I wanted each member to ... Read more

A:Cant create form or query from joined fields

Read other 7 answers
RELEVANCY SCORE 59.2

Problem: Some, but not all, of the form fields on my Word 2007 master document disappear during mail merge.

Background: Last year I merged student data from Excel into a Word document to create 150 report documents for teachers to complete. I have on my hard drive the original documents and the merged documents. Both have drop down lists (for grades) and text boxes (for comments).

Current situation: When I mail merge now, the drop down menus appear in the merged document but not the text boxes. A few hours of experimentation turned up no solution and a search on the web brings a consensus that Form Fields and Merge Documents are incompatible. But the drop down menus are arriving unscathed and I have proof I achieved it less than six months ago!

I've recorded a macro that replaces the 'remains' (4 spaces) of the text box with a new (working) form but besides being inelegant its frustrating knowing that somehow I've already solved this.

Any thoughts , suggestions, (or access to a working time machine) would be appreciated.

Cheers, Tim Tuck
 

Read other answers
RELEVANCY SCORE 59.2

Form has several calculated fields. The first part of this code works fine, the second part that is supposed to calculate the Reservations Amount Owed does not work - the field returns blank. I also have another calculated field that isn't working: Reservations Balance Due which would be Reservations Amount Owed minus Reservations Amount Paid. What am I doing wrong? Thanks in advance for your help.

Private Sub Combo68_AfterUpdate()
If Me.Special_Ticket = "Corporate_Table" Then
Me!Ticket_Price = "312.50"
Else
If Me.Special_Ticket = "Sweetheart_Ticket" Then
Me!Ticket_Price = "800"
Else
If Me.Special_Ticket = "Patron_Ticket" Then
Me!Ticket_Price = "350"
End If
End If
End If
End Sub

Private Sub Reservations_Amount_Owed_AfterUpdate()
Me.[Reservations_Amount_Owed] = Me.[Reservations_Number_of_Tickets] * Me.[Reservations_Ticket_Price]
End Sub
 

A:Access 2007 form calculated fields

Read other 16 answers
RELEVANCY SCORE 59.2

A friend of mine has Windows XP SP3 with the latest Internet Explorer 7 and all patches installed. The operating system is a fresh install as of yesterday. Norton 360 v2.0 is installed as the anti-virus.

As of today, various web sites are suddenly missing form fields.

For instance, the TO and CC fields have vanished on Yahoo Mail. On a few other sites different fields have also vanished, and which go missing seems to be random. The only commonality is that all of fields that disappear are on web sites where you can send messages or mail through the web page.

Any idea what could be causing this?

A:Form fields mysteriously missing from several sites

try another browser and see if you have the same problem with it. This will help determine if its a msie problem or something else.

Read other 1 answers
RELEVANCY SCORE 59.2

I running access 2003 but i am creating for 2000

Bsaicly its a stock control system. And i have a field call "Total number ever in stock" Which basicly refers to how many of such a product has been purchesed for the shop altogether.
Reasons for this are complicated but its stems from the batch procecsing method of data colection but its not important.

>>>>>>>>
Simply i want to create a macro or simmilar so that when the user enters a Product ID and Quantity to be added into a blank non table related form the macro will add that quantity to the existing quantity for that product in a table.

So far i have created a form in design view and have inserted two unbound text boxes "ProdID" and "Amount" and have a table with field names "Product ID" Total number ever in stock"
<<<<<<<<

Thanks all help appreciated.
 

A:Adding to fields through use of macro and form - ACCESS

If I understand you correctly, you have an unbound form that a user enters a product ID and qty to be added to a related record that already stores a summary amount. You can do this using that method, but it will have some data integrity challenges. If someone enters the wrong amount, you won't know where it came from or how much the qty was for the wrong amount.

To perform the update from an unbound form can run an update query from a button.

Here's a SQL sample that you could run from a button

UPDATE Prod_Totals SET Prod_Totals.Product_ID = [Forms]![frmQtyUpdate]![txtProdID], Prod_Totals.Total_Qty = [Forms]![frmQtyUpdate]![txtTotQty]+[Total_Qty];

---------------

That being said...I would consider approaching it from a different angle.

1. Create a table of Item_Events and Products

Table Name:

Item_Event
Item_Event_ID (Autonum) Key
Product_ID
Qty (+/-)
Event_Type (Purchase / Sale / etc..)
Event_Date

Products
Product_ID (key)
Product_Description
Create a form based on Products with a subform of Item_Events. When you need the total qty use a summary query.
 

Read other 2 answers
RELEVANCY SCORE 59.2

I have just started using MSN Premium after a few years of using Mozilla Firefox. One thing I am missing is having my misspelled words underlined and easily fixed (a right-click used to show me correctly spelled options). I have been searching for information on this topic and all I can find is in reference to spell checking email. I already have that part figured out. What I want now is to be confident that when I am typing, oh, for example, THIS! that I avoid the ever-annoying typo. Does anyone know if there is a way to do this in MSN Premium? If there is no way, does anyone know if there is an add-on or downloadable spell checker that will do this for me? Hopefully for free?

There are some things I like about the MSN Premium and I would like to be able to keep using it. I may have to go back to Firefox though if I can't solve this spell check thing. I have been dealing with the lack of tabs (I love to have a dozen tabs open, but hate to have a dozen windows open!) but the tabs AND the spelling might be too much to overcome.

If anyone out there can help, I would love to hear from them!

Karla

In case it matters, this is what I am using:
Dell
Intel Celeron Processor
564 MHz
512 MB of Ram
XP with SP2

I know it's ancient! It was a hand-me-down and it's all I have

Read other answers
RELEVANCY SCORE 59.2

In Access 2010 - When a user opens a form, I'd like to inactivate specific fields. How do I do that?
 

A:Solved: Inactivate fields when form is first opened

You use similar code to the one that I have given you, but it goes in the Form's On Open event procedure.
You do not need the "If" part of the code just the fields you want disabled.
Using the code
me.fieldnamegoeshere.enabled = false
 

Read other 2 answers