Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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