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 TouchToneTommy 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: *

  • Users: Shep
  • Order by date
  1. Shep

    SQL7 Linked Server - Inconsistent Metadata

    After adding two columns to a SQL Server 7 (SP3) table we have found that a view from a linked server has stopped working with the message: SQL OLEDB supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time. This is not the first time we...
  2. Shep

    Request for Advice on SQL Server + Incoming Email

    Cheers Tom, but I've already looked at SQL Mail. Like you say, it can respond to queries via email so I could get it to invoke a stored procedure but I don't see how it can help me retrieve, store + process an email attachment. Mark
  3. Shep

    Request for Advice on SQL Server + Incoming Email

    Not looking for a spoon-fed, "here's the code to do it" answer, just a pointer in the right direction... I have a customer running a SQL Server 7 database with an Access 2000 front-end. He's very happy with it but I like to be pro-active and am looking at ways to improve it. One area...
  4. Shep

    RASAPI32.DLL + NT

    Apologies in advance if I've come to the wrong place, but I'm trying to use the above DLL to create a dial-in connection but the blinking thing doesn't seem to want to register itself on NT (yet works fine on 95/98/2000). I have tried installing the Remote Access Service on my NT machine and...
  5. Shep

    Problems with Co-related subqueries that contain a LIKE clause

    nabs, The wildcard character in Access (all versions) is the asterisk (*) The wildcard character in SQL Server is percentage (%). I reckon your problem lies there rather than correlated queries. To prove it's nowt to do with correlated queries just try running the subselect in isolation. Shep
  6. Shep

    Specifying the location for the LDB file.

    Phooey, In the example I mentioned above, all the controls were bound to an underlying record source. I've just done a test on a linked system on our network + you're right about the second LDB file being created (never noticed it before). BUT - I have also just tried the same thing using...
  7. Shep

    Specifying the location for the LDB file.

    Phooey Like you say, when you open the front-end MDB you get a corresponding LDB. But you never open the other MDB file - the tables are all linked (File >Get External Data > Link Tables...). No errors, no problems & only one LDB file. Shep
  8. Shep

    Specifying the location for the LDB file.

    Michael, Like I said in my post - I have done this several times with various payroll archives. The LDB file is created wherever the front-end MDB file is (eg C:\PayArch\) - it makes no odds where the linked tables are (eg D:\On_A_CD\). I even had one instance where I had 7 years worth of data...
  9. Shep

    Specifying the location for the LDB file.

    Phooey, As Michael says, why not split your MDB in two and put the data on a CD and keep the front-end forms + queries etc on the user's hard-drive? You dont have to create a DBF file or anything like that - just have one MDB for the data and one for the software with all the tables linked...
  10. Shep

    Export fixed width file with schema.ini

    jacquid, The way the help file read, I took it to mean that Access would only use an INI file if no specification name was included. Presumably you have included a specification for the export to use and it does exist in your database ? As an extra test could you try doing what the macro is...
  11. Shep

    Export fixed width file with schema.ini

    Looking at the (Access 2000) help re TransferText Specification Name... The specification name for the set of options that determines how a text file is imported, exported, or linked. For a fixed-width text file, you must either specify an argument or use a schema.ini file, which must be stored...
  12. Shep

    Limiting the number of records returned by a SQL query

    To limit the records coming back from a select you can use TOP: Select TOP 10 * from tblTableName This will give you the first 10 records matching your criteria - not sure how you'd go about getting the next 10 though.. Shep
  13. Shep

    Export to Excel Report Problem

    Just a thought, but could it be the actual data in the field that is causing the problem rather than the field itself ? For example, does it contain a carriage return / line feed combination (at position 126) that is stopping Excel displaying the data correctly when you come to view it ? Shep
  14. Shep

    How to display formatted date

    RTFM 8-) or Format(Now(),"mmmm dd"", ""yyyy") Shep
  15. Shep

    SubForm record source

    Forms!frmMainForm!ctlSub.Form.RecordSource = SQL statement where... frmMainForm is the name of the main form ctlSub is the name of the subform control on the main form Shep
  16. Shep

    INSERTING unbound values into table

    Do you want to INSERT a brand new record or UPDATE an existing entry in your table ? For an INSERT you want the following syntax... INSERT INTO TABLE1 (FIELD1,FIELD2) VALUES ("X","y") If it's an UPDATE you want... UPDATE TABLE1 SET FIELD2 = "Z" WHERE FIELD1 =...
  17. Shep

    More Combo Boxes and DLooUp Help

    On the event procedure line click the three little dots to the right + select Code Builder. This should take you thru to the VBA editor with the following... Private Sub Combo0_AfterUpdate() End Sub Put txtCustName = cmbCustID.Column(1) between the 2 lines so you get... Private Sub...
  18. Shep

    Saving an access report in PDF Format

    Never tried it + don't have Adobe so I can't try it now - but this suggests its possible... www.mvps.org/access/reports/rpt0011.htm (an all round good site by the way) Shep
  19. Shep

    More Combo Boxes and DLooUp Help

    You could try being a little more descriptive - how didn't it work? Does it compile OK? Does the combo row source work? Does it perform the combo drop down OK? Does it raise an error when you select? Does anything appear in the text box? Does it just not do anything? Have you done what I...
  20. Shep

    More Combo Boxes and DLooUp Help

    cmbCustID column count = 2 cmbCustID row source = Select CustID, CustName from tblCustomers cmbCustID After Update event = txtCustName = cmbCustID.Column(1) (column counting starts at zero) Regards Shep

Part and Inventory Search

Back
Top