Search results

Hi Maybe I didn't explain this very good. What I am trying to do is in a subform in Datasheet view upon going back to the main form is checking if I had missed filling in a text box. If any fields are missing Go back to the first Missed field. If there is no missed feilds do nothing. I have...

Hi I have a Subform within a form both in datasheet view. I want to put a code behind it when I click on the Hiearcy + button to close. It seems that the form in data sht view is not closed or unloaded or deactivated but just hidden in this datasheet view or something and my code will not run...

Hi, I tried that and I recieved a Message error invalid string Thanks

Thanks That is exactly what I was looking to do. I would have never thought to use this. Bryyan

Hi, In my table I want to put a default value of 1/4". Is there a way to do this I have tried "1/4"", '1/4"'. It seems it will not let me use the " symbol for inches. Thanks Bryyan

Hi, I was using Dwayne Hookam Concatenate function I was trying to Concatenate 2 different Tables but I am not sure of the Syntax TestClosure: Concatenate("SELECT DISTINCT [Nde(ClosureWeld) tbl].[ClosureWeldNo] & " * " & [FWelds tbl].[WeldNo] FROM [FWelds tbl] , [Nde(ClosureWeld) tbl]...

Hi Steve, In my Table I have the RtgNo as a Text Data Type.

Hi Steve, I tried this and I still get the error Data Mismatch - NextRtgNo: "Rtg-" & Format(Max(Val(Mid([RtgNo],5)))+1,"000") I tried this way with out the Val and it said Invalid Syntax or inclose your text data in quotes - NextRtgNo: "Rtg-" & Format(Max(Mid([RtgNo],5)))+1,"000") Thanks BBryan

Hi Steve, Sorry I didn't get back to you yesterday I had to do something and then it was home time I changed my Qy a bit to NextRtgNo: "Rtg-" & Max(Format(Mid([RtgNo],5),"000"))+1 which works fine But if i put the Val into this NextRtgNo: "Rtg-" & Max(Format(Val(Mid([RtgNo],5),"000"))+1 An...

Hi Steve, Thanks for your help I put this in a query NextRtgNo: "Rtg-" & Format(Right([RtgNo],2)+1,"00") Which now gives me the next number I need and I am using this for my DlookUp THanks for your help BBryan

Hi Steve I just tried that and An error says Complile error Augment not optional comes up yellow on the Right Me.RtgNo = "Rtg-" & Format(Val(Right(Me.LastRtgNo)) + 1, "00")

Hi Steve Thanks for help I will try to word this better I see that +1 is to add 1 to a number. I want to add the next seqence number in the text data feild and that is where i think I have the wrong syntax. No the next number would start as Rtg-05, the Next Rtg-06 and depending on the...

Hi, I have a DlookUp from the LastRtgNo textbox that is from a query when I put Me.RtgNo = Me.[LastRtgNo] + 1 popup says Type mismatch I think by putting the +1 is looking for a number where I have text using a number (field is a Text type) In the RtgNo feild I may have this...

Hi, I think the syntax is not right because if I use this Private Sub Rt_UtNo_DblClick(Cancel As Integer) If IsNull(RtgNo) Then RtgNo = LastRtNo Else RtgNo = Null End If End Sub It enters the LastRtgNo But I want the next number The Textbox itself is text and not...

Hi Sorry I had to do something But the RtgNo is the text box I want to add the last RtgNo +1 and the Last RtgNo is a unbound textbox from a Query in my Form I tried both ways and It still doesn't work It Shows an error in Me.RtgNo = Me.LastRtgNo + 1 and the other way If...

Hi, Can some help me. I'm not sure of the syntax I wanted to double click in text box and Add the LastRtgNo + 1 I have this. The way I wrote the [LastRtgNo] + 1 is not right. I tried with a ([LastRtgNo]) + 1 and a few other ways Can't figuire it out Private Sub RtgNo_DblClick(Cancel As...

Hi Bob, The file was 3.10 MB after compacing and ziping it down. It is the smallest I could get it. Is there any other way to send at this size?

Hi Bob, I just looked I don't know if I sent the dtatbase. I went to Go advanced and manage attachments upload from your computor then close window and send. is that right.

Here is the database

Sure. It is 17.5 MB. I am now sure how to send it