Search results

Okay, I found the problem but need a work around. In the parent form i have a subform that relies on the partnumber field to show the values of that subform. It is in the underlying query. What happens is the partNumber somehow ends up being null whenever you add a new record. How can I make...

Hello All, Okay, I am having the strangest issue. I have a form that allows the user to click a button and add a new record. When you add a new record, certain default values are input except for two, PartNumber and PartDescripton. After you enter a part number and a part description and...

I have something that is rather complicated and has been eating me up all night. I have a form with a sub form. I need to make some calculations off of the sub form that are displayed on the main form. These calculations are based on tool measurements. On my form there are 5 separate bins...

I have a form that is some how set to read only. It wont allow me to delete any records directly from the form. What I would like to do is create a command button that deletes a row from the underlying table. I would like the row being deleted from the underlying table to be based on a control...

I never could figure it out so I created a new form. I must have made some strange changes??? It works fine now though!!

I didn't change any names. I have several controls. several combo boxes that look up based on a field. None of them seem to work now. And neither does the filters. Could you possibly suggest another way to obtain records from notes. I don't know how it just stopped working. I didn't make any changes

I have a form that has a command button that allows for adding notes to the form. The notes table is seperate from all other tables. It is not linked to any other forms. My boss will not allow it. So, I have a couple of things going that allow the record I am viewing to know if there is a note...

I have a several combo boxes that are being used as filters. I have one for part number that goes like this in the after update event: Me.ToolMeasurementCutterToolMeasurement_Subform.Form.Filter = "PartNumber='" & cboPartNumberTest.Value & "' "...

Attached is the properties showing how the combo box is somehow linked allowing a filter to be applied. the cboPartNumberTest allows me to filter all the partnumbers. I also want to be able to filter by TraceNumber as well. Is this master/child thing somehow limiting me to only use one filter...

I have a combo box that can filter my form and its sub form with the following code inserted in the after update event: Me.[ToolMeasurementCutterToolMeasurement Subform].Requery the code in the rowsource is this: SELECT DISTINCT CutterToolMeasurement.PartNumber FROM CutterToolMeasurement...

Does anyone no where I can get some better pictures for my access database. The standard ones are really not all that great. I am looking for a stock pile of pics that I can place in my files so that I can draw upon them whenever I am designing my database. I just havent had much luck designing...

Well, Its finally been figured out. Here is the code within the module Here is the code in my first combo box Here is the code in my second combo box The Code in the Third: This allows any combo box to be picked and filters the record down

This is what I have and it still pulls up a blank. When I take out the WHERE in my query it gives me the trace numbers. I just cant get it to reference the combo box

Is this question really that difficult. I have really been trying to put this together. I have tried all kinds of methods. Here is my code. What Am I doing wrong? I mean, why wont my combo box pull data from the other one?:banghead:

I have a table that is going to link to cart32. In this table I have fields for a small image and a large image. How should I format these fields so that I can link them to a url that has the images?

:banghead: Okay, I have been at this for some time, searching for a way to put these cascading combo boxes into practice. I keep getting all kinds of problems. Can someone give me a detailed description as to how to put these cascading combo boxes into practice.:banghead: Note: I am using a...

Yah, it was a tipo in the code above. In my program it is corect. I apriciate ur help. :)

Yah, it was a tipo in the code above. In my program it is corect.

Thanks but were would you suggest I place this code?

Never mind guys, I used the following code on the after update event to check for duplicates in the table. If Not IsNull(DLookup("[PartNumber]", "CutterToolSpecs", "[PartNumber] = '" & Me.PartNumber & "'")) Then MsgBox "Duplicate Tool Number! Must Add A Differant Part Number"...