Computer Support Forum

MultiPage Form data not displaying when Value property changed

Question: MultiPage Form data not displaying when Value property changed

Hi folks, I have a multipage form as part of an Excel development that requires checking the completion of fields on page 1 when a user enters page 2. All very straightforward I thought having done it many times before in word macros

eg If Multipage1(0).<variablename> = "" then
msgbox(<error message>)
multipage1.value = 0
End if

but no. The tab of page one is activated but the form controls displayed remain stubbornly those of page 2 and vb sicks up because it can't see <variablename>. The only reference I've found to this is that it was driving people mad and 'appeared to be a bug in XL2003'(sic) I'm using Office 2010.

Has anyone else had this problem, and more importantly found a cause/solution?


More replies
Relevance 100%
Preferred Solution: MultiPage Form data not displaying when Value property changed

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

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

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

Relevance 78.72%


I am trying to create a data entry form for a large database. There is a parent form with 6 forms linked with a one-to-one relationship (due to a large number of fields) and several tables linked with a one-to-many. All have auto update/delete checked. The date entry form uses tab control (across 11 tabs) and subforms for some of the tables. I have two problems...

Firstly, if I enter part of the data for a new record in the form (eg fill in tabs 1-3) and then close it, the data appears in the tables, but when I re-open the form the record does not appear, so it is impossible to complete the data entry.

Secondly, when using the tab key to move through the fields in the table, when I get to the end of a tab control, instead of moving to the next tab control for the same record, it moves to a new record on the same tab.

I am fairly new to access and not familiar with all the code etc behind it, so I would be grateful for any advice!


Answer:Access form not displaying all data

9 more replies
Relevance 77.9%

Hello OBP and others,

I have 3 Access XP survey forms that are not displaying the uploaded data in the tables, though they are restricting the number of records to the number of surveys in entered into the tables (as they should be doing). The "Data Entry" settings are set to NO for all forms and subforms. Do you have any suggestions as to how this can be fixed?

Thank you,

Answer:Access XP Form Not displaying Table data

16 more replies
Relevance 74.62%


I have linked my calendar 11.0 to my text boxes, and then to my query criteria. Everything works, except after I click on the Calendar to choose my end date and it shows up on the text box thats linked to the query, the information from the query doesn't automatically show up on my Form in other text box I have linked for results (d*count funtion, etc).

BUT, when I go into design view, and then back to form view, the Data is Updated!

So I am very confused as to how to set it up after I input the end date to automatically update instead of hitting the design view and back to form view for it to update.

Not sure if a "refresh" or "after update" function needs to be in place? I hope I explained it correctly! Thank you!

More replies
Relevance 73.8%

I am trying to make a text box update to Now() whenever someone changes the data on a form using:

Private Sub Form_DataChange(ByVal Reason As Long)
Date Changed = Now()
End Sub


Private Sub Form_DataChange(ByVal Reason As Long)
[Date Changed] = Now()
End Sub

Nothing seems to work. What am I doing wrong?

Answer:Solved: Update date when form data is changed

Been struggling with this one for hours! My boss wants to know if any of the form data was changed, I don't need to know what was changed, just that something was changed by populating a date everytime a change was made. (Probably should also include who changed it by using Environ("username"))

I have been looking for code all over the web and keep seeing that I should use the "Before Update" event but when I use this it populates the text box with a date just by simply going to the form and looking at it (Not what I need) I thought that using the "Data Changed" would work but I can't get it to do anything.

My text box for the date is "Data Changed" and the text box for who changed it is "Changed By"

Does anyone know how to do this with code, macro,???
Thanks, Joe

2 more replies
Relevance 65.6%

Is there a way to loop through all records on a form to determine if a textbox is equal to "yes"?

I would like to have an if statement to do something like:

If textbox1 = "yes" then
textbox2.locked = true
textbox3.locked = true
end if

If this helps, the form is in datasheet view.

Answer:Solved: Access Form/Lock Property

11 more replies
Relevance 64.37%

This is complicated so read carefully.

If have a form named Form1 and it has a code module, I can declare public properties within that module:

Form 1 Code Module:

Dim MyString as String

Public Property Get CurrentString() as String
CurrentString = MyString
End Property

Private Sub Form_Open(Cancel as Integer)
MyString = "kite flies high"
End Sub
Now, I can refer to that property in some other form or code module


Public Sub ShowFormString()
Debug.Print [Form_Form1].CurrentString
End Sub
And that works just fine.

But now here's the question... How do I access the property (i.e. what is the syntax) when I'm not sure ahead of time what form I will be trying to get it from. I may have several forms with the same public properties declared or may have multiple instances of the same form that I want to reference.

I need a code syntax where I can plug in e.g. the name or index of the form and get the custom propery. Something like

Debug.Print Forms(J).Module.CurrentString

But that doesn't work.

Debug.Print Fomrs(j).Module.Properties("Name_Of_Property").value[/CODE}

does not work either

For simple things like strings, it would be easy enought to put the property values into hidden controls (visible=false) and refer to the Form.Control but there are cases where I want to be able to set whole Objects throught a Property Get.

Anyone know the syntax for referenceing ... Read more

Answer:How to refer to Public Property declared in a form class module

Declare it in a Class Module, not a Form Module.

3 more replies
Relevance 64.37%

I have an access form having a command button which will perform a certain action onclick for the current record.
I need to disable the button function by navigating the records before the current one from the form or in other words, to have the button property (enabled) = false all the time except when the current record is new only.
this makes me thinking on how to inform access vba to navigate and if the current record is a new one, then to enable the button to perform its function, or if it is one preivouse record then to nake the button property (enabled) = false.
Can this be performed and works?

Answer:Change property of command button by navigating access form

7 more replies
Relevance 59.04%

I am just beginning to learn Access and have two questions. I was trying to use a conditional expression in the default property of a date field on a form. Somehow I lost all the data in the property sheet. The sheet displays with all the captions but the data is gone. Just a blank space after the caption. The caption column is not even highlighted like it usually is. What happened or, more importantly, how do I get the information back. Secondly, what is wrong with this expression: "IFF (WEEKDAY()=1[WORK_DATE]=DATE()-2, [WORK_DATE]=DATE()-1)" I don't want to have to enter a date when I enter the previous workday's transactions. I get an error message in the data box when I open the form and try to enter a new record. I want the default date to be 2 days before today's date if it is now Sunday and yesterday's date if today is any other day of the week. I know nothing about SQL or VBA so hopefully someone can answer in simple Access terms. Thank you so much.

More replies
Relevance 58.22%

Macro help - I want to create a macro to automate certain processes:1. Customer chooses a property name form a drop down list and clicks 'run macro' button.2. Macro takes property name, searches in 'Sheet 3' for the property's ID number (ID Number in Column A, Property Name in Column B).3. ID number is copied and pasted into 'Sheet 2' Column A - (where a vlookup pulls all other relevant data)Could somene provide the basic VBAs - or advice? I'm trying to learn VBA skills, would be good to get some pointers.

Answer:Macro the uses data list to compute property costs

Here is some "basic VBA".Some assumptions had to made since you didn't supply a lot of detail.Assumptions:The Drop Down is in Sheet1!A1The destination for the ID number pulled by the macro is Sheet2!A2This code will monitor changes on Sheet1 and if a change is made to the Drop Down (A1) it will fire. (There's no need for a "run macro" button") It will look in Sheet3!B:B for the value chosen in the drop down. When it finds the value, it will place the ID number from the corresponding row on Sheet3!A:A into Sheet2!A2.Right-click the Sheet tab for Sheet1, chose View Code and paste the macro into the pane that opens.
Private Sub Worksheet_Change(ByVal Target As Range)
'Determine if change was made to drop down cell
If Target.Address = "$A$1" Then
'Find drop down value in Sheet3!B:B
With Sheets(3).Columns("B:B")
Set p = .Find(Sheets(1).Range("A1"))
'Return corresponding value from Sheet3!A:A to Sheet2!A2
Sheets(2).Range("A2") = Sheets(3).Range("A" & p.Row)
End With
End If
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 57.4%

I am a true beginner in access programming, so excuse if my methods isn't the best, and any advice would be much appreciated.

My main problem is displaying a Query I did on an attachment field in my main table on a form.
This is what i am working with:
Access 2007
My main table name : Table2
Attachment column name in Table2 : Target_photo
Query name: QuerySpecGraph (Query on the attachment field)

The query works perfectly fine when I run it and gives me the correct result. Now to display the query on the form I added an new attachment under controls and edited the control source to display the query results.

I used the function dlookup:


I tried similar code on a text box, with a text Query and that worked fine. However it does not want to work for the attachment.

Then I tried to analyze the situation to see if the query is the problem, so changed the attachments control source to:


this was to see if even a basic dlookup function works in the attachments control source, but yet again the attachments box stays empty (Again I tested the simple dlookup function with a text box to see if my table is the problem, but the textbox's dlookup works fine)

I do not know what I am doing wrong, or if it is even possible to do what im trying to do! Any advice would be much appreciated, and if there is away around this I will gladly explain in more detail ... Read more

Answer:Displaying an Attachment Query in a Form

12 more replies
Relevance 57.4%

I basically have a Main Menu form, on which I have a variety of tabs. On one of the tabs I want to have a series of combo boxes from which users can enter/select the value they require. In the After Update I need some sort of code as below, that will allow me to display the record/s matching the value provided/selected by the user.

-this command is expecting an =

So a user has a combo box called ID, they may enter or select a value from a drop down list, a form is then displayed from tblImprovements in frmImprovements. What am I missing? Any ideas?

Answer:Filtering in Access and displaying in a form

I think you have the order of the filter wrong. Also you should not need the .AfterUpdate piece of the combo box. Try

1 more replies
Relevance 56.99%

Hi all.

I am using WebEasy Professional 6 to design my website. I have inserted a form on my 'contact us' where clients can submit comments, however these comments display in html format when I view it in my inbox (Microsoft Outlook). Does anyone have any suggestions to correct this? Thanks!

Answer:Form on website displaying comments in html

Greetings, BexBomb.

Sounds like you've got something missing, most likely a bracket. Look for code similar to this:

<form>yada yada</form

Notice the missing > after the second "form".

If you can't find the culprit, post the address and I'll take a look at it, or you can validate the page at which should show any HTML mistakes on the page.

3 more replies
Relevance 56.99%

Hi all,

I am a beginner to MS Access. I was trying to create a form in Access which has 3 combo boxes on it, with each of them having the data on accountname, report type and date respectively. This data comes from 3 tables which are two column tables with one filed being the primary key one and the other fiield having the say accountname as type Text and so on. The form has the functionality that as a user chooses a particular combination of accountname, report type and date from the 3 combo boxes and clicks on a button titled 'Display report' the respective pdf file opens up. These pdf files are stored in a particular folder and are named as a concatenation of 'accountname+reporttype+date'. The form also needs to have a button clicking on which the user can close the form.
Any directions members !

Also could anyone explain me what actually a query is and what relationship does it have with a form. I have some idea about this but i am still not fully clear about these concepts.


Answer:Creating a form in MS Access for displaying reports

i posted a similar question about 2-3 weeks ago... I hope someone has the answer...

2 more replies
Relevance 56.99%

Hi Guys
First timer - so please tread gently! I'm sure this is a similar situation, but wasn't sure whether it warranted another separate conversation.
I have a situation on an unbound list box in Access 2000 and haven't yet got to the bottom of it. I have a box which displays incorrect records for the user to correct. When they first go into the box, they see all 500 records (for example) and use a dble click event to edit the one they want, when they return to the box it will only display the first visible amount of records. They can use the scroll bar but the records do not scroll!

The Code behind ( and here's where I get lost - I don't do VB!) opens another form, allows you to edit the record, saves the changes, closes the form and returns you to the original form. We have tried keeping the original form open, as it was closed and reopened, but no change.

The DB has been inherited, so I have no idea why a List box has been used an not a combo.
Forms data is taken from a query.

I'll work out how to post a copy of the empty DB to you!

Answer:Access 2000 - Not displaying all records on Form

6 more replies
Relevance 56.58%

Hi! I got this problem!

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

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

End If


End Sub

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

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

Why I can't run it???

Thanks a lot!

More replies
Relevance 56.58%

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

Answer:Transfer data from a form to another form

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

3 more replies
Relevance 56.58%

Hi there,

I don't have enough experience in VBA excel or word, and would you mind helping for the following:
The below macro code add row below the last row. And Would you mind telling me what is the code that can add row for word document table between the last row and the row before the last?


My second question is related to export/import between two different programs or files ( Excel and word document)
Would you mind providing me the proper code for
Workbook.xls - sheet1.past speical value
Suppose the word tables excel workbookD sheet 1 are as follow

Table 1 in word document
Cell 11 - Cell 12
Cell 12 - Cell 22
Table 2 in Word document
Cell 11 - Cell 12 - Cell 13
Cell 21 - Cell 22 - Cell 23

WorkbookD.xls – Sheet1
Rows Column
2 wt1.Cell 11 WT2.Cell 11 WT2.Cell 12 WT2.Cell 13
3 WT2.Cell 21 WT2.Cell 22 WT2.Cell 23

How I write a macro to make the value or text in Cell 11. in word table 1 to be copied and past in Cell A2 in sheet1 of WorkbookD.xls
and the value or text of the range from Cell 11 to Cell23 of table 2 or word.doc to be copied and past in sheet1 of WorkbookD.xls from range B23 for n rows in table1 and table 2 of word.doc.



More replies
Relevance 56.58%

Hello - I am currently building an "Agent Journal" Database. This will be an area where supervisors can enter "Journal Entries" for their direct reports. The way it is currently setup is: The Supervisor form pops up. Supervisor selects their name from a dropdown, and select a command button. This opens another form with another dropdown that lists only the selected supervisors direct reports. Once the "direct report" name is selected, they will hit another command button that opens the "Journal Entry Form" On this form, there are text boxes for Supervisor and Agent. These fields are auto-populated based on the names selected on the previous 2 forms. There is also a combo box where they can select a "reason" from a dropdown menu, and a date picker so they can enter the date. The problem that i am having is: The data entered into the final form will not save to a table. I want to maintain the auto-populating of the Supervisor and Agent names when this form opens, and i want to have them select a command button to save all of the data on this form to a table. Can anyone help me with this????

More replies
Relevance 56.17%


I wonder if you can help me with something. I have created a Form where there are 4 drop down boxes that collect data from 3 tables. How can I use that form to search for all the records matching one or more criteria chosen from those drop down boxes and display other fields on a report or a table?

The case is:

Table_Candidates (number of candidate, name, date of birth, address,…)
Table_Professional_Habilities (professional experience, years on the job…)
Table_College_Observations (College attended, degree, years, field of expertise…)

Form – Drop Down Boxes

Professional experience
College attended
Result Expected (How do I get this? In a table or a report, it doesn’t make a difference)

Number of candidate
Professional Experience
College Attended
Field of expertise
Age (how can I calculate this from date of birth?)

I've been advised to use Expression Builder. But the query isn't working because itreturns blank. Should I only select the fields on the Expression Builder (as an example, this is what it appears " [Forms]![New_Frm_Parameters_Selection]![Combobox17] "? Or should I make another expression?

Thank you very much.

More replies
Relevance 56.17%

I'm sure this is an easy fix but I can't seem to find it. I just have a form, that will be a subform of another, that needs to display the results of a query.
The query is simple enough, just displays all fields of records that fall between specified dates. The query works great, but when I attach it to the form as its record source it doesn't display the data. I can see the correct amount of record selectors so I know its understanding the query but its as if all fields are hidden!

I have also tried building a query to the forms record source that was simply Select query.* From query. Oddly I have had this working before but I had to specify every field. What I mean is:

Select title From query
Select type From query
Select date From query ...

And so on for all the fields but this seems foolish, can anyone think of what I may be doing wrong?
Thanks in advance!
Edit, forgot to mention I also tried the foolish solution that I mentioned above and it didn't work so its definitely some issue that I'm not seeing, some property that's probably not appropriately set

Answer:Solved: Access 2010 form not displaying query

8 more replies
Relevance 56.17%

Computer:Del Vostro 430 runing Windows XP Pro Service Pack 3, Comodo Firewall, AVG Free.Following a malware infection (now cured, see,134485.0/all.html) I have a strange problem with Windows Files Search.  These two images show the Windows Files Search launched from Start > Search > For Files and Folders, and from Windows Explorer > SearchAs shown, the search form at the left is not displaying properly.  Somehow it is scrunched up vertically so that only a tiny part of the actual form can be seen.  The scroll bar of the form still works and I can get to all parts of the form but to use it is like doing keyhole surgery.  Also, the link for the alternative Search Assistant (the ?cute? puppy) is missing.What in the world could be causing this behaviour?  Any ideas are welcome.Keith

Answer:Windows Files Search form not displaying properly

Do you have your XP CD ? ?If so...from a command prompt type in sfc /scannow and hit Enter...let it finish and re-boot...The cute Puppy may even come back...

2 more replies
Relevance 55.76%

Greetings! I tried to search for posts on my issue but all that comes up is advice on how to move your Documents folder. I already did that. I changed my location from my SSD C:\ drive to my data drive E:\. Everything seemed fine until today when I navigated to the E: drive with Windows Explorer. My documents and music folders somehow got moved to a "Videos" folder. The "Gary" folder appears to be gone. However, the Documents shortcuts still work. In fact, the location property for Documents shows the correct (old) path but when I click on Find Target, it takes me to the Videos folder. I'm not sure when this happened. I have a system image but I'm afraid it was created after the fact. (Yes, I have rebooted)

Answer:Documents Location Changed But Property Location Is Correct - ???

Gla4g said:

Greetings! I tried to search for posts on my issue but all that comes up is advice on how to move your Documents folder. I already did that. I changed my location from my SSD C:\ drive to my data drive E:\. Everything seemed fine until today when I navigated to the E: drive with Windows Explorer. My documents and music folders somehow got moved to a "Videos" folder. The "Gary" folder appears to be gone. However, the Documents shortcuts still work. In fact, the location property for Documents shows the correct (old) path but when I click on Find Target, it takes me to the Videos folder. I'm not sure when this happened. I have a system image but I'm afraid it was created after the fact. (Yes, I have rebooted)

You can press the Restore default button (changes it back to C:\Users\Gary\Documents) and then perform the move again to the location of your choice. Answer yes to move files if prompted.

20 more replies
Relevance 55.76%

I built a form called PO Log that contains input text boxes that the user can enter the different iputs that will add an existing row to the worksheet called PO_log. I have the add function working perfectly. But I want to add a function to the form that if the record/data already exist using the PO number as an identifier, to udate the existing record/data rather than adding a completely new row of record/data. Here is the code I have below for the adding function.

Private Sub cmdAdd_Click()

Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("PO_log")

'find first empty row in database
iRow = ws.Cells(Rows.Count, 1) _
.End(xlUp).Offset(1, 0).Row

'check for a part number
If Trim(Me.txtVendor.Value) = "" Then
MsgBox "Please enter a Order Info"
Exit Sub
End If

'copy the data to the database
ws.Cells(iRow, 1).Value = Me.txtVendor.Value
ws.Cells(iRow, 2).Value = Me.txtPONumber.Value
ws.Cells(iRow, 3).Value = Me.txtPurReqDate.Value
ws.Cells(iRow, 4).Value = Me.txtRFQSent.Value
ws.Cells(iRow, 5).Value = Me.txtSentToVen.Value
ws.Cells(iRow, 6).Value = Me.txtDateOfPo.Value
ws.Cells(iRow, 7).Value = Me.txtOrderConf.Value
ws.Cells(iRow, 8).Value = Me.txtAmt.Value

'clear the data
Me.txtVendor.Value = ""
Me.txtPONumber.Value = ""
Me.txtPurReqDate.Value = ""
Me.txtRFQSent.Value = ""
Me.txtSentToVen.Value = ""
Me.txtDateOfPo.Value = ""
Me.txtOrderConf... Read more

Answer:VBA: Excel form that updates current data or add new data

Closing duplicate.

1 more replies
Relevance 55.35%

In Win 10, I was trying to change the resolution of the monitor. However, after various settings that I did not like, I then got (after initial Win10 screen) a dark screen with a small blue box, saying out of range with H.Frequency (93 KHz) and V.Frequency (58.5 Hz). I cannot find any way to get backby working monitor. Help!

More replies
Relevance 55.35%

hi all, when i am using internet explorer 7, this happened in ie 6 too,,,, the UK pound sign has changed to displaying the letter J, on all sites, i have tried to change the encoding, changing these options did not work, any ideas anyone, thanks john

More replies
Relevance 51.25%

Hi everybody, when i have created a report using a tool called Jreport Designer.It shows the data well in html and pdf format.but when i export the same to excel then for few fields its showing ########.We know that the data would be changing dynamically ,whenever the value is huge then its showing #######.could anybody knows how to resolve this issue.Thanks in advance

Answer:excel displaying ##### where the data is big

Increase the column widths of those columns that may have large numbers. This will probably spoil the appearance of the spreadsheets with normal data.

2 more replies
Relevance 50.43%

I have no idea why, but all of a sudden Windows Media Player (current v11) is displaying a bunch of information the upper left corner about the video stream being played. It only does it on some videos. I've searched high and low for a setting to stop it but can't find anything. I've also downloaded the installer from MS and reinstalled it.

Driving me crazy -- any advice most appreciated.


Answer:WMP displaying data on screen (want it to stop)

7 more replies
Relevance 50.43%

hi,i am currently doing a small web project that uses a MySQL database and PHP.i have a table set up with a list of products that has the main headings:ID, Name, Brand, Category, Spec, Description and current problem is that i want a seperate part of the site for each category.i have figured out how to display the whole table of products in one big list using$data = mysql_query("SELECT * FROM product_db") or die(mysql_error());and then printing it into a table but cannot work out how to display a select category of data or even sort the long table by category , name or price.any ideas?Regards

Answer:MySQL Displaying select data

OK, teach yourself SQL is to big a topic for any post :-)However, although I don't know MySQL and PHP, I can probably give you some general SQL pointers. 1) To return a subset from a table, you need to USE a WHERE clause e.g SELECT * FROM FRUIT WHERE FRUIT_TYPE = "TROPICAL"The above SQL will return all records from the table "FRUIT" where the column FRUIT_TYPE = "TROPICAL" (not "tropical" or "Tropical" since SQL is case-sensitive)2) WHERE clauses can be concatenated and/or wild carded e.g SELECT * FROM FRUIT WHERE FRUIT_TYPE = "TROPICAL" AND FRUIT_COLOUR = "GR*"Check what the wild card character is in MySQL because it can vary between different types of SQL3)To sort returned results use the ORDER BY clause e.g. SELECT * FROM FRUIT WHERE FRUIT_TYPE = "TROPICAL" ORDER BY ORIGIN_COUNTRYThe above SQL will cause the returned results to be sorted by the contents of the ORIGIN_COUNTRY column in the FRUIT table.These are the simplest forms of these functions and much more sophisticated constructs are available. I suggest you google for "basic SQL" which returns a number of good intros to SQL.Like I said, the above a general SQL principles and I normally work with Oracle not MySQL. However, they should give you a hint as to where you need to look in the MySQL docsGood luck

3 more replies
Relevance 50.43%

I've entered an expression in a table field that will display the right mileage rate dependent on the post code entered and the type of vehicle used. The idea is that if a car is going from the BH post zone then I should automatically see the £1.15 rate and a MPV leaving from the GL zone should display the £1.40 rate.

The problem I have is that when I show the table none of the MPV rates are displayed other than the "SP" and "SN" which both happen to be the last post zones in the individual IIF statement and happen to precede the AND statement.

The actual expression is below:

IIf([Post Zone]="BH" Or [Post Zone]="SO" Or [Post Zone]="PO" Or [Post Zone]="SP" And [Veh Type]="Car","£1.15",IIf([Post Zone]="BH" Or [Post Zone]="SO" Or [Post Zone]="PO" Or [Post Zone]="SP" And [Veh Type]="MPV","£1.20",IIf([Post Zone]="BA" Or [Post Zone]="BS" Or [Post Zone]="GL" Or [Post Zone]="SN" And [Veh Type]="Car","£1.35",IIf([Post Zone]="BA" Or [Post Zone]="BS" Or [Post Zone]="GL" Or [Post Zone]="SN" And [Veh Type]="MPV","£1.40",""))))

Where have I gone wrong? I have got more post codes to enter but I won't bother yet until I can get this fixed. I have contemplated creating an Update query to automatica... Read more

Answer:Multi IF expression not displaying all the data

Jerry Tack,

What program are you using?


7 more replies
Relevance 50.43%

Hi Help please: I cam/cord my two youngest Granddaughters moriss- dancing each weekend throughout the summer?[ I also do the other troupes to help the trainers identify any faults?I encode the finished film normal run around 1 hr. onto the PC using Neo/DVD into MP 2 Then Transcode to video format to put on to DVDs.Question? How can I ripDVD into DATA form to go on to a CD without losing the quality of Film!Syd.

Answer:How can I rip "DVD" into DATA form to go on CD.

Why do you want to put them on cd ?Why not just copy the dvd in Nero ?Free dvd to vcd software click here

2 more replies
Relevance 50.02%

I’m creating a website that will handle tons of data, using MS SQL Server for the active content, basically dropping records into a variety of webpage templates for the end-user. But, my back-office first has to sort through tons of raw data and whip it into shape, drafting and editing text, cropping/resizing photos, assigning links, etc. I’m using Access 2003 for that process, to handle everything that is not yet ready to be imported into the SQL Server for publication to the live website.

I understand that I can display data from an Access db on a webpage, somehow (just a facsimile of the real webpages in which it will be displayed, later, one record at a time). It would be very helpful for the back-office staff to have an in-house, interactive way to see how the data they’re editing will eventually appear on the website, giving them insights into how they need to adjust it further.

My head is reeling from all of the different stuff I’ve read about how I might do this. Can you all give some general advice on how I should get started, which direction I should take?

Thank you.

Answer:Displaying Access data records on a webpage

Access 2000-2003 uses Data access Pages to display data on the Web. They are an html version of a Form and can be created by saving a Form as an access Page.

1 more replies
Relevance 50.02%

Is there a way I can scan the keyboard for data that will be entered into a cell I have the cursor on when I look at the graphic? In other words, I want [while looking at the graphic] to be able to change a variable in a particular cell from, say value 1 to value 2. This would then cause the sheet logic to generate different outcomes, and the contents of the graphic would change. Right now, I have to go back to the sheet, type in a 1 or a 2 in the cell, then go back to the graphic.

Another alternative would be it I could click on something in the graphic that changes the value in the sheet.



More replies
Relevance 50.02%

20/04/07 Please see below.

I have a Userform which collects a Product identity and other information which is all stored correctly in the spreadsheet it supports. I need to break into the Userform after Product is entered, to find the product in a separate spreadsheet (it will be there) and retrieve its price, which I then want to display in a new text box on the userform.

I have everything else working, but I cannot find a way to get the price data to appear, before going on to enter the remaining fields. I have set ControlSource for the price field = to its cell address, and I have confirmed that it is there. I have tried reissuing Form.Show but this causes an error, and Form.(next) Item.SetFocus but this seems to have no effect.

Any help will be very gratefully received.


I have solved the problem - part an error on my part and part more experiment and learning. I apologise to those of you whose time I have wasted.

More replies
Relevance 50.02%

I was given a HAICOM HAI-303III GPS which has no display. It is a unit which sends serial data in NMEA-0183 format to a receiver-display.

I have connected to the serial port of my laptop and with Hyperterminal configured at 4800 baud it receives and displays correctly NMEA-0183 data sentences like $GPRMC, $GPGGA, $GPGSA, GPGSV and others which contain information regarding position, speed, course, etc.


RMC Recommended Minimum sentence C
093721.239 Fix taken at 09:37:21 UTC
A Status A=active or V=Void.
3026.2880,N Latitude 30º 26.2880' N
09341.7718,W Longitude 093º 41.7718' W
022.4 Speed over the ground in knots
084.4 Track angle in degrees True
190108 Date - 19 Jan 2008
003.1,W (Empty fields) Magnetic Variation, W
*6A The checksum data, always begins with *

GGA Global Positioning System Fix Data
093722.238 Fix taken at 09:37:22.238 UTC
3026.2426,N Latitude 30º 26.2426' N
09341.7677,W Longitude 93º 41.7677' W
1 Fix quality: 0 = invalid
1 = GPS fix (SPS)
2 = DGPS fix
3 = PPS fix
4 = Real Time Kinematic
5 = Float RTK
6 = estimated (dead reckoning) (2.3 feature)
7 = Manual input mode
8 = Simulation mode
05 Number of satellites being tracked
24.7 Horizontal dilution of position
715.4,M Altitude, Meters, above mean sea level
51.7,M Height of geoid (mean sea level) above WGS84 elli... Read more

Answer:Acquiring GPS data via serial port and displaying it.

Hi GS3,

Searching for GPS display software +open source, I came across The GPS Toolkit &#8211; Open Source GPS Software here. The link is to a PDF (9 page) paper download with links in it regarding the kit. It works on Linux, Solaris, and Windows according to the paper. Open source software is free for personal use.

See Open Source GPS Home Page

-- Tom

2 more replies
Relevance 50.02%

I have a combobox in a subform within a subform that will not display data when the main form is displayed/loaded. If I click on the combobox (giving focus to the field) the data will appear. All other data within the subform displays fine.

Answer:Access 2003 ComboBox not displaying data

13 more replies
Relevance 50.02%
Question: multipage scanner

Any ideas please? I am looking for a scanner that can scan a quantity of A4 automatically...I have to colour scan 100s of pages and can't waste the time single feeding....Cheap as posssibe?Many thanks.

Answer:multipage scanner

Look for any scanner with an automatic page feeder. Most of the major manufacturers produce them.

1 more replies
Relevance 50.02%

I have a user form that contains three multipages on it. I want the first multipage to always be displayed when the user opens the user form. Right now the multipage the user displayed just before they close the page is the one displayed upon opening again. Does anyone know how to go about doing this?


Answer:VBA Multipage Display

Hi Jillianbk,

What you need to do is to is to set the 1st page object in view before you show your UserForm.

In your code, right before you display the UserForm, enter this line:

UserForm1.MultiPage1.Value = 0

This will always make the first page in the MultiPage control be displayed. Of course, if your UserForm is not named "UserForm1", you must change that part to match the name of your UserForm. The same goes with the MultiPage control. If your is MultiPage2, then change that part as well.


2 more replies
Relevance 50.02%

I have a user form that has three multipages on it. I want the first multipage to be displayed first every time the user opens the userform. Right now the last user form shown on the screen before the user closes the user form is displayed.

How do I do this?


>> duplicate closed <<

More replies
Relevance 50.02%

I have used the search option prior to making this new thread in order to find an answer to my question but I couldn't quite find what I was looking for.
Here is my problem.

I've made a website in PHP in which it is possible to search for data which is stored in a phpMyadmin database. This data is categorised in several different categories.

I have also made a seperate page which is only accescible by password.
What I'd like to do is to make it possible to add more data to the database from the website itself (after having logged in with the password) via a form.
The whole logging in thing works just fine but I haven't got a clue how to make it possible to add more data with a form.

So far this is a script I have found and used but it doesn't quite work:



$hostname "locahost"
$username "235301"
$password "235301"
Read more

Answer:Data entry through PHP form

To see what's going on, you can try temporarily putting error_reporting(1023); at the top of the PHP code and removing the @ sign to display all errors/notices. If you still get nothing, the script is probably not being run. Perhaps the session is not being propagated correctly? It could also be some other technicality. (I did notice the $genre line was not completed.)

3 more replies
Relevance 50.02%

Cannot save form data in IE7&8

Windows XP SP2 IE7 latest SP
Windows XP SP3 IE7 latest SP
Vista Ultimate SP1 IE7 latest SP
Vista Ultimate SP1 IE8 Beta 2
The PC in question went through the above migration and at no time
did AUTOCOMPLETE ever work.

The AUTOCOMPLETE checkboxes are indeed selected under CONTENT TAB
and ADVANCED TAB in IE options page.
Autocomplete web addresses works.

Computer history -PC was made from corporate image and I suspect a
very very special and well hidden group policy may be enabled.
Examples: Autologon disabled and remeber NTusername for Windows
logon were disabled. That stuff was easy to find and fix.
Tried so far.
Removed IE7 and IE8 numerous times.
Cleared TEMP internet files
Rebooted after changes
Cleared save autocomplete options cleared password and form data,
Turned autocomplete on for all 3 fields.
Reinstalled IE7 many times. Upgraded to IE8.
Removed IE8.
Reinstalled IE 8.
It just won't save any form field in any web page I visit.
I browsed for an hour Group policy, found internet explorer in two
places (computer and user) everything set NOT CONFIGURED.
Nothing found in LOCAL SECURITY POLICY either.
I even added a new user added to ADMIN group and that person has
same issue also. So not applicable to my admin username.
The only clue I have is the following
In the registry in
HKCU\Software\Microsoft\Internet Explorer\Intelliforms
there should be 3 subkeys
On a PC that does work IE8 XP SP3, th... Read more

More replies
Relevance 50.02%

I have been working on this for most of this week and I cannot figure out the SQL code in Access 2007. I have a table called Agent_List and a table called Matrix. I have a form to fill in data from the Matrix table but I want to lookup a PBXID and have the First Name and Last Name fields on the form automatically fill in.

Can someone help me?

Answer:Form - Automatic Fil in Data

7 more replies
Relevance 50.02%

I am designing a website where the user enters data in a form, and this data is then used to access / retrieve records.The data is simple, - forenames and surname.I am trying to find a data validation routine (using Javascript) such thata) the surname can't be blankb) the surname must be alphabetic, - plus a wildcard symboland c) the surname must be more than 3 characters long.Can anbody PLEASE recommend a routine that WORKS.I have tried one in "Learning PHP & MySQL" by Davis and Phillips which DOESN'T work and trying to make it work is driving me nuts.

Answer:Data Form Validation

You should never validate form data by JavaScript. Depending upon how it is coded, around 10% of your visitors will find either a form that fails to function or a form that is not subject to any validation. If the latter is the case, it obviously presents a very easily utilised and serious security flaw to any malicious user, who simply needs to disable JS....If you don't want to or cannot write your own PHP program that includes validation, that's understandable, but there 'net is full of resources for off-the-shelf PHP form processors. A few of which are actually very good. click here for one of them or search through Hot Scripts, etc. Even a basic array check that exits the program when bad words* are found is better than nothing. I have posted that before but I can do so again if you wish.*Bad words, in PHP, does not refer just to foul language but to any content that you wish to block.

6 more replies
Relevance 50.02%

The names, email addresses, and scrambled passwords that I use in my logins
and forms have suddenly disappeared. I am now compelled to retype the whole
ball of wax each time it's asking for it. Has a check-mark somewhere gone

I can't find anything under Tools > Internet Options > Advanced.

Sacramento, CA (USA)

Answer:Login and Form Data

Hello have you used any programs to remove temporary files ?

2 more replies
Relevance 50.02%

can i clear just one field or is it all or nothing ?

Answer:ie8 - how to clear form data

6 more replies
Relevance 50.02%

I've researched this far and wide, and I have yet to come up with a solution.

I recently did a series of password updates and changes to various forums and websites I usually go to, but in the midst of my mass changing (my old email was somewhat comprimised so I changed most of my personal data) I have forgotten a few of my new passwords and "secret question" for security purposes.

My question is if there is a way for me to view / browse the web form data I had SENT from my computer to retrieve this information? I'm not exactly where to look for programs / information to do this, is it under Post Data, Web Forms, in my cache, history...I'm lost

I'm the idiot that never enables "remember this password" for auto-complete, so I'm thinking the outcome may be dim.

More replies
Relevance 50.02%
Question: Deleting Form Data

In XP under Tools, delete browsing history. On clicking delete you are presented with several options, one of which is delete Form Data. This gets rid of names/words you've previously used in search boxes. Like Google for example.This worked on my previous comp but won't work on my present one.Has anyone any idea as to what is stopping it from deleting?

Answer:Deleting Form Data

Are you using Internet Explorer?

7 more replies
Relevance 50.02%
Question: Data form Browser

I am looking for some sort of program that can be used to control a web browser. I wish to take data from a web site and then manipulate it and then use the manipulated data to: insert data, press buttons, refresh the page etc.

Can this be done without any real knowledge of any programming? What sort of software can do this? Is there software available for download that can do this?

Answer:Data form Browser

If you use Firefox as your browser, there are extensions you can use, see:

1 more replies
Relevance 50.02%

I recently did a cleanup on a users laptop, effectively nuking all of his form data to a miriad of websites he had usernames/passwords saved for. Not a happy guy right now.
He has a desktop that has all of this data intact. Any way I can "export" this data back to the laptop ? Not sure if the data is stored in reg keyes or temp files on the HDD.
User is running IE on both systems. He actually running Firefox as well... form data on desktop is also intact. Need to get that exported too... but one thing at a time.

Any help would be GREAT !!!


More replies
Relevance 50.02%

Hello, I am trying to copy data (fields) from one form to another and I found a VBA code as follows:

Create the command button on the form and double-click it in design mode.
You now are the VBA mode for that button in the click event.
Simply add all the fields in this form:
Anotherform![fieldname] = Me![fieldname]

I tried but im getting the following error message:

"run-time error 424

object required.


Answer:Copy data from one form to another

Before I try and answer the VBA question can I ask why you want to do this?
As copying data is not supposed to happen in Relational Databases, data should be referred to.

1 more replies
Relevance 50.02%

Hi all,I'm looking at the possibilities of setting up a webform using dreamweaver.It's currently in the form of an Excel spreadsheet. It's simply a change control register. When something needs changing on a process it needs to be logged.The user will input into a form and then submit. On submitting the contents of the form would be displayed as a table (register) which anyone can view on the page.The type of fields required would be:drop down lists to choose fromdatestext field (used for job description)link to relevant job folderlinks to related job foldersa boolean option of some sort (probably yes/no)a number of other text fieldsIf anyone can give advice that'd be great. Otherwise it's either keeping it as an Excel file or having a go building standalone in Java.Thanks all

Answer:Data Form using Dreamweaver

It seems to me that you should be designing a database to drive your webpage (site). The form would be used to update the database and your display page would be generated by the database. Dreamweaver Help can get you started if you look at 'Developing Applications Rapidly'. Will the users be remote, which is why you are going down the webpage route? Will it be an intranet for your office?

2 more replies
Relevance 50.02%

Does anyone know where IE's auto-complete form data is stored in the registry??

I want to be able to make a batch file/registry file to clear the contents during the logon process but don't know where the details are stored.

I'm not referring to the typed URL's...just the form data, like the drop down lists from search boxes.

i think the following keys are involved but not too sure:
HKEY_USERS\*******\Software\Microsoft\Windows\CurrentVersion\Shell Extensions\Cached

Any help would be cool :)

Answer:IE AutoComplete Form data...


Does anyone out there know the answer please????

Further to my previous post, i'm not sure that those registry keys are relevant at all.....I took a snapshot of the registry before clearing the autocomplete data and one afterwards and then compared the two and those two keys were modified but I repeated the process and it was different so i'm even more confused now

7 more replies
Relevance 50.02%

I have a very large file that records our staff Annual leave and other absences. but all the information has to be entered by me, when people request leave via e-mail or via paper leave forms.
I would like to be able to automate this, the best way would be for a form to be sent via e-mail. If it could some how then update my existing data base this would be great.

Andy body out there who can help


Answer:EXCEL: Add data from a form?

8 more replies
Relevance 49.61%

I have been researching this issue for the past few days and can not come up with a good solution. I have pages built from a CMS that contain tables that span beyond the first page. This causes firefox to ignore anything beyond the first page and print just the first page. I cannot change the entire cms and how it builds the page. I am stuck with the tables. I'm looking for a workaround to have firefox print the entire article even it it is printing the entire webpage. I do not have this issue in IE, and it only prints the article not the right nav. Please let me know if you have workaround suggestions.

Answer:no multipage printing in firefox

Hi barbedivy.

Does it show the whole document when you do a Print Preview? If it does, when you click on the 'Print' command try selecting in the Print Range 'Pages' and enter the first and last page numbers.

1 more replies
Relevance 49.61%

Using:Windows XP Home + SP1Microsoft Works 6Open new spreadsheet8 columns24 rowsno alterations - to height/width/anythingFormat borders/gridlines around 3each cellPrintPrints 4 pagesEach page contains 4 columns and 12 rowsEven older spreadsheets now print as above

Answer:Spreadsheet prints multipage

it's hard enough trying to workout a solution, it's even harder to do it when you have to workout the question first. Could you try the question again, this time with a little punctuation and a better explanation of the problem. Sorry rrobbie, maybe it's just me.

4 more replies
Relevance 49.2%

I have an excel spreadsheet with many rows and columns. What I need to do is take this spreadsheet data and populate it on a form, like a word form, or even a web based form that I could print. So for each row on my spreadsheet I will need to create a form and the data in column A will need to be populated on one specific field on the form, column B on the spreadsheet will need to be poplulated on a different field of the form, etc...

So is it possible, or is there some program that can do this? - export data from a spreadsheet into defined fields on a form? What I'm guessing is that I will need to create an Access database and it could be driven into a web based form??

Hoping to find an easier way than manual input


Answer:Extracting Excel Data onto a Form

There is nothing I can think of that will automatically do this for you, although there easily could be such a thing out there.
However, you could easily import the spreadsheet into Access as a table and then base a report (for reading what is there already) or a form (for entering more data) on that table. From within Access, you could make a page that you can post onto the web.
Another alternative - if you just want to see the data row-by-row - would be to do a mailmerge into a Word document with the various fields representing the different columns of information you have.
If you could post a copy of your Excel sheet - with dummy data, preferably, and perhaps a Word doc or a page in Excel showing how you want the data laid out.
The more we know about what you ultimately want to do with this the more we can help you.
A VBA whiz could probably whip up some code that would turn your data into an HTML or XML file, for all that matter....

2 more replies
Relevance 49.2%

I have a problem with my database that I cannot get my head around. I can email it to be looked at if required. As far as I know I had normalised the tables and all was fine. However there have been some design changes and I am now stumped. I have a table that contains aanything between 20 to 40 records at a time, ([Timetable]), listing details of teaching classes. These records will never change much or be added to a lot. There is a junction table, ([Junction_Timetable]) connecting it to the main students details table and this table will contain all students who are scheduled for particular classes. What I wish to achieve is when a user opens a form, (from table [Timetable], and subform, (from table [Junction_Timetable], after the class has been held they can edit which students have attended and can then somehow save all the data from both forms to a completely different table, ([Completed_Classes]). This is required so we have got historical data on all classes held and students attending or not attending. I did receive good advice on here when I normalised the original table design and was hoping for help again. I have put a lot of thought and effort but my mind is fuzzy with it all. It is probably simple and I am probably capable of working it out but I cannot seem to nail it down. OBP you have already seen the table structure a number of weeks ago but if you need to see it again let me know and I can send it to you.

Answer:Transfer Data between tables using a form

11 more replies
Relevance 49.2%

I found some searches that were in a google search window in Internet Explorer. The only way that I know of getting any searches there is to actually type them there. These searches were of questionable nature. Before I blame others for these searches, I was wondering if there was any way for these entries to get there, such as spyware, etc...


Answer:IE Google search and form data

Hi, Malware does some strange things, so I would not put the idea that they could load some search windows totally away... they often install some pretty nasty Favorites links for you, as an example...
Check your Favorites list> all of them, for strange or adult sites. Probably, another user has done the googles...

Would you consider posting a Hijackthis log so we can help spot problems?

Download the file to a folder you previously made just for hijackthis.exe...a permanent folder, created in Program Files folder, for example. Run hijackthis.exe from the folder it is stored in, hit the Scan button and wait a few....when you see the Save Log tab come up, save your log as hijackthis.txt, which opens normally with Notepad.
With the logfile open, hit the Reply button as if you were going to post a Reply to your thread....go to the saved log, at the top, Edit>Select All>Edit>Copy come to the blank reply, click once inside the space, then back at the top of your browser, Edit>Paste and the log should appear as your reply, then submit the reply. Some one will review it and advise.

1 more replies
Relevance 49.2%

Hi i want to know that are dvds good form of data storage?
How long does data remains safe if i keep it clean in dvd pack?

Answer:Is DVD-R a good form of data storage?

Hi Vexxum. As long as the DVD is not exposed to sunlight or submerged in water for long periods, it will last indefinitely. With the cost of large volume flash drives going down, many people are migrating to them.

A personal choice really. If the 4.7GB capacity is enough for you then it's a pretty safe storage medium.

Oh yea, much better than the old tape/floppy days.

7 more replies
Relevance 49.2%

Hi all. New install of W7 Ult, and fully updated. I use webmail for my Comcast email, and also my personal website email (different address, obviously)

With auto complete on, I open IE11 to my Comcast email, and enter my email address & pwrd. Both are remembered.

I then open the link to my site email, click in the email field, and the email address previously entered at the Comcast site is there.

How do I get rid of that? Clearing the form data and pwrds from Int Options will get rid of the email address & pwrd from the Comcast site, which I do not want to do.

Any ideas? Thanks in advance.

Answer:IE11 form data question

Are you using Comcast domain or something with your site :/
Could you post a screen shot of both sign in pages and or a hyperlink to each one so we might see if there is any similarities ?

9 more replies
Relevance 49.2%

I have a blank form in .pdf format and an Excel 2007 spreadsheet with data. How do I enter the data into the correct places on the .pdf form ?

Answer:Entering data from Excel into a pdf form

Based on the limited information you have provided, the best I can offer is "Copy - Paste". That's how I do it with the fillable PDF forms we have at work.Perhaps with a little more information, we could offer something else.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 49.2%

My First post

I have ( should really say HAd ) a raid with 4 40gb drives the raid was setup to strip/mirror ( 1 pair stripping other pair mirroring )

Unfortunatly 3 of the drivers all decided to fail today, 1 had the click of death the other 2 just stoped being regonised by the motherboard.

I have got the machine back up and running with new drives but had to start from scratch, What i need to know is, is there any way of recovering any of the data on the drives.

One of the drives is ok but as it's part of a pair windows can read the data on it

any help would be gratefull

Answer:Data recovery form a Raid

use file scavenger/raid reconstructor

3 more replies
Relevance 49.2%

I would like to create a form in MS Word, where the layout of the form stays static, but where the User can fill in fields, such as date, name... whatever.I've tried with the instructions found at:, when the User types in data like their name, date and so forth, the layout changes.As a character is added by the user, it pushes the content down the page.How to I create a form where the User can add data but where the form remains static?

Answer:a Form in MS Word where the user can add data

mmmm been a while since I did that sort of thing... But have a look below for tutorials that may tell you how. It is possible to create text boxes that allow input which does not change the layout of the form. The text scrolls (and maybe wraps too) as you enter it; and usually when "read" later by clicking on the "box/field" that whole box opens for ease or reading. version of Word has a slightly different approach; some of the "tools" used may not be in the same place for each version; you may have to search around the version of Word you have to find something (a tool/option etc.) clearly obvious in another... Likewise some versions may allow somethings another doesn't.The above links cover most flavours of Word to whatever degree; and likely can be are modified to your version of Wod, if not specific to your version.

2 more replies
Relevance 49.2%

I know that there is previous thread along this same line, but I have a different issue. I am a beginner with VBA and have been using examples from the Internet to write my codes. I have a User Form that I created in Excel 2007 that adds the information entered to the first empty row without any problems. Since then, I have been creating a new User Form using the same code, however, I'm getting the "Application-defined or object-defined error". Debugging takes me to the code for finding the first empty row.

Here is my code:

Private Sub cmdSubmit_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Inventory Request Log")
'check user input
If Me.txtName.Value = "" Then
MsgBox "Please enter your full name.", vbExclamation, "Inventory Request"
Exit Sub
End If
If Me.txtPhone.Value = "" Then
MsgBox "Please enter Phone Number.", vbExclamation, "Inventory Request"
Exit Sub
End If
If Me.cboCampus.Value = "" Then
MsgBox "Please select the Campus item is located.", vbExclamation, "Inventory Request"
Exit Sub
End If
If Me.cboProdReq.Value = "" Then
MsgBox "Please select Type of Request.", vbExclamation, "Inventory Request"
Exit Sub
End If
If Me.cboType.Value = "" Then
MsgBox "Please select product type.", vbExclamation, ... Read more

More replies
Relevance 49.2%

The requirement is for some non-secure data that is captured in a Form to be emailed on clicking Submit. Works fine in IE. In Firefox the email is not populated with the data. Have tried Firefox Forum but no luck. Any thoughts?The HTML is quite standard stuff. form action="mailto:[email protected]" method="post" enctype="multipart/form-data" name="formReply1" id="formReply1">

Answer:Emailed form data in Firefox

Thanks for that. You may find the info on this site of value. click here

1 more replies
Relevance 49.2%

Hey I have PDF Form which would not let me save the data typed into it...

Here is the form

I want it to save the data typed into it so that I can email it to my relative...

Any ideaS?

Answer:Save data typed into PDF Form

1 more replies
Relevance 49.2%


I have a MS Word Form that is delivered to it's users as a locked document. The reason for doing this is supposed to be "ease of use" because of the "easy tab" feature of going from form field to form field, and also to prevent the user from manipulating the form or changing it's appearance. (The "users" are my employees - inspectors - who enter the results of their inspections into the form).

The user must first unlock the form to enter the job # into the header and then re-locks the form and begins to enter the rest of their data into the body of the document. The problem is that some of the users always seem to find need to go back and unlock and then again relock this document.... either to change some information or use spell check... If the document is re-locked after data has been entered into the form fields, that data instantly disappears. Vaporizes. It's gone. There is no way to go back and get it. No "un-do".

Does anyone know a way to prevent this from happening? We're all actually pretty happy with the way the form works right now except for this little detail, so I don't want to go away from it entirely. I do have reasons for wanting to stick with a locked document, too (so it can't be altered after being sent to clients, etc). All I need to do is STOP the program from devouring our data the second we click that lock button again.....

Thanks for any help that you can provide!
Wild S... Read more

Answer:Word Form Devours Data

Open your empty form.
Hit Alt+F11
At left, open your document so you can see This Document underneath it.

Paste this code into the code window at right:

Sub ReProt()
ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True, Password:=""

End Sub

Close the VB Editor.
On your document, create a toolbar button to run the macro.
For help with that, see Step 2 of:

We could create a toolbar for Unprotect and Reprotect if you like, but requires a bit more VBA coding.

Otherwise, they can only use the Reprotect because macros cannot be run (except by a separate toolbar button) when the doc is protected.

Hope this helps!

2 more replies
Relevance 49.2%

Hey I have PDF Form which would not let me save the data typed into it...

Here is the form

I want it to save the data typed into it so that I can email it to my relative...

Any ideaS?

Answer:Save data typed into PDF Form

What software is least expensive which will allow saving the data typed into the PDF form to the hard drive?

8 more replies
Relevance 49.2%


Need help please.. I need to create a Form with Combox which will display the list of data to the user to select. The selection I want to show is data list in the due date. This will then filter that data and copys the result to a new sheet.
The data is in the other spreadsheet. I have attached the data for example.

I can create the form and thats about it....

Answer:Using Form with Combox to filter data

I have attached an excel sheet that has a command button to show a form with a Combo box + lots of VBA.

However this application should really be in Access.

2 more replies
Relevance 49.2%

Hi. Is there a way to transfer existing information from existing original Outlook 2007 Contact Forms onto a newly designed format Contact Form?


More replies
Relevance 49.2%

I have opened a pdf form online which I want to fill in and save.
However it will not allow me to do this and says the following:
"You cannot save data typed into this form. Please print your completed form if you would like a copy for your records"
Can anyone please tell me how to get around this.
I have Adobe reader 9 and Windows 7.
Many thanks

Answer:You cannot save data typed into this form

Press 'Print Screen' key then paste into word

2 more replies
Relevance 49.2%

Okay, so this is weird. I've tried numerous google searches about this and nothing has come up.

Google chome is not saving only particular form data, for instance my username: therealdrag0. Also my main gmail account name isn't saved. It's so annoying. Other stuff I put in, other emails in the same form, are saved, so that when I come back they drop down, but my main one isn't.

Any thoughts?


More replies
Relevance 49.2%

Hi, I had excellent help the other day when I was talking on this forum, so I decided I would try it again. I have been searching for a way to auto-populate data into a new form.

What I am doing is I have a form that is called Invoices. I have a combo box called Customer Name. I have it set so it pulls the customer names from my Customer Information Query. I have it set to Inherit value list. (I have never used this before) Anyway, it works great except that when a person enters a new customer name that is not in the value list, it will prompt you to add the customer, they click yes and it opens the form to add the customer. This is everything I want it to except that when they click yes I want it to open the form to a new record and already have the new customer name populated into the form. So then all they need to do is add the additional details and save the record.

How do I do this? The way it set up now it opens the form to the first record and I am leary that data entry users will write over that first record instead of opening a new record and re-enter the new customer.

Does this make any sense to you? If so please help!! I know it is possible as I have seen databases set up this way, I just am not as expierenced in doing this.

Thanks for the assitance!

Answer:auto populate data in a new form

11 more replies
Relevance 49.2%

I have opened a pdf form online which I want to fill in and save.
However it will not allow me to do this and says the following:
"You cannot save data typed into this form. Please print your completed form if you would like a copy for your records"
Can anyone please tell me how to get around this.
I have Adobe reader 9 and Windows 7.
Many thanks

Answer:You cannot save data typed into this form

If you have opened the PDF file from the web I don't think you can just save it.
Try selecting Save as.
Or download the file to your hard drive first.

2 more replies
Relevance 49.2%

Hi All,I have 1 Workbook Template (Worksheet Master) which have hyperlink to another workbooks based on value choosed from dropdown list and will link it to Worksheet Membership (each workbooks have worksheet called 'Membership') by using command button. My question is, by using VBA:-How can I automatically find the match value from Worksheet Master in cell E17 into Worksheet Membership in column J once its opened from hyperlink? Currently I just using Ctrl+F to find the match value.-Once match value found, can data in the column F,K & L (in same row where value found) automatically to be copy and paste it back to Workbook Template (Worksheet Master) in cell S17, S19 & S21? Currently I just manually copypaste.This is the VBA code I wrote in Command Button 4 to link the Workbook selected:Private Sub CommandButton4_Click()ActiveSheet.Unprotect "x"
ActiveWorkbook.FollowHyperlink Address:=Range("AE1").CurrentRegion.Find(What:=Range("S23").Value).Hyperlinks(1).Address
ActiveSheet.Protect "x"
End SubThanks in advance. If someone willing to help and provide the VBA code, please tell me where to put the code.*If anyone willing to answer, with respect, please explain it in simple word and simple English because I am not too good.

More replies
Relevance 49.2%

Hi All,I have 1 Workbook Template (Worksheet Master) which have hyperlink to another workbooks based on value choosed from dropdown list and will link it to Worksheet Membership (each workbooks have worksheet called 'Membership') by using command button. My question is, by using VBA:-How can I automatically find the match value from Worksheet Master in cell E17 into Worksheet Membership in column J once its opened from hyperlink? Currently I just using Ctrl+F to find the match value.-Once match value found, can data in the column F,K & L (in same row where value found) automatically to be copy and paste it back to Workbook Template (Worksheet Master) in cell S17, S19 & S21? Currently I just manually copypaste.This is the VBA code I wrote in Command Button 4 to link the Workbook selected:Private Sub CommandButton4_Click()ActiveSheet.Unprotect "x"
ActiveWorkbook.FollowHyperlink Address:=Range("AE1").CurrentRegion.Find(What:=Range("S23").Value).Hyperlinks(1).Address
ActiveSheet.Protect "x"
End SubThanks in advance. If someone willing to help and provide the VBA code, please tell me where to put the code.*If anyone willing to answer, with respect, please explain it in simple word and simple English because I am not too good.

Answer:How to find data form another Woorkbook

There may be another way of doing what you want, but you need to explain clearly what you are trying to achieve, list your process steps and expected outcome. Also explain the layout of your worksheets. If all you want to do is open another workbook and protect it, based on the value in a dropdown menu then that it pretty straight forward and I wouldn't use the hyperlink method for that. There are other ways, not suggesting they are better but I prefer them as they don't rely on using hyperlinks or formulas which can break.

2 more replies
Relevance 49.2%

Ok I have created a database, split the database, and provided multiple users with the Front End copy of the data. Everyone is keying in the form and adding records to the table.

I have a little problem.

One user will key in the bulk of the information but another user will need to finish the record. I have a "Find" command button on the form for them to be able to look up a record number but the problem is:

The user that needs to finish the record cant see what the inital keyer has keyed until she goes all the way out of the database and back in.

Is there a refresh button somewhere that will allow all the users to see all that data that has been keyed in at that point? I hope thats clear enough.....

(Access 2003 )

Answer:Updating data within a form/table......

Figured it out . For the readers all I had to do was add "Me.Requery" to the code of the Find Record command and it updated the database before they actually would look for the records.

1 more replies
Relevance 49.2%

Does anyone know of a tutorial or a program that will do the following?

Allow a customer to go to a HTML webform. Fill out the data, then after clicking a button (submit, next, etc) will create a .pdf form for the to print out with the data inserted into it?

Any help would be great.


Answer:On The Fly PDF creation from HTML web form data?

see if this works...

1 more replies
Relevance 49.2%

HI - I'm trying to enter data in an Access form. It works fine from one table, but when I link 2 tables it won't let me even if the Edit and Dataentry boxes in the property sheet are yes. The two tables have an 'undetermined relationship' without referential integrity, which may be my problem, but how do I figure out what is allowable in the 2 table relationship? It's Windows 7...the 'error' is it's greyed out - uprseponsive.

Answer:Entering data from 2 tables in a form

Welcome to TSG elstevek.
Most likely your table is not keyed or or indexed correctly. Allen Browne (one of my favorite Access Resorces) list a number of reasons here: Why may query is read only.

1 more replies
Relevance 49.2%

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

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

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

2 more replies
Relevance 49.2%

my pc still wont work could i use another pc to install xp onto my hdd and then plug hdd into problem pc to solve issueall problem pc says is reboot and select proper boot deviceive disabled network boot set cd as 1st boot priority hdd 2nd i even downloaded linux ubuntu to see if that would work but still have same messagejust dosent want to boot in any wat at allmy mate sugested checking all the cables disabling everything reboot then re enable but that didnt work (made no diference)now only three options get help off internet, take to profesional pc shop or throw it out ide hate to doo the later if the problem has a solutionPlease help if you can ripping hair out now

Answer:can i transfer hdd form pc to pc no data loss

You need to discover why the XP CD is not booting, this is the orignal less than a fortnight old thread:

4 more replies
Relevance 49.2%

Hi everyone i have a database with 4 forms in, when i fill the data in one form i want to be able to press a command button that will print the data into a report. Is this possible? Im using access 2000 on xp pro

Thanks in Advance.

Answer:How do i get the data from my form into a report so i can print??

15 more replies
Relevance 49.2%

Hi there,
I'm having a problem I've never actually seen before. I have 4 charts embedded on a worksheet. 2 of these charts contain 2 data ranges; are simple line charts; show the data table; and data source is another worksheet in the same workbook. In both cases, the January (1st point) graph point is incorrect in one of these series. All other points in the series appear to be plotting correctly. The first point is almost 2X the actual value displayed. The data point value is correctly displaying in the data table.

Has anyone else seen this before? I'm going crazy trying to figure out where the issue might be. I've deleted and recreated the source data just to be sure, with the same results as above. The other data series in these charts is fine as are the other charts in the group.

Would sure be grateful for any advice anyone might have.

Answer:Solved: Excel 2000 SP3 - Chart not displaying data correctly

can you post the spreadsheet or is the data confidential?

3 more replies
Relevance 48.79%

In attempting to print multipage documents of late- the printer will print 3 pages and then error- the error will clear by opening and closing the paper drawer-- where upon instead of completing the run the machine will repeat ther first three pages.
I get over this by going to to the page selector panel and printing the remaining pages as singles.
This is a recent occurrence, and have so far been unable to resolve it - any ideas?
Computer - Ubuntu 10.10
Printer Dell1320C

Answer:Printer will only print first 3 pages of a multipage doc.

My first thought is that perhaps your system HHD is too full to store a complete cache print file. Check you system drive and delete (including the Recylce bin) as much as you can.

4 more replies
Relevance 48.79%

I have a printer that also serves as a scanner. Using Windows fax and scan I don't see how to scan a multipage document into one file. Each time I click on "new scan" it sets up a separate file. It doesn't tell me how to add a page to my first scan so
I will be able to have only one file with many pages scanned in it. Can you help? Thanks, kazzole

More replies
Relevance 48.79%


I am using Access to hold data. The table in Access runs across from right to left. I want to copy the data that runs from right to left and paste it into Excel from top to bottom ( up and down). Is there a way to do that without doing one field at a time. When I copy out of Access now and try to paste into EXCEL it of course paste's it across not up and down like I need it to


Answer:Data from Access table to Excel Form

Once it's in XL, you could try re-copy ; then (in a free area), Edit -- Paste Special -- Transpose -- OK.


2 more replies
Relevance 48.79%


We are currently running access 97, we have a database table created, but when we enter on the form that we have created the date and time does not show up on the table. We have on the form the date and time automatically set. Is there a way to have it transfer to the table??

Answer:Access 97: Transfer Data From Form to Table

Sounds like you don't have that form control linked to the table. I'm not sure how to do it off the top of my head, but you can try right-clicking the data field in form design view, and go to the Data tab and check out the control source. It's gotta be something like tablename->field. If you hit ctrl-F2, you should be able to "build" it. It may be helpful to you to look at how another control in the form is set up, then duplicate it, but change it to the date field.

(Maybe that'll give you something to do until the troops arrive.)

1 more replies
Relevance 48.79%

Internet Explorer 8.0 has started just recently to error intermitently between steps of a booking application displaying the 'send error report' pop-up which once sent and the page reloads produces our booking error message?

Very frustrating. Can anyone shed any light?

More replies
Relevance 48.79%

Hi,I currently have a sheet as a 'database of aerodrome details' and a form I made in VBA to enter all the details in the next row. However I would like to be able to enter in the Aerodrome name of an already entered aerodrome and have all the details re-populate the form to make changes and then re save the entry.Please help!!!

Answer:Recall data to a form previously entered

I can provide the basic file I have started prior to actually creating the mammoth task of the actual database.

3 more replies
Relevance 48.79%

Hi Everyone,

Thank you for all your wonderful work on these boards. Your advice has helped me time and again, although this is the first time I'm posting myself.

Here is my trouble.

I adapted script written by Rolin_Again written for a poster named DougS when he was attempting to move data from a Word Form to Excel. I too need to have my Form in Word as it's a mass email and most of if not all of the recipients of the form will not have Access (oh how I wish they had Access). I have written my Form and attached it for you and saved an Excel Workbook called "Registration". The sheet is also called Registration. When I first ran the Macro I ran into the same trouble the poster did here with the Form opening when I used the macro, moving to the "processed" folder but no data transfer into Excel. I tried the fixes offered in that post but not successfully it seems. I am now having a new error and I have highlighted the line that the debugger points out as a problem (Run-time error '9'': Script out of range).

Any help anyone could offer would be much appreciated. I have never written code so this is all very foreign to me.

Thank you in advance. I have seen how helpful everyone is on these boards and I'm very grateful for the help.



Dim vField As FormField
Dim fso As Scripting.FileSystemObject
Dim fsDir As Scripting.Folder
Dim fsFile As Scripting.File
Dim wdApp As Word.Application
Dim myDoc As Word.Doc... Read more

Answer:Capturing Word Form data into Excel... Again, Again

14 more replies
Relevance 48.79%

So, subsequent to my previous thread...

(Basically, I have an Access database which is to be used by many users to make changes).

...once the record has been amended, I need to allow the user to either "save changes" or "exit without saving". At the moment, the data is updated as soon as I leave the form - how do I get round this?



Answer:Solved: Saving (or not) changes to data in a form in Access 97

If the user does not want to save the changes (or additions) they can press the Esc twice to "Undo" the Actions.
However if you want to have a second Button that says Close without saving then before the button's VBA code Docmd.close enter

3 more replies