I have a Form, Products1, based off Table1.
I want to be able to search by using a combo box for records that have values in the Sec, Twp, and Rang fields.
What I am using currently uses the SortBy and FindRecord commands, but the problem I run into is that it doesn't limit the records returned like a filter does, and I want to be able to tell, of thousands of records, how many are in, say... Sec 3 Twp 24 Rang 30....
KelHemp
Last Activity: Feb 1 '07, 09:37 PM
Joined: Oct 16 '06
Location:
-
Filter with three conditionals ?
-
Maybe I need to give you all more information?
Within each Month's table, I have data to cover up to 3 biweekly pay periods each month. There will not always be 3 pay periods in a month, in fact it's quite rare, however, I know of no way to enable myself to eliminate the third pay period when it goes unneeded other than just to make the control invisible, which leaves my field count on the report for the full year at 286.
... -
Large Report - "too many fields defined" issue
I have compiled data from 13 tables, one for each month of the year that hold 45 fields each, and another for employee information, that holds 16 fields. The database is intended to record hours and special pay withholdings.
I split up the report into First Half and Second Half, as the paper version we use currently does.
My report First Half let me create control boxes for each field I wanted to include, however,... -
oh, forgot to include:
Ctrl-period will take you down the list of views for the current object (Design-Form-Datasheet-PivotTable, etc.)
Ctrl-comma will take you back up the list. (PivotChart-PivotTable-Datasheet-Form, etc)...Leave a comment:
-
F11 will pull you back to the database panel where you can switch between your objects easier, if that helps.Leave a comment:
-
Counting number of records with the same entry
I'm trying to count the number of records within a form (and report) that have the same number in the "LNumber" field.
If I had a set number I wanted, I'd just run a single query, but the number changes many times in a set of 30 or so records.
There's probably a way to count them at every individual record, but I don't see that as an efficient way to handle this.
Is there any way I can have... -
what you might want to do is create a new column for "shipping log #" and set its control source to equal your three numbers in the order you want them to appear. You may need to have it be a text field instead of a number field, however....Leave a comment:
-
Thank you! works great. It's not perfect, but it'll keep those little mistakes from ruining things. Now I have to work on keeping out those of us who think we know what we're doing!Leave a comment:
-
it's on a report and an identical form. The form is the one that's mostly screwy thanks to people updating the records. Why I feel I need it there (in the form) is because only half of the page numbering within is done automatically, the rest is after an update within the LeaseNumber field on the form. I can't set it to onCurrent, because it keeps adding to the page number every time I go back and look at the record if I do that.
...Leave a comment:
-
Overspill records help!
Hi,
I'm having issues with a setup I'm using to hold data on certain lease numbers within a region. As it is, I have a set amount of information I want on one single record, and all overspill is recorded on the next record, and so forth, until all the info I have is accounted for.
What I want to do is have a quick reference on every record, aside from the normal page numbering system, which just counts how many records I... -
I'm by no means an expert, but I think the problem is in your table you're using for the form... in my experience, just creating a text box and writing in it is like stamping the whole form with that information. instead, you need to tell it to see the difference between the records by making a field for it in your table. Then, add the text box, and give it the source of that field.
That help?Leave a comment:
-
Manual Page numbering??
So, I've set up a manual page numbering system, bound to the field "LeaseNumbe r" AfterUpdate, to keep track of how many records I have of each single lease number. It works, but if you go back and update the record extraneous amounts of times, the numbers get off.
Here's what I have:
Two controls to find values of previous and next LeaseNumber and another to keep track of previous PageNumber
... -
okay, I'm an idiot. I forgot to replace "TableName" with the name of my table, Products1. And I replaced the "." in each line with "!" and it works great now.
Thanks for the help!
Here's what I ended up with:
...Code:Option Compare Database Public Sub Lease_Number_AfterUpdate() If Me!LeaseNumber = Me!PrevLeaseNumber Then Me!LeaseName = DLookup("[LeaseName]",Leave a comment:
-
It is a number type. I went into the AfterUpdate and pasted the code, but nothing happened like I wanted. I hit the "Code Bulder" option and it automatically created the lines
And I pasted the middle section in and tried that.Code:Option Compare Database Public Sub Lease_Number_AfterUpdate() End Sub
Now, it gives me a compile error: Method or data member not found....Leave a comment:
-
If/Then help!
I have a form that I want to automatically fill in information on.
When the LeaseNumber field is equal to the PrevLeaseNumber field, I want to fill in LeaseName and Location with DLookup or some other action that would retrieve them from the previous record.
Should I use a macro? SQL? An OnUpdate event? -
New Record Auto Fill as Previous Record Runoff?
Greetings,
I've been using this site for lots of access help in the past, and it's very helpful! I have a new complexity for you all.
Reworking a form [Products1] to record 70-80 years of oil production on multiple leases, which have multiple wells within them. Most wells can fit on one printed page (one record), but in the case of overspill, we want to do the following:
-Move to a new record and auto fill the LeaseName,...
No activity results to display
Leave a comment: