- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 5
- Posts with Upvotes
- 5
- Upvoting Members
- 5
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
Mechanical Engineer & Shareware Author
- Interests
- My wife, my son, my shareware business, and my job in that order
128 Posted Topics
 | Hiya All, Nice forum that I found from SEO Guy's SERPS page. I've posted a few times on the VB board, and I hope I can be of some help to the people there. I'm a shareware author in my spare time, and a mech engineer in my work time. …  |
| | 'white hat' SEO is no more unethical than hiring an advertising writer A that writes better copy than advertising write B. Is it unethical to understand the psychology of human decision making? Why then is it unethical to try to understand the algorithm of a search engine? Makes no sense … |
| | [QUOTE=dtbn]Hi, I already have an excel file (MyXL.xls) and a Visual Basic (Form1.frm) with a command button. Now, I want to write a code for the Visual Basic so that when I click on the command button, the excel file will be opened. Any help is significant to me! Thank … |
| | lol there's a simple question with a complex answer. 1. Dont submit your site to Google, it's a waste of time. Try to get some links to your site from other sites, this will get your site into Google quicker than submitting it. 2. Long answer. Try reading seo guys … |
| | [QUOTE=Transworld]Well I have to make a microwave program in Visual Basic for school. I can't seem to find anything in the index that will help me with the timer/countdown. I found TimeOfDay() and was going to use that for the clock but I can't figure out how I would make … |
 | Forum signatures have long been believed to have some value with regard to SEO and targetted anchor text. There's a great thread on search engine watch [url]http://forums.searchenginewatch.com/showthread.php?t=2922&page=1&pp=20[/url] that goes into a lot of detail. Personally I don't think they have much value (I believe that 100 links from a site … |
| | I agree with Site Tutor, give a monthly rate and an indicative amount of work this will cover. That's what I'd be most comfortable with. |
| | Try googling for OLE control and visual basic. Tons and tons of answers.  |
| | [QUOTE=mark johnson]:cry: i need a code for first come first serve simulation based on vb programming :rolleyes:[/QUOTE] This sounds extraordinarily like homework. Why not post what you have already done and maybe we can help when it looks like you've had a try yourself. |
| | The google link: search does not show all of the links to a site. In fact noone knows really why it picks to show some links over others. What IS shown by the link: search seems to be in a state of flux. |
 | If anyone in Australia is considering buying this book then do it on Amazon. It's $40 cheaper than from a bookstore here even when shipping is taken into account. US dollar is finally working our way for once! |
| | 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.  |
| | Here's possibly the single most useful function that I use. It simply takes an ADO record set and dumps the column names and row values into an Excel worksheet. To use it make sure you have Excel marked in your project references. |
| | Uses the API to get the regional short date format from the PC |
| | ADO allows you to use the MoveNext / MovePrevious methods on a recordset allowing you to move back and forth as much as you like. |
| | Try taking a look at my ADO tutorial [url]http://www.timesheetsmts.com/adotutorial.htm[/url]  |
| | Is this an access form? If its a regular VB form then set the style of the dropdown to Dropdown List. If its an access form I have no idea :D |
| | Take a look at this ADO tutorial, it will tell you the correct syntax to use: [url]http://www.timesheetsmts.com/adotutorial.htm[/url]  |
| | [QUOTE=sandm]Does someone know about a program that 'reverts' .exe files created with visual basic? For FoxPro exists the refox program that reverts .exe files to .prg files. Maybe something like that exists for visual basic.[/QUOTE] A decompiler exists for VB4 (or 5 I cant remember). No such thing exists for … |
| | I can tell you that I never, ever, ever visit tech forums on the weekends. Weekends are for fun. I'm old enough and have been doing tech stuff for long enough that these things are no longer something I want to do in my spare time. My 17mth old son …  |
| | Access is only really good for up to 30 concurrent connections (according to MS). I can verify this as all my software has an optional MS Access backend and we have used 30 concurrent connection systems many times with no problems whatsoever. MySQL is better for more concurrent connections and … |
| | Re: date problem [QUOTE=jwshepherd]the dtpicker seems to work best for most of my applications.[/QUOTE] I'll second that. |
 | You could try SugarCRM [url]www.sugarcrm.com[/url] |
| | Great idea! I'm a software developer, and have handed out a some free licenses before, but it has never occurred to me to hand them out in exchange for links. Mmmmmmm 1 way links, luverly! |
| | Here's a quote directly from MSDN regarding the Find method of an ADO recordset: [quote]Optional. A SearchDirectionEnum value that specifies whether the search should begin on the current row or the next available row in the direction of the search. [b]An unsuccessful search stops at the end of the Recordset … |
| | Try looking at MSN search too for backlinks (link:[url]www.yourdomain.com[/url]) . It seems to be the SE that lists new backlinks the quickest.  |
| | [QUOTE=MSUMichelle]I am a summer intern who has been given a project in MS Access and has little knowledge of VBA - so I would be extremely grateful if you could help me. I have a form called Customer Programs that saves the program description, brand and year. Each program is … |
| | How are you adding the chart? If you are using the Charts.Add method then you can use this to get a reference to the new chart object. [code] dim chartNew as Chart set chartNew=ActiveWorkBook.Charts.Add chartNew.ChartTitle.Characters.Text = "This is a New Chart" [/code] And so on. By the way your CD's … |
| | Where are you talking about listing them? META keywords is essentially useless so I wouldn't bother there. Personally I'd target a page at each of the phrases you want to target making sure to put the targetted phrase in your <title>, <h1> and throughout your text. Then of course you … |
| | I saw a 60% drop from about 3 Feb right through to around 2 March. Things seem to have gone back up to the initial levels (for the last week at least :D). I know of two completely unrelated adsense advertisers who saw the same thing. Too weird.  |
 | Who knows. Perhaps something went wrong and they rolled it back. Perhaps they're messing with our heads :mrgreen: |
| | |
| | [QUOTE=stphone]Hi, I'm not quite sure which forum I should post my question, so if this seems like the wrong place for it feel free to move it to the appropriate forum. Right now when I use a barcode scanner it will scan the barcode information into one field. However I … |
| | I generate a ton of reports directly into Excel using the Excel object object model. This is the best way to do it. |
| | 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 completely natural web development process. IE Don't over optimise the …  |
| | I've seen a doubling of traffic with basic on page and off page SEO. But then my site is hardly are 'large one' :) |
| | Name: Mark Nickname: errr Mark? (I'm too old for a nickname) Height: 5'6'' Weight: 165 Hair: what's left of it is brown Eyes: Brown Location: Adelaide, Australia Age: 33 Hobbies: reading, computer games, gardening, building things in the garden, building loudspeakers, playing with my son, spending time with the missus … |
| | 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. |
| | |
| | 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 Trans.Vdate>=Date1 AND Trans.Vdate<=Date2 |
| | [QUOTE=bops]hi everyone, I am doing a project for college, which involves programming using VBA in Excel. I have most of it sorted and i am having trouble on this 1 part. I need to find out how to use variables to access a sheet and range within the spreadsheet variable1 … |
| | [url]http://www.daniweb.com/techtalkforums/announcement97-2.html[/url] |
| | Try looking at my ADO tutorial ([url]http://www.timesheetsmts.com/adotutorial.htm[/url]) and using a different connection string for SQL Server. You can read about SQL Server connection strings here: [url]http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer[/url] |
| | |
| | Use the Weekday(date,[firstdayofweek]) function, it'll return a number from 1 to 7 where 1=Sunday and 7 = Saturday. |
| | [QUOTE=artint3]how can i put the text i added to database to the combo menu i have in another form?! :confused:[/QUOTE] 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 … |
| | 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 of how to think about outputting stuff to Excel. [code] '******************************************************************************* ' … |
| | Try this link [url]http://www.vbcodesource.com/downloads/encoderex.zip[/url] |
| | 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: [url]http://www.mcdar.net/q-check/datatool.asp[/url] |
The End.