Search results

This works great. I'm wondering why it needs to be >=. I tried just putting > and it didn't work right. I would think in my mind that when they are equal I should still be able to enter (and I can still enter with the >= command) Does it start counting with 0 or something. Well I guess it's...

I think that I might be referencing the subform control incorrectly. I first tried: Forms![MainFormName]![SubFormName].Form![ControlName] It gives an error that says, "Cannot find the field called 'SubFormName'" When I try to reference it: Forms![MainFormName]![ControlName] it gives me the...

This topic has been discussed, but I can't seem to apply any of the responses to my problem. I have a combo box in a subform. It queries a table with employee information. When you enter something not in list or double-click on the box it brings up the employee info table to add an...

I have a form with a sub form. The subform is in the default view "continuous forms" so that multiple items can be viewed at a time. I want to be able to specify how many items may be entered based on a number in the main form. More specifically, we want to track our software. We want to...

I have created a report that looks similar to a excel spreadsheet. It does everything great except I would like to always fill the page. IE If there is not enough data to fill the page it will fill down with empty data. Does anyone have any ideas of what I should try? Thanks, Kenneth

Oh Thankyou! Thankyou! Thankyou! You answered all of my questions. I really appreciate your help. (and I promise I won't post the same question in multiple forums again) Thanks again. Kenneth

I don't know much about VB and I think that's why I'm having the following problem. I've set a variable as public that can be set from the main switchboard. I called it ActProj (Active Project). This is what I wrote in a module called 'SetVars' Option Explicit Public ActProj As String After...

First I would create a table with catagory and sub catagories. Set the primary field as the combonation of the two. In the first combobox set the row source as a query that looks to the table you created. Right click to turn on the totals so that you get the 'grouped by' in the totals...

I'm glad there a question that I can actually answer. But there's more than one thing that needs to be done. This is one way to do it. Go to the database setup wizard and look at the account ledger database after it's set up. Read the directions below and look at those things specifically on...

The easiest way to create a query is to used the query wizard. You can quickly choose the two tables and all the fields in those tables in the wizard. After you've created the query open the form in design view and double-click on the little box in the upper left corner. This should make...

I'm facing a similar problem as Angelo, but I'm a little confused on the vocabulary used. Could you please explain what you mean by "use DAO to open a recordset based on the second table". I think this is a solution to my problem as well. I figure what you mean is something like: Dim rs As...

Thanks again Charity. You always seem to have just the right answer. I appreciate your help. This was exactly what I needed so that I won't have to go through and reorganize all the data. I have learned my lesson and all the databases I've created recently have been completely relational, I...

That was a great idea. I went to the wizard and created the combo box and then looked at what it did. The wizard put the following in the AfterUpdate event: ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[field in record]...

It seems like this has been discussed, but I can't find it. I want a form to find the first record that matches what has been filled out so far in the form. As you fill in boxes it will go to the first record that matches. As soon as you fill out a field that makes the form not match any...

Again, that's right on target. Thank you so much! Kenneth

Hey thanks! I put it in the On GotFocus event so that everytime the form gets the focus back it requeries everything. It works great. I really appreciate your help! Kenneth

I run so many append and delete queries on this one database that I wrote a module to run a couple of them in a row. The problem is that there are two message prompts for each query. (You are about to run an append query that will alter the table.) (You are about the append _ pieces of data)...

This is the same question as ezpc's below. I have a combobox and from there you choose an instrument type from a combobox. There's a button, which opens a form to add the instrument to the list if needed. When the instrument is added to the list I need to requery all the comboboxes in the...

I'm sorry the the original statement was so vague. c,d, and e are properties that descride uses of a piece of equipment. c= equipment type (ie PLC, HMI, flow transmitter, etc.) d= euipment series or manufacturer (ie Allen Bradley, Honeywell, etc.) e= control software that was used with the...

My data needs to organized differently for data entry and for querying. Is it possible to easily change data from the following form (which allows for easy data entry) These are the fields to enter on form: nam c1 d1 e1 c2 d2 e2 c3 d3 e3 These are how the data need to be org: num...