473,383 Members | 1,885 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,383 software developers and data experts.

Enter data in datasheet view

18
I have a form & a subform. The main form will show info on the selected customer (qry based on tblCustomers). The subform will show all the parts this customer has purchased (qry based on tblCustParts - the many side of tblCustomers).

I have the subform (datasheet view) display the part number along with the specific info about that part such as Description & Price (which gets pulled from the Parts table). The user can add a part number (to the tblCustParts) & as soon as they do, the next 2 columns display the appropriate Description & Price (which of course is for display purposes only - they can't change it). This works fine as long as the user enters a part number that is in the Parts table. Is there a way to allow a user to enter a Part number that is not in the Parts table & enter their own description & price for this number?

I don't think there is, but wanted to check before I said anything.

TIA
Connie
Aug 21 '10 #1
0 1159

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

Similar topics

1
by: Ralph | last post by:
Hi My users are going to toggle back and forth between DataSheet and Form view. This eliminates the need for a pile of queries <g> Anyway, I would like my form to be viewed at the current size...
2
by: ivan | last post by:
I have a form (CustomerImfo) that has a subform within it (order). Within that subform is another subform (OrderDetail). That subform (OrderDetail) is displayed in Datasheet view. When I am...
2
by: Georges Heinesch | last post by:
Hi: I have a tables in relationship to each other. When I open the main table (table 1), I see a "+" at the very left of every record. Clicking on the "+" expands the data of the linked table...
1
by: chrissmith_76_Fed_Up_With_Spam | last post by:
Hello all, I am using Access 2002, with file format of Access 2000, and am experiencing a problem. I have a subform that is shown in datasheet view for users to edit data direct to a table. ...
1
by: jsb2n | last post by:
I haven't developed applications in 2 years (have been doing straight SQL Server work) and I am new to developing in Access. I know that using the datasheet view of a form is not usually the...
3
by: Bface | last post by:
Hello, I tried looking through some of the postings to see if anyone asked these questions before but I didn’t find any. I have 3 questions and I hope someone can help me out. I will write post...
2
by: swb76 | last post by:
I have a query in MSAccess and it is a select query. As i understand, any query run from Visual Basic would be returned in a recordset. Can i display the results to the user in a datasheet view?...
2
by: Alan Forsyth | last post by:
That rather long subject says it. In Access97 running on XP - I want to display a Maximized size Form01, then open a Restore size Datasheet View Form02 on top of the first Form. PopUp won't give...
2
by: pipeme | last post by:
Hi I am not terribly proficient in access coding so please excuse my ignorance if this is easier than what I think it will be! I have a query which has 3 columns and varying amounts of records...
3
by: mark007 | last post by:
I want to open a table from switchboard in datasheet view to enter data, can anyone please guide me how it can be done, i created a form for the table and tried to open it from switchboard but it...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.