Search results for query: *

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...

Another way is to have all of your data in multipl back end db with links into a front end db and set the file access permissions on each of the back ends. Burglar

I have had that happen but only after I change my domain password without changing it in the scheduled task.

Hey all. I am using Access 2000 and have a database that imports 200+ flat files every night into it. The database has 30 tables and 40+ relationships and is fully normalized. There are a total of 2.5 million rows across all tables and the size has just grown to 2GB after the nightly import...

Hey all. I am using Access 2000 and have a database that imports 200+ flat files every night into it. The database has 30 tables and 40+ relationships and is fully normalized. There are a total of 2.5 million rows across all tables and the size has just grown to 2GB after the nightly import...

After pulling my hair out for the last 2 days, ratsstar69's solution actually worked. I thought I had tried it but I missed one range statement. When I added the Objxl.range instead, it started working. Thanks a lot.