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 SkipVought 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: softlover
  • Order by date
  1. softlover

    File system full problem in the HP UX.

    After copy some new files to HDD and then reboot. After login in the Hp Ux system prompt "file system full" and logout. Try to frecover the system under single user mode but the system also alarm "failed write to xxxxx file" when execute the restoring process. All temporary files under /tmp and...
  2. softlover

    How to get the cursor position on user form in EXCEL VBA?

    Thanks to all. The Exit event solve the problem.
  3. softlover

    How to get the cursor position on user form in EXCEL VBA?

    Sorry for my poor expression. Thanks to Fumei that his explaination is exact in below. "Let me see if I understand this. You have ten commandbuttons. Each commandbutton has a caption ("0", "1", "2"...etc.). When any given button is clicked, its Caption ("0", "1", "2"...etc.) is put in as...
  4. softlover

    How to get the cursor position on user form in EXCEL VBA?

    What I means input number by "soft keyboard" is that I made ten numeric CommandButton which defined caption from "0" to "9" and when press any numeric CommandButton then input the caption as number to the TextBox which cursor located. The Selstart, SelLength and SelText properties of the...
  5. softlover

    How to get the cursor position on user form in EXCEL VBA?

    I made a user form in EXCEL VBA. and I want to input number to some TextBox by "soft keyboard". But before input the number I should get the position where the cursor is. Anyone know the codes to locate the cursor?
  6. softlover

    optionbutton problem

    What I want to see is when I click one of any optionbuttion in the frame the caption information displayed to show which one selected. When click another one then display the caption of another optionbutton. It seems simple but I failed with codes for Frame_Click or Frame_Enter event. I know...
  7. softlover

    optionbutton problem

    In EXCEL userform I put some OptionButtons in a Frame, then I select one of the OptionButtons and want return the Caption of the selected OptionButton. Private Sub MyFrame_Enter() Dim objControl As Control For Each objControl In MyFrame.Controls If objControl.Value = True Then...
  8. softlover

    Access db VERY slow to load using desktop shortcut

    After connected to office network, your pc will do the following jobs. 1. Check the netcard status and test the configuration. 2. Lookup DHCP server and IP address. 3. Configure the shared folders and printers in your pc. 4. Connect to the mapped drives. 5. Connect to internet to auto-update...
  9. softlover

    Use Like "*" in Module to create Filter Variable for recordset

    If you use it in vba code for query, Please try this, "WHERE DirectorID Like " & chr(34) & "*" & Eval("[Forms]![frmDirectorsTotals]![cboxdirector].column(0)") & chr(34)
  10. softlover

    Access db VERY slow to load using desktop shortcut

    I met the same problem after install the new anti-virus software. So maybe the anti-virus software get the bad performance for all office applications.
  11. softlover

    chat with any user within lan.

    Notice: All the application are under Microsoft Office Access 2000 and further version. I make a share-used database(mdb or mde format) and put it on the server. In the user application can display all the users linked to the parent database. The share-used database (parent database) need...
  12. softlover

    Automatic update database problem.

    Hi, lidias13, The following codes run ok under ACCESS2K on my PC. 'Get the Server Update Information and date Set MyWsp = DBEngine.Workspaces(0) Set MyDb = MyWsp.OpenDatabase(ServerFolder & "Update_Inform.mdb", False, False) Set MyRst = MyDb.OpenRecordset("SELECT UpdateDate.* FROM...
  13. softlover

    Automatic update database problem.

    I find another way: Open the database "TEST.mdb" normally and check if there is an update on the server. if there is then create the batch file "update.bat" as below. @echo off :WaitFin rem if the current mdb file not closed then loop. if exist Current_Database_Folder\TEST.ldb goto WaitFin rem...
  14. softlover

    Automatic update database problem.

    I met a same problem as described in thread705-1067773. I open my current mdb file (C:\TEST.mde) and check it with new version mdb file on the network. If it neet update then creat a batch file which includes the "COPY \\server\TEST.mde C:\TEST.mde /Y" command. Now I want to close the current...
  15. softlover

    Can't set recordset to a SubForm.

    Thanks to RoyVidar. I tried the following codes and work fine. Me.SubForm.Form.Recordset = MyRst
  16. softlover

    Can't set recordset to a SubForm.

    I tried the codes likes below. Set [Forms]![FrmMain]![FrmSub].Form.Recordset = MyRst But it also doesn't work.
  17. softlover

    Can't set recordset to a SubForm.

    I want to set recordset for a subform in a mainform. I tried the codes likes below. Set [Forms]![FrmMain]![FrmSub].Recordset = MyRst But it doesn't work.
  18. softlover

    Copy table between two database files.

    Thanks to TheAceMan1, But the "Docmd.TransferDatabase" command make the same result as "Docmd.CopyObject".
  19. softlover

    Copy table between two database files.

    Now I have three database files: file1.mdb,file2.mdb,file3.mdb I need file1.mdb opened and copy tables from file2.mdb to file3.mdb. I know the command "DoCmd.CopyObject" can copy current table objects (in opened database file1.mdb) to another database. But I don't know the way to copy objects...
  20. softlover

    Can't start the files in folder "C:\My Documents\"

    Just now, I find the correct codes: Call Shell(Environ("COMSPEC") & " /C START EXCEL C:\My Documents\AAA.XLS", vbHide) Thanks to all.

Part and Inventory Search

Back
Top