Tech Problem Aggregator

Help : Questions about creating forms in MS Words 2003

Q: Help : Questions about creating forms in MS Words 2003

hi guys :

got coupld of questions regarding form creation in MS words 03.

1. i need to add a "check box" to each selection in my forms

western food []
japanese food []
chinese food []
korean food []
vegetableian []

how can i limit the user to only make a single selection only ?

2. one of field in my forms is a date field and i would like to see a small calendar to pop-up when the user click on that field ? (the effect will be similar to outlook calendar one. when user click the start date, a small calendar will pop-up)

many thanks

A: Help : Questions about creating forms in MS Words 2003


1) You can use the OnClick event of those checkboxes, so that when a user clicks a checkbox, a macro clears the other checkboxes. But this is needlessly complicated. Use optionbuttons instead. Use frames to create optionbutton groups

2) Use the Enter or DuobleClick event of the textbox to show the calendar popup. I'm not sure about the actual object or ActiveX control to use...
See the attached document for examples and code.

1 more replies
Answer Match 105.84%

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 71.82%

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 62.16%

I am trying to create a form for work that I can use on my tablet computer. It should be very simple, but I am having MAJOR problems! The form needs to be composed of check boxes, a place to write notes (that can be copied to word), and a way for the client to sign their signiture on it.

I have tied different form software, but cannot seem to get a decent looking form or place for signitures. When I do a google search, I get hundreds of ideas, but the non-computer geek in me looks in amazement

This is a simple 1 to 2 page form. Does anyone have any suggestions on software, or a walk through guide on how to create the form. Currently, the form is a Word document (not form), and I use open office as a WP.

Please help!!!

A:Creating Forms Help

The answer to your question(s) really depends on what Software your Tablet Computer can handle.
If it could handle Access for instance then you could create a very nice form and store the results in a database for analysis.
If it can handle Word, which I assume it can, then the Form can be created in Word.
Have you looked at the Word Help for "Create a Form", it has a step by step guide.
If it can handle Excel a form can be created for you by someone on here, but it is more difficult.

1 more replies
Answer Match 62.16%

We currently use a program called FormDocs, for creating/Filling in forms on our network. These can be printed off, emailed etc. We have found out that this will no longer be compatible with newer versions of Windows. Something to do with being 16bit or 32bit, or something. Anyway our IT department say it won't work. They suggested InfoPath, which is part of Office, but it just doesn't do what FormDocs does. Can anyone recommend any software that will be compatible with new versions of Windows.

A:Creating Forms

6 more replies
Answer Match 61.32%

Does anyone know how to create forms in Outlook 2007? I used them in my previous job but I haven't had the chance to create one.

More replies
Answer Match 61.32%

right when creating forms say yu've already created a table called "contact" and in the contact table thr is a field called "contact ID"(this is the primary key) . right creating forms yu can either do autoform or from design view

remeber tht i has set this to autonumber on the table so how do i link it to the from instead of using form wizard how do you do this manually using control source and all the code
how would yu do this?(the bit below)

say i've now created on a blank design view form a text box called "contact ID" how do you link them with together so tht when yu enter something in this text box it goes into the contact id on the table????

how do i get the text box tht i made on the from to link up with the field on in my table so tht autonumber will apear on the form

A:creating forms in access

6 more replies
Answer Match 60.48%

Hi all
I have created a custom form in Outlook for collecting requests for service. I used a message template and have inserted Option Buttons and Combo boxes to make it easier to use. I have created a short cut to the form on the Outlook toolbar and it works well.
I have been asked if I can make it smarter in that depending on which option button is selected, the form gets routed to different recipients. I am fairly confident this is possible but I have been unable to find out how to do it.
Also, I want a field to populate dependent on a selection from a Combo box, how do i go about this.
Any help will be appreciated

More replies
Answer Match 60.48%

any one know how to change the colour of the tabs i dont =know how to do it in office 2003 i could in 2002 how odd.

yu know when when yu creating forms you can create like the tab look with sll the diffferent tabs at the top how do you chnage the colour???????

when yu click on the form the "fill" icon is blocked out (the can of paint icon)

any one know how to do it

More replies
Answer Match 60.06%

Is there any way that a person can create a custom form in Outlook and have that same form sent through email?
I have been trying to find information on this topic for several weeks and the only thing I could come up with was a XPrint utility.

If anyone really knows Outlook extensively, I would appreciate any step-by-step tutorial!!!!

Thank you!

A:Help with Outlook 2002 creating custom forms!

1 more replies
Answer Match 60.06%

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 60.06%


I would like to get help in creating a form wherebt I am able to key in several names for the same course details. I would like to make my form more efficient by reducing the need to key in repetative data/inputs.

The only data that changes are the names of the employee.

Hope you can advice. Thank you in advance.

A:Access 2007 _ Creating Multiple Forms

Welcome to the Forum, I am not sure what your requirements are going to be, what is the Structure of Tables?

1 more replies
Answer Match 59.22%

I am trying to find a way to create a form to keep track of some data, where I can open it up in a HTML or on its own without having Access open all the time. Can anyone assist me with this?

A:Microsoft Access: Creating Forms in a embedded HTML

Although I have not tried using Access in this way I do have a suggestion. There is a book called "Access 2010 the missing manual". I use Access for my job and almost everything I know I learned from this book. Also another resource is this is a forum website much like Bleeping computer that focuses on Access and can help you on high level Access use like you are looking for.  

1 more replies
Answer Match 58.8%

Good morning!

Here are my computer specifications:
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: AMD Athlon(tm) II X2 250 Processor, x86 Family 16 Model 6 Stepping 2
Processor Count: 2
RAM: 3327 Mb
Graphics Card: NVIDIA GeForce 6150SE nForce 430, 512 Mb
Hard Drives: C: Total - 472278 MB, Free - 447618 MB; D: Total - 4649 MB, Free - 421 MB;
Motherboard: PEGATRON CORPORATION, 2A99h, 6.01, X312345678
Antivirus: eTrust ITM, Updated: Yes, On-Demand Scanner: Enabled

Here are my questions:
1) I am trying to set up an Access database that takes information from 3 tables (Customer Info, Ad Data, Issue Dates) and makes one form with all information included.
(I have a "Complete" table with the Customer Info, Ad Data, and Issue dates all included that works well with the form. The problem with this is that this will easily become a huge, unmanageable database.)
2) I want to be able to update the form (which also updates the tables) as well as being able to pull up past records. (I don't want to use a subform, because the Ad Data are all calculated fields.)
3) I also want to be able to group each ad by issue date.
4) The Customer Info table should be the master table. When I try to run a query using Customer Info, Ad Data, and Issue Dates as a record source, I get a blank query (not populated with data).
5) I am not able to create relationships between the Customer Info, Ad Data, and Issue Date tables for the query. (I want to have a ... Read more

A:Creating Access database with multiple tables for query, forms

sorry, forgot to add I'm working in Access 2003

3 more replies
Answer Match 58.8%

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 57.96%

A few people have tried helping me with this and maybe I am just missing something .......

I have a report that prints out our orders by date. I did a query so that I can enter the date range I want. How when I click on the report do I get the box to come up that asks for the date range without having to go in and change the query every time?


A:Reports & Forms Questions

Have you hard-coded the date range in the Query, and do you have to re-enter it as a hard-code to change it?

Because if you input the "Criteria" as follows:
>=[Enter mm/dd/yyyy of date to be GREATER than or EQUAL to]

then both the Query and the Report that runs from it should prompt you for the new date each time?

Now I don't think all of that in the braces "[ ]" will fit, it has a limit, and you'll want to indicate the correct date format for your records.

Otherwise, you'll need to add a command button to your report, or change the source, so that it will prompt you for the correct date you need.

Tell me more about the set up; I'm not the best at Reports, but I'll try and help if I can.


1 more replies
Answer Match 57.12%

Heya,I hope I found the right place to post a question about creating a macro in Word. What I want to know, is whether it is possible to create a macro which will delete all the characters between two specific words. In short: I figured out how to find the words in the file by recording my actions when I used "ctrl+f". However, when I tried to record me deleting the characters inbetween, it turns out that I have to know how many characters there are to do that. In other words, the macro uses "Count". But I just want it to delete everything inbetween, no matter how many characters. In long:I’d like to list my bookmarks from firefox in a word (2003) document. The steps I’ve taken so far:1) I saved all my bookmarks as a HTML-document2) I opened the HTML-document and viewed the source code, which I copied and pasted in a word documentThis gives me a long list with bookmarks like this:<DT><A HREF=" ADD_DATE="133475149" LAST_MODIFIED="133471649" ICON_URI="" ICON="data:image/png;base64,iVBORw0KGgoAAAAAAAQCAYAAAAf8/9hAAABYklEQVQ4jcXTzUoCURjG8XdTnnN0Zs7Yh4JIVyAEXUm0DVp0AW26gILAFiWJFJrYwo9FErQxAoMsjJxoNhUDQbgecSPjJgYGnhaVTCO1aOMLv9Xz375EE797It7RwzUjKkxDF64RDeMvHT38/NnyMhERtXWevtPD+I+2ztPUksK80QX8bmMSdq2Ch6UUgptfSwqTmlL0r3QBv+uFOFzXxftggKf1NQT3b00p+tTQuHchBX5IxuE4DhzHwXA4xFupiMt4FMGuoXGPz2P9Ho9vBznxzspQHWNI+g0MY9utztitlrILKbGurrGQVWVeVWNw6+SmINlWbAsC2f... Read more

More replies
Answer Match 56.7%


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

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

Under Inspector, the fields are InspectedID, Name.

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

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

Under Operator, the fields are OperatorID, Name, Organisation

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

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

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

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

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

16 more replies
Answer Match 56.7%

I want to input a data ex) apple=2, banana=3and when I type2 apple + 3 banana I want13.but I have a lot of them so simpler ways the better orzthank you and sorry

More replies
Answer Match 56.7%

I need to write as much as can on a A4 page, so I have to write on the border spaces to that are usually open spaces. I changed indentation values for left and right border, but how do I change those settings for upper and lower side of the paper?

A:ms words 2003 indentation

7 more replies
Answer Match 56.28%

I am VERY new to Access 2003, and have spent $$$ on various books. I wanted to memic the Employees Form in Northwind database espically how to display pictures on the form. I copied the Employee's table and form to my new database. I also copied all of the code that went alone with the form and table. All seem to work fine until I selected a Jpeg from my folder. When I attempt to open the Jpeg, I get the following error, "Run-time Error: '2135' This property is Read only and can't be set, MS Visual Basic." It works inside of the Northwind database, but not in my database and I have no idea why it will not work. I have enclosed a copy of the VB Code and highlited where the errror is happening. I hope that someone with a lot more smarts than me can point me in the right direction.


Option Compare Database
Option Explicit
Dim path As String

Private Sub AddPicture_Click()
' Use the Office File Open dialog to get a file name to use
' as an employee picture.
End Sub

Private Sub Form_RecordExit(Cancel As Integer)
' Hide the errormsg label to reduce flashing when navigating
' between records.
errormsg.Visible = False
End Sub

Private Sub RemovePicture_Click()
' Clear the file name for the employee record and display the
' errormsg label.
Me![ImagePath] = ""
errormsg.Visible = True
End Sub

Private Sub Form_AfterUpdate()
' Requery the ReportsTo combo box after a rec... Read more

A:Access 2003 Forms

16 more replies
Answer Match 56.28%

I have created a custom form for telephone messages in OUtlook 2003 and it contains user defined fields such as "Caller Name", "Company" etc.

The form works great... the only thing is that when the recipient receives the email message, they only see all of the details if they open the message.

Most of my colleagues use the reading pane to review messages and these fields do not display in the reading pane.

My question is.... is there any way I can make my form fields to display in the Reading Pane so the message does not actually have to be opened.

Any help will be much appreciated.

Thank You!

A:Outlook 2003 forms

The problem is that the form is probably being held locally on your PC. If it is loaded onto the server then it should work perfectly fine. I have seen this before when I tried to setup a phone message form for former users of Lotus Notes and Groupwise.

1 more replies
Answer Match 56.28%


I'm a major beginner trying to create an access database for client management/data reporting.

I have 6 tables and all the underlying relationships set up how I think they should go.

Here's my current hang-up (and there have been/will be many!!):

I'm trying to create an main "Intake" form that is linked to 3 tables; tblclient, tblintake, tblecase. (client has a 1-M relationship with intake, intake 1-M with case).

On the form that I created, case is a subform, while intake is integrated into the main form. The issue is a staff member will have to either fill in (or tab through) every single entry that's linked to tblclient, before they can start entering data that's linked to tblintake, and the same thing for tblcase. It seems so simple, but I can't figure it out! Is there a way around this?

A:Access 2003 Forms

co11co11, welcome to the Forum and the wonderful world of Access.
I am not sure why you have the intake integrated into the main form, I would have thought that the logical form design would be a Client mainform with an Intake Sunform which has it's own Case subform.

As to your question "a staff member will have to either fill in (or tab through) every single entry that's linked to tblclient, before they can start entering data that's linked to tblintake, and the same thing for tblcase", isn't that what you want them to do. ie fill in all the data?
If you just want partial filling in of data the user can use the mouse to move to the other Forms to enter data in to them.
However something needs to be in the mainform to set up the correct link to the subform(s)

2 more replies
Answer Match 56.28%

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 56.28%

Hey guys! Really could use your help on this one. Okay I have a program that reads emails for a Support box and creates Work Orders based on the Sender, Subject of the email, and the message itself. Well I wanted to create a form in Outlook 2003 that basically limited what they can send to this mailbox, which would be tremendous in getting all necessary information from them as well as make it easier for this program to understand what the user is trying to say. Here in lies the problem. If I make a drop down with a value of "DEPT" then the reader form also needs to show the "DEPT" box, which works for Outlook, but never is ready by my email monitoring Program. Is there a way that I can say for the user to fill out:
Dept: [this is the department
Type: [This is the problem type]
Subtype: [This is they problem subtype]
Category: [This is the problem category]

And take all that info and put it into a message box so that this email monitoring program understands what I'm trying to say? I'm really going to need your minds on this one. Anyone have any ideas?!?!

Thanks in advance all!


A:Outlook 2003 Forms HELP!

No one has any idea? I still am not sure if this is even possible!! I need your minds here!



2 more replies
Answer Match 56.28%

I am making a form in outlook 2003 and what I am trying to do is when you check the check box to enable the text box but i haven't found the way to do this. And it looks like the little I know of Visual basic won't work with outlook.

Also is there a way to grab the computer name and place it in a text box?

I am placing the code in the Script Editor.


More replies
Answer Match 56.28%

Does anyone know how to edit the appointment form in office 2003?

Basically, im trying to change the description box into a series of titled fields rather than just a big white box.

When I go into form design mode, none of the boxes can be clicked on or edited at all, unlike the contacts form in design view. The only change in design view appears to be some new tabs at the top P.2 - P.6 and some properties.

Is there any way I can edit it and make it the default form when I click "new appointment" from the calendar?


More replies
Answer Match 56.28%

I have a form bound to one query. The form is distinct on name. There are several records for each person. When I update the form it's only updating the first record for that person. My fields are... name, ssn, dob, ph id and cost. The first 3 fields are the same for that specific person and the ph id is getting updated in the form. Cost is the only field that's different which creates many records for one person. I need the form to update all records when I enter the ph id. I've tried everything except VB coding. I think I may need to code a work around but don't know VB.


A:Please Help... Access 2003 forms

Try going to the Microsoft Office section of TSF, they might be more helpful.

Edit: I see you've posted this in the Office forum already. I realize you have a problem, but please keep the post in the appropriate section and be patient, it usually takes some time for someone to post a solution.

1 more replies
Answer Match 55.44%

I've designed a new form in Outlook and added an ActiveX control (Date Time Picker from CCRP
to a contact page. Everything works fine except the date is not retained when I save and exit the contact. It keeps defaulting back to the current date next time I access it.

Am I missing something?

Any advice is appreciated.


More replies
Answer Match 55.44%

I have designed outlook form i.e. post using Standard forms library. In this form updated few user defined items. Then publish this form in personal Forms library. When I sent this form to my outlook id then I can't see user defined items selected in form. I dont have permission to publish form in Organizational forms library as well I dont have permission to create folder in public. How is it possible to see the items in forms to me as well other recepient.?

More replies
Answer Match 55.44%

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 55.44%

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 55.02%

Hi guys,

Where i work, we use a lot of the custom Outlook 2003 forms and they generally run pretty well.

Lately when i try to send one (that has been filled out) to a coworker, the form will turn up blank for whoever i send it to. It seems to be not saving and sending? When the recipient opens the form, all the questions will be there but none of the boxes are selected.

I have spoken to 2 different IT guys and neither of them have any idea how to fix this. If anyone has some suggestions, let me know as we are pretty desperate to sort this!

A:An Outlook 2003 question... (specifically Forms)


1 more replies
Answer Match 55.02%

I am trying to make a database I have built available for people in my office. They will be adding data to it with the forms I have created, but I have been having a hard time finding how to set up what I have on a network so that it can be accessed by many clients.

I would really appreciate any tips as to where I can find this information. Thanks in advance!


A:Access 2003: Making forms available for clients

10 more replies
Answer Match 54.18%

Hi everyone.

Just wondering if someone can give me a hand. I simple used the wizard to generate a tabular form that gets the data out of a query in Access. I simply would like to click anywhere in the form and then select that record I clicked on.

Once selected the record, how can I get that record's ID so then I can run a SQL statement to delete it.

Any help would be appreciated.


A:Access 2003 Tabular Forms - Record selection

negvillamizar, welcome to the forum.
I normally get quicker responses if you post your Access questions on the Business Applications Forum.

As to your question, I am not quite sure why you need the Record's ID to run an SQL statement, having clicked on it, you can just press the delete key and it will delete the record for you.

1 more replies
Answer Match 54.18%


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


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

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

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



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

6 more replies
Answer Match 54.18%

I'm trying to get excel 2003 enter a row of data into a website form so i can submit it and repeat the the process with the next row...

I'm submitting inventory to a website but have the data in an excel spreadsheet, so I'm hoping to avoid manually entering each and every item onto each and every website. Some sites have a bulk upload feature using XML, but this is for the sites that don't...

Is this possible? By using excel's web query feature i can pull data from a site, i guess I'm trying to post it to the form...

Any takers?

Thank you in advance for your time and consideration...

A:Solved: Excel 2003 to autofill website forms?

16 more replies
Answer Match 54.18%

We need to build a form in Outlook 2003, which will be sent to a customer to fill out their details. The details should get sent back to our email, we also need to be able to edit these fields and resend to the customer to update at anytime.

I have gone through the process and seem familiar with making the forms.

But when it is sent, it appears blank in the inbox and sent items...

What do I have to do in order to have it working, and working on the customers ensuring there settings will allow it to work?

More replies
Answer Match 54.18%

I've designed a new form in Outlook and added an ActiveX control (Date Time Picker from CCRP
to a contact page. Everything works fine except the date is not retained when I save and exit the contact. It keeps defaulting back to the current date next time I access it.

Am I missing something?

Any advice is appreciated.


A:Problem with Business Contact forms in Outlook 2003

I would contact the developer(s) of the app. Without in depth knowledge of the app (which looks pretty cool BTW) it will be hard to advise. I'm not sure what date in contacts your trying to manipulate?

1 more replies
Answer Match 53.76%

Hey everybody

Okay, been playing around with our Access Database here.

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

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

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

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


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

8 more replies
Answer Match 53.76%

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

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

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

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

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

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

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

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

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

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

16 more replies
Answer Match 53.34%

Using Access 2003, Microsoft VB 6.5
I have an Access table with over 100 fields.
I created 3 forms and one subform (all bound to the same table), for the users to enter their information. Each field in the table is updated in only one form (e.g., cannot change the value of a field on Form1 in Form2)
Form1 includes 3 buttons which allow the user to toggle from one form to the other (including back to Form1, since the buttons part of Form1 remains visible even thought the other forms are open).
Form1 is opened in add mode from a Switchboard.
Form2 & Form3 can only be opened through Form1 (by clicking on one of the buttons).
The subform is on Form2. In most cases, the user will enter data into the subform before entering data in Form2's controls.
The Navigation Buttons, Record Selectors, Close Button and Control Box are all set to "No" on all forms.
The only way to close Form2 and Form3 is through Form1, which has an Exit button to (presumably) save the data and close all 3 forms.

At First, when adding a new record:
I would open Form1 in Add mode. The table has an index key, (id), which is an AutoNumber.
Form2 and Form3 were opened in add mode.
I assumed (wrongly) that all the data entered would be stored in one record. I ended up with 4 records, with different id #s, with data from each of the 3 forms and one with data from the subform.
So I changed my code to open Form2 & Form3 in edit mode, linking them with the id from Form1.
I still ended up wi... Read more

A:Solved: Access - Forms creating multiple records in "add" mode

6 more replies
Answer Match 52.5%

I’m working in Access 2003 building a database in which the records will all have the same basic fields, but will be a library of info covering a very wide range of topics. In order to make easier how the information is pulled out by the end user, I want to very strictly control how the info is categorized when it is initially stored in the db. I cannot allow careless input clerks to misspell any of the labels that categorize the record they are entering, or perhaps invent their own labels.
So, each record starts with several columns of categorization labels. The clerk will be presented with a series of drop-down lists and will select one option from each list in order to categorize the record. Each choice will fill in the corresponding column in the categorization section of the record. The options available in each of these drop-down lists are carefully controlled to represent the only sets of acceptable parameters to describe the information contained in the record at each level of detail. Each successive column in this part of the record, representing one of the drop-down lists, covers the next-deeper level in a hierarch of information labeling for the records. As you follow the columns left to right, you are describing the information in the record with greater and greater detail.

A simple example: The first drop-down shows the options “animal, vegetable, mineral”. You select “animal”. Upon you making that choice, the system returns to you a list of ONLY ANIMALS t... Read more

A:Access 2003 Data Input Forms for Mutually-exclusive and Hierarchically-categorized Re

blothrop, welcome to the Forum.
It is quite common. The key to successfully doing this is twofold. The first is to base each successive Combo on the selection made in the previous one, the second is to requery each combo once the previous combo has made it's selection.
If you Advance search this forum for poster OBP and Combo in the text you should find various databases that I have posted that do just that.

1 more replies
Answer Match 51.66%

I'm attempting to locate an Event Tracing for Windows provider that will capture all DNS questions and answers.
This article indicates that the functions are included in WinInet, but when I capture this log, it doesn't appear that
DNS questions and answers are included.
Given that I was troubleshooting NLB and came across
this article which includes an example of an event manifest, I was curious if anyone had written a manifest just for DNS questions and answers or can provide some concrete guidance on doing so.

More replies
Answer Match 51.24%

I made a system image with the built in feature of Windows 7 following this tutorial Backup Complete Computer - Create an Image Backup

Today I made another but the first one made was erased and replaced with the new one. According to the tutorial Windows automatically erases older images once they take up more than 30% of the space on the back up location. I only had the one image on there and it was no where near 30% of the space. Why was my older image erased?

A:Creating system image questions.


It seems that it only makes one and deletes the other, always.

In any event this is what you do.

Make a system image, now. Put it on an external hard drive and forget about it.. Every month make a new one and keep it on the Hard Drive in the computer.

As time goes by you may need to use the image, because of a virus or your hard drive went down, either way you cannot or should not use the one on the internal. Wow, you have problems. Wait you made one and put it away.

You can use this for image.

Good Luck

9 more replies
Answer Match 50.82%


Thanks for any help you can provide. I just bought a new HP laptop with Windows 7 on it and I want to create a dual boot with XP so I can still run ProToolsLE 7.0 for music recording. I read the great tutorial here: Dual Boot Installation with Windows 7 and XP and I just wanted to get a few things straight before I try to do this (never done this before). Processor is I3-330 and hard drive is 500 GB 7200 RPM SATA drive.

1a. (Do I need to do anything different from Tutorial with a SATA hard drive?)

1. Currently there are 3 drives: C: Local Disk, D: Recovery, E: HP_Tools. I don't want to delete any of these drives; Can I still create a new drive or should I delete everything on the D: drive? Is there a proper way to cleanse the D: drive if I have to do this?

2. How much space should I allocate for Windows XP drive? I think 130GB should be enough for recording songs, will that work?

3. The disc I want to use is a Windows XP Professional SP2. Will this work?

4. Most importantly - once I get started partitioning the drive to set it up for a dual boot, can I reverse everything I did to get it back to normal in case I am unable to successfully create the dual boot?

5. Once I boot into Windows XP, can I use it to make a floppy disc boot disc to try one last time to successfully fix my old laptop, as I think the CD-ROM is broken it and CD Boot discs did not work for it. Also if anyone wants to share how I can make a floppy boot disc for XP that would be gr... Read more

A:Questions before creating XP Dual Boot from Windows 7

1a. (Do I need to do anything different from Tutorial with a SATA hard drive?) If XP won't detect HD, you may have to insert drivers at F6 prompt during driver loading using floppy drive, or if no floppy (XP is ancient) then slipstream in drivers:

1. Currently there are 3 drives: C: Local Disk, D: Recovery, E: HP_Tools. I don't want to delete any of these drives; Can I still create a new drive or should I delete everything on the D: drive? Is there a proper way to cleanse the D: drive if I have to do this? Recov may still work as long as Win7 is not clean reinstalled so I would save it, but make your Recov disks just to be sure. Follow the tutorial's steps to shrink Win7 partition unless this isn't enough space and you need help recovering the other utility partitions but I'd do that after install.

2. How much space should I allocate for Windows XP drive? I think 130GB should be enough for recording songs, will that work? That is your call based on your usage needs.

3. The disc I want to use is a Windows XP Professional SP2. Will this work? Yes, standard XP install disk. You'll need to do a lot of updating after install leading up to and including SP3.

4. Most importantly - once I get started partitioning the drive to set it up for a dual boot, can I reverse everything I did to get it back to normal in case I am unable to successfully create the dual boot? Yes, another reason to shrink Win7 and not bother the Rec... Read more

9 more replies
Answer Match 49.98%

I want to use the "windows system image backup tool" to an external hard drive which is a backup that already contains
other folders from several computers that I need to keep.
Ive never done this B4 so these are baby questions ; )
Will the image creator erase any of that info already stored on the external drive if I backup the system image to that drive?
is the windows image creator a good tool to do this (any problems with it that are known)?

is there some better image backup creator? if so which and why?

any help appreciated

A:Questions about creating a system Image backup - a bit coinfused

While I do not know about Windows 10 backup/restore utilities, I do know Macrium Reflect [free and pay-for]. MR will not delete anything on your ext HD unless you "tell it to do so" via its purging choices. I recommend two ext HDs getting your OS and data partitions backups.

0 more replies
Answer Match 49.98%


I'm creating some XML in 2003, using the DOM.

This is the XML I'm trying to create:
<item id="1" title="some title"><![CDATA[And here is the description]]></item>
<item id="2" title="Another one"><![CDATA[Description goes here]]></item>

Here is what I have so far:
Dim xmlDoc As New XmlDocument
xmlDoc.AppendChild(xmlDoc.CreateElement("", "items", ""))
Dim xmlRoot As XmlElement = xmlDoc.DocumentElement
Dim xmlItem As XmlElement

xmlItem = xmlDoc.CreateElement("item")
With xmlItem
.SetAttribute("id", "1")
.SetAttribute("title", "some title")
End With

(in a loop for each item)

This gives me:
<item id="1" title="some title"></item>
<item id="2" title="Another one"></item>

But no way can I figure out how to add the text for the description.

Any ideas?


A:Solved: 2003, creating xml using DOM, set value

For info, I have the solution from another forum:

xmlItem.AppendChild(xmlDoc.CreateCDataSection("And here is the description"))

This can be closed

1 more replies
Answer Match 49.98%

When using windows(key) and typing in a search word(firefox,word, etc..) Windows will shown some result. Is there a way to change some particular search words. I.E dev will show visual studio as top result(pressing enter should open it).

More replies
Answer Match 49.56%

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?

A:Creating Form in Word 2003

9 more replies
Answer Match 49.56%

Is it possible to create a questionnaire using Outlook 2003 which can be sent out to colleagues and there answers fed back to me?


More replies
Answer Match 49.56%

Bear with me, I'm pretty green with Access. I've created a small database, and was wanting to play around with creating a page. All I want to do is see what it looks like, so I just used the Auto Page : Columnar wizard...and get the attached message. What to do? Thanks!!

A:Creating page in Access 2003


1 more replies
Answer Match 48.72%

Basically I created a table with different fields of course, then a form for that table that the data can be viewed on or updated in. Now I am trying to create a separate form that when I click a search button it will open up that form and display the data based on what I searched for. The problem is I have multiple search fields, some which contain Null values. The problem I am having and wasn't sure if I could do this, but I basically want it to search the table using this expression Like "*" & [Forms]![Test]![Text0] & "*" in my query for each of my fields but ignore a null value in the form I am searching with. When I put Is Null or Like... it gives me all of the entries. So I need it to ignore if the search fields on the 2nd form if they are blank. If I just use Like "*" & [Forms]![Test]![Text0] & "*" for each field in the query except changing to Text2, etc it filters down to nothing. If I include the is Null and only search based on one criteria it gives me the ones that meet that criteria plus all of the others that have null in those fields. I created a small database so I could try to figure out what is wrong with another one I am doing for my company that is rather big. At the bottom is the SQL for it when I just use the Like "*" & [Forms]![Test]![Text0] & "*" statements. I tried some IIF statements also but I am beginning to think I can't make it where I ignore the fields ... Read more

A:Creating a Form to search in Access 2003

I have many databases with search forms doing just what you want. The key is in the "criteria row structure to get you going on the correct SQL if SQL is the way you want to do it.
This SQL is for mixing and matching up to 3 fields and a "controlling" "option" column.
SELECT tblVisits.PtKey, tblVisits.VisitDate, tblVisits.odIOP, tblVisits.osIOP, tblBAsic.DOB, [PtFirstName] & " " & [PtLastname] AS Name, tblBAsic.Diagnosis, tblVisits.[Diagnostic Update], DLookUp("[Option]","[Option]") AS Expr1, tblVisits.Comment
FROM tblBAsic INNER JOIN tblVisits ON tblBAsic.PtKey = tblVisits.PtKey
WHERE (((tblVisits.odIOP)=[forms]![frmSearchPatientData]![IOP Pressure 1]) AND ((DLookUp("[Option]","[Option]"))=1)) OR (((tblVisits.odIOP)>[forms]![frmSearchPatientData]![IOP Pressure 1]) AND ((DLookUp("[Option]","[Option]"))=2)) OR (((tblVisits.odIOP)<[forms]![frmSearchPatientData]![IOP Pressure 1]) AND ((DLookUp("[Option]","[Option]"))=3)) OR (((tblVisits.odIOP) Between [forms]![frmSearchPatientData]![IOP Pressure 1] And [forms]![frmSearchPatientData]![IOP Pressure 2]) AND ((DLookUp("[Option]","[Option]"))=4)) OR (((tblVisits.osIOP)=[forms]![frmSearchPatientData]![IOP Pressure 1]) AND ((DLookUp("[Option]","[Option]"))=1)) OR (((tblVisits.osIOP)>[forms]![frmSearchPatientData]![IOP Pressure 1]) AND ((DLookUp("[Option]",&... Read more

2 more replies
Answer Match 48.72%

i need to create macro for excel. don't know anything about vba's in excel and company is asking me to create this, wondering if any one can help me. as you can see from the script below i am repeating same sequence of events. can any one write me a script that will loop the sequence until sheet 1 column a is empty. thanks you very much
Sub Macro4()
' Macro4 Macro
' Macro recorded 8/31/2009 by mike

Application.CutCopyMode = False
Sheets("Revenue Statement").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range(Selection, Selection.End(xlToRight)).Select
Application.CutCopyMode = False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Revenue Statement").Select
Range(Selection, Selection.End(xlToRight)).Select
Application.CutCopyMode = False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Sheets("Revenue Statement").Select
Range(&... Read more

A:Solved: excel 2003 creating a loop in vba

9 more replies
Answer Match 48.72%


Can you tell me please how can I create a new Query table using SQL in VBA mode?
For example: I have table "Employees" with "FirstName" and "LastName" fields. On the form user would choose to show "FirstName" only, "LastName" only, both and etc...., and the application would display the table with the chosen fields.


A:Solved: Access 2003 - Creating Query in VBA with SQL

7 more replies
Answer Match 48.72%

I am creating event tickets and would like to add consecutive #s for raffles. I started with a business card template. I tried to use the page #s in a footer, but each page of tickets carries the same # on all tickets.

I am not very experienced in Publisher at all, and don't know how to create a macro (saw that suggested on the Microsoft website for gift certificates).

Is there a simple solution to this?

Thanks for any help.

A:Creating consecutive numbers on tickets in Pub 2003

I have done this in Publisher 2003. You also have to have Excel and first create a file in Excel. That is then linked to Publisher.
This site may help
Sequential numbering of tickets | Microsoft Office Forums

1 more replies
Answer Match 48.72%

Starting this week, when we create a new user, or a group, Exchange does not automatically create the STMP email, nor the X400 configuration.

We haven't had this problem before and now no emails or names in Global Address Book for new users.

Don't know if it had anything to do with the latest MS Updates or not, but if anyone has a suggestion, I'm listening.


More replies
Answer Match 48.72%

I am creating a database in Access 2003 and I have used tabs to separate my information in the detail section. The problem I am having is that when I try to put information on the 2nd tab the information that I put on the first tabe is on the 2nd as well and if I try to delete it off the 2nd take it deletes it off of the 1st tab. What can I do to fix this?

I am pretty good with computers but I not that familiar with Access I am teaching myself as I go.

A:Access 2003 creating tabs in a form

16 more replies
Answer Match 48.72%

I'm looking for a macro that takes me to the 'Advanced Find' function (Ctrl+Shift+F) in Outlook, then to its advanced tab. Also need the field section to auto select 'Subject,' switch condition to 'Contains,' and, this is where I feel I'm pushing it, auto-fill the 'Value' with the subject of the currently selected email.

Any help would be appreciated. Thanks.

More replies
Answer Match 48.72%


I'm working on a database where I would like to do the following:

In a form, I have a drop down box with 3 options, what i want to do is that when the user selects one of the 3 options, then from another drop down box, a list is displayed (for the user to select) relevant to the one chosen from the first drop down box i.e. combo box has 3 options (i.e. premiership, championship, league 1), if the user selects premiership, than from the next box, they have the option to select only those in the premiership, likewise, if they chosed championship, than they have the option to select only those in the championship.

I can create drop down boxes but just want to know how to create the above based on what is chosen from the first combo box.

many thanks

A:Creating options on a form in Access 2003

kets, see these 2 recent Threads for answers to your question.
The key points are using the previous Combo (or it's Control Source) in the SQL (Row Source) of the next combo and using VBA to Requery (Update) the second query with the result of the first combo's Selection.

2 more replies
Answer Match 48.72%

HI guys I need to create a template of our letterhead in office

why do we need to do this?
This is so we can create a PDF invoice or general letter and email it. We are using Flash paper to convert files to PDF

We have 2 letterheaded papers, 1 is the mane letter head and the other is a continuation sheet.

What I want is to create a template in office 2003, when using this temaplet if I write an invoice and go past the first page. Office automatically adds the second page "continuation letter head" and continue to do so for as many pages I add.

So basically the first page should be the Letterhead and every page after should be the continuation sheet.

The letter head and the continuation sheet look very similar except the continuation sheet does not repeat our address phone numbers and so on.

Can you please help.

Please email me at [email protected]


A:creating a custom template in Office 2003

11 more replies
Answer Match 48.72%

Okay, so what I am aiming to do is to create a report in Excel 2003 that will only bring up data that meets 2 criteria.

I have attached the file so you can see what I am talking about.

The first one is that the Status must be "Low Priority" the second is that the same Asset ID needs to have appeared under that Status at least 3 times. It then needs to show the Pack Number, Status and Asset ID. So for example in the file I have provided, I need it to bring me Packs S123460, S123462 and S123464.
I have tried filtering, and I have tried formula's (these work but only bring back 1 Pack Number). It might be that it needs to be a Macro, but I don't know how to write my own, only record them!!

If this hasn't melted anyone's brain yet I would really appreciate any help you can give!!

A:Creating a specific report in Excel 2003

7 more replies
Answer Match 48.72%

Hi all,

I'm tasked with updating our email stationery with a nice new design.
Now we all know MS Office sucks the fat one when it comes to DTP, so i use the Adobe Creative Suite.
Problem is, i don't know how to convert my design from InDesign into an htnl document, which is seemingly the only filetype that email stationery or signatures can be saved in. I have no idea how to use Go Live either.
The other problem is that i need our email and web addresses to be hyperlinks in the sig. so i can't just save it as a jpeg and paste it into word then save that as html, import it into the sig and bingo!

Any suggestions please?
I have over 50 personalised ones to do, so i'm really looking for an easy workaround for this.

Many thanks

A:Creating stationery and signatures in outlook 2003

This explains it pretty well...

2 more replies
Answer Match 48.3%


I want to create an email format on HTML that I can use to email out clients using our corporate image.

here is a sample:
I know it can be done because I receive emails and newsletters from our partners similar to that.

I wish to accomplish that on Outlook 2003 and Outlook 2007 since we have a mix of both in the company
any help or tips will be greatly appreciated

A:Creating an HTML Template on Outlook 2003/2007

Hi SrillAlive,

Outlook was never designed to be anything other than an end user WYSIWYG editor. (What You See Is What You Get) While you can right click on HTML emails you recieve, and View the Source html, there is no "out of the box" way to compose an html email.. Outlook does it automatically for you. There are add ons availabe... but they tend to be overpriced for what you want to accomplish.

It looks like you host through ... I'm not familiar with what type of email solution they offer you or if you just resolve your mx records to point to your own server. Regardless IF you use thier email application they probably have a web interface and a way to compose email from it.

I would assume your best bet would be to start there and see if you can copy and paste your code to the web interface.
There will more than likely (hopefully to make it easy for you) a way to select the formatting of your message in thier email solution...e.g. switch from rich text to html < >

....OK now I looked up your MX record and it looks like you would log into
Start there amd see what you can accomplish.

Another option is to use a diffent application to compose and send your email or build a simple vb app and call on outlook ado's

There are a ton of free open source progs that do just this... its a matter of preference and ease.. I would recomend one but I don't use them that offten as I... Read more

2 more replies
Answer Match 48.3%

Hi Guys,

Greetings to all...

I'm facing a problem in creating the mail box in Exchange Server 2003 via script.

Let me Explain the Requirements :

I'm automating the ADMIN process via vb scripting. we are having two different server for "Active Directory (LDAP)" and "Exchange Server 2003". "Test Linux Server".

Now I need to create a email box for a particular user those who are having account in AD.

I found a utility for MailBox Creation.
The name of the Utility is : ExchMbx.exe

If we provide the DNstring to this utility it'll create the mail box for that user.

Example :
dsquery user -samid mkautomate | ExchMbx.exe -cr "CN=Mailbox Store (BLREXCH01),CN=First Storage Group,CN=InformationStore,CN=BLREXCH01,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=VITAGETECH,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=vitagetech,DC=com"

otherwise we can given -b and DNString

I placed this ExchMbx.exe in C:\Tools\ dir.

from the command prompt I called this exe with the above option, I could create the email box for the given user.

So for I does all these executions in Exchange server directly (mstsc RDP Connection as domain + exchange server + enterprice admin).


Remote Execution....

There is a utility available for executing a scripting windows server through linux.
code source & examples are available here.
winexe homepage

I used thi... Read more

More replies
Answer Match 48.3%

Hi folks,

Bit of an odd one;

- when I create an email it's in English (UK)
- when I reply to an email it's in English (US)

I've checked all the usual places; regional settings, spelling tab in Outlook options, checked Word too. Can't get to the bottom of it. Any help?


More replies
Answer Match 48.3%

Hey All,

I have a document in Word 2003 that is five pages, and what I want to be able to do is to create a footer that will ONLY SHOW ON THE LAST PAGE OF THE DOCUMENT. I have gone into Help Sections for the program on-line and there is information about creating headers and footers, breaking them up into sections, making different headers and footers on alternating pages. But I don't want them to alternate, nor do I want the one footer taking up the bottom of every page.

The example of the format that I need is the following:

Pages 1-5 contain the article
The last page, page 5 contains the following text as a footer, (text is for illustration only)

(Centered) Credits: Joe Smith and John Doe


A:Solved: Word 2003: Creating A Footer on Last Page Only?

What you do depends on how the document is laid out. If there is a page break between pages 4 and 5, you will need to change it to a Next Page Section Break. In Word, the thinking is that changes to the headers and footers create new sections in the document. In this case, page 5 would start a new section because the footer will be different than the preceding pages. But before we continue, be sure to click File / Page Setup / Layout and make sure that there is no checkmark on either Different odd and even or Different first page.

To insert a Next Page Section Break

First, you need to see what you're doing and the easiest way to see the page break is to change to Draft view (on the Word menu, click View / Normal).

Place the cursor in front of the first character on page 5.
On Word's menu, click Insert / Break
Locate Next Page and click on it.

You will have a page break and a section break. Place your cursor on the Page Break and press Delete on your keyboard to get rid of it.

You can set your page view back to Print Layout by clicking View / Print Layout on the Word menu.

If you place your cursor on page four and look at the left side of the status bar at the bottom of the screen, you will see that it says Section 1. Place the cursor on page 5 and the status bar will change to Section 2. Go into the footer area for Section 2 (if you go into the footer and it says Section 1 Footer, either scroll down until it says Section 2 Footer or click the next section but... Read more

3 more replies
Answer Match 48.3%


Is it possible to create a field in MS Access 2003 that will allow a user to select multiple options?

For example I want to create a filed called "Reason for Change" that has the following values: Customer Request, Quality, Safety and Legal, Supplier Request, Engineering, Cost Savings, Other, and System Integration. Next I want to create a form based on the table and the user will have the option to select one value or multiple values for the field above.

Thanks in advance for the help.

A:MS Access 2003 - Field with Multiple Values Creating

yes, you can use the select or/and radio option prop to do with.
for one option selct drop down menu is recommended. if u want more than one option then u can use radio buttons for that

1 more replies
Answer Match 48.3%

I have 3 queries that are run by entering a date range. I would like all three queries to be on a single report. I believe it is the date range that is stopping my report.
Can you help me?

A:Creating A report multiple queries in access 2003

16 more replies
Answer Match 48.3%


WinXP SP2 and all current updates.
Office 2003 also with all current updates.
AVG also current.

When the user saves an Excel or Word file it creates another file in the same directory that starts with that files full name plus ~RF######.tmp, where # is some random digit mostly but occasionally letters.



They say this just started a couple of weeks ago. So far the *.tmp files have been the same size as the real file.

How do we prevent this so we don't have to keep manually deleting *.tmp files other than the usual %temp% directory ones?


A:Solved: Office 2003 creating/leaving tmp files behind.

12 more replies
Answer Match 48.3%

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!


A: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
Answer Match 48.3%


I have about 2500 rows of data, and I need to create a pie chart for each row of data.
I then want to mail merge the results.

Is there an automatic way to do this? I had a go with a macro but i didnt get very far.

Thanks for any help

A:Excel 2003 - Creating lots of charts automatically

12 more replies
Answer Match 48.3%

I'm trying to create an Access database that I can use to record information about various callers. I need to be able to make a report that tells me how many of each kind of caller answered which questions. Example: How many 21-25 year olds, who are males, said their favorite color was green. How many 26-30 year olds, who happen to be female, said they do have a car.

The results have to be broken down using the criteria of age and gender. HELPPPPP!

A:Solved: ACCESS 2003: Help with creating a phone log and statistics

Do you still need help on this, or has been superceeded by your later Thread?

3 more replies
Answer Match 48.3%


I am wanting to create a dynamic Outlook Template (OFT) please.

I require the template to dynamically pull some of the data from a excel spreadsheet at random, is this field will be ever changing and have multiple possibilities eg different jokes or riddles etc

Can someone please tell me how to create this type of template for Outlook please?

Thank you

More replies
Answer Match 48.3%

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

Hello All!

I am a novice Access user. I just recently started using it to create a database for work that will track complaints. I have been searching high and low to try to figure out how to create a custom autonumber field but just don't know what to do. Maybe there is some help out there from one of you.

I wish to create an autonumber that displays the computer's date and generated numbering.
(Ex. 08/22/10-0001, 08/22/10-0002...)

Any help given would be much appreciated!

Thanks in advance,


A:Solved: Access 2003: Help with creating custom autonumber field.

16 more replies
Answer Match 47.88%

I am using Excel 2003 to create a database of hyperlinks to different paragraphs and then through the use of a macro I can create word documents. I inherited this macro from a different department and want to customize it for my needs. That being said I have no idea how to edit a macro this large and complex. What's the best way for me to post the macro and my questions, through email, message through this site, post it in this window? The macro is about 15 pages in length. Thanks.

A:Excel 2003 - Macro for creating word document question

First, welcome to the forum!!!

The best way for one of the Excel gurus to work on your problem would be to post your file, after you have removed any confidential data (make a copy and do the editing in it). If it is too large, zip it first (and zip is preferred to rar).
If you are unable to post the file (there seems to be a problem at times with people who don't have very many posts being able to attach files) just send me an email via my profile (include the URL link to this thread). I will respond to you and then you can send it to me, after which I will post it for you.

1 more replies
Answer Match 47.04%

I have a 2003 SBS server that I built, it isnt in service just yet, but it is ready to go. Problem is I was thinking about how I partitioned the 250G Raid0 drive and want to change it. What I have now is a 10G C: partition for the OS and the rest on D:, which everything but the OS is on. I want to delete the partion for D: and re-partition it 3 ways, one 6G partition for the page file, one as a 50G backup partition and the balance for the APP's. Can I do this without having to re-activate windows? I had to reinstall the OS once when I got the second drive installed and setup RAID and wound up having to call the jamooks in india to get it rekeyed. I dont want to go through that again. Can I rerun the after OS install and reinstall the SBS portion of Exchange ond others without doing a reinstall of the entire OS?

A:SBS 2003 questions

8 more replies
Answer Match 46.62%

I have a couple of off the wall questions that I don't know if they are even possible to do. I have a user that is trying to share a folder of e-mails and subfolders, not through outlook though.

1. Under users Inbox they have multiple folders and subfolders. User is trying to copy one folder under Inbox that has about 50 subfolders and a few hundred e-mails. If you create a folder on your desktop and then open that folder and copy and paste all of the e-mails, they move just fine and the icon is little envelopes that you can open. I want to know if there is a way to just copy or move the folders instead of having to create a folder and then copy and paste the e-mails. If you move the folder or copy the folder it creates a shortcut that when clicked on it just pulls up Outlook and that folder.

2. Once I am able to get the "envelopes" into the folders, the only thing that is displayed is the subject of the e-mail. Is there any way to modify what Outlook names those "envelopes"? I would like Outlook to stamp those envelopes with who the e-mail is from and the date received.

Like I said, I don't know if either of these are possible. The reason for this is the user is creating a huge share file that contains, Adobe, Word, Access, Visio and other document to share to very few users. Any help or definitive "NO" this cannot be done would be great. Thank you in advance.


A:Outlook 2003 Questions

I see that 25 people have looked at this with no response. Does anyone think that this is impossible? That it has to do with code that Microsoft has locked down and we cannot change this? Any opinions or theories would be appreciated also. I just figured I ask, but it seems like it might be impossible???

2 more replies
Answer Match 46.62%

My husband and i own a small accounting firm with 3 other employees. We need to be able to schedule appoints and enter contact info into outlook calendar in real time. In other words when i enter an appointment time, all employees can see it immediately. We are on a network. Is there some way to accomplish this? Everyone also needs to see the client contact info as well.

We are currently using QuickBook Customer Manager but it does not have real time capabilities. We have to sync if we want to see the most current info, which is not very effective.

If you know of other software that would work easier than outlook, we are open to suggestions!


A:outlook 2003 questions

this is a pretty good piece of software at a resonable price.

2 more replies
Answer Match 46.62%


New the forums and not so great with Access yet, so I have some questions regarding capabilities and whatnot.

Firstly, I am creating an inventory database for a family member who is starting a store. I'm stuck on a few points. I have two columns "Quantity" and "Retail Price" that multiply to form the column "Line Total". This works fine. My next task though is to determine the tax percentage on all items depending upon whether the item is PST exempt (5%) or not (13%). I attempted to create a check box on the form, so when it was checked, Yes it was exempt and would multiply the "Line Total" by the correct percentage. Unfortunately this is where my knowledge ends. The check box will not go to default (not checked) when I go to the next record, nor does it store the result for each record. It just stays constant as I go through the records regardless of my original choice. The only calculation I can get to work is that it's NOT exempt, thus multiplying by 13%. But the tricky part is that at this point, it ROUNDS UP to the nearest dollar amount, even though I've either manually set the decimal places to 2 or set it to auto. Not sure how to resolve this either.

As a second point, I'm curious if this would be easier to accomplish by having it automatically calculate based on the catagory of item (Women's, Men's, Children, etc). I have a separate table that is linked to a drop down menu and output in the... Read more

A:Some Questions about Access 2003

Hi KeeKee and welcome to the forum. I hope we can help!

Now, you said :

he check box will not go to default (not checked) when I go to the next record, nor does it store the result for each record. It just stays constant as I go through the records regardless of my original choice.Click to expand...

This might tell me that you do not have a field in the/a table to hold the state of that percentage tick box. I owuld add a new field to the table related to the product, lets call it PercentState, and give it a type of "Yes/No" and a default value of "No".

Update your query for the form to inlcude this new field.

Then, I'd link that tick box on the form to this new field (change its control source).

Now, when you set the tick box to yes, it should stay that way when you move to a new record and will store that value for recall later.

The rounding problem can be resolved by using some VBA code. Have a look at this link:

It might point you in the right direction.

Finally, yes, you could set the %age based on the value of a pulldown list (based on a table). You'd need to set up some code or a Macro maybe that will say "If the value of the pulldown is between X and Y then %age value is NN%, otherwise its MM%.

Does this get you going?

Good luck and let us know how you get on.


3 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 46.2%

Hey everybody

I'm still working with redoing the access database. I had an idea of how to make it what I consider a little better.

I want to have a lot of the information on one form. I have checkboxes on the database that allow the user to select the status of the agent. I want it where when the click on a checkbox, it shows fields that they need to fill in, based on what the agents status is.

For example, all agents will have their name, address, social security number, and contact information visible all the time. Active agents, however, may have information such as Contract Mail Date, IFG Agent Website, and things of that nature visible, while Recruiting agents would have information such as First Interview date, Second Interview Date, and so on.

I was thinking it would have something to do with the On_Click command of the check boxes themselves. Such as (pseudocode):
On Command_Click chkActive
Show objects Whose Tag = "Active"
I'm not sure on the exact syntax of it.

Another question about tags would be: How can I have multiple tags on objects?

The reason being, is some objects may need to be on two or three of the views, while not being on two of the others. Is there any way of implementing this as well?

Any advice is much appreciated.

A:Access 2003 - Tags questions

Hey smooth.

A tag is just a string, so in order to have "multiple" tags, you need to implement some string logic. That is, you cannot ever have more than one Tag property for a control, but you can construct your tag string however you wish; a delimited list is probably the best option for what you're talking about:

control.Tag = "group1;group2;group3;...;groupN"

If InStr(control.Tag, "group3") > 0 Then
' the control is a member of group3
End If​I think you're on the right track, and you already know how to dynamically show/hide controls. The standard method would probably be to loop through all the form's controls and check the tags, selecting controls to show or hide at run-time.

There is, however, another option. I don't know if I recommend it, but you could preload collections of control groups. That is, in the form's Load event, you could build collections of controls, place those collections in module-level variables, and then only loop through a particular collection rather than every control in the form if you want to show/hide some group.

I can't tell you which is more efficient. I think the first way would be more versatile if you have a control belonging to group1 and group2 in a situation where group1 needs to be hidden but group2 needs to be visible. Static collections can be pretty inflexible.

HTH, or at least gets you thinking.


1 more replies
Answer Match 46.2%

#1. I have been writing a Family History book for years. What is holding me up is Word 2003 . I just get a section done - text and images, and the next time I go back to it, the images or the captions have moved. See snap shot.

#2 A weird happening with "Markup".
Often when I want print preview to look at multiple views, the page with no Markup checked will open in MU mode even though there are no notes or reviewing marks in the book. I have tried everything to get the MU to behave properly. I spend all my time redoing work I have done before.

I have wondered if my Word 2003 is corrupted but I don't know how to check and I don't want to have a big learning curve to buy a new program. (I am advanced in years).

A:Word 2003 formating questions

If your file extension is .doc they should stay. If you are using a .txt extension then that is the reason.

2 more replies
Answer Match 46.2%

Can someone give me some information on Windows Server 2003?

I know very little about running a server and was wondering if there was any tips out there for running a personal one ...

Couple Questions that need answering:
- if I'm using WS2003 can I still run my normal programs like say Adobe Photoshop or a game like Operation Flashpoint?
- will running a server and leaving the computer on all the time 'hurt' it?
- are there any 'quirks' i should know about WS2003

A:Windows Server 2003 - some questions

moved to win2k/xp forum

1 more replies
Answer Match 46.2%

Hi, I need a little help with Outlook 2003, I have alot of
Drafts, which I just replace the name and date, then send
the email to multiple people multiple days, and was
wondering if there is any way to do some sort of auto date
so the date changes to the current date, any help would be
very apprechited, thanks.

A:MS Outlook 2003 Macro Questions

If you ever have a question about Word macros or Excel macros, then hopefully I can help you right here in Tech Support Guy.

However, for questions about programming in Outlook, you might want to try the following link, which is specific to writing macros in Outlook. (things don't get more narrowed-down than that, do they? )

my recommendation:

or, in case the site has moved (I doubt it), then try the following google search:"forum+outlook+help"
I'm sorry I can't personally be more of a help. As I said, I'll be glad to help when it's a Word question!!

Best of luck to you,
Kelly's Humble Macro Page

1 more replies
Answer Match 46.2%

Hi, I have a couple questions about Word 2003, I am still getting used to 2003 so it is probably very simple. (At least I hope so).
How do I set it up so that in Word 2003 the Microsoft Office Online - Getting Started task pane doesn’t show every time I fire up the program? Also, isn’t there a way to have Word automatically insert page numbers? I now have to insert everytime if I want them. Also have a IE question but will start a new thred for that.


A:(Solved) 2 questions for Word 2003

6 more replies
Answer Match 46.2%

i was wondering wen restoring ur c drive(windows drive) with norton ghost does all my programs work properly again or do i need to re-install my programs? eg. do my programs appear on my start bar again?

A:norton ghost 2003 questions

7 more replies
Answer Match 46.2%

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.

A:Access 2003 Form Questions

16 more replies
Answer Match 46.2%

I have a couple servers that we use for DNS. I am trying to get them setup "the right way."

We have almost 900 .com domains I want these two servers to run for us.
We also have a straight fiber connection for us to use for internet.

Question 1) For a dual cpu 2.8ghz Dell 2650 w/ 3gigs of ram, how many domains would you put on a single dns server? All 900?

2) When you setup a secondary DNS server to accept zone transfers from the primary, does that mean that you can enter new zones into the primary and it will auto create them onto the secondary for you? Or do I have to go onto the primary and create the new zone and then go onto the secondary and create the new zone manually myself?

Thanks guys. I really need to find someone who is an expert in MS 2003 DNS Servers that I can just sit down and chat with cause this is a whole new book for me.

A:Windows 2003 DNS server questions

The answers require way too long a response for this forum. We recommend you obtain copies of

Windows Server 2003: A Beginner's Guide (Beginner's Guide) by Martin S Matthews (Paperback - April 11, 2003)


Microsoft Windows Server(TM) 2003 Inside Out by William R. Stanek (Paperback - Jul 7, 2004)

Or similar books, or Windows Service 2003 knowledgebase articles at www.micrpspft/com.

Otherwise, you need an expensive Network consultant. They start in most locals at $85 an hour and sometimes $135 an hour. They have spent a great deal of time hands on getting to a point where they can advise you.

3 more replies