Recent content by Burglar

sorry, wrong url for the css.http://www.yjbled.info/css/styles.css

Hey all, I know this has probably been asked before and I see different hacks for it and can't get any to work. Anyway, I have a content div, menu div, left div, right div, and footer div...the content (image) in the right div is varying height. I want the left div to fill in and border at the...

Actually after pulling my hair out, one of the support files started the file with simply <? not the explicit <?php and my server is not configured for short_open_tag. Thanks for the response though...I appreciate it. Burglar

Sorry, copied the wrong lines of code...here are the 3 error messages I am receiving: [Wed Nov 19 10:56:56 2008] [error] PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: Cannot send session cache limiter - headers already sent (output started at...

Hello all, been a while...anyway, I am using the ziplib class and am getting the following error on one website where I am using sessions: [Wed Nov 19 10:57:18 2008] [error] PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: Cannot send session cache...

If you are using standard Access query objects then: In the properties under view in the query design, set the odbc timeout property to 0...the default is 60 seconds. Otherwise, check the ado/dao timeout setting in the connection string if that is the route you are taking. Burglar

Instead of declare SEQID cursor for select policyNo,EffDate,Transactiondate,TranactionTime from tblpolicyTest order by policyNo,EffDate,Transactiondate,TranactionTime try: declare SEQID cursor for select policyNo,EffDate,Transactiondate,TranactionTime from tblpolicyTest order by...

You would need to use a zip utility that can be executed from the command line like winzip or one of MANY freeware zip utilities. Then you simply use the shell command from within your module to unzip your app. Hope this helps. Burglar

It will also skip if you try to insert data programmatically that may violate one or more constraints using dao. For example: sSql = "insert into table blah blah blah" dbengine(0)(0).execute (ssql), dbfailoneroor or if you have warnings turned off so you can't catch the exception. Burglar

You may even want to consider using adp to connect to the sql server...speeds things up dramatically!

Ooops...I'm too slow I guess

The following will convert any one or 2 digit number to 2 characters. select right('0' + convert(varchar(2), 1), 2)

Thanks for the suggestion but I got a reply from another forum that solved the problem...btw, the app is up to 4.5 million rows now, talk about pushing access to its limits :)

Sweeeeeet!!! This is exactly what I was looking for! Thank you very much mp9 Burglar

Thanks for the suggestion but unfortunately, that is not an option since it takes up to 45 minutes to compact the db after importing all of the files and 20 minutes if the db was just compacted...this would take days. I appreciate the response however. As for the desktop engine, I will look...