Search results for query: *

Thank you very much for the reply. I will try the way like handling the "awarding stars". Thanks kaht and I will remember to give a star to those helping me from now on. ;-)

Hi, I have a pop-up, which gets user information and insert a record after user input values in the pop-up and click the "Add Record" button. I wrote the code like this: document.form1.submit(); self.close(); I find that sometimes the user cannot insert record while sometimes it works fine...

My code is like this: Function printrpt() DoCmd.OpenReport "RptA", acViewNormal, "", "" Application.Quit End Function I would like to schedule this module to be executed every morning. After printing the report, it close the Access also. Because the code works fine for first months...

Hi, I have scheduled a Access 2003 report to be printed every morning (using Windows schedule task), on a Windows 2003 server. It has been work fine for few months but I got the "Error 2501 The OpenReport action was canceled" yesterday. I use DoCmd.OpenReport "RptA", acViewNormal, "", ""...

Hi, I need to import data from Access to Excel like this: month item qty month item qty --------------------------------------------------------- 2005 01 item1 10 2005 02 item1 2 2005 01 item2 5 2005 02 item2 3 2005 01 item3 2 I would like...

I have build a webpage using ASP with Access database on IIS, Windows 2003 Server. I connect the database using the code: oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("a.mdb") & ";Persist Security Info=False" I also set LockType of recordset to adLockReadOnly...

Thanks! I know Access is not good for handling multi user, but due to the budget, I have to use it..[sad] I have nearly 200 items in my database item list... The 10 items will be read from user's input, varify all of them to make sure the 10 items and the inputted quantity are valid, and then...

Hi, I have a form that allow user to input 10 items and request quantity. I need to validate all the 10 items to make sure that the 10 items are exist in the database, and I need to notify the user for which item that are not valid. Do I need to loop through all the 10 items, submitting the...

Thanks! I have try that to reset the page number. But I don't know how to get the total number of page for each customer...

Hi, I would like to show the page number in each page of the report. The report has a group, customer. I would like to show the page number in the format of =Page " & [Page] & " of " & [Pages]. I can reset the page number in group but I don't know how to retrieve the total number of pages...

I need to use the same name for all checkbox because I need to get the qty fields in ASP code by using the code: For Each Item In Request.Form("C") ...... Just don't know how to make it work.....

Thanks! But can I have the same name for all checkbox but with different values? I mean: <input type="checkbox" name="C" value="1" onclick="myfunction('2');"><input type="text" name="T2" size="20"><br> <input type="checkbox" name="C" value="2" onclick="myfunction('3');"><input type="text"...

Hi, I have a form that is dynamically generated from the db like this: item1 checkbox1 qty1 item2 checkbox2 qty2 item3 checkbox3 qty3 I have to verify the qty fields to ensure they are positive integer only when the corresponding checkbox checked. For example, if checkbox1 has...

Hi, Can I prevent sharing the session between the browser opened by the window.open script? I mean if the user has login in the first window. If he opens the second browser, he has to login again in order to access the restricted page. Any work around for this problem? To include parameters...

If I have a excel table like this: A C O D D E 1 2 3 4 6 5 And I would like to sort the table like this (sort by first row): A C D D E O 1 2 4 6 5 3 How to sort the column in this way? Or I have to "reverse" the table first? How? Thanks!

In Outlook 2000, is there a way to check the storage limit of mailbox on Exchange server? Thanks!

Thanks VBslammer.. But does it means that I can put all the sql statements in the strSQL variable? Because I have 3 sql statements, which cannot to be combined into one.....

Hi, I have several sql statement(to insert, delete records in different tables) which are run by the docmd.runsql command. Is it possible to implement transaction to all statement? Like this: begin tran docmd.runsql 'insert record to tableA docmd.runsql 'delete record to tableB ... end tran...

Hi, I would like to prevent user from entering any text into the combo box. They can just select one of the items in it. I have use the "Limit to list" property to Yes. But user still can enter text in the text box, although there will be error message if the user try save the record. If...

Hi, I would like to export data from a Access Table to Excel. I do try some code to export the data, but I can't open the Excel file immediately for user to preview. How to let the user to view the Excel file immediately after exporting the data? Can I specified the starting cell and...