Computer Support Forum

update field A in form based on entry in field b

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

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

Relevance 100%
Preferred Solution: update field A in form based on entry in field b

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

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

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

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

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

2 more replies
Relevance 99.47%

Hi I wonder if anyone can help. I want the back colour in an organisation name field to change to green if they are a member company based on a "member yes no" check box this possible. I am pretty good with access generally but conditional formatting and code are not something I know much about. Any help gratefully received. PS both fields are held in the same form and table.

Thank you

More replies
Relevance 92.22%

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

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

This form updates an underlying table:

The date field of the "Work_Hours" table is:

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

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

I've created a table called:

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

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

and set ... Read more

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

9 more replies
Relevance 84.68%

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

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

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

14 more replies
Relevance 84.68%

Hi. Here is the situation.

I have two tables (Field_a & Table A and field_b & Table b) and I wanna set up validation rule for field_b (Table b).

Rules needed for field_b:
1. If field_a (Table A) = 0, field_b (Table b) = 0.
2. If field_a (Table A) = 1, field_b (Table b) > 0.

Thanks a lot for the help!

More replies
Relevance 84.1%

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

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

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


More replies
Relevance 84.1%

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

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

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

Building the Ultimate site list for PC support.

Answer:Make table based on form field in Access

16 more replies
Relevance 81.49%

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

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

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

16 more replies
Relevance 80.91%

I have 2 tables that are linked by a zipcode field. One one table there is a kinda count field. If the zipcode field on the first table is updated, then I want the count on the second table to increase by one.How can I go about doing this? Thanks for all the help.

Additional info left out: The zipcode field on the count table has a list of zipcodes. When a zipcode is entered on the other table, I want it to match the zipcode in the count table and update the count for that zipcode. Thanks.

Answer:Update one field in a table based on another field in another table.

Not quite sure what you are trying to do, but is linking the zip code fields a good idea? Are you tring to find the number of times that a particular zip code is entered?

2 more replies
Relevance 78.88%

I know the Include Field will include part of the text from an Include File if it is in a bookmark. The format is {IncludeText "File Path" Bookmark}. I have 2 files: Source and Target.

Source is a form template. I included a Text Form Field and gave it the bookmark AA. I also included other text in a "normal" bookmark, BB.

In Target I have 2 fields: {IncludeText "C:\\" AA} and {IncludeText "C:\\" BB}. The text from BB shows up, but the one for AA is blank.

If I go into Source and look under Bookmarks, both AA and BB are there.

BTW, I have tried it with the Source form both "Protected" and "Unprotected" and it didn't make any difference.

Any idea why this is happening, and more importantly, any idea on how to make this work? If not, it seems like a real bug in Word 2003 as they are both definitely considered to be bookmarks.

Thank you,


Answer:Word 2003 - Include Text Field - Not Including Bookmark Text if in Form Field

Thread reopened for user to post solution.

3 more replies
Relevance 77.72%

Hi everyone,

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


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

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

2 more replies
Relevance 106.19%

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


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

10 more replies
Relevance 106.19%

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

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

Help is appreciated!


Answer:Access 2007 Update Table Field from Form

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

3 more replies
Relevance 105.78%

I wish to know if it is possible to update a field on one sheet with the last entry of another sheets column?

as info is added to one sheets column the data on the other sheet is automaticall altered to show the last entry in the first sheets column where i entered the data in the first place

Answer:Solved: EXCEL: update field on one sheet with the last entry of another sheets column

16 more replies
Relevance 97.17%

Here is what I'm trying to do.

For lists Equipment in drop down box.
Whatever equipment that is select, the equipment type field needs to be updated from a table.

Is there a way to get a value from SQL statement?

SQL = "SELECT [Equipment Type] FROM OrderDetails Where " _
& " Equipment = '" & Me.Equipment & "'"
[Forms]![OrderDetails]![Equipment Type] = SQL

Answer:Help with access form (insert table value into form field)

Mhouser, if you are trying to "display" a value related to the Combo selection you can have thta value as an extra column in the combo and refer to it with simple VBA.
You should not populate a Field's actual value with that from the combo as that is duplication.
Can you tell me which one you are trying to do?

3 more replies
Relevance 95.12%

I use due dates on my Outlook tasks. When I customize my Tasks list (in the Calendar view) to group by due date, I just get too many groupings (one for each due date!). I would like to know if I can create a custom field called 'Due Month' and/or 'Due Week', extracted from the 'Due Date', so I can view my tasks by what is due during a given week or month. If the answer is yes, any suggestions on the technique I would use would be greatly appreciated.
Thanks in advance,

More replies
Relevance 95.12%

I have a table titled time_slips used to track the amount of time an attorney spends with a member. In the time_slips table there is a field titled reference_id which is a combo box pulling it's displayed information from another table titled references. Also in the time_slips table is a field named details which is native to this table.

My question is, can I have the details field auto-populate "no charge" when a certain reference id is selected (i.e. 300)?

Thanks for any help you can provide.

Answer:Solved: Access Auto-Populate a Field using a field from another table

15 more replies
Relevance 95.12%

Hi all. I have different table for each type of inventory that we have. I would like to design one master form that would ask what type of inventory that the user would like to enter. Depending upon what the user selects, it will change the fields to the categories in the pertaining table. Is this possible?

Answer:using a form field to select display of a form

12 more replies
Relevance 94.3%

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

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

under the format options.

5 more replies
Relevance 94.3%

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

Any help is appreciated!

More replies
Relevance 94.3%

I am setting up kiosks that once in the field will be locked down and not accessible to anyone in the field nor do we want anyone else accessing them. However, I need the ability to remote into the system if there is an issue.

Is there anyway to set up the machine so that I can do this without someone being in the field at the machine?


Answer:Remote connect to a system in the field w/o user in field


3 more replies
Relevance 94.3%

I have an access 2007 database that has fields for several addresses. I would like to have access skip subsequent address fields if the previous field is blank. I have done this before but for the life of me cannot remember how it was done. Thanks.

More replies
Relevance 94.3%

when I used to hover my pen over say IE URL address field,   there used to appear a little tooltip handy for context pen entry. Now it isn't there and l can't see how to switch it back on. Help!

More replies
Relevance 94.3%

I am creating an Access entry form that has a space for credit card information. I would like the box to have a drop-down menu that says "Visa; Master Card; American Express, etc.". How do I create this? There will be multiple people using this form so I am striving for consistency. Thanks!!

Answer:Drop down menus in entry field?

The item you are looking for is called a combo box. When you place one on your form, a wizard should pop up and ask you about where to get the information to fill it.


1 more replies
Relevance 93.48%

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

Answer:Continuous form field

6 more replies
Relevance 93.48%

Hello all

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

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

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

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

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

More replies
Relevance 93.07%

I have a spreadsheet which I track students test scores which works great with the following vlookup. "=IF(D22>0,VLOOKUP(D22,MAST,2),"")"The location MAST is a name field on another tab and I can change that as I need based on 3 different program codes.But now that I have mixed classes I want to be able to (for example) start in cell range B2:B35 type in their program codes then have the forumula look in example B2 for the program code, then using name manager go to the scores tab and locate the score.On my score tab I have 9 columns (3 for each program). First column is Program ID (ex: MAST), second column is Score (ex: 75), 3rd is percentage (ex: 75%).How can I have the foumlua look in B2 for the Program Code then go to the 2nd sheet where the scores are and return the correct value?Thanks

Answer:Vlookup w/Name field based on Program ID

Look up the INDIRECT function in the Excel help files.INDIRECT returns the reference specified by a text string. e.g. with MAST in B2, this formula would be equivalent to yours:=IF(D22>0,VLOOKUP(D22,INDIRECT(B2),2),"")

2 more replies
Relevance 93.07%

I am working on a database that stores genus, species, and variety I want to sort the data with genus, then species, then variety.

Now the tricky part. Sometimes there is no species. When this is the case, I want the database to sort that record off of variety.

I have though of a way to do this, but need help with the code.

If I make a species2 field, I could create an expression that would look at the species field. If the species field is empty, it could copy the data from variety. If it is not empty, then copy the data in the species field.

Once the species2 field has the updated data, I could then do a sort

genus, species2, variety

The report would have genus, species and variety showing and species2 would be checked off to not show in the report.

I am using Microsoft Access 2000.

Any help would greatly be appreciated.

Answer:Access - if field is blank, copy field A, if not copy field B

You should not actually need another field to do this, just another column in your report's Query. Something like this as a Field header :-

dummySpecies: iif(isnull([species]), [genus], [species])

this should provide a column with the species in if it there and the genus if it is not, which you can use in place of your actual species field in the report for sorting.

1 more replies
Relevance 92.66%

Hello everyone,

I have the current formula

CompPassFail: IIf([specifiedComp]>[PCcomp],"Fail","Pass")

This works O.K, but I am being told that it should pass or fail if is within -/+3percent. Both field are percentage fields, where[specifiedComp]is the main number that [PCcomp] has to more or less align to.

More replies
Relevance 92.25%

I have a field in my Access 2003 database that currently requires the user to enter the 2 digit month & 2 digit year of the incident as the prefix (prefix) to the case number. I would like to have this automatically created based on the date entered in the date of incident field (date).

Any ideas would be appreciated.

Answer:Solved: Access 2003 automatic field entry

16 more replies
Relevance 92.25%

MS Word has a perennial feature that allows you to build a Table of Contents based on words and phrases you select rather than traditional Headings. To access this feature you highlight the word or phrase you want to appear in your TOC. Then you press [Alt]+[Shift]+[o] and a 'Mark Table of Contents Entry' window appears.I understand the purpose of the Entry and Level fields, but not the 'Table Identifier' field. Can someone please enlighten me? By default the Table Identifier field is set to 'C'. Up to now I have left it alone.Thanks.howagoodhowagood

Answer:Expanation of one field in MS Word 'Mark TOC Entry' window

Google is our friend.I found the following at also that a TC field can have a ?table identifier.? If you want certain entries to appear in a specific TOC and others in a different one, you can create TC fields with different identifiers; these entries will then appear only in the table of contents whose TOC field has a matching identifier. For more on TC fields, see Word?s Help topic ?Field codes: TC (Table of Contents Entry) field.?message edited by DerbyDad03

3 more replies
Relevance 92.25%

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

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

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

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

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

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

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

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

On Error GoTo ErrorHandler

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

If txtDocotorName = vbYes Then

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

Answer:auto populate form field

10 more replies
Relevance 92.25%

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

Answer:Query Parameter Field in a Form

7 more replies
Relevance 92.25%

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

More replies
Relevance 92.25%

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

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

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

Can this be done? Any ideas?

More replies
Relevance 92.25%

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

Answer:Solved: Add calculation field to Form

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

3 more replies
Relevance 92.25%


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

Answer:Inheriting from another field in access form

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

1 more replies
Relevance 92.25%

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

Answer:Word - Text Form Field

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

3 more replies
Relevance 92.25%

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

Answer:Form Field spurious properties

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

2 more replies
Relevance 92.25%

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

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

just refreshing the post.Any ideas anyone?

3 more replies
Relevance 92.25%

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

Answer:Outlook Contacts: Add field to form

6 more replies
Relevance 92.25%

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

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

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

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

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

8 more replies
Relevance 92.25%


I hope this is an "easy" answer.

We use an Access database to track class registrations for recreation programs.

Each program has a limit on class size.
How can I set a limit in Access so that when that number is reached, it displays a message....

I'd like to be able to continue to add records if it's decided that the class size can be adjusted, I really just want the message to appear.

I have a course table which has the course name, course code, start date, end date, and cost

I have a registration table in which all the registrants info is entered and the course is selected from the course table.

Thanks for any help with this.



Answer:Access 2K-Limit records based on a field

I would do a record count and see if it is equal to or less than the class limit. It is was, then I would do a messagebox or pop up window to give a message. you could to the message box with a yes or no. yes would add it, no would do nothing. the easiest is the message box. just look up msgbox in access help or give some more information on what you are doing.

2 more replies
Relevance 92.25%

I am trying to create a database, to keep track for stores orders for the ship i am on.
I want to auto generate the stores order number (Order Number) in the format
The 0730 is fixed as is the TAK. The yy is 2 digit year and the $$$ is the sequential number.
The yy field i want to take the year from the "Order Date" field in the same form.

IS this possible?
I have Access 2007 but the final database may have to run on 2003.
The database is still in early stages so is still small can be forwarded if it helps

Many Thanks

Answer:Sequential numbering in access based on another field

11 more replies
Relevance 92.25%

I have a spreadsheet with hundreds of records. In row "I", there is a number that is representative of an employee. I need to move the entire row based on that one field.For example, in the below, I need to move Joe Smith and his entire row to sheet 2. I need to move Jason Doe and Jane Does and their entire row to sheet 3 and so on.Name DOB MR NXTASSESS Emp#Joe Smith 12/13/1984 307353 1/30/2012 1Jason Doe 7/31/1920 196986 2/2/2012 2Jane Does 6/29/1949 480904 2/2/2012 2Jim Doesnt 4/7/1942 198878 2/3/2012 3LOST, help!

Answer:Need to move multiple rows based on one field in each row

I suggest that you try the following:1 - Create a template with 11 sheets2 - Group Sheets 2 - 11 (Select Tab 2, Shift-Click Tab 11)3 - Hide the Columns that you want hidden4 - Enter your Column Headings5 - Ungroup the sheets. (Select any sheet tab other than the current sheet)6 - Press Alt-F11 to open the VBA editor7 - Paste the following code into the pane that opens8 - Create a button in Sheet1 and assign the macro to the button9 - Save the template, Macro enabled10 - Paste your data into Sheet1 and click the button to run the macro11 - Save the resulting sheet as an xlsx sheet, unless you want the macro to be saved with every sheet. Your choice.Note: The code assumes that you have column headings in Sheet1, so it starts searching Column I in Row 2.Sub CopyRowsToSheets()
'Determine last row with data in Sheet 1
last_srcRw = Sheets(1).Range("I" & Rows.Count).End(xlUp).Row
'Loop through Sheet 1 rows, starting in Row 2
For srcRw = 2 To last_srcRw
'Calculate destination sheet by adding 1 to value in Column I
dstSht = Sheets(1).Range("I" & srcRw) + 1
'Determine the next empty Row in destination sheet
next_dstRw = Sheets(dstSht).Range("I" & Rows.Count).End(xlUp).Row + 1
'Copy the row to the dstination sheet.
Range("I" & srcRw).EntireRow.Copy _
Destination:=Sheets(dstSht).Range("A" & next_dstRw)
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

15 more replies
Relevance 92.25%

So far i have read you can't do this. So i'm wondering how you achieve this the correct way. I work for a gas field company and the database i am redesigning has a lot of fields that need validation, like well site names, company names etc. The person who built the original database had no validation at all, and you could find the word Production spelled 12 different way sometimes. Made it very hard to keep data readable.

So the part im working on now is the well sites list. I have a table called Well Sites. I have a main work orders table where they must choose a well site which is a lookup of the well sites table. This is fine and dandy, however. If they choose not to use a name in the drop down list, they can simply type anything they want, which is what i want to avoid. I want them to ONLY be able to type names that exist in the well sites table.

I was hoping it would be as easy as setting up a validation rule but from what google is telling me that is not even possible. So how do i control what user's enter. I do NOT want to type in a list of 600 well site names using OR for a validation rule. That is unmanagable, but i need to restrict what they can type so we don't get mis-spellings and mis-labeled wells.

Now i understand some things but some things i've just never done before prior to now. If i setup a one to many relationship between two tables then it seems to work like i want. Only values that exist in the other table can be entered into... Read more

Answer:Field Validation based on another tables data

6 more replies
Relevance 92.25%

I have a form that populates fields from lookup box. There are multiple records for one member and not all records for that members has data from table.

memb1 has three records in table
first record has membname, category=2YO, Type is null
second record has membname, category=Pren, Type is AB

I need to show the type on the form but when selecting the memb1 but if type is null and type is AB - null shows but I need to see type AB.

I have an unbound textbox on form and populate with cboSearch.column(1)
This is in the unbound textbox: =forms!frmB!cboSearch.Column(1)

any suggestions on how I can show type ?


More replies
Relevance 92.25%

I have a field that contains say "Mel Gibson", what I need to do is pull Mel out and pull Gibson out and put into two new fields. I cannot for the life of me remember how to do this as it has been at least seven years since did this. Any help would be most appreciated. Thank you!

Answer:Two words in a field - extract based on space

8 more replies
Relevance 91.43%

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

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

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

My current code:

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

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

End Sub

Thanks for the help

Answer:MS Access Open form new record ID field

6 more replies
Relevance 91.43%

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

Answer:What the heck is Google Chrome Form field?

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

1 more replies
Relevance 91.43%

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

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

More replies
Relevance 91.43%

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

Answer:Solved: chage value in unbound form field

6 more replies
Relevance 91.43%

Hi all,

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

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

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

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

Answer:Solved: Adding field to Access Form

10 more replies
Relevance 91.43%

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

Does anyone know how this would work?


Answer:Searching in Access form on field with duplicates

16 more replies
Relevance 91.43%

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

Set up your form as normal

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

If you want bigger ticks just change the font size.

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

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

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

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

More replies
Relevance 91.43%

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

More replies
Relevance 91.43%

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

More replies
Relevance 91.43%

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

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

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

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


Answer:HTML & javascript form field value calculation

Hello All...

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

Make sense?


1 more replies
Relevance 91.43%


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




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

Thank you for any help,


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

7 more replies
Relevance 91.43%

Hello All,

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

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

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

Thanks in advance for any and all assistance.


Answer:Solved: Required Field in Access Form

16 more replies
Relevance 91.43%

Hello All.

I am attempting to create Text Form Fields in a previously created Word document. It was not created from a form template.

The field is the DAY in the date field: 10//007. I put the insertion point in the DAY field, click on the Text Form Field icon and fill in the field attributes. Type=Number, Max length=2. I type in a Help description, click OK, save the file, and click on the Protect icon.

When I key in a 2-digit num and press tab, the next page comes up. The same thing happens if I try to put in alpha characters. My help message does not appear. I pressed F1.

I would appreciate any help with this issue.

Answer:MS Word 2003 Text Form Field

9 more replies
Relevance 91.43%

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

More replies
Relevance 91.43%

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

Thanks a lot.

More replies
Relevance 91.43%

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

Answer:Word 2K Stuck in Form Field Mode

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

1 more replies
Relevance 91.43%

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

Answer:setting the value attribute of a fileupload form field

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

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

1 more replies
Relevance 91.43%

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

Answer:web response form - field appearance problem

Helproom solved it - Google autofill was turned on.

1 more replies
Relevance 91.43%


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

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




Answer:Creating a search field in MS Access Form

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

3 more replies
Relevance 91.43%

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

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

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

2 more replies
Relevance 91.43%

Dear Guys,

I am trying to get MS Access to print labels with names on them times the number in another field (i.e., Joe Smith is the name in the "name" field and a field called "Tags" has the number of car tags he is alotted, let's say 4. I need the database to print his name on 4 labels.)
I don't write code! Is there any way to do this, even in code.
Please e-mail a response to [email protected]

Thank you.



Answer:Access: Print Label Quantity Based on Value in a Field

Make a query in which you join the table with the person's name to the table with the tags. I assume there's a common field between the two, or how could you count? Join the tables by drawing a line between the fields with your mouse in the query design window.

Add the fields you want to show up on your labels. Base the report on that query. Access will print one label for each instance of the name in the tags table, i.e. 4 labels for 4 tags.

Hope this helps.

1 more replies
Relevance 91.43%

How does one create a mail merge document that will print only certain paragraphs or sentences based on data in each record? For example, a mail merge document where you wanted the first paragraph to be one thing if [fieldx] is "yes" and something else entirely if [fieldx] is "no"?

Answer:Word: Mailmerge Letter Contents Based on Field Value

Check here, Don:

3 more replies
Relevance 91.43%

Hi Everyone,I have an Excel sheet with records arranged in rows. The records represent activities, baseball, football, dance, swimming, etc. One of the columns (fields) contains an "activity description", another an activity name. I need to assign a category based on that information. The categories are things like Cultural Arts, Educational, Aquatics, Baseball, Football, Soccer, etc.Is there an Excel macro or some other tool or function that will search one column (or 2) then assign a value to another column (the category)? Does anyone have some other way to accomplish this? I need to end up with a .CSV file?Thanks in advance for your help !PS: Solution can be Windows based (Excel) but I also have a box with Ubuntu on it.

Answer:Search a field and assign a label based on results

A solution can probably be offered, but I'm not sure exactly sure what you are trying to accomplish. In order to have an Excel function or macro assign a category to each activity, it has to pull the information from some place. It has to know what category to assign, so that has to be entered someplace first.How would a function or macro save any time if you have to first set up a table that matches every activity to a category?Perhaps some more example data would help. Before posting example data, please click on the following line and read the instructions found via that link.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

14 more replies
Relevance 91.43%

Hi all,

I am looking for help on VB script to send automated emails based on the date column in excel sheet..

Uploading the excel sheet as well. The email should trigger on dates in column F to corresponding email addressed in column E ..

The email body should say :

Your employee "Column C" is approaching his probation period on "Col D". Kindly confirm if you want to confirm on the date of "Column D" or modify it.

Answer:Need help to send automated email based on the date field

Have a look at the attached I have written the code necessary however if you have any changes you would like made let me know.

1 more replies
Relevance 91.43%

Here's a sample

Record 1 - John Smith #23 - want 1
Record 2 -John Smith #29 - want 2
Record 3 -John Smith #27 - want 3
Record 4 -Fred Jones #24 - want 1
Record 5 -Fred Jones #25 - want 2

So what I want is for each row of data to place a count #. So for record 1 it would have 1, record 2 would be 2, records 3 would be 3, record 4 would be 1 and record 5 would be 2.

I need a count of records for each name. I do not want a subtotal. I need it to actually list out 1,2,3, 1,2.

I can do this in Crystal reports - but I really need this is Access.

More replies
Relevance 91.43%

I have a form designed to track processing times for various activities. This information is entered from a Production Log that the employee completes throughout the day. The main form has the following fields: Name, ArrivalTime, DepartTime, ProductionDate. After the user enters data into these fields, the cursor moves to the subform where the activity id is entered, the start and end times for that activity, the beginning & ending sequence number, and several other fields.

Since some activities don't require entry into all fields, I would like to disable certain fields based on the value entered into the activity id field. I have 4 activity ID's that I want to trigger the disable event on 3 other fields in the subform. I need to know how to code this, where to code it, and then to check in the form's BeforeUpdate event that the above is correct.

Thank you for your help!

Answer:Solved: Disable Fields on Subform Based on Value of Another Field

10 more replies
Relevance 90.2%

I'm creating a form in Word 2003 that will be filled out both electronically and as a written form. Form fields are inserted in the document but are much too small when viewed as a printed form. The only help I've found via Microsoft suggests adding fields back-to-back, which works for a printed form but makes tabbing through the electronic document a pain.

After all that, here is my question: Is there a way to increase the display size of form fields in Word 2003? Thanks in advance for being such helpful geniuses.

More replies
Relevance 90.2%

Hi There

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


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

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


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

Hi Mario

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


2 more replies
Relevance 90.2%


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

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

Any help appreciated

Answer:Switchboard Form re-sizing and Field Editing permitted

7 more replies
Relevance 90.2%

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

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

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

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

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

8 more replies
Relevance 90.2%


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

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

Any help is greatly appreciated.

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

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

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

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

2 more replies
Relevance 90.2%

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

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

12 more replies
Relevance 90.2%

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

On Error Resume Next

Dim strName As String

strName = StrConv(Me.Name, vbProperCase)

Me.Name = strName

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

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

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

15 more replies
Relevance 90.2%

As I stated in my previous post, I'm creating a survey to send out in Word 2003 using text form fields and check box form fields. When typing comments in the text form fields, if the comments go above a certain word count, it is impossible to see what you are typing.

As it appears there is no way to make these text form fields scrollable, it is possible to make the text form field expandable when typing in it?

More replies
Relevance 90.2%

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

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

10 more replies
Relevance 90.2%

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

More replies
Relevance 90.2%

Hi Database supporter(s)

I need your help.

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


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

So I create 3 tables:

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

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

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

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

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

More replies
Relevance 90.2%

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

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

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

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

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

Answer:Access2000 - use child form field as report criteria

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

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

Pretty P L E A S E!!!

2 more replies
Relevance 90.2%

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


Answer:Entering Multiple values into an Access form field

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

3 more replies
Relevance 90.2%

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

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


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

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

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

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

Answer:Solved: Word Form Field Properties and Formatting

9 more replies
Relevance 90.2%

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

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

Are you a Chrome user?

5 more replies
Relevance 90.2%

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

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

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

I need help.

Answer:Access 2007 Complex form field validation

16 more replies
Relevance 90.2%

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

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

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

Any assistance is greatly appreciated!


Answer:Exporting Word form field data to Excel

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


2 more replies