Duane: Thanks.. I was trying that but couldnt get it going.. Your advice put me back on track though..
I wasnt including the complexity in the select statement in the subreport, so i couldnt link w/ the child/master link fields
i altered the sql to include complexity, then placed hidden fields...
Hi all.
Im using a report that returns job information, names, complexity. etc.
One of the groups (complexity) has a subreport in it.
the subreport needs to perform calculations for totaling, etc. based on individual complexity ratings.
I am using a an SQL query as the source for the...
hey im executing from the VB application, not within an access vba app..
my main problem is that im using a custom database component written a few years ago, then was passed on to me to update.. i dont have the source to see what its doing so im hoping to find a way around it.
(so the code...
Hey all,
I need to run a couple of Access queries when i close my application. They are make-table queries that create tables in a separate database. they work fine the first time, but do not successfully complete when access would normally prompt to overwrite the current table.
i need to be...
sounds like a corrupt registry to me..
first thing i would do is try to restore it using the recovery console.. hopefully it made a good copy on the installation.. check http://support.microsoft.com/default.aspx?scid=kb;en-us;307545&Product=winxp for info on restoring corrupt registry..
faiing...
yea i screwed around w/ that bootcfg from the recovery console but it didnt seem to help me.. maybe it will help the other guys having that problem.
another interesting note that i just remembered... i was getting an error message about the mobo looking for 80pin IDE cable... I have the same...
well after screwing around, formatting, fdisking, formatting, fdisking, etc.. i decided to plug the HD into the secondary IDE chain.. kept it as the only drive in the computer, and did an fdisk/format while it was in the secondary chain... i formatted it as a 2Gb FAT drive (it was a win95 boot...
jdunderhill.. sounds like the exact same system..
im using:
AMD XP2400+
512Mb RAM
80Gb Maxtor (hmmmmmmmm)
MSI KM4ML motherboard
LG DVD-RAM
i read another post suggesting copying the d:\i386\ntldr, and d:\i386\ntdetect.com files back over to C:
i did this and it didnt help..
masterofnone -...
left the pc at work for the weekend.. tuesday ill try swapping the hd out and into a new comp, and a new hd into the old comp and post the results..
and not insulted at all.. even im amazed at some of the stupidest things ive missed in my years of working w/ this stuff..
thanks for your help
went into fdisk..
its the only partition detected
and it is set to active
formatting as fat32 right now... seeing if it was an NTFS problem..
im starting to think the HD has some underlying errors...
anyone seen this one before? its got me completely baffled..
i did a fresh install of XP and as soon as i reboot i get the error message:
Boot from cd:
Boot Disk Error: Insert System Disk and Press Enter to continue
so i put the XP cd back in and it boots up fine..
ran every test i could think...
Thanks for the help guys..
Im not sure if I will be able to do a view yet since that will require getting special permission to the db, and ive yet to hear back about that..
I am trying the 'Add Command' method to select the data source.
here is my sql:
select * from...
Hi all..
Using CR9 and ODBC connection to SQL Server 7 database..
I am trying to select values from table A based on values from table B.
example
table B contains values 'monkey', 'dog', 'cat', etc...
i want to select values from table A which are not in that master list of values in table...
i saw a post elsewhere where someone had a similar issue and i believe flushing dns using 'ipconfig /flushdns' and purging and reloading the remote cache name table 'nbtstat -R' fixed it for that guy..
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.