Tech Problem Aggregator

Solved: MS Word Forms

Q: Solved: MS Word Forms


I have created a form in MS Word and have encountered a problem. The form does not hold its structure. I have fields within the form which potentially could expand to multiple pages. At the moment though the field will only expand to a maximum of 1 page and one order to do this it seperates from the original structure of the form. Does anyone know a way around this? I used tables to create the structure of the form.


A: Solved: MS Word Forms

6 more replies
Answer Match 65.1%

Hi there,

I'm creating a document containing form fields in Word 2007.

I want to have drop-downs and so I've added the drop down list control. Viewing the properties, I created options for user's to select from.

There's also two further options in the Properties:

Content control cannot be deleted
Contents cannot be edited

Now, here's the thing...when I Restrict Editing on teh form to Form filling only with the first option selected for the drop-down, users cannot delete the control, they can make a selection from the available options but they can edit the option they have selected (including deleting all the text).

Enabling the second option displays the currently selected item for the drop-down only, i.e. the user cannot select any other option.

Entirely useless. I want to have a list of options that the user can select from but not edit in any way, shape or form.

The only way I've found to get round this is to use the legacy drop down control. I shouldn't have to do this.

FYI, I'm NOT using compatibility mode so it's not that.

Anyone else had this issue?

A:Solved: Word 2007 forms

No idea what happened. Restarting Word seemed to help. Thought it was because I had accidentally used a combo box instead of drop down box but I hadn't.


1 more replies
Answer Match 64.26%

I wish to create an online business application form using Word 2007, whereby I can e-mail an applicant who can then fill in the required boxes, eg. their name, address etc, and return to e-mail back to me.

Can anyone help me please?

A:Solved: Creating forms using Word 2007

14 more replies
Answer Match 64.26%

I have a Word 2003 form in which there are currency fields and date fields for the user to fill in. That's all fine, I can format the fields and calculate with the currency field to create properly formated currency fields that I generate.

On the last page I want to copy some of these fields. Currency ones are fine. What I can't do is copy a date field. I set the text field type to "calculation", and the expression to "=arrival" (the field I am trying to copy from is called "arrival"). Now I can't get the format right. If leave the number format field blank, I get a number that isn't anything sensible, and if I copy the date format from the original field into the new one I get nothing at all (it's offering me a number format, not a date format, so I suppose that's not surprising.)

This surely should be easy. What am I missing?

A:Solved: Copying dates in Word forms

7 more replies
Answer Match 63.84%


I am trying to create a form for colleagues to fill in. i am trying to protect the document to restrict people editing the text. but i want them to be able to type in the strengths and weakness text boxes but once i protect the document it wont let me fill in the text for these two boxes. i have a drop down list also but that seems to be working fine. any ideas how i can get this done? i have attached the document its only 1 page


A:Solved: Word - Forms, protect document issue

Hi there,

If you use a table instead of text boxes for the Strengths and Weaknesses section, you will be able to insert a Text Form Field in each box which enables text to be entered when the document is protected (make sure the option to allow 'filling in forms' is selected in the Restrict Formatting and Editing options.)

That's what I do anyway

Hope this helps!


2 more replies
Answer Match 63.84%

I am having an issue with a document created in Word XP. The doc has a table of contents, with links that jump you to different sections of the document when you click them. The doc also has a number of forms and drop-downs that I'd like to protect. However, my problem is that when I select "Protect...Forms", the links in my table of contents becomes deactivated and can not be used. With the forms unprotected, the links in the table of contents work fine, but I lose all the functionality in the drop-downs (they stop being drop downs!).

Can anyone tell me if there is a way to have the best of both worlds here, and keep the links in my table of contents active while still protecting the forms?

A:Solved: Word XP - Protecting forms & keeping links

hi nerdlyman,

caveat: I've never got to the bottom of this and sometimes it seems to work and othertimes not, need to spend time experimenting.

however, you should try these:

1. protect forms via the padlock icon on the FORMS TOOLBAR rather than the TOOLS menu.
2. if 1 doesn't work, then try putting your document into sections (Insert \ Break \ Section Break) and from the menu TOOLS / PROTECT DOCUMENT click FORMS and then also click SECTIONS then untick the section that contains your TOC.



3 more replies
Answer Match 63.84%


Relating to a previous post:
"Exporting Word Form Data to Excel"
regarding the same form in many word docs esported into an excel sheet

My question is whether its possible to export repeated forms in ONE word doc so they collate into 5 columns.
(Would like the first 2 columns and 2 rows left empty )

My form look in word is thus:

Image: 01

Image: 02

Image: 03


Sample.doc is below

This macro obtained from:
"Solved: Export Word Form to Excel"
works well for the same form in many word docs exported to excel:

Dim vField As FormField
Dim fso As Scripting.FileSystemObject
Dim fsDir As Scripting.Folder
Dim fsFile As Scripting.File
Dim wdApp As Word.Application
Dim myDoc As Word.Document
Dim vColumn As Integer
Dim vLastRow As Integer
Dim x As Integer

Sub AddFormFields()

If ActiveSheet.UsedRange.Count = 1 Then
vLastRow = 1
vLastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row + 1
End If
vColumn = 1

Set fso = New Scripting.FileSystemObject

Set fsDir = fso.GetFolder _
("C:\Documents and Settings\User\Desktop\CIKA 2004\Members\UnProcessed")

Set wdApp = New Word.Application
wdAp... Read more

A:Solved: Exporting Repeated Forms In One Word doc To Excel

12 more replies
Answer Match 60.06%

I have several Word 2007 documents containing forms controls that I need to make compatible with Word 2003. When I save the 2007 doc as 2003, the controls become static content. I tried replacing them with legacy controls but can't get them to work. When I insert a drop-down list box, only the first entry in the list displays and there is no drop-down arrow allowing selection of other items in the list. Can you help?

More replies
Answer Match 60.06%

I just started using Word 2007 and am having some difficulty adjusting to the changes. Unfortunately this is the software I am stuck with and no upgrade to 2010 is possible.

Specifically, I have created a lot of forms in Word 2003 by using text boxes to be filled by the user. I've also used links and references so that the user doesn't have to re-type some of the duplicated information throughout the form.

After creating these forms, I protected the documents and other people within my organization use them as templates. These forms need to be uniform throughout the department.

Several problems. I'm having a hard time familiarizing myself with Forms in Word 2007. Another issue, is that I can't get the Forms Spell Check to work like it did in Word 2003. I want my users to be able to check the protected portion of the document. They also need to be able to unprotect the document if they have to make some changes in the form.

It would be very helpful if there was a Word 2007 guide that explains the differences from word 2003 and offers an interactive training.

I'm desperate. Can you help me?

A:Word 2003 Forms being used in Word 2007; And Creating New

2 more replies
Answer Match 55.44%

I made a form in word 2000. Everything worked great but if you push the "entry" key instead of the "tab" key it moves everything in the form down. Does anybody know how to disable the entry key or make it think it's the tab key?

A:Forms in MS Word

If it's even possible, it'll require VBA, which gives a macro virus warning on open, and they may just disable the macros anyway.

Actually, as I recall, it's not possible.

1 more replies
Answer Match 55.44%

Hi Guys..

I am working on a project which has a requirement of
creating forms which has certain areas that user can
I am using word XP. Can I create certain lockable areas
in the form? Is compatibility an issues with different
word versions?
My main concern is that the forms are going on web and
are to be downloaded by the user? Can we still maintain
the control? If not, what are my options?

Please guide. Any help would be appreciated


A:Word Forms

8 more replies
Answer Match 55.44%


I am trying to create a form that people fill in and then the data is transferred into a new document created from a template. The Form now opens when the template is open (thank you XL Guru) but I cannot seem to get the data to transfer...

I have created a 'textform field option' in a cell in word which I have called 'Price' in the 'Bookmark:' section.

I have then entered the following code into the userform module (my user form is called userform1):

Private Sub btnUserOK_Click()

End Sub

Private Sub TextBoxPrice_Change()
vprice = UserForm1.TextBoxPrice.Text
ActiveDocument.FormFields("bkprice").Result = vprice
End Sub

I am quite new to all this so you will have to excuse my ignorance if this is complete garbage...

Do I have to enter the code into the 'Userform1 module' or the 'thisdocument' module.

I then have an OK button which I want to click and the data then be entered into the appropriate 'textform field option'

Any help will be greatly appreciated..

Thank you

A:Forms and Word

Word VBA is NOT my thing (dunno where Annie is lately).

Whatever button (AKA control) on the form you want to "do stuff", rightclick it & "View Code" and shove it in there.


Private Sub CommandButton1_Click()
vprice = UserForm1.TextBoxPrice.Text
ActiveDocument.FormFields("bkprice").Result = vprice
End Sub


3 more replies
Answer Match 55.44%

Help!!!! I have created a form in Word 97. It basically lists the information I need and there is a text box to the side for the response to the question. All I need to know is how do I fix this form so the end user can put a response in the text box and tab to the next box. I feel like an idiot, I can not figure out how this works. I could do it in excel however this is for work and has to be in Word. Any help would be greatly appreciated!!!!!!!!!!!!

A:Forms In Word 97

I believe all you need to do is just "protect" the form. Click the padlock on your Form toolbar. Then you can tab from field to field.

Works for me but I'm sure Dreamboat or someone else will respond if this is not correct.

Get paid to listen to music online!

2 more replies
Answer Match 55.44%

I am trying to set up a from in Word. The goal is to have drop-down boxes and other web components so people can enter info. It is basically a form to request stuff from other people in the company.

I am trying to find a way to have the info from the form be emailed to someone when they click the submit button. I have a test form set up with everything I need, and then when I click the submit button I get the new email message but nothing appears in the body.

I know I am missing something, I just can't figure it out.


A:Forms in Word

9 more replies
Answer Match 55.44%

Customer has a word doc, when they open it the fields appear
to be displaying a form with terms like #fieldtext# and #checkbox#
When she prints it the correct values are printed.

Is there a method to view it as it would print ?

I assume this doc is the output from a form ?

A:Word Forms ??

Perhaps hitting Alt-F9 will work?

1 more replies
Answer Match 55.44%

I need help with Microsoft Word 2003. I am working with form fields. When I type in a form field it moves my formatting around on the same line dropping it to the next line. I tried right click to make adjustments to the form field, with no avail, I have tried double clicking in the form field with no avail.

I know I am missing something, hopefully somebody here can help. Thanks in advance.

Please see attached screen shots of Right and Double Click form fields.

A:Word (Forms)

7 more replies
Answer Match 55.02%

I'm stuck on these 3 things:

1)How to keep the autotext "document name" updated in a form/template (as the form is saved to a new name this doesn't change).

2)Is there anyway to get a TOC to work in a form/template? Clicking on a TOC entry in a template does nothing, but it's suppose to take you to that point in the document. I guess it needs to autoupdate some how?

3)Is there anyway to add row to a Table in a Form? In a typicaly table, if you Tab to the end of the Row, a new Row appears below. But this doesn't work in a Form/Template.

Thanks very much!

More replies
Answer Match 55.02%

I am attempting to create a letter template that contains a form for the operator to select various options. After the form has been populated and the okay button pressed, there are a number of message boxes to be completed before the letter can be finished.

I am trying to get the form to disappear from the screen whilst the message boxes are completed by the operator but have been unable to make this happen. I’ve tried using ‘hide’ and ‘unload’ in the code but it’s still there when the message boxes are displayed.

Any ideas how I can lose the form once I have finished with it?

It's works PC and we only have Office '97 - state of the ark!!

More replies
Answer Match 55.02%

I have a form which my customers use to request samples from me but when it comes through, the info order is mixed up (not garbled -- just not in the order of the original format). I contacted my server because I thought it might be a CGI conflict. They suggested I rewrite it through Word so that it was compatible with Microsoft Outlook which is my e-mail system. It didn't work!! Why is this happening? Does anyone have any suggestions?

A:Word Forms Formatting

You know, I can think of a million questions to ask you, but I think it would just be easier to ask you to email me a copy of your form. Send to [email protected] I'm very good with forms so I don't think you'll be wasting your time.

Off the top of my head it sounds like you are not protecting your form, or the users are unprotecting it.

3 more replies
Answer Match 55.02%

Hi guys,

Could someone please give me a hand with a little project I'm working on.
This is a little complicated, I hope you understand what I am trying to say

In MS WORD, I am currently able to make drop down forms.

Is it possible that if I were to have multiple drop down forms; I could use the first form menu to define what is listed in the other form menu's.

E.g. [Drop-down form 1] has 3 catogorys in its lists;
- Menu 1
- Menu 2
- Menu 3

When Menu 1 is selected from [Drop-down form 1], [Drop-down form 2] menu changes to whatever list I pre-define for menu 1. However if Menu 2 were seleceted, then [Drop-down form 2] will display Menu 2's list accordingly. Etc

Is this possible? I've seen it used many times before on website forms, but can I do the same in word?

If the above is possible... to take things one step further.. Can I do the same with the 2nd drop-down form; (any option that I select from it) to predefine choices for for a 3rd drop down menu?

Sorry if this is confusing, if there is any part you want me to clarify I'll be happy to do so.

Thanks for your help in advance.

A:Help with MS Word DROPDOWN forms

9 more replies
Answer Match 55.02%

Hi, I am creating a form in Word 2003 (Running over Window XP Professional). I have inserted a field called Sdate and on the next line Firstname. When I reference the field Firstname in other parts of the document, it also includes the field Sdate.
So my result looks like this:
Dear Sdate
instead of
Dear Firstname

I am having no problems with referencing other fields, only these two. I have removed the date field and put it back in and still the same result.

Hope this makes sense and hope you can help.


A:MS Word 2003 Forms

Hi lotsacats,

Are you using Bookmarks as Field References?
Maybe the Ref for Firstname also spans the previous line including Sdate:

In Tools /Options/View tick the Bookmarks box and then check if the square brackets [ ] are like this:


If so, delete the bookmark for Firstname and recreate it ensuring it only covers the Firstname line.


1 more replies
Answer Match 55.02%

I have MS Word forms that are filled out and saved. On all my machines (XP with Office 2000) all is well. We open the forms, all the check boxes and fields are seen and can be edited.
On one machine, also XP with Office 2000 all the forms formatting are not there. The forms tool bar is there, but protecting or un protecting the form does nothing. The text is there, but the fields and check boxes are missing.

Taking the exact same form to another machine yields the correct formatting.
It seems obvious that the copy of Word on my "bad machine" is missing some function.

Can anyone tell me what the problem is and how to fix it.

A:Forms in word 2000

A bit of an update.

I downloaded from an on-line backup service we use a word document that has formatting. (Same file as opened on the host computer that is having problems.)

The newly downloaded file opened with the forms function intact!
It is not Microsoft Word!

The next most likely suspect is that I initially put the documents into the offending computer from a pocket PC. I set up a partnership between two computers and the pocket PC. The sync appeared to be successful but it seems that it may have stripped the formating.

I don't know if this is the correct forum to keep this post going.

Any help would be appreciated.

I am thinking of transferring the word documents into the second computer by a physical transfer such as using a flashdrive first. Then establishing a partnership?
Any ideas are welcome.


1 more replies
Answer Match 55.02%

I've searched high and low, yet I cannot find the answer to my question.

Basically what I'm trying to do is make a customer-editable lease contract document for a customer of mine. I know the basics of Word forms, and I've entered the various fields (ie. Lessee's Name, Address, Phone, etc), and there are a couple of redundancies in information (specifically names of Lessee and Co-Lessee, so text). Instead of making the lessee type out the same info twice, I thought that I'd set it up so that if they enter their name at the top, it would be entered at the bottom in the same field automatically. I can get this behaviour to work time and time again with numbers (quite simple really), but is this at all possible with text? No matter what I've tried, I can't get it to work, and I've tried everything except ask someone. I'm a reasonably logical and intelligent guy, but I'm at wit's end here with this one.


A:Word XP Forms question

10 more replies
Answer Match 55.02%

Hello, I am using word 2007 and have created a document which includes some form fields (a date field and several check boxes). The form works fine for me after turning on protection. When I email it to my coworker though, the form does not work for her (she also has 2007) and it won't let her turn on protection so that the form fields will work. Can anyone offer any suggestions on how to correct this problem?

Many thanks!

A:Word 2007 Forms

Welcome to the forum. Can you please zip and post the file as an attachment to see what is happening? How are you protecting it?

1 more replies
Answer Match 54.18%


I am trying to enable spellchecking in a protected word document containing forms. I am at the stage where i know that a macro is necessary to do this. I have tried a macro which i downloaded but when i try to compile it i am getting an error.

Does anyone have a macro that works or an alternative solution to this? Also i would like to extend this as far as being able to edit(bold, italicise etc) text within the protected form as well but the former question is definitely priority!

Thanks for your help!

A:Spellchecking protected forms in word

12 more replies
Answer Match 54.18%

I sure hope i can get a computer guru to help me. My computers at work have just been upgraded at work to xp and some of the excellent programs now do not work. any way stop rambling.

I made some forms on Microsoft Access 2000 and wish to link the information that is being imputed onto pre made word templates.

the forms look aoutstanding a masterpiece in engeneering however i cant the life of me workk out how to when i click ok the information is transferred onto the templates, like a mail merge sort of thing.

Please help


A:linking my forms into templates on word

Why not just output the report? You can also make any report output to RTF but that may mess up any formatting. I don't think you can output to a template other than an HTML one.

1 more replies
Answer Match 54.18%

I was wondering if anyone knew a way to have the "save data only for forms" option always active.

At the moment if you activate it and then close word it becomes inactive again.

Thanks in advance.

More replies
Answer Match 54.18%

I have a UserForm which contains about 20 products which when selected are
output to the appropriate place in a Word document.

Is it possible to save the UserForm to a central point so it can be accessed
by several different letters? At the moment each letter template I produce
has its own copy of the UserForm, so if one of the available products
changes, I have to go into each template in turn and apply the change.

It would cut down editing time considerably if I only had to make the
amendment once.

Only have Word 97 at work

A:Microsoft Word - User Forms

6 more replies
Answer Match 54.18%

I have a problem! I made a form field in Word and placed a second form field right after the first field. When I started to fill the first field the second just moves closer to the right side of the page. How can I keep the fields form moving. I locked the form fields but that makes no difference. Thanks for your help.

A:Making forms in Word 2003

16 more replies
Answer Match 54.18%

When making forms in Microsoft Word (2003), is there any way to enable spell check for the areas that users can input data while still keeping the form protected?

Any assistance would be greatly appreciated.



A:Using Spell Check in Word Forms

Here you go, SED.

1 more replies
Answer Match 54.18%

Hi, this is my first post on here.

I am looking to create a simple and easy to use quote form so our sales guys can rapidly generate a quote for our customers. Ideally I would like to be able to have the user select a product name/number from a drop down menu and have information from that product filled into the appropriate categories of the form. (For example the price section would be linked to our price book, and would dynamically update if a different product was selected). If possible I would also like to be able to edit those entries as well in case of custom orders etc.

I'm not sure if this would require linking to Excel or what the best way to accomplish this is.

Also because we haveso many products, I was wondering if it was possible to create some kind of a "drill-down" menu system; so that instead of seeing a list of 1000 products there's something like Category 1 -> Subsection 5 -> Poducts (1-54) (I stole the term from NewEgg)

I've looked at office online help and haven't come up with much. Not even sure if this is the right forum, but if anyone has any information, or could point me to a locale where people would, I would GREATLY appreciate it!



A:Using Advanced Forms in Word (and Excel ?)


3 more replies
Answer Match 54.18%

Hi there

Last year I created an Appraisal form that we use at work for about 500 people. It's a Word protected form with form fields set in a number of seperate tables

For this year, I need to add a function that allows a user to open up last year's form, copy one table from it and paste the data into a different table in another copy of the same form

The table with the data in it is 4 columns wide but may have any number of rows in it. Row 2 onwards needs to be copied across

The table for the data to be pasted into is 6 columns wide and may not have enough rows to accommodate the pasted data so would need some sort of error trapping to pick up that it needs extra rows adding before pasting.

Data should be pasted into row 2 onwards and should sit within the first 4 columns of the receiving table. The idea is then the user fills in column 5 and 6 adding comments about the data they have pasted in

If any extra cells are needed to fit the incoming data they should have form fields in columns 5 and 6 too for entering the comments above

Phew...hope this makes sense

My experience of this kind of thing is limited to modifying other people's VB code/macros to add some functionality myself. This is a bit beyond me!

More replies
Answer Match 54.18%

I'm creating a questionnaire form with almost all text boxes. The problem is that the people that fill out the form sometimes hit enter instead of tab resulting in unsightly new lines below the text box. Is there a way to disable multi-lines?

A:Word 2000 Forms Problem

Well, you can double-click an unprotected text form field and give it an exact number of characters to allow. Sometimes, that won't work well, so what I do is put most of my form into a table (anyway), and put this specific field into a one-cell row, and then I set the height of the row to EXACTLY 14 or 16 points or whatever you like. That way, they can hit enter all they like, but it'll never show...

Brainbench MVP for Microsoft Word

3 more replies
Answer Match 54.18%

i am making a 50-page document with lots of forms in it. i made a nice little table of contents that links to each page to make navigation easy (and "back to table of contents" on each page), BUT when i lock the forms i lose the ability to click on links! i noticed that the scroll-by-whole-page is disabled as well. i went to dreamboat's word page and learned a few new things about forms, but didn't see this particular problem addressed. can anybody help me?

A:word 2000 forms and links

6 more replies
Answer Match 54.18%

I've created a form in Word that users fillout and print and save. Is there a way to make certain fields required?
I need it to be compatable with Word 2007 and 2002

More replies
Answer Match 54.18%

Hi guys i am a real novice when it comes to excel and i have taken on a task at work that maybe over my head (Job Cuts Looming so have said YES i can do that easily). can anyone help???

I am trying to get an excel and a word form to self generate a URN for a First Aid Report Form and also a Purchase Order Request form i have created both forms but carnt figure out how to get them to assign a new URN after the old form has been submitted, Any help will be greatfully appriciated

More replies
Answer Match 54.18%

I've tried and tried and have tried reading various help manuals. I am trying to create a fill in form using Word. It is for my husband's small business. Thank you!

A:Word: How to Create Fill-in Forms

Originally posted by ruhler1
I've tried and tried and have tried reading various help manuals. I am trying to create a fill in form using Word. It is for my husband's small business. Thank you! Click to expand...

I could possibly help ... but, what exactly do you mean by fill-in form. I want to be sure that we're thinking of the same thing. I could possibly know how to help. Feel free to email me! Or post your reply.


- Isabel

3 more replies
Answer Match 53.76%

I have created a form with fields and drop-downs. 1. Is there a way after tabbing through the form's fields to convert back to the word processor of Word to allow the author be able to type a narrative and still have all the functions of Word? and 2. I have followed advise on this site to have a field cross-referenced to another field if the answer is the same. Within the first field I checked "calculate on exit" and on the second, insert, reference, quick reference and chose the "text#" of the first field. When you tab away from the first field (while protected) a blank box is promted asking "ok" or "cancel". I have to click one answer twice and the field does appear at the second location. Is there another way to auto-copy fields or a way to get rid of the blank box being prompted? Working with Windows XP. I would appreciate any help. Thanks.

A:Word 2003 Creating Forms Questions

7 more replies
Answer Match 53.76%


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!


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.

2 more replies
Answer Match 53.76%

Here's what I need... - to be able to type information in on forms - save it - email it - allow people to fill in the form- save it- email it...I recently converted a bunch of pdf files we've been using to forms. That way people could fill them out before they print them. I should have asked for more detail because now people want to be able to save and email those forms. The only problem with that is that you can only save and email those forms if you have acrobat.So, I'm looking at converting a bunch of pdfs and pdf forms into MS Word forms. I can't imagine how much time it will take me to do some of the more complicated forms even with copy/paste.Has anyone had a similar problem before? Do you know of any tools that would make the conversion quicker? Do you have any links to tutorials on MS Word Forms?Do you know of any other way to accomplish those goals other than a form in MS Word?Thanks

A:Quickly Converting Pdfs To Ms Word Forms


2 more replies
Answer Match 53.76%

I have written several pages about a subject in Word and saved those pages in My Documents. When I go back to My Documents and try to insert some corrections or additions in the copy and click on the space where I want to insert them, suddenly there appears a fine line around my entire page, like the one where you create a message on this site.

If I click on a corner of it, hoping to delete it, the copy just skips to the next page, and I seem to have lost the page I just tried to correct. I have also tried pasting it again in Word and working with that copy, and the same thing happens.

I have written a lot in Word and I don't remember this ever happening before. How can I get rid of this box and be able to insert corrections?

Thanks in advance.

A:Fine line forms all around my Word copy

11 more replies
Answer Match 53.76%


I decided to try something new in [COLOR=#05408f !important][COLOR=#05408f !important]Word [COLOR=#05408f !important]- [/COLOR][COLOR=#05408f !important]add [/COLOR][COLOR=#05408f !important]in[/COLOR][/COLOR][/COLOR] checkboxes to a survey. To do this I tried using the Forms toolbar, but while that shows a checkbox option, it instead inserts a box that displays an "x" when activated. So I used the Control Toolbox version of the checkbox instead (sample attached).

The problem is that I can't get the [COLOR=#05408f !important][COLOR=#05408f !important]document[/COLOR][/COLOR] to be easily usable by others. Even if I disable Design Mode and save, the document always re-opens with Design Mode active, so users can't fill out the form as intended. If I go back to the Forms [COLOR=#05408f !important][COLOR=#05408f !important]toolbar[/COLOR][/COLOR] and Protect the document, everything is disabled and the checkboxes don't work at all (and nothing can be typed at all, and I can't unprotect the document again). The only way I can use the checkboxes as intended is to disable Design Mode on the Control Toolbox toolbar.

Which is fine, but that toolbar still pops up as a floating toolbar whenever anyone opens the document, and it opens with Design Mode active again.

I shouldn't have to tell people that to use my document they need to first disable Design Mode (99.999% of the people this is intended for would probably have a hard enough time figur... Read more

A:Word Forms - Always Opens in Design Mode

Please upload your attachement here. The link you provided requires that you register in order to view the attached doc.


1 more replies
Answer Match 53.76%


I want to create one Attendance Form wherein employee will fill the same and send.

Also, If we can solve this in Word Form or Outlook Form or Access Form. Post the same with the help of Macro we would consolidate the leave.

Form Example :

Employee Name :
Employee ID :
Direct Manager Name :
Direct Manager ID :
Business :
Function :
Type of Leave : Sick Leave, Casual Leave, Maternity Leave, Sabbatical Leave, Long Leave.
From / Start Date : Employee would be able to select Calendar
To / End Date : Employee would be able to select Calendar
Remarks :
Would appreciate your prompt action / views on the same.
Rahul Gandhi

A:Help Required in Forms : Outlook / Word / Access

I think you need to be more precise about how this "Form" is supposed to work.

3 more replies
Answer Match 53.34%

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

8 more replies
Answer Match 53.34%

I?d like to create a form which collects data using text fields and drop down menus and perhaps even some radio buttons. (ok that part I got)

but I then want to take the responses to the form and insert into a report template. (even this I kinda get, e.g., using legacy tools and ?calculate on exit?)

But the catch is I need to convert some of the responses to different text. Let me give you a for instance.

On the medical history form I have a question such as:

"Do you have a history of heart disease" (followed by a drop down menu with yes or no)

If the person selects "yes" then I want it to autofill into the report (later in the same word document) ?the patient reported a history of heart disease, or if they select "no", ?the patient denied a history of heart disease?
So I want to take the responses to some form content control objects and replace the text (e.g., yes=reported, no = denied) and insert into a place later in the document.


A:Using data from Word forms to fill in a report template

oh, and this is all in ms word 2010.

1 more replies
Answer Match 52.5%

Have created some basic online forms. Now I am tasked with displaying each entire field length (visually somehow) so the user can see approximately how much room they have to enter test. Examples:
Name: Field length highlighted or shaded
Location: Underlining would work to indicate field length
Phone: ( Parenthesis might work )

If I type "Enter Name Here" in Properties, under Default Text, only "Enter Name Here" is shaded. The shading does not extend to the maximum length I selected. The field extends that far, but no indicator of the entire field length. Thanks to everyone for being patient. Attempted to be specific as my question seemed unclear in other unrelated forums. This forum/posting/threads, etc. is new to me. I am 62, so go figure!

A:Forms/Word 2007/Display entire field length

Welcome to the Seven Forums.
This is unfamiliar to me, have you tried enter spaces in the chosen field?

6 more replies
Answer Match 52.5%

I have created an auto fill form in Microsoft 2007, but my sample (directional) text does not the grey highlight behind it indicating to the user where each text field is located. If i manually apply a highlight, then the user cannot get rid of the highlight after their form is filled due to the document protection.

All the information I have found online indicates that the sample text should have the grey highlight which then will disappear once the user populates each field. Is there a setting to fix this, or am I creating the document incorrectly to cause this difference?

More replies
Answer Match 52.5%

I'm trying to figure out how to make it so that a very long checklist, which includes checkboxes and text boxes, can be transferred to excel. (I'm working with the Microsoft Office 2007 suite.) I've been reading about how you're supposed to enable the "Save Data as Delimited Text File" in the advanced part section of the 'Tools' Options tab, and then save it as a text file to import into excel, but when I do that it doesn't save any information, just two zeros. I've been looking at other forum questions and messing around with how the forms are protected or not, but I can't get it to actually save any of what's entered in to the forms when I save it as a text file. Any help on this would be very much appreciated.
I've attached a zip folder (I hope) with a section of the checklist in case that might help. Thanks so much!

More replies
Answer Match 52.5%

I have this form that I made on my 97-03 version of Word. I had inserted check boxes (that work when you click on them) and fields where you can enter information. In the old version of word, there was this protection button that looked like a lock and you can click it to protect the document in which case it would only be useable in the fields where you can type and the check boxes. When you click it again you could go back to editing the document.

I have jsut been upgraded to 2007 Word and I want to modify my document but I do not know where that little lock button is so that i can unportect my document and change the wording. Please let me know.

A:Word 2007 Check Boxes, Forms, and Protection/Unprotection

Review Tab > ProtectDocument > Restrict Edit

2 more replies
Answer Match 51.66%

Hi everyone!

This is my first post here so hope I am clear enough and someone can help

I am wondering if it is possible to do the following in word 2007. The reason I want to use this program is for easy access and completion by multiple low-level skilled people in my organisation.

I want to have a central word doc with employee data (ie names, addresses, phones, emails etc..) and have this data auto insert into a series of forms on multiple documents.

This data is used many times and figure this will make it easy to ensure all the data is current as it will all read off the one central document, also will the human error factor and lost time to enter the same data several times.

Is this possible?

Hope you can help

More replies
Answer Match 48.3%


I am in the beginning stages of customizing Outlook forms. I would like the same field info e.g. Business Phone to appear on both the Contact (IPM.Contact) and Journal Entry (IPM.Activity) forms.

If I add the Business Phone field to the Journal form will it automatically be populated with the info from the Contact form when I open it?

As I said I'm new at this and if my question is hard to follow please tell me and I'll retry.



More replies
Answer Match 47.88%

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

7 more replies
Answer Match 47.88%

Greetings, and thanks in advance for your help.

First off a little background...

We have many documents that we use on a regular basis in which we make small corrections to and save them and print them using a MS word template that we created. Unfortunately we were not able to save and protect the formatting of those templates because we need to add more information to the document. And after working perfectly for many years we finally had someone that thought they could "improve" what was already working....and changed the formatting of our "Printdate" Word macro, but not on all the documents only a few.

My question for you is....

1) Is there a way to do a "Search and Replace" with all of the documents to update the "PRINTDATE /@ mm/dd/yy HH:mm" formula that works correctly, with whatever is currently in use on specific pages?

2) Is there a way to protect the template and still alow users to type on the form? Currently the templete itself is protected, however when someone creates a new document it is saved as a .docx file

Thanks for your help.

More replies
Answer Match 46.2%

I need to convince Nuance and Adobe to play nice together. I have Nuance PDF Converter Professional 7, and a form I originally created in MS Publisher and made a PDF from. I used Nuance Converter to make a fillable form from that PDF, which works really well in Nuance PDF Reader, and allows the user to type in the form and Save or Save As.
However, when the same form is opened in Acrobat Reader 7.0, I get an error message that says "You cannot save data typed into this form". I could work around this if I thought every computer in my target department could print to PDF, and if I thought the employees in said department could manage that. I have my doubts on both scores, so I need Nuance and Adobe to play right. Any tips on this?

A:Nuance PDF Forms to Adobe PDF Forms

9 more replies
Answer Match 44.52%

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

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

6 more replies
Answer Match 44.52%


I have go a main form with cascading lists which I use to run a query.

I want to display the query results in the subform.

I have set the source object as the query which runs from the values in the cascading list.

I have then set the Ok button on click command to

DoCmd.OpenForm, acForm, "subfrmSectionQuery"

Does anyone know where I have gone wrong??


More replies
Answer Match 44.52%

I would like to take the attached database and create a tabbed form.

A:Solved: Tabbed Forms

16 more replies
Answer Match 44.52%


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?

2 more replies
Answer Match 44.52%

I have a button, when pressed it is programmed to open a form that correspondes to the related form on which the button was pressed. However, when the form opens it is blank on the form view, and normal on the design view.

I tried directly opening it and it does the same. Why?

A:Solved: Blank Forms

8 more replies
Answer Match 44.52%


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

16 more replies
Answer Match 44.52%

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.



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.

2 more replies
Answer Match 44.52%

My operating system is windows xp. For some reason i cannot download forms off the internet.

A:Solved: Downloading Forms

7 more replies
Answer Match 44.52%

Hi all,

I am creating a form in excel to record two variables, the type and size of a bin, at a range of properties.For each property i visit I will need to record data on multiple bins on a separate row in excel. I am doing this using option buttons and visual basic as I feel this is the easiest way to collect the data while in the field.

My question is this. The form records the data perfectly for a single row, but i cannot work out how to make it start recording data on a different row, for a different property. Ideally I would like the form to start recording data on whatever row I click on, but if it just moves down a single row each time, that is fine as well.

This is the code I have so far come up with:

Private Sub CancelButton1_Click()
Unload Me
End Sub

Private Sub OKButton1_Click()
nextcol = Application.WorksheetFunction.CountA(Range("1:1")) + 1
nextcol = nextcol + 1
'Application.WorksheetFunction.CountA (Range("1:1")) + 1
If OptionRefuse Then Cells(1, nextcol) = "Refuse"
If OptionRecycling1 Then Cells(1, nextcol) = "Mixed Recycling"
If OptionRecycling2 Then Cells(1, nextcol) = "Paper Recycling"
If OptionRecycling3 Then Cells(1, nextcol) = "Glass Recycling"
If OptionRecycling4 Then Cells(1, nextcol) = "Cans Recycling"

If Option80 Then Cells(2, nextcol) = "80L"
If Option160 Then Cells(2, nextcol) = "160L"
If Option280 Then Cells(2... Read more

A:Solved: Forms in Excel

6 more replies
Answer Match 44.52%

I have run into what seems to be a common issue with forms and resizing of other forms that are already open. If I open a main form full screen and open another smaller form, the small form I want to stay small also goes full screen. If I hit the restore button on the small for the main form also resizes with it and cuts off half of the window and I have to resize it again. Annoying to say the least!! I am tire of trying to accomodate screen sizes so I am going full screen on the majority of the forms with the exception of a few forms that do not need to be that large.

LEmme know what you think.

A:Solved: Sizing of forms

Rockn: Which application? Access? I think you can set form screen sizes independently.

3 more replies
Answer Match 44.52%

Well i did a big report on my computer with Word Perfect i couldnt print it so i took to school on my flash drive. IN my first class i edited it on Word 2007 and in the class i could print it they had Word 2003 and i couldnt open my file and now i cant even open it in word perfect. I doubt i can use the laptops for a while anyway i can open this on wordperfect

A:Solved: Word Perfect- Word 2003 - word 2007

If you saved the file in the "new" Word 2007 format (with a file extension of .docx) then you will be unable to open it in the other applications.

For Word 2003 you can install a converter, but I know of no XLM converter for WordPerfect.

When using Word 2007 you need to "save as" Word 97-2003 format to retain backwards compatibility.

1 more replies
Answer Match 44.1%

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

6 more replies
Answer Match 44.1%

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

6 more replies
Answer Match 44.1%

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?


A:Solved: Microsoft Access - Forms

8 more replies
Answer Match 44.1%

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?


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.

3 more replies
Answer Match 44.1%

I am creating, first of all - an MDI parent. It will be the main window for everything I will be making.

I want to have all the modules in this main program to be .dlls so that its easier to auto-update or have the user add/remove modules.


So I started with a Windows Application - made my main window and all that (looks pretty by the way) - then I add a Class Library to the solution, add the reference, etc...

When I try and use a form (whether it be from the class in that CL or from the main windows application) it doesnt really recognize it as a form (i.e. there is now Show())...

I'll continue to play around and research until i figure it out... but i'm sure somebody here can easily write a small paragraph that'll tell me exactly what to do..

A:Solved: Forms within a Class Library (.dll) in VB.NET

in dll:
Shared Sub test(ByVal own As Object)
Dim a As New frmSurveys
End Sub

in main window:

2 more replies
Answer Match 44.1%


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.


A:Solved: Access forms binding

16 more replies
Answer Match 44.1%

I created a form using two tables, but when I access it in form view, I can't edit/add data. I have checked that it will allow edits/deletions/additions, nothing is locked and fields are enabled. The tables are linked by the column they have in common. I have searched for an answer for three days to no avail! Can anyone help?

A:Solved: Forms using multiple tables

RowanFV, welcome to the Forum.
It sounds like you have made what is known as a non-updatable Recordset. It is not normal practice to have 2 tables on one form, you would normally use a Main form for the main table and a Sub form for the secondary table.
But it does depend a little on how you have "Related" them in the Table Relationships.
Can you post a Screen Print of your relationship in an Office 2003 program format (word, excel etc)?

2 more replies
Answer Match 44.1%

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

16 more replies
Answer Match 44.1%

I work at a school and have an Access 2010 database with 3 tables, a "Pupils" table, "Comments" table and "Actions" table, all linked (relationship) by an id number.

I have a form where I have Pupil name on the header and can scroll through associated comments and another form where I can scroll through acssociated actions.

Can I put both tables with continuous views on 1 form,perhaps adjacent to each other with 2 vertical scroll bars (so that I can see both tables at the same time)?

Many thanks

A:Solved: 2 Continuous forms on 1 form

6 more replies
Answer Match 44.1%

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

15 more replies
Answer Match 44.1%

Hello Anyone!

I am new to Access and am creating a database to store survey data. I have created many tables, each based on a specific portion of the survey, ie one for demographics, one for substance use, etc. Each table is connected via a unique participant ID#.

I am attempting to create a giant form that will mimic the order of the survey for ease of data entry after it is distributed. Many different people will be entering data and I want to ensure there are as few errors as possible.

My issue is that I can't seem to get the form to look right and I'm only trying with two tables at a time for now. The wizard crowds all of the questions onto one page. If I manually do it, I need to move one question over at a time and there is more room for error on my part.

Anyone have any suggestions?

I'm using Access 2010.

Thank you kindly!!

A:Solved: multi-table forms

efreedman11, welcome to the forum.
I am afraid that if you do not like the way the wizard arranges the fields on the form the only way to get it the way that you want it is to manually move them to where you want them.
The way that I would approach this is to get the wizard to create a form for each table, arrange each form the way that you want each "Section" to appear and then add all the forms on to one mainform (I would use the form that is the start of the data entry for that) as subfroms and then arrange them to appear how you want.

2 more replies
Answer Match 44.1%

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 32 bit
Processor: Intel(R) Core(TM)2 CPU 6600 @ 2.40GHz, x64 Family 6 Model 15 Stepping 6
Processor Count: 2
RAM: 1790 Mb
Graphics Card: NVIDIA GeForce 7100 / NVIDIA nForce 630i, 256 Mb
Hard Drives: C: Total - 73123 MB, Free - 22744 MB;
Motherboard: SAMSUNG ELECTRONICS CO.,LTD, Samsung DeskTop System
Antivirus: Panda Antivirus Pro 2014, Updated and Enabled
Hi: My mouse wouldn't let me even get into this website to see why I couldn't fill in forms, as I couldn't enter my User name and password. I finally realized that this had happened a couple of days ago when I updated Security Items from Microsoft, so I went into Programs and found the last item by date that I had installed. It was Compatibility Pack for 2007 Office System. It was a pretty large install and anyway, I uninstalled it. Lo and behold, I can now enter my name, etc. on forms again. What is concerning me now is that I have probably lost some of my security, so am wondering which items in this Pack that I can download without stopping me from filling out forms.
Help please and thank you.

A:Solved: Mouse will not register on forms

The compatibility pack has nothing to with security. Are you running an older version of MS Office? That is the only time you would need the compatibility pack if someone sends you documents created in newer versions so you could read them.

8 more replies
Answer Match 44.1%

Hello again,

I have a button that when pressed, opens up a form that shows records that meet a certain criteria. Now, I know that I can just put my cursor where I want, and go Records --> Sort --> Sort Ascending while I'm looking at the form.

However, I want it to where it automatically sorts the records ascending by the last name field without having to use that method. As in, I want it to open up sorted by the last name. Is there anyway of accomplishing this?


A:Solved: Sorting forms by field?

6 more replies
Answer Match 44.1%

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??


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!NameOfTextBoxOnSubform = ValueYouWantToGiveIt
End With

End Sub

That should do the trick.

Good Luck!

2 more replies
Answer Match 44.1%

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?


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).

1 more replies
Answer Match 43.68%

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!

More replies
Answer Match 43.68%

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.

3 more replies
Answer Match 43.68%

Hi, I have uploaded a pdf form to a website, but when I go in to fill out the form - it will not let me backspace or edit the field that I just typed into. I only have this problem when using google chrome. Is there something I can do to fix this? Thanks!

A:[SOLVED] Can't Backspace in web PDF forms on Google Chrome

Ok, I found the answer to my problem. I have the backstop extension added in my google chrome settings (so that if I hit backspace it does not take me to the previous page) and when I disable this extension then the pdf form lets me backspace the text I typed into the form fields. *Pats self on back*

1 more replies
Answer Match 43.68%

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

12 more replies
Answer Match 43.68%

My table X has a field “DateLastUpdated”, along with 7 other fields.
Within my Form, I wish to set this field to today’s date whenever any of the 7 others change.
To do this, I suspect I can set an ‘On Change’[Event Procedure] for each of the 7, but is there a better way of doing this ?

And can you suggest what the vb coding might be, as I am a complete novice.

This field should also be set when a new record is written to table X.

Many thanks

A:Solved: Forms : On Change Event Procedure

grinder, the Form has an "On Dirty" Event and a "Before Update" that you could use, and I would use the Before Update. Enter in the following code

Me.DateLastUpdated = Date()

if you want just the Date and

Me.DateLastUpdated = Now()

If you want the date & time

2 more replies
Answer Match 43.68%

My cryptic title means the following.
I have the following pop-up calendar code to fill a particular field in a userform:
Option Explicit
' ===================================================
' Code by Martin Green eMail [email protected]
' Visit my Office Tips web site at
' ===================================================
Private Sub cmdClose_Click()
' Close the UserForm
Unload Me
End Sub
Private Sub UserForm_Initialize()
' Check if active cell contains a date. If 'yes' show
' same date on calendar. If 'no' show today's date.
If IsDate(MedewForm.ActiveControl ) Then
Calendar1.Value = DateValue(MedewForm.ActiveControl )
Calendar1.Value = Date
End If
End Sub
Private Sub Calendar1_Click()
' Transfer date selected on calendar to active cell
' and close UserForm.
MedewForm.ActiveControl = Calendar1.Value
Unload Me
End Sub

I would like to use this form for more than one form.
I imagine I could store the active userform name in a variable and replace MedewForm with this variable and then use it for any number of userforms but:

I have tried declaring a public constant but that did not work.
Any suggestions will be appreciated.


A:Solved: VBA (Excel) code one userform for more forms

I found the solution.
Remove the userformname, in my case MedewForm, and it works with any form.
Tested it and it works.

1 more replies
Answer Match 43.68%

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.

12 more replies
Answer Match 43.68%

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

8 more replies
Answer Match 43.68%

i recently had to reinstall windows xp and i cant remember where the setting is to tell my computer to remember my names, addresses, e-mails, etc. when im filling out forms over the internet. hope you understand what im referring to.

A:Solved: remembering info for filling out forms, etc.

Open Internet Explorer>Tools>Internet Options>Content tab>Autocomplete button.

2 more replies
Answer Match 43.68%


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).



A:Solved: Access 2010 - Linking 2 forms together

7 more replies
Answer Match 43.68%

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.

A:Solved: MS Access Forms and Screen Resolution

6 more replies