473,326 Members | 2,114 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,326 software developers and data experts.

Populate form from specific cells of table

So I would like to fill out six sections of a form from specific cells of a linked excel spreadsheet.

For example I want to fill the form with:

Project:___ Stage:___
Version:___ ID:___
Type:___ Composition:___

And each of those unknown values can be found on specific cells from one of my tables. I am unsure how to fetch the information from specific cells.

Thanks for helping me out.
May 19 '16 #1
6 1029
Seth Schrock
2,965 Expert 2GB
Is this an Access form or an Excel form?
May 19 '16 #2
Access Form, from an table in Access
May 19 '16 #3
Seth Schrock
2,965 Expert 2GB
Let me see if I'm understanding the question correctly. The Excel spreadsheet has the list of fields that you need populated and the table in Access has the values to enter into those fields? If this isn't accurate, then please restate your question and provide more detail.
May 19 '16 #4
Access Form, from an table in Access.

I found this code from a previous question but the question is slightly different from my own.

https://bytes.com/topic/access/answe...s-access-table
May 19 '16 #5
So I have an excel table with some information on specific cells that I would like to extract and use to fill an access form.

Send information from specific cells of a table to specific text boxes of an Access form.
May 19 '16 #6
Seth Schrock
2,965 Expert 2GB
But since the Excel spreadsheet is linked, it is in an Access table as well. I think that I understand. There needs to be something in your data that identifies which record contains the information that you are wanting. Once you have that, then it is just a matter of creating the WHERE criteria of a query to return just that record and then you can pull the values just like in that link that you supplied.
May 19 '16 #7

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

Similar topics

8
by: L Major | last post by:
Hi Unfortunately, I am limited to using tables for part of my current project. I have a form that spans across a number of TR and TD in the shape of checkboxes. Doctype is XHTML 1.0...
10
by: Magnus Warker | last post by:
Hi group! I know that HTML output is not as predictable as sometimes desired, but let me ask a question. The following HTML code produces a rectangle that covers the entire client area of a...
21
by: bha123 | last post by:
Hi I am struck with this problem . i have 2 forms .. Form A has 2 dropdown box state : city :
3
by: mbatestblrock | last post by:
Perhaps this is a no brainer...I have a database that is comprised of just one form and one table. This was made quite a while ago for someone, and now they want to do some more with it. Now they...
4
by: lena1342 | last post by:
Hi Everyone! I tried to insert a picture in specific cells and I have coded a small VBA for Excel 2007. Unfortunately the macro only opens and inserts a picture in the active sheet but it should...
1
by: Scott Martinek | last post by:
I created a form (Base_Data_Form) that updates a table (BaseDataTbl) and I created a combo box to populate the account number from a different table (0004_All_Accounts) when the account number is...
2
by: emiko771 | last post by:
I am new to C# and am not experienced in creating complex methods. I need to create a class that will input data into a DataGrid with set number of columns but an unknown number of rows. This...
1
by: Ineedhelpplz | last post by:
I am trying to export the record displayed on a form in Access to an Excel template which I would then rename and use the data in further calculations. I want to click a button on the form to...
4
by: MightyMike | last post by:
I am exporting multiple records into specific columns of an excel spreadsheet. There's 6 fields i want to export. There's a great discussion re exporting a single record into specific cells....
4
by: markiemark | last post by:
Hi there I'm trying to add several fields to a form from a table that has criteria towards obtaining a specific risk index. In the lookup table, there is: (the first column is the heading and the...
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
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: 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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
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....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.