Search results

Hi Wayne, I did not think about the DLookUp method before you mentioned it. Maybe you can take a look at my form and give me your 2 cents worth. If the user types in something that can't be found in the database, there will be a form prompted for them to add the item to the database first...

The combobox consists description of all the items in the table. Users are able to add new records to the table through input into the combobox as well. That is why I have to let users fill up comboboxes by typing in. I think the maximum size is 50 chars and that's not a lot. :(

How abt subforms?

I entered around 230 words in my combobox and it says that I have entered too many characters. Why is that so?

What is the maximum no. of characters allowed in a combobox?

How do I set the Orderbyproperty in the OpenReport method?

I set the form's property to be Edited Record. The write conflict message is no longer prompted. Thanks for everyone's time :D

It displays the fields on the report now, but there's a write conflict when I click the cmdbutton. It says that the record has been saved and I will be saving it again. How can I get rid of that messagebox?

I have a purchase order form that has a subform embedded. After users have filled up the form, they click on a button that will open up a print preview of a report. The report shows the details of the form they entered. However, all the fields on the parent form that are filled up after filling...

How do I let users choose the way they want to sort their reports through a form dynamically?

Thanks for your reply but one problem though, Im using Access97 and I cant open your db. Could you convert it for me?

I have a combobox that has a rowsource based on two fields, ItemCode and ItemDesc, in respective order. The combobox has its Limit to List property set to No and its bound to ItemCode. Filling up the combobox will fill up other fields such as UnitPrice and UOM. The problem that I face is when...

Yeah that's what I have in mind but sad to say, I don't know what to code to catch the error. Could someone guide me in this? :eek:

I have thought of a possible problem and that is when the user doesn't know whether the item they are going to type is new. They will proceed to type it in the combobox thinking this is an existing item in the table and the error will then occur. I have attached a sample db for you to try it...

I have four fields, ItemDesc, ItemCode, UnitPrice and UnitofMeasure(UOM). ItemDesc is a combobox and the rest r textfields. When the user types in ItemDesc and there's such an item in tblItemMaster, it will automatically fill up ItemCode, UnitPrice and UOM. However, I have a problem if the user...

I want to create fields that are in the form IC0000001, IC0000002, etc. I can do the increment in the numbers by using the dmax function but how do I add the alphabets before it? How can I start with 0000001 instead of 1? Any help would be greatly appreciated, thanks so much! Swee

Hey all, I was wondering if anyone has an example of a system documentation that could be shared. I'm about to start writing one myself and I'm not sure what to include in the documentation. Thanks in advance! Regards, Swee

Thanks guys. Got it working using the OpenForm method.

All my records are displayed on a form. Upon clicking on their respective 'View' button, I would like to open that particular record. How can I do that? I have attached a screenshot for better clarity. Thanks in advance for the help! Regards, Swee

I have created an xls and its the same format as the table in my db. Same column name and same data type. However, when I try to import the xls to an existing table in my db, there was an error message that says, "An error occurred while trying to import file 'C:\MyDocuments\POSystem_Book.xls'...