Computer Support Forum

Pre-empt a form field according to invoking source in html...

Question: Pre-empt a form field according to invoking source in html...

This may not be possible, but I would like to embed a value in a form field (the form can be invoked from several different links within an html page), the value depends upon the place from where it was invoked

Relevance 100%
Preferred Solution: Pre-empt a form field according to invoking source in html...

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

Answer: Pre-empt a form field according to invoking source in html...

12 more replies
Relevance 86.92%

See the webform located at which I created only to use the generated HTML from the browser source.

Can you view the source, look at the HTML and help me to craft the following:
Additional button [Calculate] to be located to the right of "Add 3% Electronic Payment Convenience Fee" and when clicked will calculate the product of "Amount" and "Add 3% Electronic Payment Convenience Fee" and place the newly calculated value in "Calculated Total". Database fields exist for all form fields and are named as seen in the source. I am assuming javascript is necessary to accomplish this. My javascript skill is very limited. I am also assuming there is no reason the javascript will not work if placed inline on the same page. "Add 3% Electronic Payment Convenience Fee" field and "Calculated Total" field should not be editable by user.

This CMS system allows HTML to be used where needed. I can copy the HTML from this type of form (which is built using a site tool) and place the HTML into a new site page, edit the HTML so as to reformat the layout of the table, customize attributes such as placeholder text and other changes.

I hope this is enough information. If not, feel free to ask.


Answer:HTML & javascript form field value calculation

Hello All...

Another thought I guess is that javascript could be disabled in the user's browser. The more I consider this, the more I believe that I could do without storing the calculated total especially knowing that results could be skewed based on user's browser. Amount, Item Name and multiplier used in Fee are required. Others are not. However, I still wish to display the calculated total if the user wishes to click the [Calculate] button to see it.

Make sense?


1 more replies
Relevance 71.75%

I attached my database what i would like to do is create a form when an end user will enter a corresponding user ID from that I wish to populate textbox fields with Agent Name, Supervisor, Location, Dept *all seperate text boxes of course* I have attached the database if someone could help me do this it would be great. Let me know if you need any further details to help get me through this.

Answer:update field A in form based on entry in field b

Welcome to the forum, before answering you question can I suggest some improvements to your database.
Currently you do not have any "Key", "Indexed" fields in your tables and there are no relationships set up between the tables.
Also do you really need the Archive Table?
The data looks like it has been exported in from a spreadsheet, relational databases work quite differently to spreadsheets, so to make the most of their advantages you need to correctly relate your Tables.
Your UserID Roster also has some disconnect between the Field Names and the actual data in them, particularly the Name and Type feilds.
In the Supervisor Table the Birthdate does not seem to have Translated correctly.

2 more replies
Relevance 71.75%

I'm doing a quick-and-(very)dirty design as a proof of concept. During this process I fat-fingered the word Description, as Ddescription. No problem, I know what it means, right. But it annoyed me, so I changed the underlying table (where the error occurred), deleted the control from the form, and added the (now correctly spelled) control.

However, every time I try and ruin the form it wants a value for the now non-existent field Ddescription. I simpy click-through, and the form runs fine. When I look at the available fields in the form's View query's Field List, it still shows Ddescription, and i seems to think it's coming from the underlying table.

Any ideas on how I can remove this phantom field? I can't find anything called "The_View_for_form_FooBar" anywhere, but I know it must exist somewhere...


More replies
Relevance 69.29%

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

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

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

Hello all

I wonder if any of you could help me with a simple thing which has been driving me crazy for several hours.

I have a form which opens as 'Add' (for new record)
The first field is called 'Admin_name' and needs to be filled in before the user can move on (it's a combo box)
The next field is called 'Client' (set by Tab order)
The primary key field is an Autonumber which doesn't populate until data is added anywhere on the form (everyone knows this of course).

I have tried absolutely everything I can imagine to make this happen: validation settings on both table and form, functions, macros and code (some of which I copied from this forum and adapated to my own form).
When I get Debug to smooth out any errors (I am an beginner really), the code just doesn't work. It's as though the conditions I'm asking for are not met. I can't see why.
I've tried triggering the code with command buttons, via On_Exit, On_Lostfocus etc events on both fields...whatever I try things don't happen the way I want them to.

I wonder if the problem is that until a new record is created none of the conditions work.
Having said that, if I populate another field to activate the new record, when I move back up into the admin_name field and leave it empty, STILL nothing happens.

The only time anything happens at all is when I try to close the form (or move back to design view) when the bog-standard Access messages kick in OR ... Read more

More replies
Relevance 60.68%

Hi everyone,

I am trying to created a form from a query. these query is created with two tables A and B
table A have two fields that I match with table B, I need a couple of fields from table B. but then when I open the form I need to enter some of the fields on table A but I get a msg saying this recordset is not updateable..!
I could moved those fields from table B to A and then open the table but I really would like to have then if those fields change on table B. table A would be wrong.
What am I doing wrong?


Answer:How come I can update a field on a form?

describe the purpose for the A & B tables, give examples of the data you are puttin in.

2 more replies
Relevance 60.68%

I have a continous form with a field called " leased", and if it is a yes its a tick, if not just blank. On trying to printa report i wrote a code saying if the leased is (-1), then Msgbox" This has no leased".
The problem is its only looked at the first one only and declare if its leased or not. Despite the second or third or maybe the 100th item could be a yes . Is there a way that I can tell the system check all continous form for that field for the yes " -1".

Answer:Continuous form field

6 more replies
Relevance 60.27%

I have a table consisting of 8 columns by 26 rows. In each cell, I'm adding a Text Form Field. Is there anyway, besides doing it cell by cell, where I can just copy a row, then paste the same Text Form Field with text length maximums in the other 25 rows?

Answer:Word - Text Form Field

Sure, Brian.
Create first row.
In Print Layout view, take your mouse pointer to the left of the left-most cell in the row, and it should turn into a 1:00 pointing arrow. Click to select the whole row, then Ctrl+C to copy. Place your cursor in front of the paragraph return just below the table OR in the left-most cell of the row that you want a new row above, and hit Paste.

3 more replies
Relevance 60.27%

Please assist, I have a Form with a Rand/Ha field (currency) and a Ha field (number), the Value field should be the (Rand/ha) / (Ha)? How do I get this value to reflect in the Value field and have it stored in the table for reporting purposes?

Answer:Solved: Add calculation field to Form

Are you talking about Access?
If so you use simple VBA to add the calculation to the field. The Field's Control Source must be the Table Field.

3 more replies
Relevance 60.27%

I am looking for an alternative to Adobe.
The key feature is being able to load a pdf, and then for the software to recognise were the fields are for completion so I can convert it to a fillable pdf.

More replies
Relevance 60.27%

Sorry that this might be hard to explain but here it goes.

I have a form (attached) that the user can insert the Name,Description, PIN #; select a Can Size and multiple Upcharges.
The form creates the record into table DNP.
The query "Items Form" takes DNP records and (will eventually) create total and discounted prices, etc.

Price is determined by Can Size as seen in the Can_Size table and SizePrice query. What I need is for when the user creates the record, the Price goes to DNP table AND/OR just the "Items Form". Price can not be on the form like it is for Can Size and Upcharges (yes I know its in the Can Size combo). I'm pretty stuck.

Any directions or guidance would be greatly appreciated- Thank you!

Answer:Have a form look up field when creating a record

8 more replies
Relevance 60.27%

I can add a field to the 'phone list' view, but I want the new field 'mobile phone 2' to appear in the contact form, general tab under the first mobile phone and can't. It only appears in the 'all fields' tab.

Answer:Outlook Contacts: Add field to form

6 more replies
Relevance 60.27%

I use a perl script (form-mail) for an email form on a website. I've noticed that when the mail arrives it is addressed as "from:" the server at demon but the "to:" box is empty. The script contains the address to send the mail to, and it does arrive, but when it arrives it is not addressed to anyone so the server has problems sorting it into relevant mail boxes.Because of the way the mail system is set up I need to have an address in the "to:" field.Anybody know how I can achieve this?

Answer:cgi email form "to:" field is empty

just refreshing the post.Any ideas anyone?

3 more replies
Relevance 60.27%

Please help. I'm running Access 2007. I have a Form that's running off a query. The query has a parameter that requests two user inputs. This works fine except when I open my Form it automatically asks for those two inputs. It still works but I'd like to be able to open the form, enter data and when I get to those fields have the parameter questions populate at that time. Any help is greatly appreciated

Answer:Query Parameter Field in a Form

7 more replies
Relevance 60.27%

Form Fields spurious error(hope this doesn't appear twice - slight problem at first attempt)A very strange problem: on a couple of forms i have created on different sites, when I view thm in IE some (not all) of the form fields are recessed (shaded border at top and l'hand side) and with background colour = #ffffcc.This does not happen with Firefox or Netscape - all filds are plain boxes with no background colour.This may have started when I copied a form with a table in it that had background colour = #ffffcc.I've check form, table and form field properties but can't fathom it. Is it a registry problem? Any ideas?

Answer:Form Field spurious properties

The google toolbar will shade form fields that can be automatically completed with its autofil option.Others may have the same funcionality.

2 more replies
Relevance 60.27%

I think this is a simple question, but not sure.

I want a field in a form to auto populate as the user types into it. For example, as they type "J", the first name that begins with "J" comes up. As they type "Jo" the first name with "Jo" comes up, etc. That part is basic. I am using a combo box and it works fine.

The next part is the tricky part. If the name does not appear in the list, is there a way to add it as a record in the related table?

Actually I created a simple table (only one field) just for this purpose, so if there is a trick on the field control level, to add the new entry to the combo box list that would be fine.

I don't think I can use a sub form because it won't give me the "auto populate as you type" part, right?

I also found some code on the MS help menus that may do it, but I am not a VBA programmer so I am not sure but here it is:

Private Sub DoctorName_NotInList(NewData As String, Response As Integer)

Dim dbsIPutMyDatabaseNameHere As DAO.Database
Dim rstDoctors As DAO.Recordset
Dim txtDoctorName As Text

On Error GoTo ErrorHandler

txtDocotorName = MsgBox("Add " & NewData & " to the list of doctors?", _
vbQuestion + vbYesNo)

If txtDocotorName = vbYes Then

' Add doctor stored in NewData argument to the Doctors table.
Set dbsIPutMyDatabaseNameHere = CurrentDb
Set rstDoctors = dbsOrders.OpenRecordset("Doctors")
rstDoctors!D... Read more

Answer:auto populate form field

10 more replies
Relevance 60.27%

Hello All.
Public Sub AutoExec()
MsgBox ("The Word Startup Folder is: " _
& vbCrLf & Word.Application.StartupPath)
End Sub
First, I want to again thank everyone who helped me with my first question: Text Form Field in Word 2003.

My next question is: Is there a way to automatically tab to the next form field?

End Time
I would like to key in the hour (00), skip over the colon, key in the minutes (01) and have Word or VBA tab to the next field.

Can this be done? Any ideas?

More replies
Relevance 60.27%


I have a table1 with a lot of fields a,b,c,d,e,f and so forth.
I also have a table2 with just a and b. (because you are not allowed to fill in value a if it is not in table 2.
I have a form that i use to fill in a,b,c,d,e,f
Is it possible to make the form fill in b based on the value of a ?

Answer:Inheriting from another field in access form

The answer to your question is Yes.
However as the data has to be in table 2 then the User should not actually enter the data in the Form for table 1.
Ideally the User would "Select" the data from table 2 and the only thing stored in table 1 is the ID Key value from table 2.
The selection process would be made using a Combo drop down box.
Normally the data from Table 2 would be on display in a Main form and the data to be entered in table 1 would be entered and shown on a Sub Form, usually in continuous forms mode or Datasheet view.

1 more replies
Relevance 59.45%

We are currently using QuarkXpress on our Mac for reports and invoicing. Our forms are set up in format and then with text fields. We can link the text fields together and tab thru the report filling in data. We want to switch this over to the PC now but don't want to deal with the cost of Quark 8 for Windows, $800. Any suggestions on software that isn't going to set me back $500 - $1000? Don't need fancy... just basic..we're small...just want to tab thru it and print it.

More replies
Relevance 59.45%

I am trying to follow some instructions regarding Google Chrome. The instructions simply state #1 Open Google Chrome, #2 Click in the Google Chrome Form Field.
My problem is when I open Google Chrome I cannot for the life of me see anything that says "Form Field" or anything that appears to be a form field that I can click on.
Can anyone direct me to the Google Chrome Form Field?

Answer:What the heck is Google Chrome Form field?

Hello there,Form fields are the white boxes that you can type in. Just look for a white area where you can type in Alex

1 more replies
Relevance 59.45%

Hello World!On a web form I'm developing, one of my pc's shows the background to all fields as white (as I intended).However, viewing the same code on another pc shows the background to 3 fields (postcode, telephone and email address) with a yellow background. The same happens on the PCAdvisor sign in page where the email address background is yellow.What is causing this (browser behaviour) and can I prevent it?

Answer:web response form - field appearance problem

Helproom solved it - Google autofill was turned on.

1 more replies
Relevance 59.45%

Is there a way to set the value of a fileupload field programmatically (not requiring user input)?

Answer:setting the value attribute of a fileupload form field

What are you talking about? Exactly what do you want to do?

We need more info to try and answer that. Like what programming language, and if you're talking about on a form or in an app or what.

1 more replies
Relevance 59.45%


On the form that I have on my Access Database, I would like to add a field in the form so that I can do a search by ID # and hence pull up the information for the record matching this ID #.

I am somewhat familiar with Access. I would really appreciate any help that you could provide.




Answer:Creating a search field in MS Access Form

Doesn't the form wizard automatically give you the id field to type into? Are you saying you want a dropdown box instead of the regular field-type box?

3 more replies
Relevance 59.45%

I have been put in charge of creating a database to record all of our quality audits on parts. (a simple part inspection)

Most info will be entered into the Audit form named frmAudit. However, if the parts fail inspection another form is opened from frmAudit called frmNCM.
All the info entered into the NCM form needs to be linked back to the audit form. So, my NCM table has a field for AuditID.

The problem is I can not get the NCM form to open and automatically fill in the AuditID in the NCM form from the Audit form.

My current code:

Private Sub btnNCM_Click()
On Error GoTo Err_btnNCM_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmNCM"

stLinkCriteria = "[AuditID]=" & Me.[AuditID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit Sub
MsgBox Err.Description
Resume Exit_btnNCM_Click

End Sub

Thanks for the help

Answer:MS Access Open form new record ID field

6 more replies
Relevance 59.45%

Hello All,

I am fairly new to Access and can really use some help here. I have a form with a field "PO Number" that needs to be a required field before my user can use the print button.

All the other ideas I have seen seem to be very complicated to me as I do not do VBA and I am using a button with a macro that saves the form and prints the report. The form is a Sales Ticket.

All I want is to require the field "PO Number" to be required before it will save or print the report from the form.

Thanks in advance for any and all assistance.


Answer:Solved: Required Field in Access Form

16 more replies
Relevance 59.45%

Hi all,

I need some more help with a form in Access. I used the wizard and created a form with all fields I thought I wanted. Now I want to add another field (item from the field list) from a table in my database. I cannot find a way to update or change the field list of my form once I have created it.

It is the same form I had help with last time (an overtime tracker). I select an employee from the list who has his salary info saved in the employee table. When I select the employee in my form, I want to display his salary in another text box so I can use it for calculations.

On a similar note. I updated the table that my form is based off of and renamed a column. Whenever I open the field list in my form, the same column heading remains even though it exists nowhere else in the database. How do I update the field list?

Any help would be appreciated. If you need more info please let me know, thanks.

Answer:Solved: Adding field to Access Form

10 more replies
Relevance 59.45%

Dear all,
I don't know how to elaborate my problem. But what i wanted to know is Eg, i got a master sales type table [ ID, orderTYPE , OrderNo] which is related to sale table [id, ordertype, orderno date] in a relationship of 1 to many.
SO, how can i insert 2 fields (ordertype and orderno) into a form in which i would select the ordertype from the Sale Type table by combo box and it will auto-shown the orderno which is in sale type table. Meaning that i would need the sale order no to be like YD (ordertype) 1(orderno) , YB.1 and so forth.The orderno in sale table is duplicated as well as the ordertype.
Hope u help me out.

Thanks a lot.

More replies
Relevance 59.45%

Heres how to make a TICK work in a word form instead of a check box.

Set up your form as normal

Add the text form fields where you want and use this macro to put a tick in the field. If you want the "boxed tick" symbol then change the CharacterNumber to = 3842

If you want bigger ticks just change the font size.

It?s a good idea to set the macro as a tool bar button if lots of ticks are needed in your forms etc
Remember to lock the form before starting.
Sub tick()

' tick Macro
' Macro recorded 29/06/2011 by J Hayward
''Unprotect the file
If ActiveDocument.ProtectionType <> wdNoProtection Then
ActiveDocument.Unprotect Password:=""
End If

Selection.Font.Size = 12
Selection.InsertSymbol Font:="Wingdings", CharacterNumber:=-3844, Unicode _

'Reprotect the document.
If ActiveDocument.ProtectionType = wdNoProtection Then
ActiveDocument.Protect _
Type:=wdAllowOnlyFormFields, NoReset:=True, Password:=""
End If
End Sub

More replies
Relevance 59.45%

I have an Access form and want to search on a field that contains duplicate records. At that point the user could manually scroll through the records to find the one they need.

Does anyone know how this would work?


Answer:Searching in Access form on field with duplicates

16 more replies
Relevance 59.45%

Each time the Enter key is pressed while in a Word form field, it adds an extra line to the field. This ruins the layout. How do you stop the Enter key from doing this ( or how do you keep fields a defined size? )

More replies
Relevance 59.45%

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

I have a protected word document with form fileds. But I can't apply formatting to the content in the fields. How do I enable formatting for the form fields?

More replies
Relevance 59.45%


I have a doc which I have added the many checkboxes by using Check Box Form Field. Now I want to add textbox for others to enter text. I have added a Text Form Field to the doc but it is kind of hard to tell that there is a field in there. How I can make something like this:




so others can enter text above the lines only or making an enclosed box so others can only enter text inside the box?

Thank you for any help,


Answer:How to use the Text Form Field in MS Word 2000?

7 more replies
Relevance 59.45%

Hi there,
I have recieved several word files that have me stuck in form field view... I have tried toggling (Alt + F9) but still only see the Form field {FORMTEXT} If I print it the correct word/name can be seen, if I forward it to another person they can see it correctly. I have removed and reinstalled Office hoping that the settings would default back ( I am thinking I set something ) This also did not correct the viewing. I've compared my settings under tools/options to another machine who is not having this problem.. they are the same... there must be some (probably simple) thing/setting that I am missing. The IT people here at work are clueless to this as well. Help!

Answer:Word 2K Stuck in Form Field Mode

Ok found out the answer and thought I would go ahead and post it.
Close all word windows.
Start/Run/browse/C:\Program Files\Microsoft Office\Office\WINWORD.EXE
Right click on Winword.exe Select
you should be back in the Run box with the path typed out at the end of winword.exe" type the following /a (That's a space /a) Should look like this "C:\Program Files\Microsoft Office\Office\WINWORD.EXE" /a
Now run... it resets hidden settings.

1 more replies
Relevance 59.45%

I had 6 fields accross the top of my form that were automatically showing up on every page or tab of the form I replaced one field and now it will not show up on multiple pages like the rest of them do?

Answer:I want a field to show up on every page of a form I created.

Select all pages in your spreadsheet that should show the field, by holding SHIFT-KEY and leftclick with the mouse.Then create the field in the currently shown page and press enter.Now it should be shown on every page, you've selected.

2 more replies
Relevance 59.45%

Just created a Word (2000) form. One of the fields requires the entry of a start time, and is formatted as a Date field with format HH:mm. The next field requires the entry of an end time, same type and format. I would like the next field to calculate the elapsed time (hours as a decimal [e.g., 1.5 hours]. I tried entering bookmark names for the start- (Stime1) and end time (Etime1) fields, then putting in a calculation field with the expression "=Etime1-Stime1". Doesn't work; always displays 0.

How can I configure a form field to calculate the elapsed time between two other fields in the document?

More replies
Relevance 59.45%

I have a unbound field call "ND". in property sheet, the control data is set to = 20
I would like to change the 20 to 10 without going into design view. I would like to do it using a macro or event vba code.
Thanks for any input

Answer:Solved: chage value in unbound form field

6 more replies
Relevance 59.04%

I used MS Word to create an FAQ. I then used the Frames option (Format->Frames) to create a header frame and TOC frame. I now have a 3-frame FAQ, and I will be saving it as a web page. I now wish to include a search engine field in this project, but I am not sure how. I am thinking there is some kind of html coding I could apply to have this field appear once I convert to html, but I do not know the code. Can someone help me on this? Feel free to recommend a product if that is the only solution. Thank you.

Answer:Building a Search field in MS Word-html

11 more replies
Relevance 59.04%

Hi, I'm just exploring the Legacy Controls and Form Fields in Microsoft Word, and I'm having a problem that almost looks too dumb to put in writing, but that I can't seem to figure out!

When I insert a form field for text, and then restrict the document for editing, I want typing to appear inside the form field, and with the same formatting as I've set. Right now, when I restrict access and try to fill it in, it looks more like:


The typing inserts itself, but doesn't appear in the formatting I want (size, underline, etc.)

Is there a way to change this before I restrict the document for editing?

See attachment for a screen-shot of what I'm talking about.

Thanks in advance; this one really has got me puzzled.

Answer:Solved: Word Form Field Properties and Formatting

9 more replies
Relevance 59.04%


I am looking for some help on my code to lookup the largest incident # then add 1 to it when a new form is selected. I created a new record button on my form but would also like to have the new incident number populate when the new record comes up.

What I have is
Private Sub cmdnew_Click()
If Me.New Record Then
Me.Incident# (not really sure if I should put the field name here or not?) =Nz(DMax(Incident#, External_Theft),0)+1
End If
End Sub

Any help is greatly appreciated.

The field name is Incident# and the Table name is External_Theft

Answer:Access 2007 Increase Incident# by 1 in field on form

You may want to consider changing the name of your field since the # is used for dates in certain instances.

You could create a query to do Max(Incident#)+1 and then call that query from your forms onLoad event handler to populate the field you want with that number.

2 more replies
Relevance 59.04%

I have a control in a form that calculates the Gross Monthly Income based on amount entered in Annual Income (=IIf([AnnIncome]>0,[AnnIncome]/12,0)). Can the results of this expression be used to update the Gross Monthly Income field in the underlying table?


Answer:Access-Update field in table from expression in form?

10 more replies
Relevance 59.04%

Hi there,
I'm trying to export data from Word 2007 form fields into an Excel spreadsheet. I was hoping to have the spreadsheet contain data on a cumulative basis for the year or quarter at a minimum. Not sure how the code runs and if this is even possible. Does it scan a folder for all pertinent info to populate the spreadsheet?

Currently we are writing about ten of these docs a day and the data entry is becoming burdensome.
I have attached an example of the spreadsheet for reference.

I can provide specific examples of file paths or folder names if that becomes necessary.

Any assistance is greatly appreciated!


Answer:Exporting Word form field data to Excel

Here's the word doc with form fields associated with the spreadsheet.


2 more replies
Relevance 59.04%

Hi There

To make a long story short say I have a table called Table1 with only 3 currency fields called Deposit1, Deposit2, Deposit3 and TotalDeposit. I then create an input form based on Table1. On the form, In design view, I use all 4 fields. On the TotalDeposit field on the form, I do a calculated field as follows:


I then populate the 3 fields with currency - $100, $200 and $300

On the form the calculated field shows a total of $600. However, when I go back to the table, the TotalDeposit field has a zero? How come? How do I get the calculated field on the form to appear on the table??


Answer:Access problem in calculated field on form to appear in Table

Hi Mario

How exactly have you set your TotalDeposit field to be populated with the sum of the other three fields? That is - where have you typed [Deposit1]+[Deposit2]+[Deposit3]?


2 more replies
Relevance 59.04%

I've been working on a database to save subscriber & ticket information for my community non-profit theater group. After lots of trial and a ton or error, I like what I have, but determined that I need to change the way I store some of my data. This required the addition of a text field which has a list of 3 lookup values. I added this to the table in design view--no problem.

The problem is in the forms I've already generated. I went to design view for my form and put in a combo box for this new field. The wizard asks me what I want to do with the values: remember them for later or enter them into a field. I would like them entered into my new field. That's what this combo box is for. However, to enter them into a field, the wizard lets me select only from a drop down list of the fields available in that table, and it doesn't include my newly added field. I imagine that this is because the form itself was created before I added this field. I could recreate the whole form, but I spent a long time designing it, and all I want is to add the one new field. If push comes to shove, I'll start from scratch and do the whole form over again, but I can't believe there is not a way to do this.

If it's of any consequence, this form is actually a subform, but I'm attempting all the modifications to the subform on it's own, so I don't imagine that's got anything to do with this prpoblem.

If someone could please educate me I'... Read more

Answer:Solved: Access--new field in table & problem with form

8 more replies
Relevance 59.04%

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

I'm trying to make a simple form but one of the fields needs more complex validation than it allows me to do. Basically, the user chooses a material, enters the number of units and their combined weights. Another field calculates their average weight (total weight/units). I have a table specifying the range that each material's average unit should weight. I'm trying to make access validate the calculated average weight field (or something equivalent) according to the material chosen by the range specified in the other table.

I'd rather not forgo the table with the ranges by hard coding the ranges in VBA so that users could change the ranges.

I've put a relationship for materials from each table and display the range in the form but now I can't enter in a new entry.

I need help.

Answer:Access 2007 Complex form field validation

16 more replies
Relevance 59.04%

The OLE field on a form in Access 2002 SP-2 will only show the icon (can double click to open a photo) instead of the content, even though the "Display as Icon" box is not checked in the "Insert > object" instruction, and the field property is set to "content." This is on a new computer. The old computer had Access 2002 SP-1 and there was no problem with viewing the content of a photo in the form. I can copy and paste a picture from a Word document ok, but I have to explain that to others who use the database. Any help appreciated.

More replies
Relevance 59.04%

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


Thanx to many of you guys on here, I am inches away from completing my database. However, as always, there is something simple that fails me.
I have hidden all the tables, querys and I only have a switchboard form. (See Fig 1 & 2)

The switchboard form has buttons that has access to querys within the database. Alhough the switchboard window will always be displayed, I do not want any users being able to resize, reposition forms and buttons etc displayed on the switchboard form.
I must stress though, they will need access to the view icon in other parts of the database, but am I answering my own question here.
Is there a way of making the view icon within the switchboard form only being able to function if the button was pressed within a query search?

Any help appreciated

Answer:Switchboard Form re-sizing and Field Editing permitted

7 more replies
Relevance 59.04%

Sorry - I forgot to tell you that I am running MS Access 2003 SP2 on an XP machine


Answer:Entering Multiple values into an Access form field

Delete this thread by using the "edit" button & add this info into your other post.
It will only confuse people if your keep 2 running.

3 more replies
Relevance 59.04%

I have the following code behind the After_Update event of the textbox...

On Error Resume Next

Dim strName As String

strName = StrConv(Me.Name, vbProperCase)

Me.Name = strName

The code is used to make sure that the last name is in proper case. The code works fine as long as the last name is a typical name: smith, williams, doe, etc.

Is there a way to get the proper case to work properly with names like McMillian, MacSmith, McCord, etc.?

Answer:Solved: Access Form - Name Field (Proper Case)

15 more replies
Relevance 59.04%

Hi I am working on an existing database and trying to change the input method on a form to a combo dropdown box. I am trying to use the existing data in tblProjects and the data is in a column called "PM" I sort of have it working but instead of showing my "PM" data it is showing the data in the first column of the table???

Any ideas how to get this to work? It's been a few years since I messed with Access so I am a little rusty. I have included a screenshot.

Answer:Change form field entry to a combo box in Access

14 more replies
Relevance 59.04%

This seems like it would be a common task in Access but I can't find any reference to it.

I have a combo box with three choices, Kamazaoo, Grand Rapids, and Traverse City. The field name is location. The location is entered only once but there is no limit to the amount of records that can be added. When one record is finished Access defaults to the previous location and starts a new record.

I know how to do a make table query but can I do a make table query based on the fields value? For instance if the entry person is finished entering data for Kalamazoo a button could be pushed that would make a Kalamazoo table.

Building the Ultimate site list for PC support.

Answer:Make table based on form field in Access

16 more replies
Relevance 59.04%

I am creating an application using Access 2000, yuck I know! I have a parent form and child form with fields on it. I want to create a one page report that will show data from the main form and the child form (two different tables). I would like the query criteria to read the content of a field on the child form. I created a query for the report that works fine. Here is the current FROM and WHERE SQL:

FROM tblBasicRCData INNER JOIN tblNoticeChange ON tblBasicRCData.RecordID = tblNoticeChange.RecordID
WHERE (((tblBasicRCData.RCNo)=[Forms]![frmNoticeChange]![RCNo]));

This works fine for the RCNo which is on the main form. What I really is a field located on the child form (tblNoticeChange.ChangeID) that comes from the tblNoticeChange table. I can't make the report run without it asking me for the parameter.

I can't be the first one to try and automate a criteria from a child form. I can make it read data from the main form but not the child form. There must be a simple solution to modify my SQL.

HELP P L E A S E!!!!!

Answer:Access2000 - use child form field as report criteria

I feel ignored. Everyone must be too busy. I looked all over the internet and different books that I have along with the internal Access help and can't find nothing on the subject. I figured this would be something simple.

I looked through your message log and couldn't find anything either. I am getting a bit desprite I need to finish my by 4pm EST on Friday. I can't afford a major redesign at this point for one stupid field.

Pretty P L E A S E!!!

2 more replies
Relevance 59.04%

I have a Date field in a Form. I want the Date to be appear in red when it is more than 6 months older than today's date. Where and how do I make that happen?

Answer:Access 2010 Date Field in Form Macro or ()Iff ??

10 more replies
Relevance 59.04%

Hi Database supporter(s)

I need your help.

I’m not used to work with the OpenOffice (3.2.1) database Base and the Forms, so this is my problem, that I need you to help me with:


I want to register all my shopping-payments (using the receipts from the stores) in a Database, for later analyze. I want to find out where and when I spend my money and to what purpose, my shopping habits.

So I create 3 tables:

Table: Shopping_Payments (items)
Field: ID (INTEGER), automatic value, primary key
Field: Date (DATE), the date when I bought the item
Field: ShopID (INTEGER), The shop where I bought the item, reference to the ID field in the Shop table. It’s a list of the stores that I use.
Field: Price (NUMBER), the price of the item, DKR with no decimals
Field: ItemCategoryID (INTEGER), The category of the item, reference to the ID field in the Item_Category table. Ex. of category could be ecological food.
Field: Description (VARCHAR, 50), if a description is needed else empty

Table: Shop
Field: ID (INTEGER), automatic value, primary key
Field: Name (VARCHAR, 50), name of the shop
Field: Description (VARCHAR, 50), if a description is needed else empty

Table: Item_Category
Field: ID (INTEGER), automatic value, primary key
Field: Name (VARCHAR, 50), name of the item category
Field: Description (VARCHAR, 50), if a description is needed else empty

And this is how I would like to enter the data:

All data is entered via a multi row Form (Shopping... Read more

More replies
Relevance 59.04%

I'm trying to create a word doc with text form fields. I have them in the doc but I want them to remain the in the same location after I type in each box. Currently when I type enough characters in the box the next text form box moves to the next tab location. How can I make each box "freeze" where it is before I start typing in it? Any Suggestions?

Answer:Word 2007 - Text Form Field Help Needed

Embed the form field inside a frame. You can then set the frames border so that it is invisible so that it can't be seen.


1 more replies
Relevance 59.04%

I have created a database in Access 2007 with 4 tables, Customers, Products, Orders, and Order Details (the specific items for each order). I know you don't want to dupliate data and "calculated fields belong in reports and queries" but we change the prices frequently and I need the UnitPrice from the Product Database to "update" to the Order Details Table on the day the order is input.

I have a Order Input Form with 2 sub-forms and my relationships are set one-to-many on primary keys. All other queries and forms work great. I have tried looking at the Northwinds database to determine how they do an "AfterUpdate" event procedure but I haven't used VBA since Access 97 and am not able to convert it for use with my form.

Help is appreciated!


Answer:Access 2007 Update Table Field from Form

Cosla, have a look at the database that I posted here
at post #5.

3 more replies
Relevance 59.04%

I was cleaning up my system today and while at it I decided to get rid of Foxit reader too. So I discovered Sumatra pdf reader and I love the simplicity. But it has only one flaw - It won't allow me to write in form fields in pdf files which made me reinstall Foxit reader. So are there any alternatives as light-weight as Sumatra but with this function?

Answer:Sumatra-like PDF reader with interactive form field capability?

Are you a Chrome user?

5 more replies
Relevance 58.63%


we have never been able to navigate the church web site ( with the Juno browser or IE. And I get these wierd URLs a lot when I am navigating around various sites. I get the 'Page Cannot Be Displayed' message -

Cannot find server or DNS Error
Internet Explorer

Here is an example of what happens in the URL field:



I'm running XP.

Do you have any idea where I should start troubleshooting?

Answer:can't navigate - results.html coming back in URL field

AdAware SE
SpyBot S&D

DL them (they are free), install them, check each for their definition

updates and then run AdAware and Spybot, fixing anything they say.

THen run HiJack This and post a log - DO NOT FIX anything

2 more replies
Relevance 58.22%


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

Hi All!

I have a form that calculates an employees current age in a Text box (based on today's date and their date of birth). I created the form to act as an 'entry' form for new employees in an HR database.

I have a field called 'age' in a table that I would like to populate with the result of this formula. How can I do so when the 'Control Source' property of the text box on the form is holding the formula!? That's where I would normally link it back to the table!

Thanks in advance for any help!



Answer:Can an access table field populate from a calculated cell in a form?

You use simple VBA code in the Date of Birth field's After Update Event Procedure and set the Age field's Control Source to the table field to store the data.

1 more replies
Relevance 58.22%


Could anybody help out with MS Access 2007?
Is there any way that the prompt parameter value which is entered to generate a report is captured somehow and its value is passed to be displayed in a form's field. The report is generated from this form.

Specifically, the form has a subform (datasheet). One of the columns is Date. This subform is populated throughout several days. User needs to generate a report that includes the data from this subform every day (or every other day). User enters Date as a Parameter Value to filter data to a report. User does not remember what is the last Date for which report was created.

If a form's field will display the last Date for which report was created this would be solution.

More replies
Relevance 58.22%

MS Access 2003 crashes after I add a new record and try to edit any form field. I can add a new record in the underlying table and then go to the form and edit any field. Can't catch the error with a breakpoint either - it seems the new record is not being initialized properly from the form that creates it.

Other forms in the same database do not have this problem. No server or network or sql involved with this database.

(Microsoft Office Access has encountered a problem and needs to close)
AppName: msaccess.exe AppVer: 11.0.8166.0 AppStamp:46437912
ModName: msaccess.exe ModVer: 11.0.8166.0 ModStamp:46437912
fDebug: 0 Offset: 0020ba36
Tech Support Guy System Info Utility version
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, 32 bit
Processor: Intel(R) Pentium(R) D CPU 2.80GHz, x86 Family 15 Model 4 Stepping 4
Processor Count: 2
RAM: 499 Mb
Graphics Card: Intel(R) 82945G Express Chipset Family, 128 Mb
Hard Drives: C: Total - 147644 MB, Free - 64485 MB; D: Total - 4963 MB, Free - 2775 MB;
Motherboard: Intel Corporation, D945GBI, AAC99325-202, AZBI52800690
Antivirus: avast! Antivirus, Updated: Yes, On-Demand Scanner: Enabled

Answer:MS Access 2003 crashes after I add a new record and try to edit any form field

9 more replies
Relevance 58.22%

I have the cursor jump problem in my Dell laptop with Vista Home Premium. Granted I have a wireless mouse but when I unplug it the problem of the cursor jumping persists whether I restart the computer or not. It jumps from the form field to the address bar mostly. This appears to be an explorer related problem because the cursor will NOT jump if I'm typing in yahoo messenger or notepad BUT it will jump in firefox etc. In addition, all the icons will flicker on and off (not the monitor setting so please don't bring that up.) If I'm lucky and hit esc they'll stop long enough for me to bring up a program. I work around when it really gets bad by typing in notepad and copying and pasting to the field I'm filling out, sometimes it can even be so bad that it's the address field in a web browser. I have a registry program, I've defragged recently, I have a driver update program. etc. If it's the keyboard then why would the icons on the desktop rapidly blink. It is not the monitor so please don't go into that.

Answer:Cursor Jumps from form field to address bar in Dell Laptop


Run an complete anti virus scan

Download and use malwarebytes (do it weekly to avoid future problems)

Try in safe mode (report back to us)

Read and try these suggestiions

Mouse Jumping All Over Screen This link is very old, the names may have changed but the principles are the same.

Good luck

2 more replies
Relevance 57.81%
Question: HTML Source

When I click on View and scroll down to source, I no longer can see the HTML Source of a web site - how can I remedy that?

Answer:HTML Source

Is View Source Disabled or does nothing appear in when it's loaded into NotePad?

3 more replies
Relevance 57.81%
Question: HTML Source?


I am in need of a very simple program but I have no idea as to where I should start.

Essentially, I need a program that can take a website from a list, [One that displays different stats] and pull a specific element from the source code into a separate excel file and then move on to the next link in a loop. I don't need the element itself, but rather the number contained within the element.

(Here's the website)
(Here's the source of one of the stats, HP) <th style="background: #FF5959; width: 30px;"> 60 </th>

In this page's case, I would need the 6 different stats extracted under the "Base Stats" table taken out and placed in a table on a spreadsheet. *HP, Attack, Defense, Sp. Attack, Sp. Defense, and Speed*

Is this at all possible?

I've been told there might be a way to do as such with VBA, but with work and a very tight schedule, learning an entirely new programming language does not seem feasible.

[As a bit of context, my son has gotten into a game called Pokemon and has involved me in playing. Being very analytically minded, he wanted to know which of the characters are the strongest and which are the weakest. This being said, we found a website containing stats on all of them and, since I'm teaching him Excel, I figured it would be a great way to introduce him to statistic analysis. The only problem is I am unable to gather the statistics in an ... Read more

Answer:HTML Source?

I'm sure there are ways to do it, but this is probably the easiest.émon_by_base_stats_(Generation_VI-present)

3 more replies
Relevance 57.81%
Question: HTML Source?


I am in need of a very simple program but I have no idea as to where I should start.

Essentially, I need a program that can take a list of URL's, [Profiles on a website] and pull a specific element from the source code into a separate text file. I don't need the element itself, but rather the number contained within the element. (Here's the source) <span id="dollarvalue">32</span> In this case, I would need the "32" taken out and placed in a text document.

Is this at all possible?

Thanks so much for your time,

Answer:HTML Source?

13 more replies
Relevance 57.81%

I am currently looking to gather more information on a company I believe may be attempting to scam my volunteer organization. I don't want to do anything illegal, but I want to find out more contact information about this group.

Is the web form I'm looking at. How do I find the source code for the web form so I can see where the information is sent and stored? Is that illegal?

Answer:Web form source code

1) Download Wireshark

2) Start a capture on your NIC

3) Fill-out the form and click send on the website

4) Look at the tcp packets to determine where it is being sent.

I'll go ahead and save you the trouble. It goes to their web provider who is Network Solutions.

Their IP for that website is

4 more replies
Relevance 57.81%

I have a form that I'm using to enter orders for inventory. I just ordered 2 phones I'd like to have listed as 2 separate records (they will be physically tagged individually, so they need to be separated in the table).

I'd like to have a Quantity field that when I type a number and save the record from the form, the number in the Quantity field adds that number of identical records (aside from the Autonumber field for the primary key).

Is this possible? If not, how should I go about it?

We have larger orders, sometimes 10-20 items, all with the same everything in the record except for the physical tag number that will be applied to each item when it comes in.

Thanks in advance.

Answer:Access 2010: Form quantity field that adds records to table

If the form is for entering the actual order details then you shouldn't have a record in the order table for each item in the quantity field.
What you could do is is to add a record for each item in the quantity field in the Inventory table using the Item's ID to identify it.

1 more replies
Relevance 57.81%

Hi, I would like to display a message box when a total on a subform does not match a field in the main form.

I have a form (FormA) with a subform (SubformA)

I need to compare the total on subformA (located on SubForm A footer) with a field on FormA

I am entering a number on the subform and in the On Exit Event I entered me.requery to requery the data and update the total in the footer - then I entered the code to compare the two numbers

This is the code I am using (edited):

If [FormA field] <> [SubformA total] Then
Msgbox ("Amounts Do Not Equal")
End IF

The problem I am having is the refresh time of subformA footer - the field takes longer to refresh or requery (I tried both) and the message box displays even when the numbers are equal

Thanks in advance

Answer:Access 2007 Compare subform total with field on main form

6 more replies
Relevance 57.81%

Dell Inspiron 8100 WinXP professional, sp2 (need to update)
30gb hd, Intel Pent 3, 572mb ram, mobile cpu 1000mhz
Office XP sp3 professional edition

Hello All!

I hope someone here can help me out.

I am entering contacts from a roladex into OLXP. These contacts are for business only, not personal or HOME numbers. When I am entering a new contact, there is usually no need for the HOME number phone field. Therefore, I would like to change the initial view/list of phone fields...from BUSINESS, HOME, BUSINESS FAX, MOBILE to BUSINESS, BUSINESS 2, BUSINESS FAX, MOBILE.

Now I do know how to create a new custom form and field and to design and publish it. BUT the phone selctor and phone selected fields are more tricky - unless I'm missing something very simple - who knows.

Does anyone know how to change the initial phone listing that is displayed?? This would really improve the flow of input.

Thank you for reading my post....and hopefully helping me out


Answer:OLXP custom contact form-change view of phone field

dunno wether this is the same of OutlookXP, but in Outlook 2003 you can change the layout of the forms by oping up a new contacts form then choose from the menu, Tools > Forms > Design This Form > change & remove what you need then save.

3 more replies
Relevance 57.4%

I am buliding a website using html and have made questionaire but i need to display results as a graph on a seperate results page and need to know how to do this using html.

Answer:I need html source code

You will have to pass the data from you form questionnaire to code or page in another language to do the processing such as PHP, JavaScript and ASP. It will also help if you have a MYSQL database to store results in.However there are some free scripts about that you can install.. providing your host allows you to do so. I have had a quick look around but most of the the scripts I found were for single question opinion poll, I get the impression you want several questions to be answered, and these are a bit harder to find.. however heres one I found click here , there probably are more I just haven?t had time to look maybe you can use search engine to search for ?free survey scripts? etc.Only draw back is that these can be very hard to install and sometimes incompatible with the server you are hosted on, but don?t let this deter you.

2 more replies
Relevance 57.4%

I am trying to add some affiliate programs to my site. and having a problem getting the image to show up and the link to work. After several emails to their tech support, came here! This is the HTML that I copied/pasted. (Clicked on the area I wanted the image, then went to 'design/split' view, and pasted the HTML in.)

<a href="" target="_blank" >
<img src="" width="160" height="100" alt="Companyname.Com" border="0"></a>

Their support told me I had to "add the HTML to the source code", and I would have to get that info from my domain host?! Can someone please tell me what is wrong? I do not know HTML, other than the basics. I really want to get this working, is there some code I need to add before & after the above html?
OS is WinXP
Built site using FrontPage 2003. Going to learn HTML!!!-downloaded HTML-Kit awhile ago.
Thanks for any help

Answer:How do you add HTML to Source Code

13 more replies
Relevance 57.4%

i am buliding a website using html and have made questionaire but i need to display results as a graph on a seperate results page and need to know how to do this using html

Answer:Need html source code

You'd probably be better off asking this in a web forum like:SitePoint click hereorHTML Forums click here

2 more replies
Relevance 57.4%
Question: Html Source Code

when I try to print anything from off the web I get very fine print over 7 pages (approx) which I have been told is html source code. Could anyone please tell me how to change it to normal print. Thanks

More replies
Relevance 56.99%

I have a table with a field called "current fund balance" which is intended to be a data entry field. I have a query with multiple calculated fields. Both the table and query share a common field. I'd like to have a datasheet form to where data from the query and table are combined and have that field "current fund balance" be a data entry field. I'm having the hardest time figuring this out.

I've read a form/subform would work but I need to be able to see all the records at once. And so, datasheet with all fields would be best. Anyone have any thoughts?

Answer:Solved: Having a form field in Access to enter data based on a query with calculated

16 more replies
Relevance 56.99%

I have 2 buttons, New Record and Duplicate. When these buttons are clicked on, I want the cursor to move to the Employee ID field after executing the command. Can anyone help please? If it is just a bit of code can you tell me exactly where to put it? Any help would be greatly appreciated!!

Answer:Solved: Move cursor to required field when form is complete, access 2007

Solved this myself. I created a macro at the end of the Buttons Embedded Macro 'On Clilck' event. Macro:

GoToControl cbotextboxname

Works like a charm.

3 more replies
Relevance 56.99%

Hi fellow PCReviewers

I'm having difficulties with my Word 2007 form. I have set it up to allow fields to be populated and have the sum total appear in another field. Unfortunately I am having no success in regards to the total automatically updating as data (numbers) are being populated.The F9 fails to update the total as well.

I have checked and double checked the properties and it all seems fine to me, ie, data fields all set to "calculate on exit", the total sum field is not set to "calculate on exit" and the calculation formula reads =Text1+Text2+Text3+Text4 i've even used =sum(Text1+Text2+Text3+Text4) without success.

As a footnote, I am able to open a former 2003 Word form and it does behave correctly. The form outlined above was created in W2007.

Can anyone help me please

Answer:Word 2007 form calculate field fails to udate when data entered

3 more replies
Relevance 56.99%

Firstly, let me apologise, I'm a complete Access noob & am trying to teach myself as I've got no one to help me in person.

I'm trying to build a Time Sheet database that should record daily duties via an entry form:

This form updates an underlying table:

The date field of the "Work_Hours" table is:

However, workers get paid fortnightly and all their entitlements, allowances & overtime are calculated on these fortnightly periods. To be more specific, the workers are paid for a certain amount of overtime for each fortnight upfront & when they exceed that, then they are entitled to all excess time back in TIME OFF. So it's pretty important that each day's duties are assigned to the correct fortnight period so that their overtime & so-forth are calculated correctly.

Each fortnightly period is numbered according to year. For example, each year there are 26 fortnightly periods, so as an example today (3rd October 2013) falls in period 2013-19 (23rd September 2013 to 6th October 2013).

I've created a table called:

Which has the following Fields:
"ID" (Auto-number)
"Period_Start" (date - the first day of each new fortnight period)
"Period_Number" (number - eg: 2013-19)

Back in the "Work_Hours" table, I inserted a new (Number) FIELD called:

and set ... Read more

Answer:Solved: MS Access - How to get a field auto-update based on date entered in a form

9 more replies
Relevance 56.99%
Question: HTML Form

Hi. I am a begginer webmaster(!)

I was wondering if any master-coders out there could help me with a form i was building. There are two problems on it. When you hit submit, it runs posting via Outlook or Outlook Express which in turn asks the sender if this is ok and warns him it is a nor secure connection. I'm feeling this is worrying potential buyers. I'm sure there must me a way to send this info without using a mail provider.

Another problem: I have just added a new funky way of ordering, using an add button to move the selection accross to another box, but these selections are not sent along with the rest of the form.

Please help. Paul.

(PS) I will add the form as an attatchment if requested.

Answer:HTML Form

10 more replies
Relevance 56.99%
Question: form name in html

1-what is the advantage of giving a name to form;

2-if i use this name either this is declared as an array or not.
i am using infact php

<form name="web[]">
<input type="text"name="abc">

Answer:form name in html

YOu only need to name the form elements if there is scripting that needs to reference that element name for some sort of processing. Passing variables from one page to another is a good example.

2 more replies
Relevance 56.99%
Question: HTML in XML Form

I used XML in HTML.But is it possible to use html tags in xml.

regards shine

Answer:HTML in XML Form

Let me give you a list of my tutorials and a place to take classes for free (besides learning here).

Tutorials for html:

Specific Tutorials: (this is a frames tutorial) (finds fonts) (tables tutorial) Photoshop Tutorials (Java script) (for almost any code)

This is a very good site for almost anything about web
and web devlopement, including the free classes:

Color sites: Read more

1 more replies
Relevance 56.58%

I wonder if you can help me. I can right-click and get the menu, but now when I select View Source nothing happens. Same if I go via the View menu. This even happens on my own pages so I know there isn't some javascript in there somewhere which is causing it. Any suggestions?your help, as always, much appreciated!

Answer:can't view source html - what am I doing wrong?

Try looking in the Program options in Internet Explorer (Tools, Internet Options, Programs) and see which program is set as the default web page editor.Have you fully cleared your temporary Internet files ?Try clearing the cache as this sometimes, on some systems, affects the view source properties of the browser.This is a solution I read about online but I've not tried it so I've no clue whether it works or not:1. Close any instances of IE. 2. Create this registry key if it does not already exist (chances are it does not exist):[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\View Source Editor\Editor Name] 3. Modify the Default value of the "Editor Name" to the path of the program you want to use to view source code. For example, "C:\Program Files\Accessories\wordpad.exe" or "C:\Windows\notepad.exe"I have my suspicions of that method.An MSDN page for those who need to change registry settings for View Source click hereMicrosoft Knowledge Base Solutions:click hereclick hereclick hereandclick hereHope one of them helps.RegardsTaran

5 more replies
Relevance 56.58%

Hi again (FE? ade? anyone on NOF?) I've inserted cut and paste html date into the html source but it's not where I want it - I want it underneath the banner not at the very top of the page. Could someone tell me in which bit of html I should be pasting it? ( or is this not the right way to do it?) Thanks. PS Please don't knock the site yet; it's only in its early stages and I only published it so you could help me change the date!click here

Answer:moving my date in html source!

I want it under the writing 'geography dept website'

5 more replies
Relevance 56.58%

Maybe I ate too much turkey yesterday and haven't had enough coffee today?

I just started using Firefox and when I View/Page Source I can't edit my HTML files. I used to be able to edit HTML with Internet Explorer.

What am I doing wrong?

Thanks and have a great holiday weekend.

Answer:Edit source of HTML file

Internet Explorer uses NotePad to view the source of a web page. Since NotePad is an application that can be written to, it can also be used to edit the file. Firefox just uses an internal viewer to look at the source. It cannot edit it. There are a couple of ways around that:

* Right-click on an HTML file stored on the hard disk and choose to open it in NotePad (or other editor). Edit the file and save it.

* Install the 'ViewSourceWith' extension and it set up with a source editor your choice (NotePad or other). With this done, right-click on an open web page. Select 'View Source With' from the menu and open the source using the chosen the editor. Edit the source, save the changes and them refresh the page.

2 more replies
Relevance 56.58%

Anyone have any ideas on this one, please?I have 2 PC's, both running ME. On one, I can right-click on a web site, choose "View Source" and see the source code displayed.On the other, on the same site, clicking on View Source does nothing.Any help gratefully received!Tizzle

Answer:Cannot view html source code

Tools, IE Options, Programs. Take a look to see if Notepad is availabe there as the source code editor. If not, that may be the cause of the problem.

1 more replies
Relevance 56.58%

I cannot edit the source code of my HTML pages. I am able to view and edit the code in notepad, but the computer then fails to save the changes. It is, however, possible to save the changes when I edit the source code on my other pc over the network.

More replies