473,569 Members | 2,735 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Auto Data Entry

I have the following tables:

TblSaleDetail
SaleDetailID
SaleID
AccountCategory ID
AddendumDate
SellingPricePlu sTax

TblAccountCateg ory
AccountCategory ID
AccountActivity
AccountNumber

TblAddendumDate
AccountCategory ID
AddendumDate

There are 7 records in TblAccountCateg ory that wll never change. The
AddendumDate in TblAddendumDate changes every 6 months and may be different for
some of the 7 Accounts. That's why I need to record it for each sale detail in
TblSaleDetail.

I have a query that includes TblSaleDetail and TblAccountCateg ory with a Type 2
join on AccountCategory ID. The query is updateable. I have a data entry form
based on this query and the form displays all 7 accounts with the AccountNumber.
SellingPricePlu sTax will be entered in the form programatically for the
accounts. Some sales no not include all 7 accounts so SellingPricePlu sTax will
not be entered for all 7 accounts each time.

I need the query to do more. I need the query to:
1. AccountCategory ID from TblSalesDetail is hidden on the form. I need it to be
set equal to AccountCategory ID in TblAccountCateg ory for each account
SellingPricePlu sTax is entered on the form.
2. I need to include TblAddendumDate in the query and display the AddendumDate
for all 7 accounts.
3. I need AddendumDate in TblSalesDetail to be set equal to AddendumDate in
TblAddendumDate for each account SellingPricePlu sTax is entered on the form.

All help is very much appreciated!!

Sue Ann
Nov 13 '05 #1
0 1164

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
1818
by: Steven Burn | last post by:
I'm curious, I've written a very simple PIS (personal info store) that allows one to store whatever they wish..... the problem is, when one deletes an entry, the auto-numbering isn't corrected to account for said deletion..... for example; 1. entry 1 2. entry 2 3. entry 3 delete entry 2, and #2 is no longer available (i.e. 3 should...
1
1211
by: rasta | last post by:
i've a web page that loads the entire cust record tbl to simulate a auto fill during data entry this works great when tot cust recs < 1500, going over the 1500 numbers the conescute page loads take several seconds. that is the user must wait few seconds before the next page appears and then they can continue their order entry i am...
2
12707
by: Tom | last post by:
I am trying to store information into a table that has an auto increment field. There is currently no data in the table. Using the code below I cannot insert data into the table. I get an error telling me that "Number of query values and destination fields are not the same." If I add a value for the auto increment field to the SQL String...
1
1277
by: Scott Simonson | last post by:
What is the trick to allow auto filling? I have two tables that look something like: table1 SSN Text Lname Text Fname Text table2
2
2269
by: SalimShahzad | last post by:
Dear Gurus, i had written following codes to auto generate the next claim no Private Const strC = "GCT/02/J/" Private Sub Command1_Click() Dim stra, stre As String Dim intb, intd As Integer Dim strd As String stra = "200"
1
3085
by: ainsley | last post by:
Hi this is going to sound like a very basic question, but I am creating a database in Access which is based on a number of unlimited tables. In my data entry form i have a number of combo boxes relating to these tables in which the look up field has no limit to list, as I require the users to be able to add new fields. This works fine, however, I...
13
4728
by: S.Dickson | last post by:
I had an access database that i use as an ordering system. I have a form for entering customer details. When i add a new customer on the form the customer number is an auto number that appears when i type in the details. I have just moved over to mysql server with access as the front end. I have setup the sql tables with the customer number...
2
1703
by: des-sd | last post by:
Access Experts, Please help! I have looked through ref. manuals, Google Groups on "Auto Populate", and I am still lost. Problem #1 My DB is 2 relational tables of (1) sales transactions of, (2) radio stations. A transacation may/may not contain multiple radio stations. Each radio station is in a radio market (eg. Los Angeles or...
1
1457
by: glasssd | last post by:
Hi, I was hoping someone might have some ideas on how I can hack around a problem I'm having with the auto-complete feature of the ComboBox. I have a data entry application that uses a pair of ComboBoxes on the main entry screen. These are configured to use the Suggest Append auto-complete feature with the List Items as the data source. ...
5
8081
by: David Wright | last post by:
Hello Everyone I would be grateful if someone could help me with the automatic increment of a field on my subform called ‘Test_SrNo’. I am Using Microsoft Office 2000. The auto entry of the incremented number would help to reduce errors and make data entry simpler. The next record in the Test_SrNo field should not have any entry in it until...
0
7609
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7921
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8118
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7964
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6278
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3651
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1208
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
936
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.