Search results

missinglinq Thank you for the links. I am familiar with Steve Lebans so I will take a look.

Mr Smin, Its a manufacturing shop. Hope that satisfies your curiousity.

I'm not sure where to begin with this .... I am using Access 2003 and I am building a database for multiple end users. The database contains records of how to perform processes in the shop where I work. Each process will have multiple steps and each step can have multiple elements. My...

Ah.... thank you -- yes, that's it. I just realized that SET was only for an Update query. D'oh. Okay, back to working on getting the rest of this database running smoothly. Thanks again for your support.

This would require a course in Ergonomic Burden analysis.... :confused: I'm not going into that now. Okay, playing around on my own I was working with something like this: Dim strQuery As String Dim HoldElementID As Integer HoldElementID = Forms!frmElement!ElementID...

I'm sorry, but it is not creating records I don't need. I have to have 3 records for each element regardless to whether there is a value greater than zero or a zero value. I want to add this functionality in case the user forgets to add the additional zero value records when they are entering a...

Hmmm.... but that's not exactly what I am looking for, I want to auto-populate to a maximum of 3 records. So if 3 records do not yet exist, I want the subform to automatically populate with 3 records of zero value. If one record exists, I want the subform to auto populate with 2 records of...

Tools are separated because the gripping and or weight of the tool can have ergonomic factors. "Lifts" does not refer to equipment but rather the ergonomic burden of lifting parts and the height the part may need to be lifted to. So, if I change my table structure as you suggest -- how can I...

It just so happens that I am trying to re-write an old database that is a big mess and causing problems -- each movement was recorded as "armmoverment1", "armmovement2", "armmovement3" all on the element table.... There are many many movements, actually, so I separated the arm movement into...

Hmm.... let me better explain the table structure: Table ErgoArm has a Primay key (ErgoArmID), a foreign key (ElementID), and 4 number fields called: i.e. ArmMovementPoint, ArmBurden, ArmTime and ArmCoefficient. Each of these is to have 3 values for each ElementID. Are you telling me that if...

I am using Access 2003 and I have a mainform with several subforms. All forms are bound. I have restricted the subforms to show a maximum of 3 records each. But really, what I want to do is auto-populate the text boxes with zeroes for 3 records each. I want the user to change the value, but I...

You need to create a module in vba and insert the Public Sub you can then call it from the command on your form.

I'm not expecting you to do the work for me. I'm just looking for direction and where you sent me didn't really help me because the coding was not along the same lines as what I already have. I am still quite new to VBA and I cannot just make do as you suggested. I provided the coding I am...

I'm even more lost....:confused: this is a big learning curve for me..... sorry..... These two examples are way over my head.....

Okay.... but I don't know how to do that? :o

I am running Access 2003 and have created a module which sends an email to recipients from the database in Lotus Notes. It works just fine, but now I have been asked to "Bold" specific text in the email so that it is easier to read on their blackberries :o. Can anyone help me format the text...

</br> or <br> didn't work at all.....

Thank you! SOS..... vbCrlf worked beautifully!

hmmm.... let me try.... I also got the number thing sorted out so its just the new line issue.....

I have been experimeting and I hope that someone can give me some direction. I did the following: Sub SendEmail() Dim stTomb As String Dim HoldNotes As String HoldNotes = "Safety Notes: " & Forms!frmTest!Notes.Value stTomb = myboss@abc.ca Call SendNotesMail("Test Email"...