Search results for query: *

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

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

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

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

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

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

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

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

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 (" &...

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

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

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

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

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

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

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

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

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

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

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