[AccessD] Dumb one for ya!

John Clark John.Clark at niagaracounty.com
Mon Oct 27 15:06:56 CST 2003


I suggested this, but she doesn't get it...and I don't have time to do
it right now. So, if I can just give her a quick answer for now, and
then dodge her for a few days, I'll be good to go. 
 
However, my headache has started to ease, and with it I have gained
some clarity. I am realizing how stupid my approach was--even if I could
find the proper syntax to reference the table, it still won't work. I
think I'll just have to be mean and tell her she is doing it wrong, and
that I can help her re-work it, but she will have to wait a few days.


>>> wdhindman at bellsouth.net 10/27/03 03:33PM >>>
...why not change the form source to a query based on both tables?

William Hindman
<http://www.freestateproject.org> - Do you want liberty in your
lifetime?


----- Original Message ----- 
From: "John Clark" <John.Clark at niagaracounty.com>
To: <accessd at databaseadvisors.com>
Sent: Monday, October 27, 2003 3:19 PM
Subject: [AccessD] Dumb one for ya!


> I am trying to help someone with their DB...I don't even know why
they
> are doing one, because it is the secretary and not a programmer...I
know
> this because I am the only one (sort of). In any event, I am running
> really behind on another project...as usual...and just want this one
to
> 'go away' for the moment. Which leads me to my stupid question.....
>  
> She wants to bring a balance over from one table into a form that
uses
> another table as its source. How do I reference the field? Simple
> right?
>  
> I have tried : 
>  
> StartBal = Tables![AcctBalances]![AcctBal]
>  
> and it 'does not recognize the field 'Tables'.  Keep in mind that my
> head is throbbing at the moment, and I have a night of overtime
planned.
> Please tell me that I don't have to go through the whole rigamaroll
of
> declaring the Database and Tabledefs.
>  
> Thanks in advance!!!
>  
> John W Clark
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd 
> Website: http://www.databaseadvisors.com 
> 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 



More information about the AccessD mailing list