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. KenReay

    Changing Content of List Based on Combo Choice in Form [Access 2003]

    Hi Looking at your screenshots, is DocumentId present (even if hidden) in the sub form? Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  2. KenReay

    Changing Content of List Based on Combo Choice in Form [Access 2003]

    OK, what you are getting is exactly what you are asking for. Ie you tell it to list the revisions with the same document id as the "parent" and that is what is doing. If you want to display a particular revision you have to "tell" it which one. There are a couple of approaches here, you could...
  3. KenReay

    Changing Content of List Based on Combo Choice in Form [Access 2003]

    Hi for your item 1 see How to use Combo box as a Navigation tool faq702-4398 in this forums FAQ for you item 2, do you know how to use a subform ? Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  4. KenReay

    Linking Database on Network

    Hi File has to be accessible to the users who will use it, and they must have read/write/create/delete priviledges in the folder in which it is contained. How about setiing the file hidden property to true once you have linked the tables? Not perfect, but betetr than nothing Regards Ken Reay...
  5. KenReay

    SQL: How can I make two value from two record to appear in one line.

    Not sure if you have simplified the table content to explain what you want, but if there is a column to indicate in/out then a cross tab query may give you what you are looking for Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  6. KenReay

    Network Directory on Shared dbase

    Instead of saving "F:\Path\Filename.ext", save \\servername\Path\Filename.ext" (I think this is called the URL, but not sure of that), that way the link is not dependant on drive letter mappings Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  7. KenReay

    Auto Sending Mail

    Automatically" what exactly do you mean?. If you mean without any user intervention, then look up Windows Scheduler. The sending of the EMail is no problem, you can do it using docmd.sendobject or by using Outlook automation. See "EMailing From Access" in the FAQ's of this forum. Regards Ken...
  8. KenReay

    Hidden Field Capture? - Is it Possible

    They are suggesting you put all of the code in the example in a module, and save the module with a suitable name for example mdlNetWorkUserId. Once you have done that, the function fOSUserName() will be available (ie will be in scope) from anywhere in your application. OK? Regards Ken Reay...
  9. KenReay

    INSERT INTO Date issue

    Hi no matter what the windows locale settings are for date format, in SQL statements date must be in "american" format or "yyyy/mm/dd" format as skip says: so DoCmd.RunSQL "INSERT INTO Timesheet (EngineerNo,ContractNumber,Chargeable,ChargeCodeNo,Hours,TimesheetDate,Rate)" _ & " VALUES (" &...
  10. KenReay

    Simple Question: Convert to Uppercase

    To answer your question mkallover. I would put the code in the after update event of the (textbox) CONTROL Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  11. KenReay

    maintaining record position after a requery

    Sorry should have said I am assuming Rs is the recordsetclone of the subform source recordset Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  12. KenReay

    maintaining record position after a requery

    Hi Does the underlying query (of the subform) have a unique key? If yes, why not save the key before the requery, then position back to it, if that is it is present in the filtered result set. I am assuming Rs is the recordsetclone of the rcordset. So something like this Dim lSavedKey as...
  13. KenReay

    RecordSet.Index and .Seek for multiple indexes?

    Yes You could do it as you are now with rs.edit etc, so long as the recordset returned by your SQL is an updatable recordset. You can also update via SQL of course, using UPDATE query and/or INSERT query Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  14. KenReay

    RecordSet.Index and .Seek for multiple indexes?

    Instead of usining index and seek, why not create your recordxset based on SQL with a WHERE clause to return on the rows which would be returned by the seek? Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  15. KenReay

    Use Multi-Selct List Box to Filter subform

    how about: me.frm_ListWellsByPad_subform.Requery that is assuming frm_ListWellsByPad_subform is the anme of the subform CONTROL Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  16. KenReay

    Linked tables & relationships

    Hi you put the "relationships" in the PostgreSQL 8.1 backend (or whatever backend you are using Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  17. KenReay

    Hidden Field Capture? - Is it Possible

    1. in table (design view) set the default value of the date column to Date(), in the Time Column set the default to Time(), if you have only one column, for date/time then set the default to Now() 2. see http://www.mvps.org/access/api/api0008.htm Regards Ken Reay Freelance Solutions Developer...
  18. KenReay

    Record Numbers

    sorry, my typing, should be If Me.RecordsetClone.recordcount > 1 Then Regards Ken Reay Freelance Solutions Developer Boldon Information Systems Ltd UK
  19. KenReay

    Record Numbers

    Hi OK, no problem In the oncurrent event of the form If me.recordsetclone.recordcount > 0 then me.recordsetclone.movelast me.recordsetclone.movefirst if me.recordsetclone > 1 then ' code here to make visible whatever else ' code here to hide it end if else ' code...
  20. KenReay

    Record Numbers

    Hi A recordset has a .recordcount property, which as its name suggests returns the number of records in the recordset. Be warning howver, the .recordcount is not accurtaley populated until the last record has been accessed, so it is usually necessary to execute a .movelast .movefirst before...

Part and Inventory Search

Back
Top