Forum Replies Created

Viewing 15 posts - 16 through 30 (of 105 total)

  • RE: Combo box .additem

    Hi,

    This is not something i've heard of -or can find mention of else where - so i have three suggestions.

    1. Check that the datasource is correct i.e. that the data...

  • RE: The Daily Commute

    Lynn Pettis (7/9/2008)


    Clive Strong (7/9/2008)


    WFH...Hmmmm the Xbox360 is there - bad idea.... 😛

    But yes, the price of petrol is a killer...As I catch the train, I rarely use the car...

  • RE: The Daily Commute

    Hi,

    I've done the work from home bit- only a couple of days a week - and remote office working on my own neither of which i enjoyed. For the...

  • RE: The Daily Commute

    Just to add to the misery 🙂

    1 litre of diesel here (UK) cost £1.33 ~ $2.58 give or take a cent

    That makes an Imperial gallon [4.546 litres] cost £6.04 or...

  • RE: The Daily Commute

    Hi,

    65 miles each way 🙁 Just outside of Cambridge to North London (West on the A14 ->South on A1). It takes anywhere from 65 to 120 mins but avgs about...

  • RE: Scripting Access Queries

    Hi,

    Expanding a little on the above suggestions. This will create 1 file containing the SQL of all the queries in the database it is used in.

    Works in 2000 and 2003.

    HTH

    K.

    Public...

  • RE: Automatically insert text from one text box on a subform to an unbound text box on a form as typing

    Hi,

    I think the best you're going to get is using the Keypress event of the text box you are typing into.

    Assuming i've got your hierarchies correct

    [Code]

    Private Sub ExternalTechnical_KeyPress(KeyAscii As Integer)

    Dim...

  • RE: Compact and Repair partially fails

    Hi

    I have had this happen with 1 of my app's which i've written to allow users to autosync objects i.e. forms and reports from a master copy on our network...

  • RE: Count # Rows for 25 tables and output it to a table

    Hello,

    This should do what you want.

    Run This once to create the table which will store the data

    DoCmd.RunSQL ("CREATE TABLE TBL_TABLEINFO (TABLENAME Text(30) NOT NULL, TABLEROWCOUNT...

  • RE: MatrixDB

    Components could fail, and it would seamlessly adapt without any downtime or any admin intervention. And no query or workload would be too big for it, because to get more...

  • RE: Easy or Hard

    Hi

    There is already a company that follows that model, Oracle. I'm sure I’ve read a number of articles on here suggesting with some justifiable pride that SQL Server DBA's are...

  • RE: Access 2007 very slow with SQL server odbc connection (sql 2000)

    Hi,

    Patching to SP1 may resolve some responsiveness issues however i suspect that Access 2007 is a resource hog. I've only run some small tests as we have no intention of...

  • RE: "Suspended" process caused by MS Access

    Hi,

    Rather than looking at Access as the problem perhaps someone should question the implementation.

    Why do you need to be able to look at 13,000 records at one time?

    An assumption here...

  • RE: Database Optimization

    Hello,

    I have to say I would wait until the vendor has finished working on the DB. Unless they are not touching the same areas of the DB as you intend...

  • RE: How to lay out SQL Code

    Tom Garth (3/6/2008)


    Karma (3/6/2008)


    Hi,

    Interesting topic 🙂

    Does anyone else think it's slightly obtuse to spend time creating naming standards for tables and then alias them in code with something so meaning...

Viewing 15 posts - 16 through 30 (of 105 total)