Search results

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 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 & "' "...

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...

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...

My form has a command button to allow me to save a record. Whenever I save a duplicate record I get a runtime error that throws me into debug mode. How can I keep this from happening and perhaps just have a standard, "you cant save this record because it will cause a duplicate"?

I have four combo boxes that allow me to look up a record on my form based on the criteria within each combo box. What I would like to do is start my search in the first combo box. Once I select a criteria in the first combo box, I want my second combo box to have only the filtered from that...

We have one system written in C# and our access database. At this moment we are able to pull open a form in access from our C# program. What we want to be able to do is open the form to filter to a specific record. Can we do this by passing a variable? What would you guys suggest?

My form has a button that copies all the current data into a new record. Only two fields are not being updated in this process. What I would like to do is have a dialog box that pops up and allows me to update those two fields within the dialog box. I can do all that. What I need is some code...

I have a dialog box that pops up to select a certain part number to print. In this dialog box is a combobox that has a list of my partnumbers. When I select a part number and hit the okay button I get this error: Syntax error (missing operator) in query expression Here is my code when I click...

Okay, I did the following, but the problem occurs if there is no such date range. My report seems to have an error that says there is no such value to evaluate. Is there a way to catch this error and have a message box explain that there is no such date?

I have a form that has a lot of information. What I would like to do is have a command button that allows perhaps a dialog box to pop up where I would enter two dates. After the dates have been entered I would like my form to display only those records within those two dates. Any ideas?

I have a command button on a form that shows two text boxes when clicked. The two text boxes are the date range in which I want a connecting report to print. There is a start date and an end date. The problem is that I dont want an error message to pop up whenever someone doesnt enter the date...

Is there a way to minimize the navigation pane and the upper tabs on start up? I have several big forms that don't seem to fit unless these are minimized. Your help is greatly appreciated.:)

I have a form that prints the current record on a report. My boss tells me he needs to do the same thing but wants to print records within a certain date range. Is there a way to do this without having to switch the record source to a parameter driven query? If I can only do it through a query...

I am new to these forums but have been working with access since office 97. Because I am doing bigger and better things, I need help. So far I have received quite a bit of help from Mr. Larson(Thanks). So, instead of being a parasite, I figured I would introduce my self and sift through some of...