473,320 Members | 2,164 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Automatic update of data to minimise errors

Hello there, I have just joined the site and I have a very basic knowledge of MS Access.
I wish to make amendments to a DB @ Work so that is a user ID is entered into a field in the form then the name; manager and site will automatically update in the form and main table. The information is being referenced from a Family Tree table.

I have been able to master this in Excel by simply creating a VLOOKUP formulae but I am having great difficulty in Access.

Please help

Thanks
May 1 '16 #1
2 988
zmbd
5,501 Expert Mod 4TB
Chuganaught:

+ You'll do basically the same thing at the query or form level that you're doing in Excel. However, we have precious little information about he overall design of your database; thus, it's almost impossible to point you in the right direction.
>> NORMALLY, avoid doing this at the table level unless you are going to be publishing the database to a sharepoint site. Lookup fields at the table level can create a lot of difficulties for you in the future!

> We do not need a copy of your Database attached. In fact, many of our experts (me too) are not able to usually open these attachments for various reasons.

Instead, please just type the information in to a normal post and format it using the [CODE/] button found in the post toolbar. A recent example of what we're look for is here: Sum Across Columns in Crosstab

Use the [CODE/] format for posted VBA, SQL, Scripts, and Formatted Tables. It will insert a [code] [/code] tags around your selected text.

In tables use spaces not tabs to align your data. :)

+ I'll also PM you a copy of my resources for new Access designers. Please check your Bytes.com inbox at the top of this page. :)

+ One of the entries in the PM is a link to a tutorial that will provide you a hands-on learning experience covering most of the basic skills you'll need to get up and running.

+ Normalization is usually your best friend, there are also entries in the resources I've PM'd you for two articles covering this concept. It is VERY important to master this concept... doing so will make a lot of your tasks, for example the one you've asked about, so much easier to accomplish!

+ Finally (this link is the PM too) look at the bottom of this page, the VBA Insights Sitemap will send you to a set of documents covering a lot of common tasks and questions. If you will take a few minutes to read the titles I'm sure you will find a lot of useful information. >> If you have any questions about something in these documents, please start a new thread with that question as we try to keep the articles strictly related to their content.
May 1 '16 #2
That's brilliant, thanks very much for sending that through, I'll work through that.
May 4 '16 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Kelly Olsen | last post by:
I have created an automatic update field in my Vendor_Table that automatically updates the date in that field to respond to any changes made to the record. However, I would like to display this...
0
by: KC | last post by:
http://msdn.microsoft.com/library/default.asp? url=/library/en-us/dnbda/html/updater.asp?_r=1 >-----Original Message----- >I want to add a Windows style automatic update feature to >my C# app....
2
by: anony | last post by:
Maybe this feature is already out there. I guess you could write triggers to do some of this. Often when designing a database I add a start_date and end_date column to the table. The start_date...
1
by: chris.thompson13 | last post by:
Any relevant advice would be most appreciated for the following problem I have. I have a query that draws its data from 7 other queries. I would like to be able to edit data through that query....
0
by: Dean Slindee | last post by:
Any implemented an application that simulates the "automatic update" functionality normally done by Access in VB.NET? Or, know of a posted application example? Thanks Dean S
1
by: =?Utf-8?B?RGF2ZSBDdW5uaW5naGFt?= | last post by:
I'm new at this so I hope I get it right THIS time! Running Windows XP SP2. When I boot up I get the following message: RUNDLL Error loading C:\WINDOWS\SYSTEM32\valcesfk.dll The specified...
1
by: Lisa66 | last post by:
Hi - I am having a problem on MS SQL Server 2005. I have 2 databases: DB1 and DB2. I am writing a stored procedure in DB1 to update data in DB2. Looks like this: ...... USE (stored...
1
by: fxtao | last post by:
my question is how to realize the automatic update of our application programming. Now ,I haven't idea almost.
2
by: =?Utf-8?B?RG91Zw==?= | last post by:
Automatic Update has started installing XP SP3 on my Dell P4-2800 running XP Home. It has been at the same point "Finishing Installation" with details of "Running Processes after install" for over...
1
by: =?Utf-8?B?UHNldQ==?= | last post by:
Hello. System: Win XP Media Centre Edition – Service Pack 3 Somehow, I picked up a variant of VirtuMonde; Symantec Anti-virus, Spybot Search & Destroy etc did not locate it; I discovered it...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.