Is This The Impossible?

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 Replies

Is This Impossible???

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

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 5 Replies View Related

Mission Impossible

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

Report Output Impossible? =(

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

A Query (i Think It's Simple, But Impossible For Me)

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

Forms :: Impossible To Add Custom Icon To Button

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