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
  • Content: Threads
  • 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, I have got a run-time error here. It said as follows "Execution of this application has stopped due to a run-time error. The application can't continue and will be shut down." That's all there is for the error message. I'm not sure if it's to do with runcommand thing that i put into the...
  5. 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
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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
  12. 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...
  13. 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...
  14. ahau

    writing formula into the spreadsheet

    Hi, I was wondering if anyone might be able to help me on this. I would like to be able to read data from one file (e.g. .csv file) and write to another spreadsheet as well as being able to put in some formula into the field. My problem here is for example in that csv file, there are some...
  15. ahau

    "permission denied"

    Hi, I don't know why i'm getting error message "Permission denied" when running the following code. Sub CreateAfile Set fs = CreateObject("Scripting.FileSystemObject") Set a = fs.CreateTextFile("c:\testfile.csv", True) a.WriteLine("This is a test.") a.Close End Sub what i'd...
  16. ahau

    got error when assigning value

    Hi, I've got a table that has fields as follows studentID, ..., 2005/6, 2006/7, and so on. My question is if i know the studentID but i don't know whether it'd be 2005/6 or 2006/7 because it's based on the current year and i want to make it flexible enough. I've got the following code...
  17. ahau

    Help with access report

    Hi, I was wondering if anyone might be able to help me here. I have a form that has a button called export to excel. I have tried to export report to excel and it works. However, i've been asked to produce an excel file that looks like that in the report in the access. Because in the report...
  18. ahau

    export to excel

    Hi, I have a form that has a button to export access report to excel. I've got that button working. It creates an excel file based on the access report. However, i want to do something more. In the form, i also have a listbox showing records filtered by a couple of comboboxes. So what i would...
  19. ahau

    chose print/page setup

    Hi, I was wondering if anyone might be able to help me. I have a form and it has listbox displaying a certain number of records and it also has a button "Print All". What this button does is it would print to the report whatever on the listbox. My question here is because i'd like to let user...
  20. ahau

    Issue with mousewheel

    Hi, I have a question in regards to the mousewheelonoff. I've the code from the internet and it works fine. The mousewheel can be set off or on. Great. However, it has to have the mousehook.dll sitting on the same folder as the database. My question is is there any way of incorporating this dll...

Part and Inventory Search

Back
Top