Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. seagoing

    Equivalent syntax VB 6.0 vs VB.NET 2008

    There is a useful tool within VS 2008 (VB at least) which may help to point you in the right direction in understanding how to convert VB6 code to VB Net. Open a project in VB NET 2008 (express version will do), Open a form and view source code. Then, select Tools -> Upgrade Visual Basic 6...
  2. seagoing

    Print to the very edge of the page

    You can reset your page margins Top, Bottom, Left, Right to 0cm and design your publication right to the edges of your paper size. Whether or not it will print like that will, of course, depend on the capabilities of your printer.
  3. seagoing

    Table of Contents linking objects

    Whilst MS Word has the facility to create and manage a table of contents. MS Publisher does not. You have to mannually maintain your table of contents entry and the page number
  4. seagoing

    How to edit subforms placed on top of one another

    You could try placing your subforms on seperate pages of a Tab Control then manipulate the visible property and/or active page of the tab control as appropriate
  5. seagoing

    Closing Connections to my ADODB Access DB

    Try.... objConn.Close Set objConn = nothing ...after you've closed the last recordset you use in your script
  6. seagoing

    What tools do I need for ASP?

    The only tool you NEED, to develop an ASP based website, is a text editor, such as notepad.exe. However, Dreamweaver provides for nice syntax colouring, as does the MS Visual Studio suite of programs. However, such software can prove expensive! You may be better off, in the short term...
  7. seagoing

    Checking for which text box had focus last

    You might experiment and see if Screen.ActiveControl and/or Screen.PreviousContol could be of use to you!
  8. seagoing

    Access 2000 - Reports Crash when opened in vba using DoCmd OpenReport

    Yes, frequently, doesn't help though! Regards TS
  9. seagoing

    Access 2000 - Reports Crash when opened in vba using DoCmd OpenReport

    Thanx again. No offence taken! Not much code to display, a simple DoCmd.OpenReport.... statement. The report itself is nothing special, NO subforms, No VBA Code. So, you see my problem, not much to try changing! I understand your point about Access 2003 Regards TS
  10. seagoing

    Access 2000 - Reports Crash when opened in vba using DoCmd OpenReport

    Thanks for your comments IGPCS, I must admit though, I've found MS Access 2000 brilliant, over a number of years usage. I think I can honestly say that this problem, crashing reports! is the only real problem I've experienced with Access itself, so I'd love to get it sorted. There must be an...
  11. seagoing

    Access 2000 - Reports Crash when opened in vba using DoCmd OpenReport

    Have a problem contolling reports in MS Access 2000 (ver 9.0.6926 SP-3) through VBA. When attempting to open reports in vba using... DoCmd.OpenReport stDocName, acPreview, , strWhere ...Sometimes the report(s) open, sometimes they don't and, more importantly, sometimes they cause a Fatal...
  12. seagoing

    Cannot add to value in previous months

    On_Load ...ing the form, why not determine the current month and then disable all the controls on your form you do not want your users to be able to make an entry in?
  13. seagoing

    Access Do Loop problem with Dates

    Might help to check to make sure your comparing like with like... ... if datevalue(workdate) = datevalue(format(rshol!HOLIDAY, "General Date")) then ... Using datevalue() has the advantage of ignoring any time values that may be included in your tables date field(s)
  14. seagoing

    Paging Records?

    OK Tony, thanks for that, looks like a promising start. Regards TS
  15. seagoing

    Paging Records?

    Re: Win XP Pro IIS5.1 PHP5 MySQL5. New to PHP/MySQL. Normally develop in ASP, MS Access/SQL Something I frequently find myself doing in ASP is displaying paged data, from a database, on a webpage, by using the ADO Recordset object. I've not seen an obvious way to do this in PHP with data from a...
  16. seagoing

    Insterting formatted text into MS Word

    OK fumei, thanks. Guess I'll have to go the way of using a temporary file and an include!. I appreciate your responses.
  17. seagoing

    Insterting formatted text into MS Word

    I'm sorry, I thought I had! There is NO post merge processing. The user is entering the textual content into an Access database, this content is LATER to be merged into personalised Word documents. The user needs to be able to format the text they enter, into the Access database, as described...
  18. seagoing

    How to split date

    All true but Chrisma asked how to split an existing date into three component parts, to present each part seperately in his forms <input> fields, so the date could be edited?
  19. seagoing

    captilize first character of last name string

    '**************************************************** ' Function - doCaps - Capitalisation of Text '**************************************************** Function doCaps (mytxt, mymode) dim tbuff dim nBuff dim tchar dim tAscii dim n nBuff = "" tbuff = trim(mytxt) if mymode = "First" then...
  20. seagoing

    How to split date

    Value for day... <% =right(("00" & cstr(day(session("start_date")))),2) %> Value for month... <% =right(("00" & cstr(month(session("start_date")))),2) %> Value for year... <% = cstr(year(session("start_date"))) %>

Part and Inventory Search

Back
Top