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!

Register Log in
  • Congratulations derfloh 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. Norris68

    Developing Webparts With VB 2005

    I have downloaded the WSS 3.0 extensions for VS2005, but this only creates C# templates. Does anybody know where I can lay my hands on a set of VB templates for creating sharepoint webparts?
  2. Norris68

    Detecting when a form is moved

    Anyway, I'm off home now so I'll have to leave you to it. I'll flag this thread.
  3. Norris68

    Detecting when a form is moved

    OK, here goes. The code hooks the window messages for each textbox individually. Within the Form_Load event we hook the messages and remember to unhook them in the Form_Unload event - otherwise you will crash the IDE very quickly! The form has a public sub (HandleMouseHook) to handle the mouse...
  4. Norris68

    Detecting when a form is moved

    You could hook the main window procedure using the SetWindowLong API call and trap the WM_WINDOWPOSCHANGED message. It's very involved though and requires expert coding skills so I'm not going to attempt to post any code here at the moment. I have got some code that hooks the window message...
  5. Norris68

    Return value of Text Field using Month Abbrveiations

    MonthNumber = Month("1 " & [MonthPymtFor] & " 2000") - builds a string e.g. "1 FEB 2000", then returns the month number (quick & dirty solution).
  6. Norris68

    Compiling A Form

    In addition to the other suggestions, publish your database as a mde (or ade) by clicking Tools -> Database Utilities -> Make MDE File. This is a cut down version of the database that has all of the editing functions stripped out - your users cannot alter the design of forms, queries, tables...
  7. Norris68

    Microsoft Windows Common Controls-2? where is it

    <whisper>It's in Project -> Components</whisper>
  8. Norris68

    Input Box Querying

    er ... the SQL statement that I wrote in my last reply.
  9. Norris68

    RecordSet Error

    Ah! Now we are in ADO we don't need to do the MoveLast/MoveFirst - it will give an accurate RecordCount (under most circumstances) without it. Looks like by default you will get a forward-only recordset. Before you Open the recordset, set it's CursorType property to either adOpenKeyset or...
  10. Norris68

    Exclude Duplicates on Import

    Pull it into a temporary table, duplicates and all. Then perform a SELECT DISTINCT query on the temporary table. Unfortunately unless you write the import routine yourself you will not be able to exclude duplicates during the import phase. If you do write your own import routine, check whether...
  11. Norris68

    Input Box Querying

    You need some parameters.The way lynchg described it uses fields on your form to contain the upper & lower values for the date. You could as an alternative use 'imaginary' fields which means Access will prompt you when the query runs. lynchg's form method is more robust as you can verify that...
  12. Norris68

    Not a Valid Bookmark

    Create a brand new database and import all of your data into it. There are no guarantees it will work, but this is the only solution I have found when a compact/repair won't fix it.
  13. Norris68

    RecordSet Error

    What references have you got? CurrentDB() returns a DAO.Recordset. By default in Access 2000 you will be using a ADODB.Recordset. If so, use CodeProject.Connection. Dim rs1 As ADODB.Recordset Set rs1 = New ADODB.Recordset Set rs1.ActiveConnection = CodeProject.Connection rs1.Open StrSql etc...
  14. Norris68

    which REFERENCE do you tick to get the DTPICKER

    Microsoft Windows Common Controls-2?
  15. Norris68

    RecordSet Error

    If you are using DAO (which you are if you are referencing CurrentDB), you will need to fully populate the recordset. If Not rs1.EOF Then rs1.MoveLast rs1.MoveFirst End If total = rs1.RecordCount BTW: Dim A, B, C As String A and B will be Variants - only C will be a string. You want -...
  16. Norris68

    Dlookup function syntax error

    Remove the semi-colon. It's added to the end of queries by Access for no apparent reason - it's not part of SQL syntax.
  17. Norris68

    Linked table path syntax

    Adding the UNC path to your Network Neighborhood will cache the security information, thereby speeding up access.
  18. Norris68

    sql problem

    Try using some aliasing - it will make your SQL code much easier to read. e.g. SELECT a.AdvertID, m.[Name] FROM tblAdverts a INNER JOIN tblMembers m ON m.MemberID = a.MemberID With all those joins it may also be worth considering saving some of the subqueries as individual queries. You can...
  19. Norris68

    SearchForNumber +or_200

    If I understand you, you want the serial numbers that occur at the top & bottom of a range based on your given serial number. In other words, the serial number 300 before your one and the one 300 after - not SN-300 & SN+300 necessarily. OK, but in Access it's going to take 3 queries as Access...
  20. Norris68

    Multiple processing with VB

    I assume you want to launch a window ;) VB does not (easily) support multi-threading, so if your other window is doing any work you will need to liberally spread DoEvents statements throughout the code.

Part and Inventory Search

Back
Top