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

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

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

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

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

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

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

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