Recent content by sdlewis

I'm not quite sure what you mean. I'll try to define the problem better. The first table is 'tblJT9Main'. It has 'Date' and 'ESN' as primary keys. It also has a field 'Removal' that is a yes/no. The second table is 'EPCData'. It has the same primary keys and also has the 'Removal' field. I want...

I have a database that contains information about various incidents. In the generic Incident form, there are check boxes regarding what type of incident each record was. If the type of incident causes a removal, there are a great deal more fields that need to be filled in that are on a seperate...

That all worked great. Thank you all very much. I've been the one in my group tasked with developing some new databases, so I'm sure I'll have more questions later, but thank you for your help.

I'm sorry, I don't know what I was thinking. This is a report. Can you have a pop-up box come up when the user opens a report? Ideally, they would open the report, be propmted for their name, and then returned the items pertaining to them. Can that all be done from the report?

How do I put a combo box in a pop-up?

I have a Report that several people access. When they pull up the report, I want them to have to enter their name, and then show only those things which are assigned to them. There are two fields within the Report which need to be checked for the name, Event Assignee and Rem Assignee. How might...

That code again worked very well. Thank you. If I hit cancel in the pop-up box, it won't let me cancel out. How can I make this work? The only thing I can think of is not having it set to data entry, but then other things won't work.

Which event?

That code worked great! Thank you so much. I would also like to have the boxes pop up if it goes to a new record. Can I put that same code under another event to do that? Thanks again.

For the Form, I put Me![ShaftSN].SetFocus in the On Current part. In the On Lost Focus part of the ShaftSN Text Box is the Event Procedure, and the same goes for the Date Text Box. The Class Module is: Private Sub Date_LostFocus() If IsNull(Me.ShaftSN) Then MsgBox "You Need To Enter A...

This is the code I'm using to try to write the data to the table: Private Sub Text412_Click() Dim rst As Object: Set rst = CurrentDb.OpenRecordset(tblLongShaftFront) Dim strVar As String: strVar = Me.FinalDeg With rst .AddNew !FinalAngle = strVar .Update End With Set rst =...

ToeShot- the serial numbers are non-sequential and are letters and numbers, so I don't think it can be automated. Taff7- I defined the primary key as both the serial number and the date, so I'm not expecting overlap to be a problem. I also need assistance in how to create a pop-up box to begin...

I have a database where the user will enter several numerical values and will be given a calculated value based on those entered. I have the form set to bring up a fresh form each time (data entry = yes). I want the user to be forced to enter the primary key (in this case a serial number and the...

Let me try to define the problem better. The user enters several numbers (radius lengths)and gets returned a 'high point' value. The calculations are really just vector addition. So, I end up with a degree value, I'm calling it FinalDeg, that says how many degrees from the start point the high...

I can't get the coding to work, but I'm open to not puting the calculated field in the table. My understanding is to shoe it in a query, but how do I go about doing that? As far as I can tell, I can only use fields from another table or query in a query.