Impossible? Perhaps
Nov 23, 2004
Hi,
I'm creating a form to input data with. But, since forms are by an individual record basis, I was hoping that I can somehow see a general view of what is happening for all the records as I'm inputting data. Is there any way to stick the table into the form itself, kind of like a subform, so that I can see all the records as I input them in? If not, is there any such thing that I can do, where I'm not just limited to the one record I'm working on, but where I can see what's happening around that record I'm working with? VERY much thanks to anyone who can figure this out. Hope it wasn't too unclear.
G
View Replies
Jul 7, 2006
I have a table with 3 fields: CUSTOMER, START INVOICE NUMBER and END INVOICE NUMBER
I want to populate an identically formatted table with a consolidated list of start and end invoice number ranges for each customer. HOWEVER! Heres the rub....
The ranges for each customer in your starting table may overlap, one range of numbers may fit inside another range of numbers for the same customer.
For example:
Customer: X Start: 10 Finish: 15
Customer: X Start: 11 Finish: 17
Customer: X Start: 9 Finish: 16
Customer: X Start: 3 Finish: 7
I want to represent this in my new table as:
Customer: X Start: 3 Finish 7
Customer: X Start: 9 Finish: 17
I have been banging my head again against a wall for hours trying to work this out.........
PLEASE HELP!
Regards,
Dalien51
View 2 Replies
View Related
Apr 25, 2006
I have created an Access database to be placed on a company network consisting of 25 individual tables and 1 large table (the large table is an amalgamation of the smaller 25). The 25 individual tables will be updated regularly by different staff!
I was wondering if tables can be linked to one another? i.e If I enter data into an 'individual table' can that information be automatically transfered to the 'large table' to save entering the same data twice?
Confused :confused: - Me too :)
View 4 Replies
View Related
Jun 29, 2005
Hey Everone.
In the middle of building a DB system obviously for someone else. Is it possible to generate an email with the subject box & body filled in automatically.
e.g The button will say "Send Email", when clicked will generate an email with the subject box filled in with "Turmic Records....." and the body of the email filled in with "Thanks you for joining us...balblabla". You know what I mean.
Is this possible at all with Access. Has anyone ever generated any kind of emails from Access.
Please Help
Shane
View 1 Replies
View Related
May 10, 2007
Hi all,
I was wondering if this was possible to do at all using access or ideas on how to do it in any other way.
View 3 Replies
View Related
Jul 27, 2006
Hi,
I have 3 tables (i have 5, but i think it's the same)
t1 (id,name,month,hours)
1,peter,july,25
2,peter,july,5
3,mike,june,7
4,peter,april,50
t2 (id,name,month,hours)
1,peter,june,13
2,jane,july,5
3,peter,july,6
t3 (id,name,month,hours)
1,jane,july,70
2,jane,june,3
i want a query that returns me (the order doesn't matter):
peter,june,13
peter,april,50
peter,july,36
mike,june,7
jane,june,3
jane,july,75
thank you very much for your help
View 7 Replies
View Related
May 23, 2015
I got an image bitmap that I want to use to customize my button. I got following error pop up."Image Generator" - "search key not found in any record".I'm using access 2013
View 1 Replies
View Related
