Search results

  1. P

    Run another application after Access exit

    YES, I agree, this is exactly what I need!:) Please could you publish here an example how detect process ending via Windows Scripting Host? Thanks
  2. P

    Run another application after Access exit

    THANKS, it sounds like VERY good advise. I never use Windows Scripting, but I will study fast. First, could you suggest me some start points links (except microsoft.com, I just see)? Second, what you mean "on the fly"? As I understand for Windows Scripting must script files (VBS, JS) exist...
  3. P

    Run another application after Access exit

    Better way? Thanks, it is one possibility, but I prefere "for user invisible" solution something like "asynchronous shell". Somewhere inside API it must exists, because many install programs use this feature...
  4. P

    Run another application after Access exit

    I need run another application after Access exit. Another application must start just after Access exit, but not before! Any ideas? THANKS
  5. P

    SQL Server record key

    1) If you working with ADO (Access project), new record will be current after save. 2) If you working with DAO, new record can be access as bookmark via LastModified recordset properties 3) @@Identity is related to session (i.e. connection) so you can use it freely in multiuser enviroment. See...
  6. P

    How to browse sorted/filtered ADO recordset?

    Thanks for answer, but I disagree, there isn’t relation database concept trouble! This is MS Access GUI (especially form control) problem! Access itself displays sorted records but don’t offer them for programmers. In datasheet form you may browse sorted records i. e. via arrow keys, very...
  7. P

    Create Controls Real-Time

    Every Access form can be displayed in three basic views. Single form, Continuous form and Datasheet. See properties DefaultView and ViewsAllowed or in form design view pop-up option next to View mode (first from left) button. I suggest you create table i.e.: QuestBase(id, condition, operator...
  8. P

    Create Controls Real-Time

    Search help for CreateControl and CreateReportControl These methods realy work, but total number (index, count) of inserted controls is low (about 1024) per form. When you delete unused control counter doesn't decrease (stays same) :cool: I suggest countinuous form instead...
  9. P

    How to browse sorted/filtered ADO recordset?

    Hi ALL! I have Access 2000 ADO project (backend MS SQL server 2K) with form in datasheet view based on stored view. For some reasons I need know primary index of next and previous record related to current record. I used RecordsetClone with MoveNext and MovePrevious methods. Solution works well...
Back
Top Bottom