Search results for query: *

Hi all I am having a problem getting this code to work. What I want to do is on a form (frmI) I want user to check a checkbox on each row (continuous form) and then click a command button and auto insert some information, then create a word document for that record, then save the word doc...

Hi Andy Thanks - that worked I just used: varNcNum = Format(Forms!frmName!Nonum, "0000") VNCno = "NC-1" & varNcNum Worked like a champ! Thanks again! Raven

Hello All I am trying to format an number (long integer) into text to send an automated email from Access. I have the format in the table and am able to get this format to work everywhere but when I try to format the number while sending email. so the number is 1 (no leading zeros), when...

Hi all I have textbox on a form that is numeric data type. I am trying to have data validation instead of the ms Access error message for this field. I have tried everything, even adding a new textbox. I have deleted format "general number", default value, and for some reason cannot figure...

Ok jumped the gun here - the data the user types into the combo box does not transfer to the frmupdateitems. Any ideas? Raven

I fixed it. <Ah ha dummy moment> For anyone reading this - this is what I had to change. <cannot believe I didn't catch this before> Private Sub NCItemNo_NotInList(NewData As String, Response As Integer) Dim ADL As String ADL = vbNewLine & vbNewLine msg = "ITEM NAME...

Hello All I have a form (frmNCOE from tbl1) that has a combo box with a record source coming from tbl2 - (item list), that has 4 fields that show in the combo box, then based on the choice the user makes auto populates the combo box, plus the 3 other combo boxes. (This all works fine) When an...

For anyone trying to do this, here is what I had wrong THe code above was in the form in database2, the code I had in form in database1 was wrong. below is the code that worked for me. Dim StrNonCno As Integer StrNonCno = OpenArgs Me.NonConNo = StrNonCno Just got frustrated...

Hi All What I want to do is to open a form in database1 from database2 and passing one numeric field into database1 form. I have the form in the database1 opening from database2 with the following code: Dim acc As Access.Application Dim db As DAO.Database Dim strDbName As...

Hey Aceman - so sorry it took so long to reply back this code worked like a charm. here is the finalized code I used. Code thanks to Aceman! Thanks! Public Function AppendDepts(Depts As String) Dim rst As DAO.Recordset, hld1stID As Long, Ary, x, PsEcn As Integer Set rst =...

Thanks MajP. I apologize for it taking so long to post back........always crazy busy here. Because we are not quite ready for paperless so only the ImpactYN = true emails are being sent now. (You will see the ImpactYN = False commented out for now and a few declarations that are not used...

So I did as you suggested. My logic is off. I need to test each record in the subform recordsetclone for ImpactYN = True. But when I did that it crashed the database. I am thinking it was an infinite loop. I will work on it more. Thanks!

Hello I have a main form (frmECNOE) that has one subform (subfrmECNDE). I am trying to send two different emails, based on whether ImpactYN field is true (This field is in the subform) First the code is sending to all, instead of testing for True value in field ImpactYN. Second when first...

TheAceman1: Main Form name: frmECNOE Sub Form Name: subformECNOE sub form recordsource: SELECT ActionID, ECNNO, DeptsImpact, ActionItem, ImpactYN, DeptPerson FROM tblActionItems; DeptsImpact is the field that needs 9 Departments inserted. ActionID is the primary key to the table...

Hi All I have a main form that has a sub form on it. I want to have the user enter the main form and when they enter main form or sub form, automatically add 5 new records in the sub form with one of the fields filled out. Would it be better to add when entering the main form or wait till the...

Thanks guys........ Zelgar:This worked. Thanks. I guess i could not see the forest for the trees. Raven

I have just tried the statement this way it errors with too many arguements: =IF(ISBLANK(OR(H4),(G4)), "NO ESTIMATE", NETWORKDAYS(G4,H4))) I would think there is an easy way to do this but i have googled and searched thru this forum. No dice. Thanks Raven

Ok it is now formatted as general But now it is returning True instead of days between two cells (should be how many days between start and end date) ANy ideas?

Hello I am trying to do the following in excel: 1. test 2 cells for null value (should contain date) 2. After testing both cells for null use networkdays to figure the amount of dates between Here is the statements i have tried to no avail: =IF(ISBLANK(G857:H857), 0, NETWORKDAYS(G857,H857))...

Thanks guys. Lameid: That is exactly what i did. now to make code work! Thanks! Raven