Search results

Thanks a lot Neileg, I like the idea of the iserror() function that I didn't know which I am going to try just now. I just fought about an other possibility: The "parameter field" can only be equal to 2 differents values or have no record so I could create a function to Calculate The PARAMETER...

Well, the function is to be used as a new field in the query and therefore, give errors and values depending depending on the parameter field values . So, I don't think I could use the first method. When your saying to test a text box to see if it is an error, what do you mean? How would that work?

I am running a query with a field that can have or a values or no records. When the field has no record the field is blank. My problem is that I am using a function with that field as a parameter, when that field has no record the function return #Error, It is quite important that I get a "0"...

Yes, that's exactly it, I'd like to have a specific record displayed for f2 and sf1

Cheers Ken, It's still can't make it work but I get a blank form now. Do you think that the way I have referenced the txtbox in the subform seems to be correct? ie: StLinkCriteria2 = "Forms!FrmDrawingDetail!SFrmDrawingDetail.Form!TxtDrawingID=" & Me![DrawingID]

Hello, I am trying to find a way to open a form with a subform on a specific record (for the form and the subform), I came up with the following but keep getting a mismatch mistake which means me think I am not doing it right. What would be the apropriate way to achieve what I am trying to do...

Rural Guys, your suggestion is correct, if the first form is set to no locks as well as in the 2nd form. I can edit the data, I thought that by closing the "viewing Form" (with the property set to record locked )the the table wouldn't stay locked..was wrong...Thank you again rural guy.

Oh, yeah... Forms.FrmDrawingFile.SetFocus Docmd.Close I have added this 2 line after to see if it would still not work when the form for viewing the record was closed for the editing. The first form as the records locked to avoid any changes and the 2nd form as the record not locked to allow...

Hi rural guy, Here is the code for the button (I have used the wizzard) Private Sub CmdEditDrawing_Click() On Error GoTo Err_CmdEditDrawing_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "FrmEditDrawingFile" stLinkCriteria = "[DrawingFileID]=" &...

I have a problem with 1 of my form (FrmEditDrawing) that I use to edit a specific record from 1 of my table (TblDrawing). The user will see the Data for each drawing on a form that I called (FrmViewDrawing) and will be able to edit the data for each drawing by clicking a button that will open...

Hi Everybody, I am trying to delete a record on a Single Form, then Close that Form and then requery an other form that should be already open. The Code I wrote doesn't seem to work, the code is interrupted before the command Close? What would be the correct way to write the code? Private Sub...

Here is a snapshot of the form .

Thanks for your replies, I understand what you are saying. My situation is a bit more complex though, the Continuous form is already a subForm: The main form is an enquiry form which shows all the different drawing for that enquiry. The subform ( the continuous form ) is linked to an "enquiry...

Well, it's a bit complicated to explain but I'll try: I have drawings for various item and each item can have 1 to 30 drawings. I Wanted to use the continuous form to select a specific drawing: 1)You select the item 2)You select the drawing Then you can add command button in the continuous form...

Hi everybody, In a continuous form, If I use a comboboxe with a criteria looking up a field in the same record, it seems that the combo boxe only looks up the value of the firsrecord, Iam not sure I understand why? I was wondering if it there was any method to be able to use Cascading combo boxe...

Solved... I got the code to work using DAO Dim rstCount1 As DAO.Recordset Dim rstCount2 As DAO.Recordset Set rstCount1 = Form_SfrmPattern.RecordsetClone Set rstCount2 = Form_SfrmPattern2.RecordsetClone If rstCount1.RecordCount = 0 Then SfrmPattern.Visible = False Else SfrmPattern.Visible =...

Thanks a lot Allan, It is working if I change some of the references in the library but now a different kind of problem which is kind of puzzling occurs. To get the form to work I need to desactivate the "Microsoft Access activeXData Object 2.1 Library" but then, bits of code use with other...

I have copied all the Concerned form in a new database file: here is the file,

'Set rst1 = Form_SfrmPattern.RecordsetClone'

Indeed 'Has Module' was set to no, i've changed it to yes and I get a msmatch error now.