Search results for query: *

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

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?

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

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

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

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.

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

I want to execute any file in the folder "C:\My Documents\" by the codes below. Call Shell(Environ("COMSPEC") & " /C START C:\My Documents\" & FileName, vbHide) But failed with following message: System can't find the object "C:\My". I think the blank character in the "C:\My Documents\" string...

In ACCESS2000 VBA, I need to change the shortcut icon of a MDB file on the desktop with codes.

I want to create shortcut for a file and put it on the desktop. The codes need run under ACCESS2000.

I want use the micor_sheet in the EXCEL sheet.

I know the way to copy a table from current database to an external database. Here is the syntax, DoCmd.CopyObject [destinationdatabase][, newname][, sourceobjecttype][, sourceobjectname] Now I want to copy a table from external to current.

I want to set the format of the centerfooter from "Page 0001" to "Page xxxx" in EXCEL2000. And I use the following codes. With ActiveSheet.PageSetup .CenterFooter = Right$("000" & "&P", 4) End With But the result is not good. Before ten pages the centerfooter were "00x" ("x" means "1" to...

I used to set the recordset of a report with codes below. Set Me.Recordset = MyRst But failed. Anyone help me with it and give me more codes.

In Access 2000, I use continuous form to display the records for anyone can see the relative data. The form were protected with all the records locked when the form opened. But on the TOOLBAR, anyone still can use "EDIT" - > "DELETE RECORDS" to delete the current records which cursor on it. How...

I want to protect some form under ACCESS2K and need input password to access the secret form. So I use codes: InputBox("Please Input Password:") But the input window will display the actual characters and anyone will know the password. Can any codes to change the input characters to "*" at the...

I use Application.FileSearch codes to find a file in any folder. But the result isn't exactly. See following codes. With Application.FileSearch .LookIn = StrDirName .filename = StrFileName If .Execute() <= 0 Then SeekFilesInDir = False Exit Function End If...

In a form I need the number in a text-box increase/decrease it's value continuously when the Command1 or the Command2 button are pressed. I had try the Command1_MouseDown event but the number can change after every mouse-click. I had to click and click to increase/decrease the number. Below is...

I want to print a report to the printer directly. but the following codes can't fit it. Docmd.OpenReport "MyReportName", AcNormal Anyone help me.

I want to define the columnwidth of any column in EXCEL sheet with ACCESS2K VBA. Before do that, i had got the width value with codes: ColumnWidth = xlBook.Sheets(1).Columns(1).Width but the following codes can't work when redefine the newone. xlBook.Sheets(1).Columns(2).Width = ColumnWidth