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!

Register Log in
  • Congratulations derfloh 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: ahau
  • Order by date
  1. ahau

    help with run-time error

    Hi, would anyone be able to tell me how to run the access database in the run-time environment? I have a client who can only operate the access in the run-time environment. I created the database using access 2003 and sent it to them for them to use. And now they said they got a run-time...
  2. ahau

    need vbscript to activate Filezilla

    Hi, I was wondering if anyone might be able to help me. I have set up Filezilla FTP here and like to schedule it so that it would run automatically at the set time. I know how to schedule it using the windows schedule task however, i got trouble here because since it needs to know the address...
  3. ahau

    set up LDAP server

    Hi, I was wondering if anyone might be able to help me. I'd like to set up LDAP server on windows XP. I found phpldapadmin but couldn't get it to work. I'd like to try out a different one but to no avail. Is there any that allows an easy setup and configuration? Thank you in advance
    • ahau
    • Thread
    • Replies: 0
    • Forum: TCP/IP
  4. ahau

    run-time error

    Hi MajP, I have checked the code once again and i realise that i actually do have the on error statement on the top. Here is the code. On Error Resume Next If PS_ID > 0 Then DoEvents stDocName = "Plan Summary" stLinkCriteria = "[PS_ID]=" & PS_ID 'Set Filter DoCmd.OpenReport...
  5. ahau

    run-time error

    Thank you MajP and Rjoubert for your support. Rjoubert, I can replace the runcommand with docmd.open ..., however it won't allow the user to select a printer they want. In another words, it doesn't bring up the printer dialog windows which is what the user wants. MajP, yes, you're right i...
  6. ahau

    Adding printer problem

    Hi Markdmac, Thank you for your support. The reason i'm reluctant to run the wizard to connect the computer to the domain is simply i don't want to stuff up the computer. It's not mine but one of my colleagues. It's got a lot of software programs and cable modem utility installed and run on...
  7. ahau

    run-time error

    ...customer(custID, CustFName, CustLName, ...) cb1 filters custID, cb2 for CustFName and so on. So that when a user comes along, he can type in "2*" in the cb1 and it lists out all the record starting from 2 on the list_box. The codes here are very simple, no runcommand or stuff like that...
  8. ahau

    File dialog - save as

    Hi MajP, Thank you for your reply. Yes, i found them.
  9. ahau

    File dialog - save as

    Hi, I was hoping if anyone might be able to direct me to a source where i can find some VB codes that pops out file dialog windows for user to get a file name and save as that filename in any directory they want in Access 2003. Thank you in advance
  10. ahau

    Adding printer problem

    Hi, I have another issue with adding a printer to a computer that's not yet connected to the server. This is what happens. For example, I have 2 computers, one is called comp1 and the other called comp2. The comp1 is connected to the server SBS but comp2 is not yet. A printer is connected...
  11. ahau

    server re-started??

    Hi Markdmac, Thank you for your support. I checked it and it restarted at 3:18:58 AM. Yes, you're right. I think it's the automatic update. Thank you
  12. ahau

    server re-started??

    Hi, I was wondering if anyone might be able to help me. I've got an email from the server saying it restarted. I didn't plan for this. I think it happened in the middle of the night. I was hoping if anyone might be able to tell me why it re-started itself. Anyway, i got the following critical...
  13. ahau

    disable the compact database

    Hi, I was wondering if anyone might be able to help me. I have a database that would compact just before it closes the application. However, i have decided not to use it anymore so i commented it all out the code. However, it still does compacting whenever it closes the access application...
  14. ahau

    help with SQL query

    Hi I was wondering if anyone might be able to help me. I was trying to calculate for the gross payment by adding up the sum of net_pay and the sum of tax_pay. I've got the following error message runtime error '-2147217900 (80040e14)' Syntax error in FROM clause when trying to run the...
  15. ahau

    can't browse file

    Thank you Linney for your reply. That's a really good information i can use in the future.
  16. ahau

    can't browse file

    Hi, I was wondering if anyone might be able to help me. It happen when i was in a word document or excel or any applications and was trying to open another document by going file - open, then the open file dialog pops up, then i clicked on "Look in" the combobox, it took about 20 seconds...
  17. ahau

    Hide worksheets in VB

    Hi, How do i hide a worksheets in excel using VB?. I wrote a code but it didn't work . worksheets("Sheet2").entirecolumn.hide = true Thank you in advance
  18. ahau

    can't show records in the listbox

    Hi, I was wondering if anyone might be able to help me here. In a table, i have the following data. ID ProjectName NA_ID NA_Site_ID 1 Team30 3000 2 Microscope Team31 3000 Then, in a form, i have a listbox that displays everything from...
  19. ahau

    insert a new line using VB

    Hi, I was wondering if anyone might be able to help me here. How do i insert a new row in excel worksheets using VB? For example, in the worksheets "Data", i have the following data as follows A B C 1 Merchandise 500 300 2 02-000 300 400 3 Total...
  20. ahau

    writing formula into the spreadsheet

    Hi Combo, Thank you for your reply. However, i need to know if there is some tips out there that can help me write VB codes to open a CSV file and write its content line by line or cells by cells to another spreadsheet. I'd really appreciate your help as this is my first time writing codes in...

Part and Inventory Search

Back
Top