Search results

Thanks, that should work fine. I also found that in design mode, if you right click on the area of the screen not covered by the report, and click properties, there is a "data" tab for the entire Report which lets you select a record source. You can then use the [...] button to build a query and...

Hi, I'm new to this whole reporting thing, but pretty familiar with queries and forms. I would like to report off of a table, but use a form to run the report based on a date range. So I choose a start date and end date and then hit a button to open my report and display my formatted data for...

Oh, sorry. I didn't even notice that.

Ahh, this is giving me a head ache, it won't let me insert values from my form. I have two in particular that I have started testing with. The first is a text field which has the label 'Add_EquipmentName' and the other is a combo box which has the label 'Add_EquipmentTypeID'. The records source...

Thanks, I really just needed some guidance. I have decided to go with using SQL to add new records to my table which is unbound. The main issue I am having now is how to go about calling the SQL. The only way I could figure it out is by using the following code in a module that is called on a...

Ok, I'm completely lost. I can't figure out the best way to go about this, and I am not very familiar with Access 2007 (VBA and Forms anyways) I do have a good working knowledge of SQL. I have a bunch of questions so maybe I'll just index them cause they might be pretty random. 1.) Whats the...

Thanks, exactly what I was looking for!

Hi, I'm having trouble creating a form that has a drop down list and two entry fields. Both entry fields have a default value of NULL. Now what I am trying to do is keep the user from entering data in one of the fields when one of the values is selected from the combo box, and have both fields...

Ok so I figured out that by not bounding any of the fields to the form, I can get the list boxes from working properly. I have all of the fields filled with the data I want, but now I can't figure out how to append theses values into a new row of a table. I have created a button and in the "on...

This is exactly what I am trying to do. The form is only for data entry. I will try and look online for "data entry form" and see what I get.

I'm pretty new to this type of event handling, could you give me an example of how to do 1 and 3? Do have to write VB functions and place the function names in the boxes next to the event names? I also have a button, say called button1, that takes the data in the fields and uses that data to...

I have a form which that is bound to 1 particular table, whereby people can enter data into the text boxes, and select data from the drop down menus, and then hit a submit record button that loads those values into the table as a new record. I have three problems that I am experiencing. 1.) If...

Thanks for that, I'll take a look!

Nevermind, after I figured out that this type of operation had a specific name I just searched the internet and came up with this: Thanks for the help on terminology Paul!

There is no way to do this in the Properties Sheet of the design form? I don't have time to learn VB nor do I choose to for this project, that can be another day.

I am trying to make a form in design view to enter data into a transactions table. I have the following set of tables with these relationships: <EquipmentTypeTable> [EquipmentTypeID] PK [EquipmentTypeName] <EquipmentTable> [EquipmentID] PK [EquipmentName] [EquipmentTypeID] FK...

Thanks, I found a way that makes it much faster than joining all the fields. I simply turn the "value" into a string and add the rank to it, now when I choose MIN of my new frankinstiened string I get to retain the "value" portion which I can parse back into its original value and convert back...

Thanks for the heads up, but these field names were not what I was using, just what I'm using to describe the problem in a simplified manner. Second, I don't think that I can use Domain Aggregate functions, as this query is being designed in access, but will eventually be migrated to SQL...

I was wondering if someone could offer some help. I have the following table structure RESULTS: [Contaminant] [Date] [EmployeeID] [Value] [Rank] I need to group these values so that they have the same: Contaminant, Date, and EmployeeID. I then need to select only the lowest ranked value. If...

I figured as much, thanks for the timely response though!