Uses the API to get the regional short date format from the PC

Sure, as long as you come over here and change my kids nappy when he smells. :mrgreen:

Try:

format(DatePart('d','{subreport1.jobdate}'),"00")

lol you'd think with the stunning silence to his/her requests that this would be obvious to him/her.

GetNextRow looks like it does something. Is there a 'GetPreviousRow' or something? If there isn't it would be pretty trivial to add this to the class. Just copy the GetNextRow code, change the...

How to ask for help doing your homework that will result in you getting no answer.

Parameters Date1 DateTime;Date2 DateTime;Account Text;SELECT * FROM Trans_Details INNER JOIN Trans ON Trans_Details.Vno=Trans.Vno WHERE Trans.Vdate>=Date1 AND Trans.Vdate<=Date2 and Accid=Account;

No. Someone has written a wrapper for some of the ADO stuff by the look of things. What methods are available?

You could try SugarCRM www.sugarcrm.com

HOw are you opening your recordset? ADO or RDO?

That wont work. Firstly,

sheets("sheet").range("range1") returns an object, namely the range named range1 in the worsheet called sheet. So you'd need to do:

Set...

Here's a quote directly from MSDN regarding the Find method of an ADO recordset:



So, before you execute a search execute the MoveFirst method on the RS. Then after the search check if the RS...

ADO allows you to use the MoveNext / MovePrevious methods on a recordset allowing you to move back and forth as much as you like.

I'll second that.

This should work for the command text for a command object in ADO

Parameters Date1 DateTime;Date2 DateTime;SELECT * FROM Trans_Details INNER JOIN Trans ON Trans_Details.Vno=Trans.Vno WHERE...

Use the Weekday(date,[firstdayofweek]) function, it'll return a number from 1 to 7 where 1=Sunday and 7 = Saturday.

http://www.daniweb.com/techtalkforums/announcement97-2.html

Well if you know the text you want to add you can add items to a combo on another form with

TheOtherFormName.TheComboName.Add.AddItem "Item Text"

Alternatively you can select the data again...

This sounds awfully like a homework question......

The code I posted is a way of doing that.

Get Excel and all of this stuffing about with the clipboard will be fixed.

Try looking at my ADO tutorial (http://www.timesheetsmts.com/adotutorial.htm) and using a different connection string for SQL Server. You can read about SQL Server connection strings here:...

OK here's some sample code I use to output an ADODB recordset directly to Excel. You'll need to include Excel 8.0 or better as a project reference for this to work. It should give you a good idea...

I generate a ton of reports directly into Excel using the Excel object object model. This is the best way to do it.

Are you sure? In Google try typing site:www.yoursitename.com.au (insert your URL of course) to see if your site is in the G* index. Just because you're not showing up in the search results you'd...

Hiya,

Its not just me arguing this, here's some articles that mention exactly the same thing:

http://www.softwaremarketingresource.com/article55.html...

Let me say it slowly, the theory is, the sandbox is applied for harshly for terms that are highly competitive, and much less harshly (if at all) for terms that are not competitive at all. Does that...

There's no rule. It can be a few weeks to nearly a year. There's nothing you can do once you're in it. The best theory people have to avoid getting into it in the first place is to show a...

Actually I don't have it wrong at all. I didn't mentioned adwords, here's what I said:


Thank for repeating what I said and adding some useless rubbish at the bottom that takes this post further...

The 'Sandbox' has absolutely nothing to do with getting pages indexed. Supposedly the sandbox is a filter that Google (and only Google) applies to the search engine rankings of new sites for...

Submitting to search engines is a total and utter waste of time. Try getting links from external sites to your site. This is the most proven way of getting search engines to spider your site.

The tan function is expecting the argument to be in radians so convert your 45 degrees to radians before doing the tan. You can confirm this in windows calculator by setting the units to RAD and...

Basically you need a crystal reports file for this to work. It may or may not be legal for the author of the software to supply you with this file (depends on what license of Crystal Reports he...

There is a list around somewhere but I can't find it. Here's a neat tool to allow you to check your rankings across data centers:

http://www.mcdar.net/q-check/datatool.asp

Try looking at MSN search too for backlinks (link:www.yourdomain.com) . It seems to be the SE that lists new backlinks the quickest.

Patience. Keep adding links. Try pointing some of them at deeper pages rather than all of them just at the index. This can help encourage Google to look deeper.

You really really really shouldn't be doing peoples homework for them dude :cry:

Posting the error message would be helpful.

As Alvein said all you need to do with that tutorial is change the connection string to get it to work with SQL Server. Look here:...

Try doing the total direct in your SQL

SELECT sum(column_name) as sum_column_name from table_name

Then use normal ADO/DAO or whatever to access the field sum_column_name

Personally I believe that CSS can only help your SE rankings, but I wouldnt expect too much (or anything actually) :mrgreen: . Why? It makes your html cleaner, easier to index, smaller, and faster...