Over 1 million tech questions and answers.

Suddenly can't type into form fields

Q: Suddenly can't type into form fields

Hello Group,

Suddenly I am unable to type into form fields.

I have to trick it by writing the text in an e-mail, copying that, then right-click and paste into the form field - even to login here I had to do that - nothing happens when I try to type into the field.

Environment: Windows 7 Home Premium
Asus PC

Hope someone can help. Thanks for looking in.

seekinganswers

RELEVANCY SCORE 200
Preferred Solution: Suddenly can't type into form fields

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

A: Suddenly can't type into form fields

Problem partially solved. Still have no clue as to why I could not type into form fields, even logons, google ... but a simple re-boot and now I can enter text into form fields. However, sporadically I lose control of positioning - sometimes the arrows stop working, and sometimes I cannot change position in the form by moving the cursor. What is going on?
Thanks for looking in. seekinganswers

Read other 3 answers
RELEVANCY SCORE 61.2

Hi all,

Was wondering if its possible using CGI or Javascript to fill in FormA and click on link to FormB and have certain fields pre-filled in FormB with information from FormA? (i.e. Name, Address, etc.) Thanks.
 

A:Form Fields

Absolutely....passing variables from one form to another.
 

Read other 2 answers
RELEVANCY SCORE 60.8

I am using Windows 2003 with Access 2003. I have a main form that uses fields from a table that I would call the Master table, and this form has several tab pages in it. In this form the 2nd tabbed page uses a subform which displays data from a different table (I call it the Job Number table). I have linked these two tables with a one to many relationship. One of the fields in the Job Number table is named "Contract Amount". So each job record in the Job Number table tracks a separate Contract Amount value, but it is linked to the Master table through the one to many relationship. My goal is to sum all of the the Contract Amount values for each linked Master record and display that amount on my 1st tab.

I have created a subform that uses a sumquery which sums the Contract Amounts from the Job Number table. I tested the subform and the sum feature against the live data, and it does perform correctly. I then added that subform into my main form on the first tabbed page along with other fields on the same tab page. These other fields come from the Master table. In the Data Entry view, I can see a box where the subform should display, but the data doesn't display. What can I do to force the subform to display data along side the other fields from the Master Table?

Thanks in advance for your help.
 

A:Display subform in a main form with other fields from main form

Read other 6 answers
RELEVANCY SCORE 60.8

Hi there, I've created a form on this form I've got a tab control(consisting out of page1 & page2) with multiple option buttons, text & combo boxes on these 2 pages.

When the user enters his data or selects his options and then click on the submit button I want that data to go to my table (already created with the exact fields).

I also need to create a counter for several fields ex. I've got a field college, campus and race.....now they would like to know how many females in college A with campus C there are.

Thank you,
 

A:From fields on form to table

What program are you using?
 

Read other 2 answers
RELEVANCY SCORE 60.8

I know how to use the Text Form Fields for templates in Windows XP but I have now upgraded to Windows 7 Professional and can't find this feature - is it still available in Windows 7?
 

A:Text form fields

Templates in what application?
 

Read other 2 answers
RELEVANCY SCORE 60.8

Is there a way to set forms up in Excel like Word? When I have the form toolbar open, the Text Form Field icon is grayed out. Thanks for the help!
 

A:Excel Form Fields

There's no Text Form Field icon on Excel's Forms toolbar, it's an EditBox button. It's greyed out because it can't be used on a worksheet, only on a UserForm (custom dialog box).

There are ways you can get Excel to jump to various cells for user input, it depends on exactly what you want to do.

Example:
Click on A3, hold down CTRL, click on A5, A7, A9, A1. Release CTRL. Select Format -- Cells -- Protection, uncheck "Locked", click OK. Protect the worksheet (Tools menu), then you can tab around the sheet in that order (starting with A1).

HTH,
Andy
 

Read other 1 answers
RELEVANCY SCORE 60.8

I have a word document that I am creating Drop down fields in forms tool bar. My problem is that I have to have some of the words be italicized and other's not. I know you can italicize all or none of the words but is there a way to italicize some of the words and leave the others in regular text form?
P.S. I've also tried to use Autotextlist but I can only get two options to come up and I have three options. ???? Help!!!
 

A:Drop Down Form Fields

Sorry, fatso.
The answer is no.
If you need it badly, this CAN be done in Excel.
 

Read other 1 answers
RELEVANCY SCORE 60.8

Hi
I am creating a form on word 2003 with Text Form Fields. At several points throughout the form the same information needs to be entered (eg: name). Does anyone know if there is a way to make it so that if you enter the date into the first 'name' text form field it will automatically put the same information into the other text form fields labelled name?
Thanks
 

A:text form fields

Read other 6 answers
RELEVANCY SCORE 60

Hello everyone,

I'm new to the TechSupport Forums, so I'd like to start out by saying hello to everyone! I need some help with a (possibly) unanswerable inquiry.

I have created a protected document with form fields for users to enter information. When they hit enter, I would like for the document to go to the next form field rather than do a hard return. Is there a way to do this? Any help anyone can provide would be great!

Read other answers
RELEVANCY SCORE 60

Ever since I upgraded to IE 6 I have had an incredibly slow response when filling in form fields. For example, let's say I'm going to log into a message board like this one to post a message. I fill in the username, hit tab to the password field or click in the cursor on the password field, and it takes anywhere from 10 seconds to a minute before the cursor shows up in the new field.

On top of this, during the wait I cannot access any other browser window I may have open at the time. I can access other programs (like, say Microsoft Word), but my browsing is virtually halted during that time.

Has anyone encountered anything like this? It happens regardless of how many browser windows I have open, and started only after I upgraded to IE 6.

Thanks,

Zach
 

A:IE 6- Slooooow response on form fields

Try closing down some of the applications in the background. IE6 is pretty bloated, as is most Microsoft apps, so try shutting a few of them down.

Alternatively, Opera opens it's browser windows in itself by default, meaning that you don't have to have numerous instances of the same program open at the same time.
 

Read other 3 answers
RELEVANCY SCORE 60

Is it possible for a user to choose a field in a combo box that somehow is connected with another field that they don't choose? I need this "not choosen" field to populate in a table.

The reason I want this is because the "not choosen" field is not known to the user, but need for linking
different tables together.

Example: Have a field Description and Customer Part ID. The user knows the Description and that's what they choose, they do not know the Customer Part ID, but need that for linking tables together.

Do not know Virtual Basic very well, so is there a way just with the combo box wizard or a query? Need as simple as possible.

Thanks!
 

A:Combo Box in Form multi fields

Read other 8 answers
RELEVANCY SCORE 60

I am trying to fill in a weekly dates using a form field start date.
It is setup as such:

Start Date: ________ (user enters date here in format ddMMMYY)
This is setup as a Text form field, set to date, with calculate on exit checked and bookmark as DateField.

Later in the document, I have a weekly calendar that I want to fill in the dates for Mon - Fri based on Monday as the start date from above.
I have been using the insert>Quick Parts>Field but cannot figure out the calculations even after multiple guides and searches.
I am able to reference the bookmark and repeat the date for Monday, but cannot figure out how to set Tue-Fri dates.

Please give me the exact code to put in if possible.
I could figure it out using VBA but want to do this without macros if possible.

Thanks
 

A:Solved: Form Fields in MS Word

Read other 6 answers
RELEVANCY SCORE 60

Okay, I thought I had this figured out yesterday, but I guess I didn't. I was using continuous section breaks in the form to try and solve the problem. The only problem with this method, though, is that Word seems to only allow one break per line, which means the most precise I could get this way was to place a break at the beginning of the line I want to leave editable and then another break at the beginning of the following line. This won't work for me because it will still allow someone to use the enter key to create a new line in the editable part of the form, thus pushing everything below it down and changing the layout of the form. So, is there a way to get more precise when it comes to locking areas of the document around certain fields? Sorry if my post is a little confusing. Any help would be greatly appreciated.
 

A:Lock certain fields in MS Word form?

Could you e-mail me the form so I can take a look at it please? Have you locked the form as well so the user cannot edit it?
 

Read other 2 answers
RELEVANCY SCORE 60

i have laboriously figured out (with help from this forum) how to make the text and numbers entered into my forms repeat throughout the document. however, if i type a space in the field, such as between first and last names, the second word shows up as bold everywhere else in the document. what's the fix?
~melias
 

A:first & last names in text form fields

Read other 7 answers
RELEVANCY SCORE 60

I've created a form in Word that users fillout and print. Is there a way to make certain fields required?
 

A:Word Form - Required Fields

Read other 9 answers
RELEVANCY SCORE 60

Hi All,

Quick one - trying to create a data entry/ edit form that has 3 years worth of dates in it. I.e. 2016, 2017, 2018

Project Name| Project Manager |
Jan 16 effort
Feb 16 effort
March 16 effort
April 16 effort
May 16 effort
June 16 effort
and so on....

Some projects will go into other years and what I'm trying to get to is a form that has a button that can cycle through to the next year rather than creating 3 separate forms with a button that will just take you to the next form... can it be done? If so, can anyone tell me how?
 

A:Create Form that Cycles through fields

Read other 9 answers
RELEVANCY SCORE 60

I am trying to create a form with required fields for a document at work. I was able to use code provided by Anne Troy to easily do this. However, I just have one additional question to complete a modification I had. Basically, on certain questions, I want the form to verify that the "Next" field is completed. So that if on question 7a "Yes" is selected from a drop down box, then question 7b must be answered. Here is an excerpt with the IF statements...
For Each fld In ReqFields
If Trim(fld.Result) = "" Then
MsgBox "You must complete " & fld.Range.Bookmarks(1).Name & " before you can print.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
If Trim(fld.Result) = "Select..." Then
MsgBox "You must select an answer for " & fld.Range.Bookmarks(1).Name & " before you can print.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
If Trim(fld.Result) = "Yes" And "NextField" = "" Then
MsgBox "You selected 'Yes' for " & fld.Range.Bookmarks(1).Name & "." & vbNewLine & "Please answer Question 'b' after " & fld.Range.Bookmarks(1).Name & " before printing.", vbOKOnly + vbExclamation, "Error"
Cancel = True
fld.Select
Exit Sub
End If
Next fld
End Sub
 

A:Word Form - Required Fields

See if this helps?
http://pcnorb.blogspot.com/2008/04/word-and-vba-forms.html
 

Read other 3 answers
RELEVANCY SCORE 60

I need 3 fields created (2 of these are almost identical):
1. a field that automatically populates the e-mail address of the person filling out the form (it reads their mailbox name somehow).
2. a button that allows me to click to pull up the Outlook Global Address list and choose a name that is then populated into a custom field (I cannot attach the "To" button control in the field properties because I am already using the "To" button on this form for another purpose).
3. another field just like the one above except that it would be independent (choosing from the global for #2 would not affect what I choose from the global in #3).

Make sense?

Background: I am using an Outlook Mail form - I think I need VB for this part but don't know what to type. Any help you can offer would be welcome.
 

Read other answers
RELEVANCY SCORE 60

I have created a form in table format. Is there a way to change the tab order from top to bottom instead of left to right?
 

A:Form in Table w/Fields - Tab Order

In Datasheet View (table format), each row represents a record. The only way that you could use the tab key to move from one record to the next would be to disable the Tab Stop property of all the controls on the subform, then set the subform's Cycle property to All Records. Bear in mind, this will prevent you from tabbing into any other field than the first field in your subform, so you'd have to manually focus (i.e., click) on a control in order to edit its data.

Why exactly do you want to do this?

chris.
 

Read other 3 answers
RELEVANCY SCORE 60

I've looked for this and people don't seem to have the problem. I have a form that populates a single database. on enter a new refreshed form is presented to the user - but now my user has requested that 3 fields on the form not clear. She wants to be able update them if needed, but generally they will not be changed during a batch of input, after she has entered them the first time. How do I STOP them clearing?
 

A:Access form clears all fields

Read other 6 answers
RELEVANCY SCORE 60

I have an MS Access FORM which presents 2 fields from a table

X is data type YES/NO, and Y is data type TEXT.

I would like my Form to always display X, but only to display Y if X is YES.

I know I can right click on Y, then Properties > Format > Visible : No, but this isnít sufficient.
I can also right click on X, then Properties > All > After Update which takes me into V B.

Can anyone help this layman who doesnít know anything about V B ?

Many thanks in advance....
 

A:Conditionally hiding fields in a form

In the Form's On current event procedure and the X Field's After Update event procedure enter

if me.X = -1 then
me.Y.visible = true
else
me.Y.visible = false
end if
 

Read other 3 answers
RELEVANCY SCORE 60

I have 4 number fields that is formatted to currency with 2 decimal places. When I key in a dollar amount it is rounding the numbers. How do I get it to not round up or down?
 

A:Solved: Number fields within a FORM

Read other 6 answers
RELEVANCY SCORE 59.2

I running access 2003 but i am creating for 2000

Bsaicly its a stock control system. And i have a field call "Total number ever in stock" Which basicly refers to how many of such a product has been purchesed for the shop altogether.
Reasons for this are complicated but its stems from the batch procecsing method of data colection but its not important.

>>>>>>>>
Simply i want to create a macro or simmilar so that when the user enters a Product ID and Quantity to be added into a blank non table related form the macro will add that quantity to the existing quantity for that product in a table.

So far i have created a form in design view and have inserted two unbound text boxes "ProdID" and "Amount" and have a table with field names "Product ID" Total number ever in stock"
<<<<<<<<

Thanks all help appreciated.
 

A:Adding to fields through use of macro and form - ACCESS

If I understand you correctly, you have an unbound form that a user enters a product ID and qty to be added to a related record that already stores a summary amount. You can do this using that method, but it will have some data integrity challenges. If someone enters the wrong amount, you won't know where it came from or how much the qty was for the wrong amount.

To perform the update from an unbound form can run an update query from a button.

Here's a SQL sample that you could run from a button

UPDATE Prod_Totals SET Prod_Totals.Product_ID = [Forms]![frmQtyUpdate]![txtProdID], Prod_Totals.Total_Qty = [Forms]![frmQtyUpdate]![txtTotQty]+[Total_Qty];

---------------

That being said...I would consider approaching it from a different angle.

1. Create a table of Item_Events and Products

Table Name:

Item_Event
Item_Event_ID (Autonum) Key
Product_ID
Qty (+/-)
Event_Type (Purchase / Sale / etc..)
Event_Date

Products
Product_ID (key)
Product_Description
Create a form based on Products with a subform of Item_Events. When you need the total qty use a summary query.
 

Read other 2 answers
RELEVANCY SCORE 59.2

Problem: Some, but not all, of the form fields on my Word 2007 master document disappear during mail merge.

Background: Last year I merged student data from Excel into a Word document to create 150 report documents for teachers to complete. I have on my hard drive the original documents and the merged documents. Both have drop down lists (for grades) and text boxes (for comments).

Current situation: When I mail merge now, the drop down menus appear in the merged document but not the text boxes. A few hours of experimentation turned up no solution and a search on the web brings a consensus that Form Fields and Merge Documents are incompatible. But the drop down menus are arriving unscathed and I have proof I achieved it less than six months ago!

I've recorded a macro that replaces the 'remains' (4 spaces) of the text box with a new (working) form but besides being inelegant its frustrating knowing that somehow I've already solved this.

Any thoughts , suggestions, (or access to a working time machine) would be appreciated.

Cheers, Tim Tuck
 

Read other answers
RELEVANCY SCORE 59.2

Is there a way to lock certain fields in a Microsoft Word form while keeping others editable?
 

A:Solved: Lock certain fields in Word form?

Got it.
 

Read other 1 answers
RELEVANCY SCORE 59.2

Hi guys,

I have an ASUS computer running Windows 7. In the last few weeks, I started having problems with the NUM LOCK keys intermittently not working in form fields. The NUM LOCK light is on, and if I use the pad in the URL field, for example, it works fine, or in a Word document. But sometimes I will be in a form where I need to fill in a phone number, etc., and when I go to use the number keys, the work like the arrow keys instead. The NUM LOCK light is still on, and if I immediately, on the same page, go up to the URL bar and try them, the numerals work, but back in a form field, and nothing.

I was using the ASUS keyboard that came with the computer, so I tried updating the driver - no result.

I took my husband's HP keyboard, and I have the same problem, so it seems there is some issue from a software or Windows standpoint causing the problem.

Interestingly, if I go into Control panel, Ease of Access, Change How Your Keyboard Works and change NOTHING but then close that window out, the num lock keys will begin working in the forms...for awhile. But then it goes right back. It seems just the act of going into the screen that alters your keyboard is enough to make it start working for a bit, which makes no sense, I realize.

For the record, in that screen, "turn on mouse keys" is not checked. In fact, nothing is checked.

Any ideas??? I am not super computer savvy as far as altering reg keys, etc., so if you can give specific instructions to try if you ... Read more

A:Num lock working intermittently in form fields

Wow, I've posted this in more than one tech forum and no one seems to have an answer. I now leave the "make the keyboard easier to use" window open, and just the act of going in, changing something around and unchanging it, then hitting "apply" makes the num lock pad work for at least an hour or so and then it stops again. No one??
 

Read other 2 answers
RELEVANCY SCORE 59.2

A friend of mine has Windows XP SP3 with the latest Internet Explorer 7 and all patches installed. The operating system is a fresh install as of yesterday. Norton 360 v2.0 is installed as the anti-virus.

As of today, various web sites are suddenly missing form fields.

For instance, the TO and CC fields have vanished on Yahoo Mail. On a few other sites different fields have also vanished, and which go missing seems to be random. The only commonality is that all of fields that disappear are on web sites where you can send messages or mail through the web page.

Any idea what could be causing this?

A:Form fields mysteriously missing from several sites

try another browser and see if you have the same problem with it. This will help determine if its a msie problem or something else.

Read other 1 answers
RELEVANCY SCORE 59.2

Form has several calculated fields. The first part of this code works fine, the second part that is supposed to calculate the Reservations Amount Owed does not work - the field returns blank. I also have another calculated field that isn't working: Reservations Balance Due which would be Reservations Amount Owed minus Reservations Amount Paid. What am I doing wrong? Thanks in advance for your help.

Private Sub Combo68_AfterUpdate()
If Me.Special_Ticket = "Corporate_Table" Then
Me!Ticket_Price = "312.50"
Else
If Me.Special_Ticket = "Sweetheart_Ticket" Then
Me!Ticket_Price = "800"
Else
If Me.Special_Ticket = "Patron_Ticket" Then
Me!Ticket_Price = "350"
End If
End If
End If
End Sub

Private Sub Reservations_Amount_Owed_AfterUpdate()
Me.[Reservations_Amount_Owed] = Me.[Reservations_Number_of_Tickets] * Me.[Reservations_Ticket_Price]
End Sub
 

A:Access 2007 form calculated fields

Read other 16 answers
RELEVANCY SCORE 59.2

I would like to create forms in PDF...What I would like to do instead of creating the text fields in PDF is create them in Word placing a tag on the cell and when convert PDF will capture the text box. Is this possible with any plug-in even. I called Adophe and they informed me plug-ins are available for this but I could not find any.

We currently have forms on the web in HTML which I am converting to word the cell fields are carried over all I would need to is format the document the way we want it and rename the cells...The reason why I do not want to do it PDF is becuase I have approx. 100 forms and I know at some point they will be modified I would have to re-create the entire form in PDF where as in word it would be easier to re-create then I could just create a PDF and have it completed.
 

A:Convert word cell tag to PDF form fields (How can do this?)

Hiya and welcome

Looking here:

http://www.pdfzone.com/bguide/product/SearchResults.asp

There is Acropad, but you have to join to look at the actual program, but this is where you can get it:

http://www.acropad.com/

It may not be exatcly what you're after, as you said Word.

Also, there is this:

http://www.planetpdf.com/tools.asp?webpageid=550&TBToolID=1976

http://www.go2pdf.com/product.html

It may take a bit of playing with the plugins, to see which one will work, but the one above mentions this:

You may convert Microsoft Word, Excel, PowerPoint, Access documents into PDF formats, convert AutoCAD file into PDF, convert image formats to PDF, convert plain text file to PDFClick to expand...

Thats for Go2pdf, so you may want to look at that first.

Regards

eddie
 

Read other 3 answers
RELEVANCY SCORE 59.2

I have just started using MSN Premium after a few years of using Mozilla Firefox. One thing I am missing is having my misspelled words underlined and easily fixed (a right-click used to show me correctly spelled options). I have been searching for information on this topic and all I can find is in reference to spell checking email. I already have that part figured out. What I want now is to be confident that when I am typing, oh, for example, THIS! that I avoid the ever-annoying typo. Does anyone know if there is a way to do this in MSN Premium? If there is no way, does anyone know if there is an add-on or downloadable spell checker that will do this for me? Hopefully for free?

There are some things I like about the MSN Premium and I would like to be able to keep using it. I may have to go back to Firefox though if I can't solve this spell check thing. I have been dealing with the lack of tabs (I love to have a dozen tabs open, but hate to have a dozen windows open!) but the tabs AND the spelling might be too much to overcome.

If anyone out there can help, I would love to hear from them!

Karla

In case it matters, this is what I am using:
Dell
Intel Celeron Processor
564 MHz
512 MB of Ram
XP with SP2

I know it's ancient! It was a hand-me-down and it's all I have

Read other answers
RELEVANCY SCORE 59.2

My church asked me to create a db. I'm a newbie but I figured I give it a shot. Since then, I've been pulling my hair out.

I'm using Access 2000 on M$XP. The Church Stewardship Secretary (CSS) is responsible for logging in each person's activities choices, and there are many activities to choose from. One may choose to be in the Adult Choir, be an Eucharist Mininister at 8 and 11:15, and volunteer to do electrical work.

I am trying to create a FORM with multiple yes/no choices and comment boxes so that the CSS can input each person's record. This "Masterform" will view current records and will update as new records are entered.

Step 1: Instead of using one ENORMOUS table, I subdivided the data onto 11 or 12 catergories. (BIG MISTAKE!!!)

1-Members (lastName, firstName, Phone)=TEXT (ChurchID=TEXT= PRIMARY KEY)

I linked the choices using a Church ID primary key----> I decided to use the first 3 letters of the first and last name for a primary key: Michael Jordan= micjor

The rest of the tables went as followed:
2-EM's
3-Greeters
4-Music Ministry...

And so on ... Tables beginning from 2 had each record beginning with the ChurchID and yes/no columns. Usually each table had a comments text column as well. NOTE: Only those whom had selected a choice on the table would have their ChurchID and record appear on the table.

STEP 2: I created a one-to-one relationship from the Members Table to the other tables. I wanted each member to ... Read more

A:Cant create form or query from joined fields

Read other 7 answers
RELEVANCY SCORE 59.2

In Access 2010 - When a user opens a form, I'd like to inactivate specific fields. How do I do that?
 

A:Solved: Inactivate fields when form is first opened

You use similar code to the one that I have given you, but it goes in the Form's On Open event procedure.
You do not need the "If" part of the code just the fields you want disabled.
Using the code
me.fieldnamegoeshere.enabled = false
 

Read other 2 answers
RELEVANCY SCORE 59.2

Is there a way to display the HTML Form info? In FireFox you can get a list of all the input fields and their currrent values for a Form. If there is more than one form on your page, you select which Form you want to view. It's an add-on in FF (links and forms).

I am an ASP developer and it's very helpful to view the field and their values. Especially Hidden fields that are populated by some JavaScript code.

I am trying to use IE instead of FF, but there are a few features I depend on in FF that I can't find in IE.

Thank you for your help.

Read other answers
RELEVANCY SCORE 58.8

I am using similar code to this thread:
http://forums.techguy.org/business-applications/175786-word-form-required-fields.html
but instead of required on print, I have fields to be required before saving and printing.

To accomplish on save I used the same code except for the Title line of code:
Public Sub wordApp_DocumentBeforeSave(ByVal Doc As Document, SaveAsUI As Boolean, Cancel As Boolean)Click to expand...

I am using a 2003 Word Document Template.

My question is, I have a custom calendar userform that seems to break the field requiremens whenever the calendar pops up (I have a macro set to run on entry on certain date fields).

Is there any way to work around this? I can post up some sample code as necessary.

Thanks for your help =)
 

Read other answers
RELEVANCY SCORE 58.8

Hi all,

Ive tried a few things to solve this but cant get. Hope I can get some help here please! Here goes:

I have a query by form that allows me to search for a date range, a physician, an injury code, and three possible procedures. I have set up each procedure control (procedure_1 through _3) to retrieve data from their repspective fields in the injury table. Heres where the problem lies. I want to set up a control that looks up ALL three fields at once and gives me the result whether the procedure is listed under procedure_1, _2, or _3 field in my table. As it stands now, I have to do three separate queries with the same procedure in the different controls than combine those results to make one table and that is much too much work.

I would like to get rid of having 3 controls (one for each proc_1, _2, _3) and just have ONE control named PROCEDURE... and it will look at all of them and give results that have that procedure in any one of those procedure1,2,3 fields.

Hope this makes sense here. I am not a VBA expert and really dont have time to learn.. So I have been trying to accomplish this using the CRITERIA box in the query design. I am using the criteria:

Like [Forms]![FormName]![ControlName] & "*" Or [Forms]![FormName]![ControlName] Is Null

My control names are proc1, proc2, proc3 and I have tried combining three of these statements in every possible combination in order to achieve my results but have been unsuccessful.

Is there an easy way to do ... Read more

A:Access 2003: query by form - One control for up to three fields

Read other 9 answers
RELEVANCY SCORE 58.8

Hi there,
I'm working on my A level coursework and trying to update a table by using a form which allows the "user" to input their information easier. I have tried using an update table query, however, I can't run that off of a form. Anyone got any ideas?
Thanks 

A:Microsoft access: Is it possible to update table fields from a form

Hi,
 
You need to create a Select query to do that.

Read other 2 answers
RELEVANCY SCORE 58.8

simple databe for inventory i created and 2 of the fields are not writing info to the table after they are filled in on the form. One of them is a drop down box for several choices and the other is a field for the amount of inventory left which is automatically calculated depending on the user entering what they shipped verus what they received in? I am stumped on this since all the other fields are writing to the perspective table columns. Please someone help me !!! lol

Anthony
 

A:Access 2007 Table does not contain all info from form fields

Read other 6 answers
RELEVANCY SCORE 58.8

Hey there folks.. I have what may amount to be a small problem or an easy fix but I can't figure it out for the life of me. I have spent the last week researching this problem, off and on.

What I need help with:

I have a semi-complex database in Access 2007 and I will have several forms. I need the forms to have clear fields when the user opens the form. Is there a way to automatically clear the forms upon opening of the form by the user without the need to click a 'clear' button? If so, how do I go about achieving this end?

Thanks,
Jason
 

A:Solved: Automatically clear form fields when opened

Read other 16 answers
RELEVANCY SCORE 58.8

HI,
I have an issue with updating Microsoft CRM web form fileds in one laptop, fileds are grayed out. This is only in one laptop other pc's can update web form fields. I am using internet explorer 11.

Read other answers
RELEVANCY SCORE 58.8

How can I have field have the same numeric value as field [A], but then be able to manually enter a different value for without it also changing [A]? EG: Price for Monday automatically is price for Tuesady, but if change Tuesday, Monday does not also change.
 

A:Want identical fields in Access Form so only duplcates in one direction

One of the easiest ways is to use some simple VBA in the first fields "After Update" event procedure. The VBA would be
me.b = me.a
or
me.b.value = me.a.value
where a and b are the field names with no spaces in them.
If the field names have spaces in them then use
me![field name] = me![first field name]
where the names in the brackets are your field names or you can let the VB Editor supply the name from a list when you press the ".".
This will only work in one direction, i.e. it will only update field b's value with field a's. If you enter data by overwriting what is in field b it will not affect field a at all.
 

Read other 2 answers
RELEVANCY SCORE 58.8

Hi,

I'm working with form fields in Word 2003 and I was wondering if it were possible to create a form field with a line extending to the maximum length of characters allowed? For example:

Name:_________________________________

Where the underline is the form field. I know that MS shows them using tables to create a kind of pseudo line but I was hoping for something more...elegant? One that would be incorporated right with the form field.

Thanks for all your help!

JFresh
 

A:Solved: WORD 2003: FORM FIELDS question

Read other 6 answers
RELEVANCY SCORE 58.8

I have created a form in MS Word 2007. I used the form fields and have locked the form. When the user fills out the form it is saved and sent to someone to review, edit and/or comment. The receiving party unlocks the form and adds comments however, is not able to use track changes in the form fields. Do you know of a way that they can use track changes within a form field?
 

Read other answers
RELEVANCY SCORE 58.8

I did some marketing work for an old client to market their product and I started noticing that afterwards, their clickbank link would pre-populate in certain form fields of my browser when a single field needed to be filled out on a page. This is happening on more than just 1 browser too. It does it in both Chrome and Firefox which I use.
 
Now...it doesn't happen in every form field so it's just something I see from time to time. But when it happens, it happens upon the page load before I can even click on the form field to fill it out.
 
I no longer have the clients information to get a hold of them (not that it would help) and I'm just wondering what this could be and how to get rid of it. I run both BitDefender and MalwareBytes on my computer and neither has managed to pick it up as a virus or spyware.
 
Can anyone help here?
 
 
 
 

A:Form Fields Are Being Pre-Populated With Clickbank Affiliate Link

It's probably simply the auto-fill; goto auto-fill section within browser and dump the contents.

Read other 2 answers
RELEVANCY SCORE 58.8

I know how to export the default fields in Outlook 2000, but I created a form with about 20 of my own fields. Need to export to .dbf file, and can't figure out how to export those fields.
 

A:Export Outlook 2000 form fields to .dbf file?

Read other 6 answers
RELEVANCY SCORE 58.8

Hi,
I'm completely new to vba and trying to modify a code I found here but failed.
While the original code exports cell data (1 row only) from excel into the form fields of a Word document, I tried to modify the code to work for multiple rows, one after the other.
My code works for the first row and generate a word file as supposed, but immediately stoped with an error message "Runtime Error -2147417848 (80010108), "The Object Invoked Has Disconnected from Its Clients"
Could anyone help me modify the code so that it works please? Thanks a lot!
I'm using 2003 excel and word.
P.S. I know this can be easily done by mail merge but I would like to use Word form for further process.

Code:
Option Explicit
'Requires reference to Microsoft Word (11.0) Object Library
Sub Copy_Cells_To_Word_Document()
Dim rng As Range
Dim row As Range
Dim wdApp As Word.Application
Dim wdDoc As Word.Document

Set rng = Range("A2:E4")
Set wdApp = New Word.Application
Set wdDoc = wdApp.Documents.Open(Filename:="C:\Desktop\file.doc", ReadOnly:=False)
wdApp.Visible = True

For Each row In rng.Rows
Copy_Cell_To_Form_Field wdDoc, Range("D" & ActiveCell.row).Value, "Surname"
Copy_Cell_To_Form_Field wdDoc, Range("E" & ActiveCell.row).Value, "Forenames"
Copy_Cell_To_Form_Field wdDoc, Range("B" & ActiveCell.row).Value, "Ref"

wdDoc.SaveAs ("C:\... Read more

A:import excel data into word form fields

Read other 6 answers
RELEVANCY SCORE 58.8

I don't know if this is possible.

I do know it isn't possible to insert a form field into a field code.

The functionality I'm trying to achieve is something like this:

{ SET _Check1 { FORMCHECKBOX } }​
Then, further down the document:

{ REF _Check1 { FORMCHECKBOX } }​
In other words, I want to use bookmarks with form fields. Can it be done?

chris.
 

A:Solved: Merging form fields in Word 2000

Read other 7 answers