Search results

Hi, I've lost touch of Access few years back & now I'm back again using Access... kinda rusty & yet rushing for a proj... so I'll very much appreciate if someone can help me on this..... :) I've a database storing inventory details & after adding these details, i'm supposed to have another...

Thanks a lot...I'll go try it out..... :)

I have a simple database asking user to enter eg. P/2222/1234F. After every record is added, I'll clear the txtbox. However, when user uses the mouse to click on the txtbox (with input mask) to input the data, err msg will pop up and if user uses keyboard (Enter key or arrow key) instead of the...

thanks a lot...i'll go try it out......i realli do appreciate that.....:)

Hi, may I know how do I retrieve report by month? I have an unique id for every roll, eg, 20020809/85, 0809 will be 9th of august. How do I prompt user to enter the month and to churn out data according to the month that the user had entered? Its been a long time since I touched access.

Hi Y do i always get this msg "The openreport action was canceled?"

I have a table that looks like this : Date Type Amt 07/11/00 f 100 07/11/00 c 200 20/11/00 f 200 21/11/00 c 250 07/12/00 c 350 09/12/00 c 480 10/12/00 f 300 I’ll be adding a record with Date : 11/12/00, Type : c and Amt : 100 from a form. However, I need to add up the Amt with...

The problem is resolved, Thanks anyway. I think I make a silly mistake

Hi..anyone here knows how to solve this "ActiveX Component Cannot Create Obj"? I've actually tried to go to the microsoft website and have followed the instructions to register the DAO, and it said DAO has been registered successfully, however this "ActiveX" Problem still remains.... What can I...

Hi..anyone here knows how to solve this "ActiveX Component Cannot Create Obj"? I've actually tried to go to the microsoft website and have followed the instructions to register the DAO, and it said DAO has been registered successfully, however this "ActiveX" Problem still remains.... What can I...

Hi Thanks for the solution... I think I understand what you said.. I have another question here regarding the leading zeros. If I want the length to be 12 and to append the zeros infront of the number, can I just use the Format function but specify in the table that this field to be 12 digits?

Hi.. Anyone here knows if there's any way that u can fixed the number of spaces between each field?Otherwise the other application will not be able to read in the actual data. Thanks

Thanks guys... It works...

I have a problem in some validation, that is I need to validate a string of 3 characters with no numeric values and I actually used the IsNumeric Function, however, it is true only when I enter only numbers and if I enter "12f", it returns false. How can I make it return True? any other function...

I've got this problem whenever I on my pc and started running my access database. It would give me an error message "ActiveX Can't Create Object". I always have to create a new database, open it and close it and then return back to my previous access database otherwise it will not work. Is there...

How do I search and import or link files using Modules or Macro? I have to prompt the user to enter the pathnames for the 2 files in a input box instead of using the Import and Linked Tables function. I really hope that u guys can help me with it ...thanks Your help is greatly appreciated

Hi everybody!Currently, I'm doing a program with access to import 2 files and to compare them and print out the difference as well as exporting them back.However, I'm new to Access with no experience at all.I would like to know where and how do I start from? Do I need to use modules and VBA?Does...