Search results

CEH is right on, for more info on what he is talking about do a search for "Many-to-Many" relationships. Going back to your original question, you are looking for two properties on your combo box: "Control Source" and "Row Source". "Row Source" is the property that populates the list of...

Try moving the frequency text box into the group footer of MyField.

Thanks Gromit, great solution!

Hi all! I have a tough problem I was hoping I could get some help with: I would like to create a recordset based on the "middle" 50% of the data. I need to chop 25% off the top of the data, AND 25% off the bottom of the data. Any ideas?

First, create an empty table with the same fields as the source table you want to edit, maybe call it something like TEMPtblobligation. Next, create a parametric append query. Your users will specify the criteria to select the records from tblobligation they need to edit, and the append...

I would create the logo and address information in the page footer, then set their "Visible" property to "No". Then on the "On Print" property of the page footer, use an If statement to check for the current page number and set the "Visible" property to "Yes" for the first page, and "No" for...

If you want to hide the database window on startup go to the "Tools" menu and select the "Startup" option. You will then have options to select which form you want to show on startup and if you want to show the database window. If you want to hide the navigation buttons on a form, change the...

I think your looking for the "Allow Autocorrect" property of a combo box.

Hi all! I have created a database with auto-archiving features. I have "working tables" that are populated when the product is moved to the correct process, in this case when it reaches the test department. When the product is moved out of the relevant process, the database runs several...

Hey Ken, your method works like a charm! Thanks much!

I can't seem to find the correct syntax for the split function. Think you could post an example for me? Thanks!

I am normalizing data from a spreadsheet of just over 4000 records. The spreadsheet has a "Model" field that contains both the model number and a model description, separated by a space. I would like to split this field into two different fields: "Model_Number" and "Model_Description". The...

Try using a crosstab query. Setup with "DepartmentId" as the column heading, "DocumentTitle" as the Row Heading, and "Date" as the Value. I can't really tell exactly what information you want to display in the query, but this should point you in the right direction.

I assume Me.Department is bound to the department field. The following code is actually adding a null vallue to the table, which shows up as a blank entry in the list box and the table. 'Sets the value of the current record to "": Me.Department = "" 'Goes to a new record, adding the "" entry...

Hey! Good idea! Why didn't i think of that?

Are you using a primary key in tbl_Department? If so, is a text field?

One way or the other this sounds like a primary key violation. If BlowerId is part of a compound primary key in tblOrderDetails your getting a compound primary key violation. You can't leave a field that is part of a primary key blank! Try setting your primary key in tblOrderDetails to just...

Thanks for the reply Tom. Unfortunately, my report is so complicated I can't include the criteria fields in the data set of the report. I'm counting yes/no data fields in the main report (Totals Query in the data source), then summing them in the grouping footers. Adding the criteria fields I...

Percentage values should be specified using a single or double data format: ie. 5.00% is actually stored as 0.0500, and 78.33% is actually stored as 0.7833. This is done this way to lend functionality to calculated fields. For example, if you want to calculate a given employees percentage of...

Have you tried right-clicking on the object in the project explorer and using the "Remove MyClassObject" option?