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

Add rows in access subform

Hi

I have a member form with a supplier subform in an Access 2002 database.

The suppliers need to be in a certain order and are sorted in SQL.

I want to be able to add all the suppliers to a new member automatically instead of selecting each one individually. Can it be done in Access 2002? or 2003?

I tried using add record and it adds the first supplier and crashes.

Thanks for your help

Julie

PS I'm only a beginner in VBA
Feb 11 '06 #1
1 2725
PEB
1,418 Expert 1GB
Hi,
1. You have to create a bouton! On clicking the bouton an append query will be started and will append your suppliers to the member!
2 On clik event in the bouton you ass=ociate a macro

Macro have to have the fooloing commands
RunSQl with the append query

And

Refresh or requery for actualisation of the subform!
Sep 6 '06 #2

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

Similar topics

3
by: Greg Neef | last post by:
I need to develop a Tab Form where selecting a particular key from an unbound combo listbox will resulting in the display one or many records from several tables, where each tab has the matching...
4
by: Laura | last post by:
Here's the situation: I'm trying to use an update query to copy data from one row to another. Here is the situation: I have 5 companies that are linked to each other. I need to show all 5...
5
by: ego | last post by:
Hi all , I had created the following Form/SubForm structure : MainForm SubForm A (SubForm of MainForm) SubForm B (SubForm of SubForm A) SubForm C (SubForm of SubForm B) SubForm D ...
1
by: fecket | last post by:
I have a subform which is a continous form and displays the content of a table, with a subjext number, then a line of text, then a score. I have used an option group to update the score as...
1
by: Terry | last post by:
Hello, Has anyone experienced the following problem following an Upsize from Access 97 to SQL 2000 using the MS Upsize Wizard? Or can anyone see what the problem might be. Before Upsize...
0
by: Krij | last post by:
Hi! I have a problem with the following code (behind a button on frmOrders): (structure: frmOrders->frmOrderdetails (form with subform)) strPutBack = "INSERT INTO...
1
by: pdesh3 | last post by:
I have created a form where one text box and two command buttons named Search and Clear are present. Under all these fields I am also including a subform which displays all the values stored in...
0
by: chico_yallin | last post by:
Download Subform Alternate Colored Rows http://access-forum.com/plus/viewtopic.php?t=148 Hope it helps Ch.Yallin
5
Breezwell
by: Breezwell | last post by:
I have done some searching on this one and I have yet to find any information that sheds light on what I am trying to do. At lease from what I can understand. Basically, I have a main form which...
6
by: AdamOnAccess | last post by:
Hi all, I'm in Windows XP, Access 2007. I need to create either a tabular subform or a list box that, from a query, returns a list of records showing amounts of money sorted in descending...
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
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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...
0
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,...
0
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...
0
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...
0
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,...

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.