Search results

Thanks Paul. Didn't think of that one. ;)

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

Thanks, found what I wanted. Phew.

Yes its an A97 database. The user is using A97 as well. Have you any ideas?

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

Thanks dude. Got it working now. XD

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

I think I get the point. Looks like it's not viable to work in that direction. I'll make some adjustments to the design of my system. Thanks for everybody's time. Cheers, Swee

Tried that and it doesn't work still. Uploaded a small db of mine for you to understand what the problem is like. FrmFilterAccCode is the form for you to enter the field to filter and RptLookupRecords is supposed to display the related results. The Acc Code can be found in the subreport of...

I think it might be my code that could be the problem. Dim strACCode As String Dim strFilter As String ' Build criteria string for A/C Code field If IsNull(Me.txtAccCode) Then strACCode = "Like '*'" Else strACCode = "='" & Me.txtAccCode & "'" ' "='" &...

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

Thanks for the feedback and suggestions. I added a button and on its click event, i added the following code: strSQL = " DELETE *" & _ " FROM tblName" & _ " WHERE CritieriaField = '" & Me.txtCriteriaField& "'" CurrentDb.Execute strSQL...

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 think i get what u mean Pat. That was an error on my part. I meant to put the code in the BeforeUpdate event of the subform itself. Thanks for the advice.

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

Thanks Steve! You just helped me sleep better tonight :D That had been bugging me for days and I've been trying all sorts of methods but to no avail.

Hi, I've attached a small db for you guys to experiment with and hopefully, understand my problem better. 1. Open FrmOrderInfoMain 2. Choose an outlet from the Brand combobox. 3. Click on the subform. At this point, you will get an error message. Grateful and appreciative of any input. Thanks!

Does anyone have any ideas?

Thanks mdemarte. But I came across another way to achieve that. Under the properties of the Detail Section of the report, I selected Before Section for the Force New Page option. It works fine too. Thanks all again!