Search results

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

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?

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

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

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

I have the following code in the click event of my button, Dim strCriteria As String strCriteria = "[1stApproval]='-1'" DoCmd.OpenForm "FrmLookupRecords", acNormal, , strCriteria However when I click the button, there was an error that says, What does this error mean? I want to open a form...

I have copied a copy of my system onto a user's computer to start using the system. However, when the user tries to open the system, all of my forms that use Date() come up with some error. Then it goes on to show me an error message saying "VeenLR3.hlp can't be found". That's actually a help...

Hi all, I have a purchase order form that has a checkbox to determine if it has been approved. If it has been approved, btnApprove and btnReject are hidden and if not, they are shown. However, subsequent unapproved records after the first approved record do not show out the two buttons as they...

Hi all, I would like to create a simple login system for my db whereby users differentiated by approvers (people who approve PO forms) or preparers (people who prepare PO forms). The problem is, I do not know where to carry on after creating the form for login. How do I go about doing it? I...

Hi all, When I try to filter my report through input into a form, I get a pop up box that says "Enter parameter value" when I click on the button to filter the report. Has anyone experienced this before? Regards, Swee

I have a data entry form. Let's say I have filled up all the required fields in the main and sub form, and then I decide not to save the form. I want to have a button that upon clicking, will discard all the data on the form and not save it in the tables. How do I write the required code...

I'm trying to check if a control on the subform is null. I've the following line of code: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Form!FrmOrderInfoMain!SubFrmOrderInfo.ItemCode) Then Msgbox "Empty ItemCode" End If End Sub ..whereby FrmOrderInfoMain is the...

I have a report based on a form and when I view the report in print preview, part of it has been truncated. I have attached a screenshot of it. Is there a better way for me to print the form other than as a report? If not, how do I show the entire report without leaving out any part of it...

When I click on my subform after entering some data in the primary form, I get this error message: "The Microsoft Jet database engine can't find a record in the table <name> with key matching field(s) <name>. (Error 3101)" This is because I have not filled in a ItemCode, a combobox, on the...

I have a combobox that sets a textfield PONumber by using the dmax() function. They are both on the parent form. The parent form and the subform is linked by PONumber. The problem is like this: I click on the subform and click back on the parent form again. If I choose the same option in the...

Report not displaying all records Not all my records are being displayed on my report. Only OutletB is being displayed and OutletA's records are not visible at all. Attached is my sample db. Note: Report generally shows all the purchase orders whereas mainForm_Report shows the records based on...