Over 1 million tech questions and answers.

Access, trying to autmatically fill in fields after chosing ID

Q: Access, trying to autmatically fill in fields after chosing ID


I couldn't find the answer answer anywhere, so hope someone here can help.
I have several tables with info about partners, subsidiaries, contracts etc.
They all come together in a single table with the name project. Since 1 partner can participate in many projects I need to know how I can set up that my form for the table projects, with subforms partners and contracts etc fills in the data (name etc) for partners automatically when I only choose the partner ID from a list box.

Thanks in advance!

Preferred Solution: Access, trying to autmatically fill in fields after chosing ID

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

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

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

A: Access, trying to autmatically fill in fields after chosing ID

Can we have a look at your table structure?

Read other 1 answers

I have a table in an Access database. This table has three columns in it, and I want to add a fourth column. I want the value of this fourth column to be "Primary" for every record.

What's the easiest way to accomplish this? I'm an Access newbie.

-- Richard

A:Auto-fill access fields?

Read other 6 answers

Earlier I was playing an online game (Final Fantasy XI) when my screen began to behave strangely. I logged out, and then noticed that a TextPad window I had open began to fill with "+++++++++++++++++++++++" as though the plus key was stuck. I checked my keyboard (Logitech wireless LX710) and didn't see any obvious issues.

None the less, I shut-down the computer, swapped keyboards with my other PC and booted up again. The problem did not follow the keyboard, it remained on my first PC.
I tried a corder USB keyboard, and it does the same thing. Initially I can sometimes login because the "+++++++++++++" begins - but it is hit and miss. I generally need to reboot 2-3 times before I can login.

I have removed the Logitech software and installed the latest edition.

I have run McAffee and Spyware Doctor, but nothing was found.

Does this sound like any Virus, Trojan or Worm anyone has run across?

A:Virus? Text fields fill with +++++++++++

Meh... it was mouse-related.

After much swapping of gear, several virus scans, and copying a ton of data from the "bad" PC to my other PC (just in case), I tracked the issue down to my Logitech MX700 mouse.

I had swapped-in a corder mouse earlier, but apparently I was too hasty in eliminating the mouse as the issue.

Now I am back up a running, with my cordless keyboard - no issues. Just using a vanilla Dell corded mouse for the time being, until I can determine if the MX700 is salvageable.

Read other 1 answers


I'm working in Access 2000. I created a database in which you select a course number and the course name automatically appears in the "course name" box. I created this database but cannot for the life of me figure out how I did that.

Now I need to do it again...I've looked at the properties of the fields in the form and everything, and cannot find where you point it to fill in one field based on a another.

Can anyone help me with this?


A:Access2000 -Automatically fill in fields based on a selection

Read other 6 answers

I think I have narrowed it down to on mouse movement that text input fields fill with %E?;E?+E? or %%E; or different variations of those characters followed by ENTER... I think!?!?
I removed all other languages from the keyboard settings in windows, and turned off the hotkeys for switching languages, this didn't help.
The next step was to swap out the Logitech keyboard/mouse combo with a ps2 keyboard and usb mouse and uninstalled logitech's setpoint software thinking that might be the problem.
It wasn't.
Not sure what steps to take next.
BTW, it doesn't matter what program is open...

Thanks for any help

A:On mouse movement text input fields auto fill with %E?;E?+E?

Maybe take a look in device manager to see if any of Logitech's drivers are still in use, if it is, uninstall them.

Read other 3 answers

Good evening,

was trying to find a piece of VBA code online for the following problem, found pieces for some single aspects, but cannot make it work. Have excel and word 2013.

I have a excel spreadsheets which is my master database. Every row (90 in total) lists one data set with up to 40 columns, but I will not need all informations. The first colum has a checkbox which I would like to use to chose which data set to work on to populate the word doc (working with multiple ticked would be great as well).

In addition I have multiple word documents, where I added text form fields which should then be filled with the informations from the excel sheet (I will not need all 40 columns for every word doc).

The code needs:

(1) To open the correct word document

(2) Fill in automatically the present date at a defined location in the word doc styled Jan 31st, 2018 with the correct st, nd or th.

(3) Fill in the specified data in the text form fields

(4) One column in my spreadsheet is a drop down menu, is there a difference if this content is transfered to the text form field?

(5) Some of the cells in the excel may be empty, how to make sure the transfer is not hicking-up?

(6) Save for every data set ticked a document (word and pdf) in a distinct location with some information from the data set contained in the name of the file.

I would be so greatful, If one of you can help here, guess for you this is done in a split of a minute...


Read other answers

Hi all,

I?m really in need of some help from some Access experts! I?m a newbie to Access, but I got myself busy with quite a big project... I?m trying to map out the product supply to shops in the whole country. I?ve come quite far for a starter, but I keep having 3 questions, it would be great if you could help me with this!

I have, amongst other tables, two tables called Stock_counted and Reported_quantity.

The table Stock_counted has the following fields:
- Shop_number
- Product_code
- Quantity_counted

The table Reported_quantity has the following fields:
- Shop_number
- Product_code
- Quantity_in
- Quantity_lost_or_returned
- Quantity_out

1. What I would like to do is to make it one table based on Shop_number AND Product_code. So in one record I would like to have Shop_number, Product_code, Quantity_in, Quantity_lost_or_returned, Quantity_out and Quantity_counted. How do I do this, making sure that the quantities end up behind the right product and shop? It is possible that some shops don?t have all items, while other shops might not have all products reported, or both. On top of that, I have another table with a price for each product, which needs to be related to it as well.

2. It happens that some products are found more than once in one specific shop and therefore appear more than once in the table, with the same shop number and product code. How do I automatically SUM these quantities, so that this product only shows up once per shop?

3.... Read more

A:How to combine fields in Access 2010 based on 2 equal fields?

Quote: Originally Posted by Josephine87

2. It happens that some products are found more than once in one specific shop and therefore appear more than once in the table, with the same shop number and product code. How do I automatically SUM these quantities, so that this product only shows up once per shop?

select shop, product, sum(quantityfield1), sum(quantityfield2)
from sometable
group by shop, product

Read other 1 answers


I got a form A and a subform B. I use B to display data retrieved from a table while use B to simutaneously update that data. More particularly, if I click a row in B, that row will be display on A and the user will be able to edit that data. The forms were designed by someone in MS Access 97. I converted it to MS Access 2003 format. Therefore, I have to link form A and form B. However, I couldn't find Link Master Fields and Link Child Fields in MS Access 2003!

Any ideas? Thanks in advance!

A:Link Child Fields and Link Master Fields in MS Access 2003

climbingrose said:


I got a form A and a subform B. I use B to display data retrieved from a table while use B to simutaneously update that data. More particularly, if I click a row in B, that row will be display on A and the user will be able to edit that data. The forms were designed by someone in MS Access 97. I converted it to MS Access 2003 format. Therefore, I have to link form A and form B. However, I couldn't find Link Master Fields and Link Child Fields in MS Access 2003!

Any ideas? Thanks in advance!Click to expand...

It really sounds like form A and subform B are both using the same table, and are not a Master/Child field link situation. But rather, form B (the subform) will have code in the "On Current" event that will find the current record on the form B within the form A, therefore allowing that record to be edited. Review your original post, I think you used the "B" one place where you meant to say "A". No matter what, you need to clear up with us out here if both form A and form B are using the same table.


Read other 1 answers

MS Access:
I have several fields in a form that uses two tables. I would like to set up a command button so that when you are on a current record, it will copy the field information from the record you are on to other fields in the same record. I do not know the SQL commands to set this up.

For example, there are name fields, address fields, and phone to be copied. Reason: One is contact information; one is survey information. In most cases the information is the same but on rare instances, the information needs to be entered (when different).
This is not an update for all records in the database. This is based individually on each record.
Not sure if you need to do On current, on click, or after update.
Not sure if default value in form can be used.
Please help.

A:Copy data fields in same table to other fields in same table MS Access

Read other 16 answers

how many total fields can you have in an access table
I'm using access 2000

A:access fields

I believe the limit is 255, but I am not 100% sure. Even so, you will most likely never have that many fields in one table...

Read other 1 answers

Access newbie using Access 2007 with Windows XP. I have a table that contains the following columns.
Author LN

I want users to select title from a drop down list in the title field which will auto populate the two author name fields. Users will enter data in remaining fields.
1. Title field has scroll arrows but only shows first title?
2. How do I get the AuthorFN and Author LN to auto-fill based on title selected?

Can't find a solution that a newbie can understand.

Forgot to add that users will create multiple "info cards" because only 1 comment for each record.

A:Access 2007 Auto-Fill

Read other 16 answers

i do not know how to make pages fit my monitor. there is 2.5 inch gap at either end

A:[SOLVED] my web page does not fill fill my monitor screen in the horizontal direction

this is not equip. failure as it worked ok before i had to go back to a restore point. i am a complete novice,trying to keep up with grand kids,please excuse.

Read other 6 answers

Ok, i have a form that has a calendar...when you click on the "hiredate" or "birthdate" the calendar appears, and when you click anywhere on the detail area, it disappears...however, whenyou change a date on the calendar you must click in either the "hiredate" or the "birthdate" for it to take the change....i would like to make this automatic, so that when a person clicks the calendar the coresponding field...hiredate or birthdate, is changed....is this done with the "on update" event? any help would greatly help my grade!
if so could someone give me an example?


A:Access: One Calendar for Two Fields?

Yes, well, a couple of questions, so that our solutions change your environment the minimum amount possible:

1. Are you sure that the calendar that appears is on the same form? Or is a special calendar form appearing and disappearing? You might want to poke around in the db window, and/or post back the details (macro or code behind the events, for example, on click) for hiredate and birthdate.

2. Also, what's behind the calendar? The tricky part of what you're talking about is having the same control (or form containing a control) for two different text boxes; that's why you're having to click in the appropriate box, I'm guessing: to tell the calendar which box to put its value in.

I'm guessing that you didn't build this initially? If these questions seem to complicated, just zip up an example version of the related table(s) and the form(s) in an .mdb file and send them to me. (Must be under 1MB.) But if you can post back the details on what's going on behind your controls, we can probably give you a faster response.

Read other 3 answers

I have two tables tEp and tLn.

I have a field in tLn for tEp but I need to be able to select multiple values, Ive followed guys on office and here: http://www.databasedev.co.uk/multivalued-fields.html

But I cant get the Allow Multiple Fields checkbox!! It just doesnt show!?


A:Access Multiple Value Fields

Worked out this only in accdb, is it possible to do something similar in mdb?

Read other 1 answers


I am currently building a shop type database...

I have made a 'transaction form' On the form is things such as transaction ID, customer details, staff details etc, then there is a subform, where the products on the transaction get entered into.

On the subform (Transaction/Product link Subform), there are the fields (among others...) 'Product ID', 'Price' and 'Quantity', I have then made an unbound field to calculate the subtotal which has '=[QuantityOrdered]*[p_Price]'

On the main form, I then wanted to have a 'total' field, whereby it adds up all of the subtotals from the subform, the problem is is that through the various methods i have used i keep on getting #Error or it will only show me the subtotal of one record, when I need it to show me the total subtotals from all records.

Any solutions? please

A:Calculated fields in Access

... it will only show me the subtotal of one record, when I need it to show me the total subtotals from all records.If I understand correctly what you said, I think you need to make a calculated field on the form which will say something like=Sum(the name of the calculated field on the subform)and put that total field in the footer of the form. The footer should contain form totals.

Read other 4 answers

In Access 97 SR-1 is it possible to create a lookup field in a table that is also a required field? I have created a table in Access containing several lookup fields. Now the user is requesting that the fields also be required - that the person doing the input via a form would not be able to advance to the next record before choosing an option in each lookup field in the current record. Setting the required switch to "yes" after the field has been created as a lookup field does not prevent the user from advancing to the next record in the form.

Please advise any suggestions. Thanks!

A:Access 97 required fields

You can set the "lookup" field back to a standard field and use a Combo box to do the look up for you.

Read other 2 answers

Here's the situation:

I have been given several access databases with contact information in them. The contact information has all the usual info (address, phone, etc.); however, the name format is two different fields: a first name, and a last name. My goal is to import all the database information into ACT!

I was planning on doing this by exporting a text file with comma seperated values; the only problem, though, is that the existing ACT! database doesn't have two name fields, and instead only has one "Contact" field.

Sooo.. my question is, would it be best to try and convert the names to one full name in access, or is there some way to import and convert them with ACT!? And, whichever way is best, how exactly would I go about doing that?

Thank you very much!!

A:Merging two fields in Access and/or ACT

Read other 7 answers

I know how to concatenate field values in a record but I'm wondering if it is possible to concatenate field values in separate records. My reason is that I have a form showing data from a query made from two tables. I want only one record in the underlying data and if I join two tables where one has multiple matches then there will be multiple records in the query. Table 1 has a record with joining field f1 (no duplicates allowed) and Table 2 has multiple records for f1 with different f2 values. Here's what I mean:
T1 has f1 = 90000
T2 has
f1 = 90000, f2 = T
f1 = 90000, f2 = Y
f1 = 90000, f2 = N

Is there a way to set up a query operating on T2 to give a table with the value
f1 = 90000, f2 = Y,T,N

If so, then a join on f1 with this table would yield only one record for the form I display. As a fallback position should I just do a summary query on T2 and show the resultant records in a small subform?

Thanks in advance for any advice on this?

A:MS Access Concatenate Fields

Read other 6 answers

I must be having a brain fade here but what i want to do is real simple, just can't get it right.

I have a field on an MS Access form and all I want to do is check if something has been entered into it.

Something along thw line of :-
if field is blank do then
do something
else if field is equal to spaces then
do something different
end if

of the life of me I can't get it to work :-(

A:Blank fields in Access

I'm presuming this is just pseudocode for a corresponding Vb project.

If so then i recommend:

Option Explicit

Dim wksp As Workspace
Dim db As Database

Private Sub command1_Click()

Dim entry As Recordset
Dim search_string as string

search_string = txt_search_string.text

Set wksp = DBEngine.Workspaces(0)
Set db = wksp.OpenDatabase(App.Path & "\DATABASE NAME.mdb")

Set entry = dbfacilities.OpenRecordset("SELECT * FROM [TABLE NAME] WHERE [FIELD NAME] = '" & search_string & "'")

If entry.RecordCount = 0 Then
MsgBox ("The field is blank")

txt_search_string.Text = ""

'unsure of what you wanted here...
End If

Hope this helps.

Read other 3 answers

I have this table that I want to have a drop down list for the builder and then the next field another drop down list that only lists those tracts that the chosen builder has. I am trying to create a form right from the table

A:Access lookup fields

Please read this previous post

Read other 1 answers

I am building a query in Access 2007 and when I select and drag a field from a query into the lower section of the building query screen it only brings the one field (like I want), but when I run the select query I am getting all the fields in the original query. How can I get it to only show the one field?

A:Access Query too many fields

Ensure that the query does not contain a column with the heading tablename.* or queryname.* where tablename and querynames are the names of your query table or query.
The "*" means all fields.

Read other 2 answers

I have a form with Qty, Price, Total, MTD(MonthToDate), YTD(YearToDate). I am only storing Qty and Price in the Table. I can get a sum for Total, but how do I get a sum for MTD and YTD?

Should I have a field in my table for the Total, MTD, and YTD?

What is the best way to set this up?

A:Summing fields in Access

Read other 10 answers


I am using Access 2003 and have a question-- I have a table called tblContacts, and an associated form with demographic info. I want to add a field to this form called "notes" , which would be opened with a button on the form (that way the notes on the individual would not be immediately visible to anyone walking by).

I created the subform Notes (and associated table tblContacts_Info). My problem is this:

I want the contact_id (unique identifier of individual) to automatically fill in when the subform opens with the value from the record of the parent form.

I tried creating a one-to-many relationship, and tried setting the record source as the contact_id from the parent table, but am having no luck.

can anyone help? Is there a better way to do this than a subform/second table? I just want to create privacy on the form...



A:Access subform (I think) and auto fill in question

Read other 10 answers

Dear all​ I have a problem to fill table for preparing database.​ Problem:​ I use COMBO to fill table. For example we are preparing a table related to cloths of some people.​ I want, If i select shirt from the combo of first record, the combo of next record (cell) show me only specification of shirt (e.g. color, size...) not shoes, etc..​ OR, If i select shoes from the combo of first record, the combo of next record (cell) show me only specification of shoes (e.g. price, size ...) not shirt, etc..
​ It would be appreciated to have your reply,​ Regards,​ M.Maleki​

A:fill table in microsaft office access

Read other 7 answers

I have read through similar threads/posts but they don't seem to answer this exact problem (or I can't find the answer - maybe someone could point me to the solution?):

I have a hierarchy of descriptors for a program/project management tool I am creating as follows:
Department contains several AreasofResponsibility, which contains several Goals, which contains several Programs....etc....

I want to build a form for entering a new project task with combo boxes to select the right path in the tree above to associate with this project task.

Therefore the first combo reads its values from a table containing a list of Departments.
The user selects a Department from the list.
The second combo should only be populated with the AreasofResponsibility (AOR) that are in the selected Department. So I want to conditionally display the list of AORs that corresponde to that particular Department.

What Event Expression should I use?

Here is what I have set up already:

I have a separate table and form for entering the Departrments = Dept Table
- this is a simple 2 column table where each record has a Department name and an ID (key field)

I have a separate table and form for entering the AORs = AOR Table
- this is a simple 3 column table where each record has an AOR, a Deparment name based on the above table and an AOR ID (key field).

Now I need to combine these two in a third table/form for a lower value entry on the hierarchy and am stuck....

A:Conditional Combo Box Fill Access 2003

DunnerJ, welcome to the Forum.
Your search should have shown up at least 2 databases that I have worked on for other Posters that do exactly what you are asking about.
There is this one

Read other 1 answers

Please help

I have 2 tables:-

1 Master Input Table.
1 Job Lookup table - (contains Job Number and Name)

When in-putting job details into the Master Input table i would like to enter the job number only and have the job name appear automatically without running a query, much the same as a 'vLookup' command in excel.

Is this possible?

Can anyone help?

A:Auto Fill In MS Access Table Field

Yes it is, the easiest way is to have the Job Lookup Table as a Sub form on the master form (Master Input Table) linked via the Job Number.
Or you could select it from a combo box, (no typing).

Read other 1 answers

O...Kay! I need help with a now, 4 year old Access database. Many thanks to OBP, I have cleaned up and worked out kinks that really has made keeping up with parent involvement in the schools much easier. Now that I have worked with the database, I am in need of some advice regarding a form that is needed now. This is a form that is used to enter just basic demographic information on a parent who calls to sign-up to be notified of special events.

The form is simple, but this is where I cannot quite make it work. The unique identifier of the record is the school's location code number. I have tried to find out how to fabricate the form so that when this location code is entered, the associated fields (school name, type, and region) will auto fill in. I'm sure that this may seem trivial to the experts, but I am once again STUMPED. Many thanks in advance for any assistance that I may be given.

Read other answers


I am wondering how to automatically fill a cell in my TransactionForm. When I want to lookup and insert a commodity into a transaction I would like the form to automatically insert the CurrentPrice of a commodity into the SalePrice field. I have attached the database. Thank you!

A:Automatically fill blank field - Access

Read other 9 answers

Hello! I'm hoping someone out there can help me. I'm creating a basic form, it would be nice if when a record is created the day you created the record could autofill into place. Does anyone have any suggestions out there how I could do this?

Thank you,

A:MS Access Date Auto-Fill Form

You could set the default for the date field to Now().

Read other 2 answers

I'm running latest firefox, vista and windows 7. Wireless Laptop worked fine yesterday. Went to log on today and can't connect. Think I've found problem, but ran into another. under connections tab-LAN settings---automatically detect setting is unchecked. It allows me to check it, but when I click "ok" to set it nothing happens. Literally nothing. the box does not go away and the check mark stays. "ok" doesn't work at all. any ideas?

thank you,


A:autmatically detect setting does not work

Read other 16 answers

Hello All.

I am working on a piece of code to check what field names are in a query and then I need to pass those field names into another query.

I found this code here on the forum and it gives me field names but I need to skip a few known field names as well.

Any ideas?

Sub FieldNames()
Dim Rst As Recordset
Dim f As Field

Set Rst = CurrentDb.OpenRecordset("qryAccessorial_CrossTab")

For Each f In Rst.Fields
MsgBox (f.Name)
End Sub

A:Getting fields names in Access 2007

Read other 13 answers

I've got a form in access and all I want to do is make a "total" box that adds 5 fields with numbers (not all those fields may be populated at the same time). So if the first field has a value and the second does not, my total field is blank. If both those fields are populated, it adds. What am I doing wrong? My syntax thru the expression builder is =[1st Account Balance]+[2nd Account Balance]


A:adding fields in access database

Read other 16 answers

Our objective was to get the field to populate throughout the datasheet table. Meaning that

Field 1 Field 2 Field 3 Field 4
1111 Contract Apples Carrots
1111 Contract Soups Celery

Getting and Maintaining Field 1 & Field 2 to stay the same throughout the table
Since my brain is fried today and its already the middle of the week. Any suggestions?

A:Access: Record Keeping. Same Fields

Read other 12 answers

I have generated an access report that shows the process comments for the different locations we have in the organization. What I need to do is to count the total number of comments we have per day for the daily report I generated. I used a textbox under the gourp footer with the expresson "=Count([Comment])". It worked fine to get the count of teh comments under each goroup. I need to gererate a grand total for the report summing the values of the textbox with the above expression. Also, is there a way to count the text fields one time as a grand total for the report. Thanks in advance.

A:Summing calculated fields in access

The unbound text box that you have used for the "=Count([Comment])" should have a name like text2, so you use the following in a another unbound text box in the report footer using the correct name for your counting text box


I am not sure about your last question "is there a way to count the text fields one time as a grand total for the report"

Read other 2 answers

Please help. I am trying to calculate a percentage of my yes's. I have several yes/no fields in which I'll need to calculate a rate. I would prefer to create a report that will calculate this for me. However, right now, I am really just looking for the easiest/quickest way to do this. So if I need to run a query first and base the report off the query, I'll do it. Please help ASAP if you can.


A:Solved: Calculating Yes/No Fields in Access

Read other 16 answers

Hi, I receive an excel file everyday that I need to import. However, the column header of the fourth column of data changes daily (it's the corresponding day's date). I would like to import/append the data to the previous day's import. Is it possible to import and append fields by their position number, e,g, the fourth column is not called using its column header but is called by its position, say "field4"(?).

A:Access: querying fields generically

PMCD, welcome to the Forum.
I don't think what you want to do can be done with just one Import query because of the name change and Append Queries use the field names.
You can Import the Data to a temporary table, change the name, append the data to the master table and the run a delete query to remove the data from the temp table.
What you could have is an SQL statement renaming the field, although I am not sure if SQL can handle the field name change, and then run the append query.
You can definitely use VBA code to change the name and then run the Append query though.
Or you change the field name manually prior to running the Append query

Read other 1 answers

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

A:Access form clears all fields

Read other 6 answers


I have developed a simple database and used the built-in 'access search' facility that is applicable to all forms. There are around 7 fields in each table.

Problem: When I select more than one field (through the dropdown list), it lists all data instead of listing only data related to the first selected field.

Question: How do I link the fields so that during a 'search', if I click the first field and select a value (e.g. field size) then if I select the next field (e.g. colour) - it will only list colours pertaining to the selected field size - not all the colours of all the field sizes in the database table?

Any assistance appreciated.

Many thanks


A:Access 2003 - linking fields


I requested the moderators to move this thread to the Busines Applications section. You will get more attention there, and most probably, the quickest solution as well.

Read other 2 answers

I produce my departmental purchase plans on MS Access so that I can attach my own symbols eg prioritising and run queries. I have been told that I can transfer/link/export individual fields from Access into a template order form set up in MS Word. Is this possible? How is it done? Is there an easier way?
Any suggestions?

A:Linking Access Fields to Word

Hey there.

Is there some reason a mailmerge from Word won't work?


Check out how to set up a mail merge.

Read other 1 answers

I cannot change entry in ID field of Facilities Table due to 1-1 relationship to Test Data Current Table. I just want to modify it from "70100" to "AI-70100".

A:Modifying Fields in Access 2010

Is there just the one record that you want to change?

Read other 3 answers

I have to concatenate the following by item number: I have attached a file with a sample table.

item number / memo subject / memo text
15056 / x/ e
15056 / t / r
15056 / s / q

there is also the issue where I have ~;~ in the memo text field. This is coming from some type of code in our ERP software. I would like to have this removed and not added in the final result which would be something like this:

15056/ x t s / e r q
I do not need comma's in between the data but if the field is blank i don't need that either.

I have researched and I have tried to do some VBA with Modules but I really don't know what I am doing.... Help!

A:Solved: Access - Concatenate fields

Read other 16 answers

I am fairly new to database and I don't know much about VBA coding.
I am creating a database and I have created a form for end-users to submit create a new record. but I want all the fields except one to be required.
I tried to make them required in the table but it gives me error when I enter data through the form. Can anyone please help me with this.

I have the following fields to be required

First name
Last name
Date of birth
Employee level
employee status
Employee ID
Hire date
Phone number
Model ID

Thank you in advance

A:Access 2010 Require Fields

Read other 6 answers

I have a database, and I already have several fields "locked" so that chances cannot be made to these particular fields.

I have some command buttons that I currently have enabled, but would like to disable them when a certain checkbox has a "true" value (is checked).

How can this be done (if at all) on a "per button" basis, as I have some other buttons that I want to leave enabled all the time.

Thanks in advance!

A:Solved: Locking fields in Access

Read other 9 answers

Hi there,

Let my preface this post by saying that I have some experience working with Access, but nothing official and so what I know is as a result of hacking my way through. Also, let me start by saying that I apologise if this seems long winded, but I am unsure how much info to give.

I've inherited a database at work which I need to develop further, but it uses some methods I am unfamiliar with, though I think I understand enough to know they need to be there.

Basically the database is a customer transaction system and its that particular section I am trying to sort.

I have a table (tblPupilTransaction) which is meant to be updated whenever a transaction occurs. It has :

Transaction Date
EAN (item code)
Billing Status

However, because there will only be a static group of customers that can purchase from us, we have a lookup table (tlkpPupil) which has :


My difficulty comes when developing the form that would be used to input the transactions. I had thought to use combo boxes to link FamilyName, GivenName and PupilID into one selection, but that doesn't automatically complete the exisiting PupilID field (which cannot have a null).

Likewise, when I use a combo box to put in the product data, the price is not automatically complete (these also have the appropriate lookup tables).

So, in short, I want to know how I create a form which will input into tblPupilTransaction w... Read more

A:Bound Fields on Access Forms

You are on the right track. Have the data in the Combo boxes. All it takes then is some simple VBA code in the Combos After Update Event Procedure to pass the values to the fields.
However, the only thing that should be stored for the Pupil and Product is the ID numbers.
The rest should only be "Displayed".

Read other 3 answers

Hoping this is one of those easy to answer, dumb questions.

I'm using Access 2002. I've created a form with subforms, and linked the data collected on the subforms to the main form via the master/child links.

What I now want to do is:

1. On the subforms, enable the user to select a value from a drop-down list, and then populate the remaining fields on the subform with data based on the user's selection;

2. Enable the user to edit the autopopulated fields, yet maintain the integrity of the original values so that they can be used again and again.

I'm a stumped as to how to accomplish this. As you guessed Access isn't exactly my forte, but I'm a quick learner.

Any ideas? Thanks for your time.

A:Autopopulating editable fields in Access

Hi Shug02,

Try this:

In the combo, add the extra data you want to use to autopopulate the form as extra columns.

You can do this by clicking on the Row Source in the combo box's property sheet. Increase the number of columns in the combo by setting the column count to the required number, and set the width of the additional columns to 0.

Now the combo will invisably return the associated data along with the original data... but this will be cunningly hidden from the user.

In the AfterUpdate event add an Event Procedure along the lines of:

Private Sub ProjectName_AfterUpdate()
Me![ProjectManager] = Me![ProjectName].Column(1)
End Sub

This will put the data in the first column of the ProjectName combo into the ProjectManager control on the form. If the column has a width of 0 it will be hidden from the user.

Read other 3 answers

Aloha FRIDAY Tech ppl!!
I've set fields in MS ACCESS 2010 table to be required fields --- BUT it "kicks" me out the form IF i try to save the record to test the field by leaving the field blank!!

Were should I enter the parameter to ask me to enter the required field then SAVE the record ...
thank you!!!!!

A:MS ACCESS table required fields

The table is the correct place to do this.
I am not sure what you mean when you say "save the record" as Acces automatically saves the record.
What happens if you try to close the form yourself, or move to another or new record?

Read other 3 answers