Computer Support Forum

Word Form (2003) need to be able to protect part of the form but not all of it

Question: Word Form (2003) need to be able to protect part of the form but not all of it

Can someone please help. I'm I can't seem to figure out how to keep an imported Excel file open to my users once I lock the Word form that I imported to. I need for my users to be able to be able to fill out the form as wellas open that Excel file if they need to. Any help would be greatly apreciated.

More replies
Relevance 100%
Preferred Solution: Word Form (2003) need to be able to protect part of the form but not all of it

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 (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 105.37%

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.

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

11 more replies
Relevance 98.81%

Hi all.
I have a form word document that looks ok when viewed but when printed there are the words "formdropdown' in areasthat should contain names, addreses, etc.
Running XP Pro.
The form works ok when printed from other pcs.
Having the same prob with other forms.

Please help.



Answer:Word Form Doc Printing Crap Instead Of Form.


3 more replies
Relevance 98.81%

Actually, it makes sense because it's in the middle of the form where the cursor is sitting and the user will first enter their data. But first they need to read the instructions at the top of the form.

Is there a way to set it to load the page scrolled to the top rather than to the middle where the data is to be entered?

Thanks, Peter

More replies
Relevance 98.81%

Unable to convert Word form to Excel form. Tried screenshot of Word form, pasted to Excel sheet and filled-up by text but the text itself always mis-arrange.Kindly help me please...

Answer:Convert Word form to Excel form

Rather my cherry picking and copying a few how to... suggest you follow the results here:'s a google list found using:convert excel document to wordas the search term...

2 more replies
Relevance 98.81%

I had to design a fill able form at work using Word (2003) only. I used text form fields in tables and set it up as a template (.dot). It has repeatable header at the top. The form is to enter info about a segment of a route. As an example; it’s to put in certain info of I-40 (Interstate 40) between Memphis, TN and Little Rock, AR. No problem it worked great and everybody liked it. They have now told me that if they want it to be able to add further segments on the same form as needed. Like say they want to add info of the segment of I-40 from Little Rock to Ft. Smith, AR. So how do I do that? The way I made the form up was to protect it with editing restrictions set to filling in forms. Because of that they just can’t copy and paste the fields. Is there anyway to make a macro or something that asks them if they want to add another segment for the fields to repeat?


Answer:Word 2003 Fillable Form

Little bump please....

2 more replies
Relevance 98.81%

I want to create a form where I can fill in a field once and all other fields in the document seeking the same information are automatically filled with the same response. For example, if there is a document that has multiple locations that require the name of the person filling out the document, I want to be able to enter the name once, and have that same response be filled in at all the subsequent fields requesting the person's name. Does anyone know how to do that?

Answer:How do I automate a form in Word 2003?

I hope THIS link is of some help to you....

3 more replies
Relevance 98.81%

I would like to create a form in Word 2003 and post it on our intranet for users to fill out and print. I do not want them to be able to save to the desktop. Any thoughts on how this can be done?

Answer:Creating Form in Word 2003

9 more replies
Relevance 98.81%

I'm trying to create an editable form using Word 2003. I do some text, use the Forms toolbar to add a form box, and set the number of characters for the box. I then leave enough spaces in my text to accommodate the box's set maximum. The problem is that when filling in the box, after 10 characters (the size of the field), rather than fill in the space I've left for it, it pushes the next line of text.

Am I missing something obvious, or is there a workaround? I'm a Word novice.

Thanks for your help.

More replies
Relevance 97.99%

I just started using Word 2007 and am having some difficulty adjusting to the changes.

Specifically, I have created a lot of forms in Word 2003 by using text boxes and dropdown lists. After creating these forms, I protected the documents and other people within my organization use them as templates, i.e. performance review forms, OSHA First Report of Injury.

My problem is that I can't convert some of the forms to 2007. Sometimes the 2007 Protect Document feature works great and other times it doesn't work at all. I really don't undertstand what the problem is.

I tried to upload the form here but I received an error message which said that the format was invalid.

I'm desperate. Can you help me?

More replies
Relevance 97.58%

I'm creating a survey to send out in Word 2003 using text form fields and check box form fields. When typing comments in the text form fields, if the comments go above a certain word count, it is impossible to see what you are typing. Is there any way to make these text form fields scrollable?

More replies
Relevance 97.58%

Hello All.

I am attempting to create Text Form Fields in a previously created Word document. It was not created from a form template.

The field is the DAY in the date field: 10//007. I put the insertion point in the DAY field, click on the Text Form Field icon and fill in the field attributes. Type=Number, Max length=2. I type in a Help description, click OK, save the file, and click on the Protect icon.

When I key in a 2-digit num and press tab, the next page comes up. The same thing happens if I try to put in alpha characters. My help message does not appear. I pressed F1.

I would appreciate any help with this issue.

Answer:MS Word 2003 Text Form Field

9 more replies
Relevance 96.76%

As I stated in my previous post, I'm creating a survey to send out in Word 2003 using text form fields and check box form fields. When typing comments in the text form fields, if the comments go above a certain word count, it is impossible to see what you are typing.

As it appears there is no way to make these text form fields scrollable, it is possible to make the text form field expandable when typing in it?

More replies
Relevance 96.76%

Hi Everyone!

I have a form that I created in Word 2003 (see attached). There are a few things that I’d like to accomplish with this form.

1) once the form is completed by the user, I want to be able to export the entered data into an excel spreadsheet (via macro button – submit/export - and VBA for the actual transfer of data?)
2) for 3 of the sections with radio boxes (employment type, rate your experience, and the 1st line of availability (1 shift/wk, 2shift/wk…)) I would like only one selection to be made. So the user can only select one of the options, and not multiple. Actually the Teaching Experience one…I need it so they can select whichever grades they teach, but only one selection of ‘years taught’. They can select any/all the MPMxx but it’s the ‘years’ that is important…

I have a very basic understanding of VBA but I work with excel all the time so I’m relatively comfortable with some things and willing to learn/try new things…

Can someone please point me in the right direction as to how I can accomplish this?

What I envision is the form being completed then sent back to me. I then hit a button embedded in the form that will then export the data to my excel spreadsheet where I can sort, etc…

Any help would be much, much appreciated as I’ve tasked myself with completing this…when maybe perhaps I should have tried to figure out how complicated this might be first…

Thanks for reading!!!

Answer:[VBA] Exporting Word 2003 Form Data to Excel


Okie, my objective here is to transfer the data from a word .doc into an excel spreadsheet. The form is all bookmarked with proper tags. I have started the VBA code, but I’m at a loss as to why some things aren’t working…

Sub Report1()
Dim path As String
Dim wdApp As Word.Application
Dim wdDoc As String
Dim curDoc As Word.Document
Set wdApp = CreateObject("Word.application")
wdApp.Visible = True
path = "C:\Users\xxxxxx\Documents\APPLICATION FORM\FINAL COPIES"
'Get first document in directory
wdDoc = Dir(path & "\*.doc")
'Loop until we don't have anymore documents in the directory
Do While wdDoc <> ""
'Open the document
Set curDoc = wdApp.Documents.Open(path & "\" & wdDoc)

ActiveCell.Offset(0, 1).Value = curDoc.FormFields("DATE").Result
ActiveCell.Offset(0, 2).Value = curDoc.FormFields("FNAME").Result
ActiveCell.Offset(0, 3).Value = curDoc.FormFields("LNAME").Result
ActiveCell.Offset(0, 4).Value = curDoc.FormFields("EMAIL").Result
ActiveCell.Offset(0, 5).Value = curDoc.FormFields("OCT").Result
With ActiveCell.Offset(0, 6).Value
If FieldName = True Then
ActiveCell.Value = "PERMFT"
ElseIf FieldName1 = True Then
ActiveCell.Value = "LTOS"
ElseIf FieldName2 = True Then
ActiveCell.Value = "RET"
ElseIf Fie... Read more

2 more replies
Relevance 96.76%


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:


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!


Answer:Solved: WORD 2003: FORM FIELDS question

6 more replies
Relevance 96.76%

hello all

I am having trouble with something that seems like it should be so simple! I need to recreate a form for my boss that she only has in hard copy. I am using a table and removing the borders so that everything is straight in the form that people will need to fill in. I need to put a place for people to write on, like a line, and each cell will need text then a line. I tried using the underscore but it comes out looking spotty, meaning there are spaces between each underscore.

there has to be a better way of doing this? I have never recieved any formal education with regards to word 2003, so all I know I've learned by trial & error but I can't seem to figure this one out.

I can't access photobucket or anything like that, so I can't add a screenshot. Basically it needs to look like this:


^ that was done with underscores but they don't show up nicely in word 2003.

thanks for your attention, all!


Answer:Solved: creating a line in a form in word 2003


This is a simple one if you are using tables to layout your form.... just add the border to the bottom of the cell where the text will be entered.

I have attached an example of this if that helps.....

2 more replies
Relevance 96.76%

I'm creating a form in Word 2003 that will be filled out both electronically and as a written form. Form fields are inserted in the document but are much too small when viewed as a printed form. The only help I've found via Microsoft suggests adding fields back-to-back, which works for a printed form but makes tabbing through the electronic document a pain.

After all that, here is my question: Is there a way to increase the display size of form fields in Word 2003? Thanks in advance for being such helpful geniuses.

More replies
Relevance 96.76%

Hi all, I am sure this is simple, but I have been struggling for hours now. I am creating templates in Word 03, which is essentially a letterhead style document with some areas 'protected' so the company 'brand' is maintained.

The document includes some drop down lists and some areas which are free for users to add their own letter specific content.

Currently, I have the date automatically inserting, drop down lists working .. easy. I have areas where users can enter their specific text ... easy.

BUT I can't find how to give users the ability to insert text or pictures, within a specific area if they so desire. The pictures will be completely user specific it may be a map, or a photo or a graph ... it's up to them and I what them to be able to do it .... any help would be appreciated.

More replies
Relevance 95.53%


I am currently using Word 2003 and have created a template. Within the template are text fields. My current issue is that if I make a change to formatting in one of the text fields, it replicates to all of the text fields. To give an example in the screen shot if I enter text then change the formatting under Point 1 (Project Statement) that change remains with that text field. If I go down to the next form field, and before entering any text, make formatting changes, that replicates to all of the form fields below. Similarly if text is entered first, then a formatting change made i.e. bullet point, that then seems to replicate through to the rest of the text fields. Can someone please explain as to why this is happening? thanks.

More replies
Relevance 95.53%

I have created a form in Word 2003. Every time a user opens the form a text box (fill in the blank box) appears. This occurs whether or not the form is protected.

The header on the box says "Microsoft Word" and there is a place for the user to fill in text. There are also "OK" and "Cancel" buttons.

If you click OK or Cancel, then the form continues to open up normally.

Does anyone know how I can get rid of this box?

Thanks for any help!

More replies
Relevance 95.53%


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.

Answer: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!

2 more replies
Relevance 95.53%

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.

Answer:Formatting form fields in Word 2003 in protected mode

Here's something to look at:

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.

1 more replies
Relevance 95.53%

Hi,I have a letter that contains several text form fields. This document also has mail merge fields in the header. I need to perform a mail merge to insert addresses in the header, but I need to KEEP the text that is in the text form fields (it provides a guide for what the user needs to put in that field). However, when I perform a merge, that form text disappears. If  I protect the document, I can't perform a mail merge.The final product will be a series of form letters to be used by several locations of our office. Each location will get a letter with their address in the header, and then they need to be able to fill in those form fields in order to send this letter to a customer. I would rather not have to manually enter the address for each location into the header. I thought a mail merge would save time... instead I'm tearing my hair out trying to make it work.Help?I'm using Word 2003 and Windows XP.

More replies
Relevance 95.53%

I am having this problem - I converted the Word 2003 form, but the 'Controls' panel buttons remain disabled. I saw a thread with the same problem, but it had expired so I can't determine how to correct this?! How do I get those buttons enabled so I can unlock the form and make edits? Thanks!

Answer:Solved: Problem converting Word 2003 Form to 2007

12 more replies
Relevance 92.25%

Hello I found an answer to this question but it was specific to his form. I have several Excel Logs (Tables) that contain information that is also entered into a separate form. Some forms are in excel and some are in word. I would like to hit a button that transfers a row of data to the form so i only have t enter data once. The forms will have additional information that will be entered. The forms are saved as a specific file type and are also printed so the answer that i found on this site may work but it puts the data into a different spread sheet in the same workbook and i need to send the data to a new workbook and in one case to a word doc. Can someone help me out. I have attached a couple examples of what i currently do.

Thanks for the help

Answer:Solved: Populate Excel Form and Word Form from Excel Table

16 more replies
Relevance 88.15%

Does anyone know of a way to convert a MS Word form to a PDF form? I have a few forms that were made in Word, but I need to be able to distribute them as a fillable PDF form.. I'm using the full version of Acrobate 6.0. If there's a way to do this without having to buy a thrid party plug-in, let me know (I'm too strapped for cash right now to buy a solution).

Answer:MS Word Form to PDF Form

Download and install OpenOffice
open the word file,
File > Open
File > export as PDF

Start > Control Panel > Add/Remove Programs > Uninstall Microsoft Office

your done

3 more replies
Relevance 85.69%

If you know about security in website and computer then tell me how to secure Website from Malware Attack. And what is the role of Google Webmaster in security purpose?

More replies
Relevance 85.69%

Hi all,

i have one form I'd like to password protect. I found the following code online that I know will work:

In ON CLICK event
Dim PassWord As String
PassWord = InputBox("Enter Password")
If PassWord = "YourPassword" Then
' Open Form
DoCmd.OpenForm "YourFormName"
DoCmd.GoToRecord , , acNewRec
MsgBox ("You're not authorized")
End If

but the problem is that this is tied to a button on the switchboard. I have 5 different switchboard pages, and if i tie this to the first button on the physical form (in the form section), I think it will require the password for the first button on all the pages.

is there a workaround or another way to do this?



Answer:Access: Password protect a form?

8 more replies
Relevance 84.87%

I use sxipper to manage all of my passwords and form filling. When I go to my banking wesite though, I always have to fill in my information manually.

My question is, by using sxipper to fill in my forms, are my passwords protected from hackers? Also, I read somewhere that it works just having sxipper enabled on your computer even if you're filling forms manually. Is that true?


Answer:Using a Form Filler to Protect My Password Online

I never really trust anything like that handling my passwords.

3 more replies
Relevance 84.05%

Hi all

I have a simple Access (2003) db which has a single form view with a subform. The main form is a record based upon a physical case file the subform only details actions past and future, a sort of event log.

I also have a continuous form which displays all upcoming actions sorted by date on all cases for a particular user so they can see just how busy they are likely to be for a particular period. What I would like to do is have an on click() property for the detail of the continuous form so that it opens the main form filtered by the record in the continuous form that was clicked. User can then update or add new events for that case before closing form and returning to the continuous form

Hope this makes sense

Answer:MS access open single form filtered by selected record in continuous form

coasterman, welcome to the Forum.
It makes perfect sense.
If you add a Command Button to the Continuous Form and after selecting the mainform select the "Open the Form and find specific data to display". This will give you the code that you need to add to your On Click or On Double Click property or of course leave the button and use that.

2 more replies
Relevance 84.05%

I sent to look at my Sent Items tonight and to my surprise I saw another email apparently sent yesterday that I definitely didn't send.

I was astonished to find this as I have just upgraded to Vista in the last 2 days and have sent minimal emails.

The subject is "Form posted from Microsoft Internet Explorer." & is sent to a Hotmail account. The attachment is a POSTDATA.ATT. When I look at this file in txt format it has info such as one of my email addresses, my website & description - as if I had filled out a web form & pressed Submit.

Now, thinking about it, shouldn't IE let you know that it is about to send data?

One strange thing is that the email is dated yesterday evening in the Sent list, but when I open the email to view it, it will always have the current date & time - seemingly from the Windows clock.

I am thinking that either

1) this is due to a bug in the new IE & yesterday I visited a website which submitted data via email without my knowledge or

2) this email is an old email that I Imported from backed up email (PST format) from a form I ACTUALLY sent that Internet Mail has redated - maybe something went

Sorry for the long post but I'm just wary, hope it makes sense! I was liking Windows Vista so far!

Answer:Sent Items: Form posted from Microsoft Internet Explorer. - I didnt submit any form!

I have moved this to vista forum as I believe it is more likely to be a vista live mail issue

3 more replies
Relevance 84.05%

Hi All,

Noob first-time poster I'm afraid!

I'm new to Access 2007 (but have used 2003 & 2000 reasonably extensively).

I'm building an App and have created all the necessary tables, as well as creating the relationships in the Database Tools area (which I know are correct - I'm a SQL Server DBA in my day job)!

Anyway, it's an almost text book example of an employers and employees database; one employer having many employees (employerID is the foreign key on the employee table).

I have created an employer form (using the wizard) which is fine, but then when I add a button to open the employee form (selecting 'Open the form and find specific records', matching employerID on the Employer table with EmployerID on the Employee table) it doesnt work. Instead, I get a popup box asking me for the EmployerID! Even if I manually enter the correct employerID when the popup box appears it actually displays all records, so I'm sure that the problem is more fundamental (and therefore, probably my fault)!

I'm hoping that I've just overlooked something REALLY stupid, but would apprecaite any suggestions!


Answer:Access 2007 Form Button Wizard - Form does not open with the correct records

I have seen this kind of problem with Access 2007 VBA code which does not work when it dod in 2000-2003.
It can be a Syntax problem which you may be able to get around, if not you can get around the problem bby using a Criteria in the Query that supplies the Employee Form.
Although I would have thought it would be better design wise to have the Employees as a Subform or Tabbed Subform on your Employer Mainform.
I do not have Access 2007, only 2003 so I can't help with the VBA, but you could post the code anyway.

Did you use a Wizard to create the Employee Form, if so check the Record Source SQL it may be preventing your EmployerID from working.

1 more replies
Relevance 84.05%

Hi all. I do have another post going but do not want to cram so many questions in one post. (Hope that this is an acceptable practice )Anyway, my Sony desktop crashed the other day. I had a new Hard Drive installed and recovery disks were used. PC is good to go. Trying to tweek it back to the way I am used to having it.QUESTION:I had a form filler program called ROBOFORM on this PC before it crashed. I had MANY years of passwords and stuff saved there.When I brought this PC to the Geek Squad at Best Buy the other day to see if the PC could be repaired, I was told the hard drive went. They were, however, able to make a disk with my ROBOFORM passwords. I can not get the disc to open the list of passwords. It asks me where I want to open the and give me a list of choices. (Paint, notepad, adobe etc.) None of them will run/open the files so I can see them.This was a program that I paid for. How can I make the disc start to fill my forms again when I am at certain sites? (Gee, hope I am making sense)I just realized I never downloaded the ROBOFORM program onto this pc.  Does that have anything to do with the disc not opening??If I go and download ROBOFORM, how does it know who I am. How will it know about the disc full of passwords? How do they recognize each other?HELP PLEASE..........My Passwords are VERY important to me.Thanks!!

Answer:ROBO FORM / Form Filler - Help Needed Opening/Running a Disc

Yes. I know the website but what do I do? Will they know my info or do I need to pay again. I am lost.(Sorry)Dee

6 more replies
Relevance 83.64%

Does Heart Internet support the uploading / attaching of JPGs in web forms?I have installed their Form-to-Email CGI and now have a fully functioning web form as far as text fields are concerned. The web form is used for reporting software problems.Since most users have a habit of being incredibly vague about their problem in the text box area I would like users to have the option to send me a JPG screenshot with a maximum file size of 100KB within the same form but am not sure what the correct procedure is or if it's possible.If it needs a separate form to do this I could put one on the following page that the user sees.

Answer:Upload / Attach JPG as part of Web Form submission

It's not difficult to upload files, here is a here

6 more replies
Relevance 83.64%

i have tried to echo the form values in head part of same .php file. but when i submitted the form clicking submit button the value of submit button is not getting to head part and it is opening another page.

how to echo the values in head part using php.

Answer:echoing form values in head part using php

Are you using POST form type?

When you reload the form you should just be able to <?=$_POST['inputname']?> in the head of the page - i prefer that method to echoing, as it looks better from a code point of view.

Where in ther header of the page is this going? It should be fine in the correct place - i.e. Title or the Meta Tags...

Hope that helps.

1 more replies
Relevance 83.64%

thanks for taking a look at this thread, any help will be greatly appreciated by a complete Noob.

I've been given a LOT of help by members of this Forum (especially OBP) with a DB I'm making as a first look at any type of IT product, and I'm very grateful, so thank you all.

Recently, I was advised to take a look at the "Tabbed" style of "MainForm" instead of the "Switchboard" style I originally used. I must say, I really like the tabbed style much more than the switchboard but I've hit one hurdle that I can't seem to overcome.

In the Switchboard style, I was able to set a form to load in either DATA ENTRY = YES or DATA ENTRY = NO mode depending on which sub-switchboard the user selected. For example, I had a ENTER NEW sub-switchboard that all forms would open in DATA ENTRY = YES mode & I had another EDIT EXISTING sub-switchboard that all forms would open in DATA ENTRY = NO mode.

However, with the new tabbed style, I cannot set the form load type for separate tabbs, it will only accept the LAST type as the GLOBAL type. Example, on the ENTER NEW tab, I set the form to load as DATA ENTRY = YES & sets the form to open in DATA ENTRY = YES on both tabs, then I go to the EDIT EXISTING tab & set the same form to DATA ENTRY = NO & it sets the form to open in both tabs in DATA ENTRY = NO mode.

So, my question is:
Can I set the same form to load differently on different tabs on the same MainForm?
If so, w... Read more

Answer:Solved: MS Access - Tabbed MainForm - How to make a form open a form in multiple mode

I would just copy the Subform, so you have version 1 for data entry with the Data Entry set to "Yes" and version 2 set to "No".
The only thing you need to do then is to Requery the Editing form each time you make an entry in the data entry form.
Although I prefer to just have an Edit form with a "New Record" button for the data entry.

2 more replies
Relevance 83.64%

My multi item form isn't letting me add new records, only update and delete current ones.

My guess it that this is because the form is based on a multi-table query. That's fine, I can make a new form specifically for adding new records, but I'd like to be able to salvage this form if possible. Is there any way to either force this form to accept new records in the bottom row, or is there any way to get rid of the "add record" bottom row completely so it's not misleading users into thinking they can add records here?

Thanks in advance.

Answer:Solved: Access 2007 - multi item form (continuous form) trouble adding records

16 more replies
Relevance 83.64%

Hi All,

I need some help to figure out how to do a project.
i was given a sample tax form from the government that i have to re-create in electronic format. I have to build the form to match their specifications exactly. I've tried to do it in MS Word 2003 using a table, but the when i try to ensure that the tables cells are the same size as that on the paper - the tables keeps either changing the dimensions of the cell or changing the dimensions of other table cells.

the major thing is to ensure that the form i build matched that paper sample exactly - for example i cannot be off by even a millimetre.

In addition to that, my company has extracted the tax data for its 400-500 employees into an Excel Spreadsheet. I have to use the excel spreadsheet to make the "form" i created fillable.

The previos analyst used ms word 2003 and created the form using the drawing menu and text boxes and then mail merged the info in the excel sheet to the word doc.

can someone suggest an easier to do this? i wold be grateful for any help i can get.


Answer:Create Electronic Form to match sample paper form

Welcome to TSG

If I got your meaning correctly, then yes, ther's an easier way.
I'm almost sure that you can create the form in Excel, though setting the exact sizes and positions could be difficult.
I'm absolutely sure that you can create the form in Powerpoint, and with this latter, setting the exact sizes and positions should be much more simple.
Automatically filling the Powerpoint form is also possible.

If you only need to print out the filled forms, or create PDF-s, this Powerpoint-Excel duo might be good for you.
If you need to do further calculations with the filled forms, then I strongly recommend to stick with Excel.

I'm also curious what others can say.

2 more replies
Relevance 83.64%


I have a subform which on its own - works beautifully but fails under the mainform. I use a main form to select the record that the end user wants to update. Upon update event on main form, the sub form opens, presenting fields for possible updating. The Sub Form also present 2 buttons - Save & Close or Cancel and Close (Undo). When the main form opens, the code set AllowClose as False. When the sub form is opened as a result of the update on the mainform, the issue is the Close command /code gets canceled. (Error 2501). I have tried: 1. setting AllowClose (true and False) on both forms, 2. only the main form and 3. only the subform. None of these 3 configurations resolves the issue. Also, I tried moving the buttons to the mainform instead of the sub form but that failed as well.

The application has a dozen forms and all of them utilize AllowClose functionality so the end user MUST use the buttons on the forms to force background queries (updates, deletes, perform calculations, recalc control totals etc). This is the first time I have tried to use Allow Close on a subform with buttons.

XP and Access 2007


Private AllowClose As Boolean

Private Sub Form_Load()
AllowClose = False
End Sub

Private Sub Form_Unload(Cancel As Integer)
Cancel = Not AllowClose
End Sub

Private Sub SaveChangeandCloseForm_Click()
AllowClose = True

Private Sub CancelAddingNewRecord_Click()
If Me.Dirty Then
End If
If Not Me.NewRecord Then
En... Read more

Answer:Action Canceled - Using AllowClose on Form and Sub Form - Access 2007

Why not just use a listbox to display the records based on the selection on the main form? I don't think you can actually close a sub-form on a main form since it is tied to the main form.

2 more replies
Relevance 83.64%

I have a form Third party Invoice.I need to calculate taxes for GST like as it done for Purchase order,sales order.
so please help me how to calculate taxes for my customized form  ????

More replies
Relevance 83.64%

I have a database which ultimately will have a couple of thousand records. The primary table has 30+ fields. I have lots of queries and connected reports to show various subsets of the data needed from the table. However, there are times when what is needed is all fields for a specific subset. Because the records sought often need to be filtered by several criteria, I've found the "Filter by Form" option to work well. I have a button on the main dashboard marked "Find Record" that automatically opens a search form in the "Filter by Form" mode. This allows me to enter information into as many controls as necessary, and returns exactly the right records after clicking on "Toggle Filters" on the ribbon. The problem is that ultimately I need to make this "Access-free". The goal is to create an application from the database without ribbons. I've created a button to run the filter, and another one to print the results, but when the search form is open in the "Filter by Form" mode, it greys out the buttons. I understand that there is a GotFocus command or something similar. Can anyone help with specifics, both the syntax of the command and where the command needs to be typed? Thanks a bunch...I look forward to your reply.

More replies
Relevance 83.64%

Morning Guys.

I am having a problem with Access 2007. I am not good with code, so would like to resolve this without using code if possible?

I have a form "A" that I have created. I want to be able to select a row on form "A" press a button and it will open a form "B" based on the selected record in form "A".

I have had a look at the button wizard, and it lets you have the option, but when you go through the wizard, it gives you an empty box on the left and a box on the right showing all the fields in the form "A". Nothing to relate to?

Any ideas?


More replies
Relevance 82.82%

Here is what I'm trying to do.

For lists Equipment in drop down box.
Whatever equipment that is select, the equipment type field needs to be updated from a table.

Is there a way to get a value from SQL statement?

SQL = "SELECT [Equipment Type] FROM OrderDetails Where " _
& " Equipment = '" & Me.Equipment & "'"
[Forms]![OrderDetails]![Equipment Type] = SQL

Answer:Help with access form (insert table value into form field)

Mhouser, if you are trying to "display" a value related to the Combo selection you can have thta value as an extra column in the combo and refer to it with simple VBA.
You should not populate a Field's actual value with that from the combo as that is duplication.
Can you tell me which one you are trying to do?

3 more replies
Relevance 82.82%

I am a new user to Access 2010. My operation system is Window 7.
I have created a data base with two tables. The first table contains a list of students and their personal information. The second table contains student subjects and has many subject records with a relationship to the student record. The relationship key is the student id.

I have created a form that populates with the student information and contains a subform that populates with that students subjects. All of this works great for existing students. I can edit the student information and and new subject records.

Now here is my problem. I would like to create a form that preceeds my current form. The user would input a student number and click search button. If that student number exists on the student data base then the form that I created should open populated with the student data and their subjects and allow the user to update it. If the student number does not exist, then I would like that same form (or a form with the same layout) to open and the only data populated is the student number that was input on the search form. The user should be able to input all of the student data and course information and hit a save button that would insert the records into the correct database tables.

I have tried many methods to create the intitial search form that would open the correct version of the student form without any progress. Could someone provide me with the macro that would open that correct form, or set t... Read more

Answer:Access query to open Add form or Edit Form

needaccesshelp, welcome to the Forum.
First a couple of points, you do not need to "save" the record, access does so automatically. Also when creating a New record the subform should be automatically populated with the Student Number, this is controlled by the master child links.

The combo you need is a Find combo which can be created using the combo wizard, that combo can have it's Not In List Property set to yes, which can then be used to trigger adding the student that to the table and then to the form (and combo).

1 more replies
Relevance 82.82%

I have this small database I am converting from A97 toA2010. I created a new A2010 db and pulled over objects I needed. Everything is tested out and working fine.
I also added a drop down box to the main switchboard toselect a "user". Its purposeis so the filter through all the records and pull up only the list of drawing #for that specific drafter.
So I have a table called tblSign_In which has UID autonumber, and the employees name. Thiswill be the user names for the drop down of the Main Switchboard.

I have a table called SHEET LIST that list all the data Ineed to display. This will end upholding tens of thousands of records of information about drawing. I added to this table a field called theLogInID field (UID) to link back to the tblSign_IN, and the correct number andcombination.
I also have a query called qrySHEET LIST which selectsall SHEET TABLE and inner joins to thetblSign_IN to pull the Employee Name linking on a LogInID field.

What I was trying to do is filter SHEET LIST form (my outputform) by the user selected on the MAIN SWITCH form in the drop down box Icalled cboSignInEmployeeName.
For example:
Sheet List (tbl) might contain information like: Sheet# 22a6; description Dryer; buildhours:12; drafter #4.

qrySHEET LIST (also my ouptut data) is pulling all theabove, but replace 4 with actual drafter’s name, John Smith.
To filter, I have two methods:
The query is my record source for my form SHEET LIST, so Iadded

WHERE (((tblSIGN_IN.[Employee Name... Read more

Answer:Filtering a form using selection of a combo box on a another form (user ID)

13 more replies
Relevance 81.18%

I inherited this Excel document and have been asked to modify it so that when a selection is made from a drop down list a Form pops up for them to enter the reason. I put this code into Private Sub Worksheet_Change(ByVal Target As Range)

If Len(Trim(Range("$H$" & Target.Row).Value)) = False Then
Exit Sub
If Len(Trim(Range("$H$" & Target.Row).Value)) <> "" Then
ProcessReasonForm.Show vbModeless
End If
End If

Which worked fine on three machines that I tested it on locally. However in the 2 remote location there it was tested it the Form would pop upwhen ever any changes were made to the spreadsheet. I need the form to only come up when a selection from the dropdown list in column H is made. As no personal data is in it I'll post a copy with this. To view code use "amber". Any ideas would be great as I'm lost as to why it's happening out there but I cant recreate it.


Answer:Solved: Form call is causing the Form to pop up everywhere!

File is attached. Code to unlock code is amber.

2 more replies
Relevance 81.18%

I have my form sending to my e-mail so it prints out my data line by line. Can anyone give me some pointers on how to get this data into a nice form that can easily be read.

E-mail from From Looks like this.

[email protected]

Answer:Form to E-mail back to a Viewable Form

6 more replies
Relevance 81.18%

Ok guys, I can give a really easy example of this problem I'm having right here on the message board. If I place my cursor in between these two words (this) (that) and then click on a smiley, it SHOULD insert the smiley face in between them. I'll do it now.

See how it put it at the very end of the line? When I'm finished typing this whole thing, I'll try to insert a confused smiley here ( ) .

The same happens for ANY auto-insert stuff, whether it be the hyperlink or the quotes button, anything here. Its annoying . Anyone know how to fix this? No matter where my cursor is, it always inserts the auto-text into the end of the post.

Answer:Firefox - Form auto-insert always at the end of form

I imagine it's a quirk of the javascript in VBull. IE has added a lot of nonstandard code that makes editing windows more robust, and I expect that's what VBull is using. If so, there is no workaround.

1 more replies
Relevance 81.18%

Hi all. I have different table for each type of inventory that we have. I would like to design one master form that would ask what type of inventory that the user would like to enter. Depending upon what the user selects, it will change the fields to the categories in the pertaining table. Is this possible?

Answer:using a form field to select display of a form

12 more replies
Relevance 80.77%

I know the Include Field will include part of the text from an Include File if it is in a bookmark. The format is {IncludeText "File Path" Bookmark}. I have 2 files: Source and Target.

Source is a form template. I included a Text Form Field and gave it the bookmark AA. I also included other text in a "normal" bookmark, BB.

In Target I have 2 fields: {IncludeText "C:\\" AA} and {IncludeText "C:\\" BB}. The text from BB shows up, but the one for AA is blank.

If I go into Source and look under Bookmarks, both AA and BB are there.

BTW, I have tried it with the Source form both "Protected" and "Unprotected" and it didn't make any difference.

Any idea why this is happening, and more importantly, any idea on how to make this work? If not, it seems like a real bug in Word 2003 as they are both definitely considered to be bookmarks.

Thank you,


Answer:Word 2003 - Include Text Field - Not Including Bookmark Text if in Form Field

Thread reopened for user to post solution.

3 more replies
Relevance 80.36%

Hello all,

I have been presented with a project that involves Forms that I am not able
to resolve.

Basically I have been asked to create a document template where other team
members can fill out a form that asks a series of questions, then to have
only the completed form results export to a new file.

I am aware that Word can export the form results to a text file, but when I
do this all of the questions that were on the original form are exported to
the new file.

What we are looking to achieve in the end:
If the end user is faced with 20 questions, but only 12 of the questions
pertain to the end users project, only the 12 completed form fields will
export to a new file.

I know that this should be possible with using a macro button to export the data, but that is where I need the help.

I tried searching for this exact situation, but I did not find any matches, hence the new thread.

Thank you in advance,


Answer:Macro help needed to export Word form results to a new file... Word/Excel

11 more replies
Relevance 78.72%

FrontPage 2003 Form How do I get one user input field to = another; such as: email: Confirm email:
Validate function asks for an equal to value; however, I have tried everything to no avail.


More replies
Relevance 78.72%

I create an outlook form with some VBS code in an earlier version of Outlook.
We are using OUtlook 2003, and now the functionality is not longer working. I.E when the user checks the box: For Tracking Use Only. Only the fields in yellow should remain and the rest will be invisible.

I have done some research and I think that my form is what is consider a one-off form.
I would prefer not to publish the form, but distributed via e-mail.

Also, whenever I make the functionality work(I select design this form, and the run this form), I am able to see the functionality, but after I send the form, the person that gets the form, is unable to run the functionality.

I create functionality for the compose and the read.

Any idea how I can make both areas work?


More replies
Relevance 78.72%
Question: Access 2003 Form

I am using Access 2003 and trying to setup a form that automatically fills out the information someone has entered. I already have the database setup with the customer information and transaction information. I want to setup a form where it will pull the information it needs (for example name, ss#, address, etc.) and fills the form I created, so I don't have to manually type everything. Does anyone know how to do this?

Answer:Access 2003 Form

6 more replies
Relevance 78.72%

Is there any way to spell check a text form field in a protected word document? I have a memo form that I have created and users need to be able to run a spell check, but not change the form.


Answer:Need Help with Form in Word

I found this on another forum and is probably what you need.

You're not the first to notice this seemingly missing functionality
when working with form fields. The way to get around this is to use a
macro that includes the additional logic to check all of the fields in
addition to the rest of the document.

There is actually already a great macro available from the Microsoft
MVP group that does exactly what we need. It is available from:

The link above provides a detailed 'how-to', including the VBA code
used within the macro. If you aren't familiar with VBA, even reading
the comments inserted throughout the code will give you a very good
idea of what is happening.

If you don't want to deal with code and just want to confirm that the
feature actually works, you can download a sample template which
contains the macro (make sure you enable macros in Word before using

To try the macro:

1. Open a new document based on the template
2. The document will open with content from the template (including
protected areas and pre-filled fields)
3. Perform a spell check and confirm that the check reveals errors in
all areas of the document

To move the macro into your template:

1. Open your template
2. Go to Tools > Macro > Macros
3. Copy the text of the macro into the template
4. Save the template
5. Each document created b... Read more

1 more replies
Relevance 78.72%
Question: Form in word

Hi, I'm building a form in word and need some of the words to be locked. for example: one field is labeled: AGING: and there is a text form field next to it with data typed in. I want the word "AGING" to not be deleted, moved etc...fixed in position. I've tried everything I know at this point..any help would be appreciated.
Thanks in advance,

Answer:Form in word

Check the "enabled" property of the text field and set it's value to false. It would be helpful to post your sample doc or form if you have additional questions.


3 more replies
Relevance 78.72%
Question: MS Word Form

Hi, I am trying to create an order form in MS word that sales reps can bring up and type an order on. The problem is that when they type on the form, the things that I have on there such as Customer name... all shift over. Is there a way to freeze the things that I already have on the form so that when they type info in, nothing moves???
Thank you

Answer:MS Word Form

Try this, curleylox:

3 more replies
Relevance 78.31%

Hey I am still having trouble taking info from a form to a printable page. Now I want to take the simple add it up form that I have and transfer all the items they add up and the total to a printable page. Are cookies the way to go. Should I set a cookie and retrieve it, and how do I set a cookie to the javascript that calculates my total?

Here is my add up form.<FORM NAME="MyForm">
P>Size<SELECT NAME="size" SIZE="1" ONCHANGE="totalPrice()">
VALUE="2400">4' x 4'</OPTION><OPTION VALUE="3550">4' x 6'/OPTION><OPTION VALUE="4125">4' x 8'</OPTION><OPTION VALUE-"4700">6' x 6'</OPTION>
OPTION VALUE="6300">8' x 8'</OPTION><OPTION VALUE="7900">8' x 12'</OPTION></SELECT>
P>Ceiling Height-(at least 8'?)<SELECT NAME="ceiling" SIZE="1" ONCHANGE="totalPrice()">
P>Door Hinge <SELECT NAME="hinge" SIZE="1" ONCHANGE="totalPrice()">

Answer:Its me again Can you set a cookie to any type of form, ie: add it up form

7 more replies
Relevance 78.31%

This ought to be pretty simple to do. I have a small table that contains contact information for a number of businesses: name, address, etc. I have an “ID” field that is an auto number and is the PK. I have created another table that contains the business name, date of a donation and a memo field to hold the donation info (since it’s stuff instead of money.) In the second table, “ID” field is also an auto number and is PK. I have related the tables with a one to many: theoretically one business with many possible dates/donations which is the basic premise. I created a main form to input the business data and created a sub-form for the donation data based on their respective tables. Each business will be unique but a business may give multiple donations, say one each month or more – whatever.

I can’t get it to work. I’ve got that big, honkin’ Access 2000 Developer’s Handbook but am still getting up to speed using it…. but I’ll keep looking until I hear from someone!


Answer:Access 2000 Form/Sub-form

9 more replies
Relevance 78.31%

I have a 256 meg mp3 player can anyone sudjest a program where i can convert the songs from cds to mp3 form , i foiund some but it can only convert 5 song from each cd. ( IT NEEDS TO BE FREE ) THANKS!!!!!!!

Answer:problem converting cda form to mp3 form

perhaps a trial version like this?

14 more replies
Relevance 78.31%

Hi! I got this problem!

I have 2 forms. A main form and an extended form. I want to pass data from a field in the extended form to main form and save it in the main table. So the field's name in the extended form is: txtBDiluentLot, the name of the main form: BondSparF and the name of the extended form is BondDiluentF. I have written a code:

Private Sub StängKnappen_Click()
If IsNull(txtBDiluentLot) Then
'do nothing
Forms![BondSparF form].Form.[BondDiluentF].Form.txtBDiluentLot = Me.BDiluentID
Forms![BondSparF form].Form.[BondDiluentF].Form.txtBDiluentLot.Me.SetFocus

End If


End Sub

.... But when I run it it says: Run-time error: 2450

Microsoft Access cannot find the referenced form "BondSparF form".

Why I can't run it???

Thanks a lot!

More replies
Relevance 78.31%

Hello all,

I am creating a school database, and I'm having trouble with the register students part.
i have the form for new course, and the form for new student. so how do i create a button on the course form so that when i click add new student, the new student forms pops up and is linked to that course.
thanks again!

More replies
Relevance 78.31%

In access, I have a field that connect to a popup form for selection and after selecting the data required, the data did not print in the field. How can I have the data in the popup form to be printed in the field.

Answer:Transfer data from a form to another form

aattas, welcome to the Forum.
Can you explain a bit more about what you are trying to do and why you are using a pop up form?

3 more replies
Relevance 78.31%

I am new to Outlook forms so my apologies in advance for the silly question. I bought a book to support me with my outlook 2007 and found that you can do forms. I have created a form and saved this in my personal folder. when I send this it looks ok, when this is received all the form content has gone and a normal email shows up at the receiver's end. I cannot find anywhere why this does not work. I delete the cache file but that did not work. Any help really appreciates, Kind regards, JBS

Answer:Not form content when form is received

If its a HTML form and you're settings are set to send Text only then that is why.
You need to be sending HTML formatted email which might I add is frowned upon by many email providers.
Plenty big businesses won't accept HTML email for security reasons. text only.

3 more replies
Relevance 77.9%

Hi there,

I am trying to learn how to use the "form control" function on Publisher 2003.. for the life of me, I cannot find how to locate it to use it. I used the help function and I can "add or remove" or it shows about 20 icons but not the one I need. Under customize there is no checkbox for Form Control either.

I am using Windows XP.

Help please!!!

Answer:Form Control Publisher 2003

You should post this in the Business Applications forum for more prompt response.

3 more replies
Relevance 77.9%

I am using Access 2003. I have a form, 'Protocollo', with a subform 'sfrm Prot' that is linked to the form on the field IDProt. The record source for the subform is a subset of the table [Prot_detail], and it contains only two records. The first record is displayed when btnIn on the subform is pushed and the second is displayed when btnOut is pushed. I want to change the font on the buttons to bold if the underlying record has any text in the 'Oggetto' field. I wrote a routine that is attached to the Current event of the subform, but it is not working. Here's what I wrote:

Dim rst As Recordset

set rst = Me.Recordsetclone

Me.btnIn.FontBold = IsNull(Me.Oggetto)
Me.btnOut.FontBold = IsNull(Me.Oggetto)


Any ideas why this doesn't work? Can someone suggest something that would work, hopefully without using DLookup?

Answer:Solved: Access 2003 form help

9 more replies
Relevance 77.9%

I want to create a form and populate some information from an existing spreadsheet (using mail merge) with the end result being people can fill in missing information and it be straigtforward to insert missing data into spreadsheet using the export function.Can anybody let me know if this can be done?Thanks

Answer:Help with creating a form in MS Outlook 2003


6 more replies
Relevance 77.9%

I have a form in an access database. This form tells us when our employees have taken their year tests and when the next one is due. This testing is yearly. I have a form that will show:
1) the name of the employee
2) when the test was last taken
3) when the next test should be taken
4) if their testing status is "expired" due to missing a test date

the problem is that 4th colum is not caculating exipired correctly. We have employees that have taken their test this year and colum 3 does state the correct next test for next year yet, they are showing as "expired" as if they had missed this years test. Here is the formula for the "status" colum:

=IIf([next test]<Now(),"EXPIRED!",Null)
Any advice or help would be appriciated....

Answer:form formula in Access 2003

12 more replies
Relevance 77.9%

Hi, I have created a database to track vehicle repairs. On my customer form there is a button which open the vehicle details form.

The code is:

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "CustomersVehicles"

stLinkCriteria = "[CustomerID]=" & Me![CustomerID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

The problem with this is the form opens, but the CustomerID (Foreign Key) is set to "0"

Is there a way of passing the ID the the opening form?

Thanks in advance.

Answer:Access 2003 form problem

12 more replies
Relevance 77.9%

I'm new to this forum, I have some formal education with access but i do not use it a great deal. I have built a database that keeps records of work done on a particular street. Each street can have many records with types of work, exact locations and dates. I want to query for all work done on a particular street. My criteria cell on the query was filled using the expression builder, [Forms]![Flushing Records]![Streetname]. I run the query from a macros button. When I run the query I get my expression coming up as the parameter instead of the form i want to use to select the street. From what I have read on the forum so far is that the form has to be opened first. Is that correct? It seems backwards. If this is true then the same macro button that opens the query can also open the form?

thanks in advance

Answer:access 2003 query by form

Northernont, welcome to the Forum.
You are corrrect, the form should be open with a "street" selected, then the query (or form/Report based on the query) opened.
If you use a Main Menu or switchboard to open your form you can add a Command button to the Form to open the query.
Or as you say you can open the form with the Macro, I do not normally use Macros other than an Autoexec macro to open the very first Form in the database.

2 more replies
Relevance 77.9%

On the form frmNz2 of my database, how can I make the Back button cancel any changes made to the information in the Search Results table after it has been editted? When I edit the information in the table and then press back, when the form is re-entered the changes stay. I would like these changes to be cancelled when pressing the Back button so that when the form is re-entered the table is the same as before changes were made. I have attached the database and would be grateful for any help. Thank you.

More replies
Relevance 77.9%

I would like to produce a report - or something similar- from a form where I enter dates into a text box. I would like to search by certain perameters- IE a month, - say 12/1/2008 to 1/1/2009 and find all of the BLANK entries- entries not filled in- is this possible, and if it is - how do you do it?

Thank you-

Answer:Solved: Access 2003 Form ?

Assuming that you have a form with 2 Unbound Date Fields on it, say Start and Finish.
In the Query's Date Field Column's Criteria Row enter
Between Forms![Formname]![Start] AND Forms![Formname]![Finish]

Where Formname is the actual name of your form.

In the Field(s) that you are looking for that are Blank enter
Is Null
in their Criteria Row.

3 more replies
Relevance 77.9%

I want to modify the standard TASKS form in Outlook 2003 (add an 'Action' field). Following procedures recommended in virtually all Outlook 'how-to' books, I first opened a new Tasks form and then clicked on the Tools/Forms/Design This Form menu command. However, when I did this, I noticed that the two visible pages ("Tasks" and "Details") appeared to be unmodifiable. The editing commands are all grayed out on these two pages, and the standard grid-style form editor is not displayed. It's possible to modify the non-visible pages for the Task form, but not the two pages that I wish to work on.

Are these pages (Tasks and Details) somehow locked? Is there any way to allow editing of these pages? I noticed that this behavior affects some of the other Outlook forms (e.g. Appointments), but not all (e.g. Messages can be modified).

Any help would be appreciated. I have never attempted to design or modify forms in Outlook (or any Office product for that matter) before.

Sam Morten

Answer:Can't Modify a Form in Outlook 2003

Right in the Help file, under the Table of Contents/Outlook Forms, it says:

Overview of Task Forms

The default pages of a task form are not customizable. However, you can hide these pages and create new pages on the form if you choose.Click to expand...

But, believe me. It took me 10 minutes to find it and I like to think I'm good at it.

2 more replies
Relevance 77.9%

Quick Summary of the Problem

Hi Everyone,

I've been tearing my hair out tonight. I'm new to Access and have been reading books for 2 days solid.

I have created a simple database but have run into a problem.

I have 2 combo boxes at the top of my form for the user to select 2 fields. From these 2 fields I need Access to calculate "SelectionA" minus "SelectionB" to give me a new hidden value that I can use "HiddenNumber3".

I can get this to work in queries without a problem, but how do I get this to work in a form?
A bit more indepth info for those who are interested.
My Access application is to allow a user to select what hair-colour they currently have and then a new colour from a list of hair colour names. The results tell the user what product to put on their hair, mixed with which peroxide and for how long in order to acheive the result.
It all begins with the difference between the 2 shades. In my table of natural hair colours I have provided a field that gives each shade of natural hair colour a number.
I have done the same with the artificial hair colour table.
Via a query I can calculate the difference between the 2 shades fields without a problem. In the form, I am stuck. Not only am I stuck, but I don't know how to store the result to be used throughout the rest of the calculations.

Another thing that I cannot seem to work out in Access is how to make everything happen on one form. Currently I have 6 queries in plac... Read more

Answer:Access 2003: Doing a calculation within a form

9 more replies
Relevance 77.9%

In Excel 2003, on the same worksheet, I have three tables. I have created a Data Form for the first table. When I go to the first column heading and press Data/Form the maintenance form for Tabke 1 displays and works properly.Can I set up Data Forms for the other two tables on the same worksheet using the same method I used for the first table? Where are the Data Forms stored?Stephen [email protected] by moderator: plain text email address altered

Answer:excel 2003 more than one data form on the sam

You should never post your email address in plain text in a public forum.It's not that we really care if you end up getting a ton of spam, it's just that we don't want to be known as a site where email addresses can be harvested.Once you let the bad guys hang around, you open yourself up to all sorts of security issues.DerbyDad03Office Forum Moderator Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 77.9%


i want to create a search form for my database. i have a table of jobs. What i want to do is search for a job that will give me a list of jobs when i find the right job double click the job and that will open an invoice form with the job details filled in.

The problem i have is i cannot write VBA or queries so finding it really hard i have tried the last few days with no success.

Any help will be appreciated.

Answer:Access 2003 search form

What criteria will you want to use when searching for a job?

Access's built-in command button wizard will write all the code for you to open the jon form from the search form.

Boyd Trimmell aka Hi Tech Coach ( free Access stuff)
Microsoft Access MVP 2010
Business Process Management - Accounting/CRM Software Developer
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11

1 more replies
Relevance 77.9%

Hi - I have created an outlook template/form for about 300 users and saved it is as
"Outlook Message Format" & also tried saving as an "Outlook Template". I have tried running this template on a few pcs with the exact same Outlook version and settings, but the template opens up blank - All that is visible is the To and Subject fields. The template does open correctly on a few pcs.

Any idea what could cause the template/form to open up blank?

More replies
Relevance 77.9%

Hi just wondering if anyone could help recover my invoice data system from an error:
The form name 'frm_main_menu' is misspelled or refers to a form that doesn't exist.
If the invalid form name is in a macro, an Action Failed dialog box will display the macro name and macro arguments after you click OK. Open the macro window, and enter the correct form name.

I don't really understand this, if anyone could help please ?

More replies
Relevance 77.9%

I have a database which will be used to track all training taken by a company's employees. The database has 5 tables - Employees, Accounts (like locations), Course Names, Course Dates, and Schedule. I am having some issues and hope I can get some help. FYI - I have tried to look for other posts related to my issues, but couldn't find them. If anyone has those links, I will be glad to look at them.

1. I have a form with two combo boxes, one list box and 3 checkboxes. This form is being used to update employee records. One of the combo boxes is used to determine the values in the other fields. I have been able to get the first combo box to default to blank, but the pother fields on the form default to the information from the first record. How can I get all of the fields to start with a blank?

2. One of my tables has a numeric field as the primary key. The field is not set as Autonumber. Because this table is already linked to other tables and there is data, I can't just change it to autonumber. Is there a way to use the existing key field, and have it auto update the entry into that field? If so, how do I do it? If not, what would you suggest for a solution?

3. I have a form that will be used for registrations for classes. This table stores the unique schedule ID for the class, and the unique employee id. I will obtain my data from other tables. How do I get the data I need and save it to another table?

I really appreciate any help I can get.

Answer:Access 2003 Form Questions

16 more replies
Relevance 77.9%

I'll start general and if it looks like I can get my question answered I will elaborate.

I'm wondering if I can get a single form to display specific records from multiple tables without using a subform.

I'll elaborate on what I'm doing if this can even be done.


Answer:Access 2003 Form question

16 more replies
Relevance 77.9%

I have an Access database that opens forms on top of forms. I would like to set the forms up so that the form on top must be closed before the forms in the background can be used.

How would this be done?

Answer:Solved: Access 2003 Form

16 more replies
Relevance 77.9%

Before I pull my hair out looking for the answer, I'll put what it surely a simple question to you guys.

Can a form reference fields in more than one table without using a subform? If so, I simply cannot find out how to do it.

Using the wizard results in forms where I can fill in the fields from one table and not the other or just a slew of errors msgs. Making the form by hand results in "control source" errors and seems to want me to choose only fields from the same table.

I have made the appropriate (I think) relationships, I don't have referential integrity selected, and, and the related fields are of the same data type, so I'm stumped.

Thanks in advance for any help.

Answer:Access 2003 form question

16 more replies
Relevance 77.9%


Really new at this VBA stuff. Having a heck of a time transferring custom field data to a Word Template. I have a custom form based on the Contacts form. The first tab is called "Build Sheet" and it has a text box on it called "usrName"

Sub cmdPrint_Click()
Set oWordApp = CreateObject("Word.Application")
If oWordApp Is Nothing Then
MsgBox "Couldn't start Word."
Dim oWordApp
Dim oWordDoc
Dim bolPrintBackground

msgbox "Open Doc"
Set oDoc = oWordApp.Documents.Add("c:\Templates\")

msgbox "Field 1: Find"
strusrName = Item.UserProperties.Find(usrName)

msgbox "Field 1: Result"
oDoc.FormFields("dName").Result = strusrName

msgbox "Field 2"
strusrCWID = Item.UserProperties.Find(usrCWID)
oDoc.FormFields("dCWID").Result = strusrCWID

msgbox "Begin Print"
bolPrintBackground = oWordApp.Options.PrintBackground
oWordApp.Options.PrintBackground = False
oWordApp.Options.PrintBackground = bolPrintBackground
Const wdDoNotSaveChanges = 0
Set oDoc = Nothing
Set oWordApp = Nothing
End If
End Sub

So I got this code from a website and I've been trying different things to get the data moved over to the word template. I added the msgbox as a sort of debug thing. The script runs until the bolded part.then stops. If I replace Item.UserProperties.... Read more

Answer:VBA Outlook 2003 SP3 Custom Form


Here is syntax that will take a custom field from outlook and put the data in a Word document.

You will need to define the bookmark in Word with the matching name.

Are you limited to Word? Excel is a lot easier to dump data from Outlook fields. Word requires everywhere data is inserted has a defined bookmark.

I assume you will have to customize this code. The syntax works on dozens of custom forms I have.

strDetail 1 is the variable to hold the string
UserProperties ("Tile1") indicates the field name in Outlook is Tile1
objDoc1.Bookmarks("Tile1") is the name of the Word bookmark.

strDetail1 = Item.UserProperties("Tile1")
objDoc1.Bookmarks("Tile1").Range.InsertAfter strDetail1

I have quite a bit of code for integrating Outlook with MS applications.

For the benefit of regular users of the forum can you please post back what works for you?


8 more replies
Relevance 77.9%

How do you stop word wrap in a Word form text field?
Even if you limit the number of characters, pressing Enter causes a new line and alters the form layout. Any ideas.

Answer:Stop word wrap in Word Form

Yep. I wrote a dissertation once...okay, not a dissertation, but worthy of a look-see:

Scroll down a bit to see the part about creating forms in tables. What I did not say (and should have) is that, while you cannot stop someone from typing, you can set the row height of a table to EXACTLY, and no matter what they type, it'll just disappear below the cell.....

1 more replies
Relevance 77.9%

Hello. I am trying to create a form in MS Word. It will have a series of questions. It seems like you can not prevent your entries from moving For example, if I type Name: at the top left and then across it, I type date which would be all on the same line. So when I start to type a name, the date entry starts to shift to the right even though I have locked it. It doesn't seem you can make it stop from shifting to the right. I know you can restrict the amount of letters but I would like to see everything really locked in place. But that doesn't seem to be the case. Sentences also will shft downwards as I type. Unless, I'm missing something, I do not see how you can use it as a questioneer when entries move. Hopefully, I am explaing this correct. Thank you

Answer:Creating a form in Word

16 more replies
Relevance 77.9%
Question: User Form in Word

Hello, I was trying to create a drop down list but realized that 2003 WORD can on only 25 items for drop down. I found the VB code to create the user form but what I cant figure out is how do I add my list. Can anyone help me?

But first let me explain, I was trying to do a combo box in Word 2007 which works great coz theres no limits but when I wanted to " Copy and Paste Special (as an icon)" this document to another document in word 2007, it only allows me to paste it as 97-03 word which I did but I soon learned that this combo box does not in since it was done in 07. That is why I am tryomg to just create an 03 document but I could not get the list to work. Does anyone have any options for me?

More replies
Relevance 77.9%

I wanted to create forms that users complete in Word and save and email the filled form.

I was wandering if I make this form .doc file and put it online, does people need to have specific version of Word to use it?what are the limitations if I put this form online?

Answer:making form with Word(.doc)


I don't know if this will help but you may want to check here:

1 more replies
Relevance 77.9%

I am new here and am looking for some help.  I have a word document, which contains links to other portions of the document in the table of content, forms, and drop-downs.  I would like to protect the forms on the document.  However, whenever I select "protect...forms", the links in the table of content are deactiviated and become useless.  Is there any way for me to have both items working in the same document?  Any help would be greatly appreciated.Thanks!

Answer:Word form protection

Would you like to just password protect the whole document itself you that you cannot open or modify the document without the password?Flame

5 more replies
Relevance 77.9%

I'm creating an MS Word template with several fields. This form will be used by field technicians to record maintenance activity performed on devices located at the businesses of many different customers. An Excel spreadsheet exists which lists various information (Device No, Customer address, City/State, Phone number, etc.) about every device in our system.

What I would like to do is autopopulate several fields of this template once the field technicians type in the Device Number.

For example, if a technician performs a maintenance procedure, it would be great if the technician could open up the template, type in Device Number 123456, then upon completion of this field, the other fields with the customer address, city/state, phone number, etc. would populate automatically by reading the data from the Excel spreadsheet.

I'm guessing this can be done with a macro of some type, but I'm not sure how to proceed. Any suggestions?


Answer:Autopopulate MS Word form

Why aren't you just using Excel for this form then?
Then, you can use simple VLOOKUP, no code...

You can make forms in Excel just as beautiful as in Word.
Let me know if you've run into issues that makes you believe that you can't.

3 more replies
Relevance 77.9%
Question: Form input to Word

This is probably Data Entry 101 but I need an answer so I can stop handwriting inputs provided at my volunteer work office.

How do I input a form to Word which I can then "fill out" for submission?

Answer:Form input to Word

What is the form in now? Do you only have a hard copy or is it in an electronic format?

3 more replies
Relevance 77.9%

I made a form in WORD having NAME, ADDRESS, PHONE etc to collect information from someone through e-mail because I don't have own website.

What I want is - The data coming through FILLED FORM should store at any formate (WORD,EXL etc)
Suppose received three filled forms, data should store as below

Name address phone
Mc Levi 378 Port blayer 99999999
St Johni GS-3 white house 99999999
St Johni GS-3 white house 99999999

I humble request to all of you that either please solve my problem in my way or anybody have other way so I will very honour them also

More replies