Computer Support Forum

Word - Text Form Field

Question: Word - Text Form Field

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?

Relevance 100%
Preferred Solution: Word - Text Form Field

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

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

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:\\Source.dot" AA} and {IncludeText "C:\\Source.dot" 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,

Stuart
 

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

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

Answer:MS Word 2003 Text Form Field

9 more replies
Relevance 103.73%

Hi,

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,

Peter
 

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

7 more replies
Relevance 102.5%

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

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.

Regards,
Rollin
 

1 more replies
Relevance 101.27%

Hi,

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

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
00:01
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?
TIA
 

More replies
Relevance 79.95%

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

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

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 _
:=True

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

More replies
Relevance 79.95%

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

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

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:

____asdfjkl;_________________

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

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

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!

Thanks!
Cameron
 

Answer:Exporting Word form field data to Excel

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

thanks!
Cameron
 

2 more replies
Relevance 76.67%

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
Cheers
Mark
 

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

https://www.pcreview.co.uk/forums/word-2007-form-fails-auto-calculate-total-t4049234.html
 

3 more replies
Relevance 75.85%

I am looking to create a MS Word 2003 document for work that has a text field that has a character limit to it and I can't seem to find anything in Word that does that. I know it is possible, as we have various documents corporate HQ has us use that has text fields with character limits on them. Does anyone know where I can find this in Word 2003?

Thanks
 

Answer:Text field w/character limit in MS Word 03

7 more replies
Relevance 75.03%

Hi everyone!

I'm sure this is probably something very simple that I'm missing...

I am creating a document template for a specific document type.

I have two rich text controls added to a document via the developer tab.

The first is the document's number in a series of documents to be created. The second is the actual document title.

In the footer area, I want these to be shown in reverse - i.e. the document name, then the document's number, so I am making it very easy to check the number of the document when flicking through a physical folder.

I tried to do this with bookmarks and cross-referencing, but the bookmarks are not saved when you create a new document based on that template.

I tried with a macro, but after recording the macro, it didn't really do what I wanted.

Is there an easy way to get this working? If not, is there a way I can assign names to the rich text controls in my template to run a macro more efficiently?

Answer:Word 2007 dynamically updated text field

See Word Variables etc. Editor which will allow you to easily map content controls to achieve what you want to do.

1 more replies
Relevance 75.03%

Hi everyone!

I'm sure this is probably something very simple that I'm missing...

I am creating a document template for a specific document type.

I have two rich text controls added to a document via the developer tab.

The first is the document's number in a series of documents to be created. The second is the actual document title.

In the footer area, I want these to be shown in reverse - i.e. the document name, then the document's number, so I am making it very easy to check the number of the document when flicking through a physical folder.

I tried to do this with bookmarks and cross-referencing, but the bookmarks are not saved when you create a new document based on that template.

I tried with a macro, but after recording the macro, it didn't really do what I wanted.

Is there an easy way to get this working? If not, is there a way I can assign names to the rich text controls in my template to run a macro more efficiently?
 

More replies
Relevance 74.21%

We use Oracle's XML Publisher to generate reports. This is where an XML file is merged with a .rtf template to generate an output (usually PDF). We design our .rtf templates using Microsoft Word 2007. I have a need to print something in the same position on the last page of every report (in this case.. customer invoices). I am placing this logic in the footer so it will print in the same position. I also have logic in there that determines when it is the last page. It isn't working and I need some help. Right now I have { if {NUMPAGES}>{PAGE} "Not Last Page" "Last Page" }. I am getting "Last Page" on every page. (This isn't the wording that I really need to go there, I was just testing this functionality). I read an article from Microsoft Support (Article ID 211755) that says this is supposed to work with version 2000. I'm hoping it is still valid for 2007. If you have accomplished something like this or can help me I would appreciate it.
 

More replies
Relevance 72.57%

I have a user with a Word doc that has fill in form boxes, when the doc is opened the words "form text" appear in a box where the text should be entered and she is unable to enter data. I know I have had this problem before and fixed it in the registry but I don't recall off-hand how I did it anymore. Any ideas?
 

Answer:Word form text boxes

The code has that entered as the default text for the text area. Go into the form code and do a search for those words.
 

3 more replies
Relevance 72.57%

I have a protected document that is showing up fine on every system on a network...but on one system the {FormText} and {FormCheckBox} only show up with the field name now an entry box. Reinstalling Word 97 or 2000 doesn't help. Any Ideas?
 

Answer:Form Text or Checkbox in Word

Even with a reinstall Windows remembers settings in Office unless of course you reformatted the system.

Open a blank document then look under Tools, Options, Views Tab. Make sure the "Field Codes" is not checked. If it is, clear it and open your protected document to see if the problem has gone away. You'll most like need to save the changes on the blank document if you had to change the Options settings.

Hope this helps.
 

2 more replies
Relevance 71.75%

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

More replies
Relevance 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...

Tony
 

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

Hi.

I have a form set up in a table and I would like to have the text fit into the cell and not go below the cell. I have set the maximum length of the field but this does not really work for me. I have set the row to an exact height so it does not expand. It does not limit the number returns. So, you can hit the return key the text disappears in the cell (goes beyond the length of the cell)

Setting the maximum length does not allow be to fill the cell completely. If you type all caps the maximum length maybe 100. If set to this then all lower case letters will only fill half the cell.

Is there a way to only allow the user to type in the fixed sized table cell and fill it up completely without the text disappearing beyond the border of the table cell using VBA or some function in Word?

 

Answer:Word Form - text to fill in table cell (VBA)

9 more replies
Relevance 70.93%

Hi.

I have a form set up in a table and I would like to have the text fit into the cell and not go below the cell. I have set the maximum length of the field but this does not really work for me. I have set the row to an exact height so it does not expand. It does not limit the number returns. So, you can hit the return key the text disappears in the cell (goes beyond the length of the cell)

Setting the maximum length does not allow be to fill the cell completely. If you type all caps the maximum length maybe 100. If set to this then all lower case letters will only fill half the cell.

Is there a way to only allow the user to type in the fixed sized table cell and fill it up completely without the text disappearing beyond the border of the table cell using VBA or some function in Word?


 

Answer:Word Form - text to fill in table cell (VBA)

I'd go for the simple approach - set the font of the field to Courier or another mono-spaced font. That way, all characters take up the same amount of space.
 

2 more replies
Relevance 70.52%

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

More replies
Relevance 70.52%

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

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

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

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

Thanks for any help!
 

More replies
Relevance 70.52%

Hey guys,
I have a client who has Macros code/text showing up on all her custom forms. The forms display fine on other Office Installations, but on her pc they show wierd code in the header / footer / fields ..
I've repaired / debugged the installation without success. Here is some of the type of txt showing up in a simple fax template form ::
header >> EMBED WPDraw30.Drawing
each field >> [MACROBUTTON]
footer >> { EMBED MSPhotoEd.3 }
any help is greatly appreciated !
thanks !
David S.
 

Answer:Solved: Word 2007 form errors / macros text

sorry guys, I think I just resolved the issue ...

[ Advanced > show field codes instead of their values >
Cheers !
 

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

I need a date field changed into a text field of YYYYMMDD so for example the date of birth field is 3/17/1953 and I need that converted to 19530317 in the Excel spreadsheet. Thanks.

Answer:I need a date field changed into a text field of YYYYMMDD

under the format options.

5 more replies
Relevance 68.06%

I support a software program that has a proprietary menu item when you right-click a calculated field. It has been this way for 10-15years and has worked in WinXP through Win10 with never an issue. This past week I had 3 different customers tell me that when they right-click one of these fields to access what is normally the Cut/Copy/Paste/ menu that also includes our menu item, they are now getting the Windows default cut/copy/paste/Right to Left Reading order/Show Unicode control characters/ etc menu. The only thing I can think of that they all have in common besides these are all Window 10 64bit pc's, is that they all have one update to Adobe Acrobat (17.012.20098).
I was able to resolve for a moment on two of these workstations by having the user go into Language/Advanced settings and actually selected "English (Unites States) from the "Override for Windows display language" even though that settings is implied by the "recommended". But after the pc was turned off over night and back to it the next day, the problem is back and that setting is still selected. All language and regional settings on all the pc's are defaulted to English/Unites States. I do not know what other avenue to go in. Could something hae been switched on or off in Windows (by this Adobe update perhaps?) that would make the context text menu switch to Windows text default right-click menu?

Any help is appreciated!
 

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

Hi all, 
I have a matter about placeholder in html. The placeholder will be disappeared when focus
on text filed with IE. But I want to keep hint text of placeholder when do that. Could you give me any suggestion?

More replies
Relevance 60.68%

Gents,
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".
Thanks
 

Answer:Continuous form field

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

Thanks
AMD2800
 

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

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 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.AddNew
rstDoctors!D... Read more

Answer:auto populate form field

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

Hello

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

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

Answer:Solved: chage value in unbound form field

6 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?
 
Thanks,
 
Harkcomp

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%

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.

Scooter1959
 

Answer:Solved: Required Field in Access Form

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

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

Answer:Solved: Adding field to Access Form

10 more replies
Relevance 59.45%

HELP, HELP, HELP!

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.

Thanks

Fatmah

 

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_btnNCM_Click:
Exit Sub
Err_btnNCM_Click:
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%

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

Thanks.
 

Answer:Searching in Access form on field with duplicates

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

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%

See the webform located at http://jasonmod.bondwaresite.com/webform.php?ViewForm=5 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.

Notes:
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.

Thanks,
Jason
 

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?

Thanks,
Jason
 

1 more replies
Relevance 59.45%

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

More replies
Relevance 59.04%

Greetings! I've searched everywhere for the answer to this issue. It must be common, but I can't find it anywhere. I'm using MS Word 2007, but the problem was the same in 2003. I sometimes get a text box that is behind regular text. I need to move it. One normally just selects a text box and drags, or cut and paste, it where one wants. However, when it is behind text, it can't be selected. I have found no way to select normal text and "send it behind."

How do I get to this text box that is behind my regular text? I've been told to "move the regular text out of the way, then you will be able to get to your text box." But the text box moves with text!

Thanks,

7nyerik
 

Answer:Text box stuck behind regular text in MS Word 2003 and 2007, Can't select text box.

You can't post a link to your computer to post an image. We cannot access your computer. Upload the png image as an attachment please. To do that, scroll down to "Manage Attachments" then click on "Browse" to locate the file on your computer then "open" it and then click on "Upload" and submit your reply.
 

1 more replies
Relevance 59.04%

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
 

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

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

Hi,

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
Erica
 

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%

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:

[Deposit1]+[Deposit2]+Deposit3]

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

Mario
 

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

Deej
 

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

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
http://forums.techguy.org/business-applications/931652-vba-ms-access-2007-a.html
at post #5.
 

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

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

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

10 more replies
Relevance 59.04%

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

Cathy
 

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

Thanks!
 

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

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%

Hi,

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%

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%

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

Hi,

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%

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

Welcome

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

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!

Cheers

Ty
 

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%

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

Answer:Convert Word form to Excel form

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

2 more replies
Relevance 58.22%

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

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

Thanks, Peter
 

More replies
Relevance 58.22%

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

Please help.

Thanks

Thee

Answer:Word Form Doc Printing Crap Instead Of Form.

?

3 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):

me.requery
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%

INFO FIRST:
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

Ruthann
 

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