Getting Started
in [Access]
|
DoCmd.Save Error I recently converted an Access 97 Application to Access 2003. When I use this forms combo box, I get the f ollowing error in a dialog box "RUN TIME ERROR 2501 the save action was cancelled", when I update the combo box for which the beforeUpdate Code is below, the debugger screen goes directly to the line ab... 6 Jul 2006 05:49
Split cells Hello everyone, how can split cells, for example from B24 to B67 vertically in 2 parts? thanks ... 4 Jul 2006 05:46
Space Removing spaces between text i would like to run update query to remove all spaces leaving 1 as in excell with the Trim Formula how do i ... 4 Jun 2006 07:21
USAGE OF VLOOKUP FORMULA if i have two different worksheet and i would like to know if there are items of each worsheet that has the same information. e.g. both worksheet have an item with a similar name how can i do that using a formula? ... 5 May 2006 04:06
Primary keys dear community can anybody let me know where can I find examples of a table with more than 1 primary key declared and how and when can I use more than 1 primary key in the data table ? thanks for helping. -- oldLearner57 ... 3 May 2006 15:47
Convert date into text Could someone please explain how to convert a date back into text. As in 31/03/06 to 20060331. Thanks ... 28 Apr 2006 12:27
Form window How does one make sure that a query result table opens at maximum window size, or at least at the size that maximizes the contents? One of my tables insists on opening at a minimum size. I use a form to display the query results. ... 27 Apr 2006 13:01
Excell functions. How do I keep a running total of columns and rows? For example I don't want to be stuck only with =SUM(A1:A4) which will only add the 4, but keep it open to infinity if needed. I have a small business and I am trying to make an accounting ledger of debits and credits. ... 15 Apr 2006 12:18 |