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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jyotko

  1. jyotko

    You don't have any linux partitions defined

    We can close out this thread. It was the hard drive. Thanks for the responses.
  2. jyotko

    You don't have any linux partitions defined

    I have installed Fedora Core 2 on an old Dell Pentium. It has been running for the past few days. When I got home it was giving me a repeated EXT3 FS error. I tried rebooting and it said there was no boot partition on /dev/hda2 - there was this morning... The error message also said that there...
  3. jyotko

    Command to list all users in a group

    I don't know of a command to list all users in a group. The following should work: grep groupname /etc/group if you are using a group file.
  4. jyotko

    CAN'T ACCESS SERVER VIA SERVER NAME

    Below is a copy of part of my smb.conf file on one of my machines. I'm guessing that you are laking about it being unreachable from Windows via Samba. You'll need to configure the Samba Server for an NT workgroup or domain, I use a workgroup and also assign it a netbios name. The netbios name is...
  5. jyotko

    Add a value every year to numeric field

    I think if you look at the right of '1460' you will see an extra ']'
  6. jyotko

    Query and data entry in a combo box

    Willie, You can do this by setting the form properties: AllowEdits = False AllowAdditions = True You may have to add an event property to the control such as below or have the user click the new record button on the navigation bar on the bottom of the form. Private Sub...
  7. jyotko

    Error on Combo box

    It may be a problem that you are having with an Antivirus program blocking the execution of scripts There is info at the Symantec site regarding this problem. If it isn't antivirus software that is causing the problem and you found the cause I am very interested in finding out what it is. I...
  8. jyotko

    Combo box and first record

    Is the following bit of code what you are looking for. I think you need to use the ListIndex method. Private Sub UserForm_Activate() With ComboBox1 .AddItem "Item 1" .AddItem "Item 2" .AddItem "Item 3" .AddItem "Item 4&quot...
  9. jyotko

    How can VBA change text box?

    That code should work to check wether the data is numeric or not. Keep in mind that if you are dealing with currency also, you usually won't have fractions of a penny so you may want to check for that also.
  10. jyotko

    How can VBA change text box?

    A textbox on a form is unaware of the type of data being entered therefore it won't know if you are entering text or numeric data (currency is just a variation on numeric data). You have to do data validation to ensure the data type is correct or you may be able to use the following...
  11. jyotko

    Custome Header in Excel

    Place this bit of code in the Workbook macro section. Whenever the report is printed it will print the current month and day. You could also prompt the user for the information with a more complex macro if you need more flexibility. Private Sub Workbook_BeforePrint(Cancel As Boolean)...
  12. jyotko

    OLE Server Error in Access

    I posted followups to the OnClick message. Norton antivirus can cause this problem. as far as adding code goes. I had code in the procedure and removed it line by line to see if the error would go away - it doesn't. The actual code would simply increment a number in another text box. It only...
  13. jyotko

    OLE Server Error in Access

    The expression OnChange you entered as the event property setting produced the following error: A problem occured while Microsoft Access was communicating with the OLE Server or ActiveX Control. * The expression may not result in the name of a macro, user defined function, or [Event Procedure]...
  14. jyotko

    Combobox selecting and deselecting items in listbox

    Have you tried using the clear method prior to repopulating? UserForm1.ListBox1.Clear
  15. jyotko

    Microsoft Word Fonts

    Which operating system is installed on this computer?

Part and Inventory Search

Back
Top