I have a subform in datasheet view whose column order I would like to be be able to customize, perhaps with a button on the main form.
Since there are different usages of the data based on the task users may be engaged in, it would be very helpful for them to have a way to order the columns...
I am hoping to save my data entry staff a lot of time entering long ID numbers for genetic samples in our database. I have been able to carry forward values in forms in datasheet view, but I'm having trouble figuring out how to carry forward a sequential alpha numeric code with an incremental...
I inherited a Database with a Table that stores information in fields:
Date SS SM SL
which I summarize in a Query with totals as
Year SumOfSS SumOfSM SumOfSL
What I would like to do is essentially unPivot this data:
Year Class Total
2012...
Hi, I am trying to run a crosstab query with criteria based on a subform control:
TRANSFORM Count([CHIN Sample Data].Species) AS CountOfSpecies
SELECT [CHIN Sample Data].Species, [CHIN Sample Data].Water, [CHIN Sample Data].Section, [CHIN Sample Data].Date, [CHIN Sample Data].Mark, [CHIN Sample...
I am trying to use criteria to create a conditional expression in an Access Query.
IIf([STHD DIP]=”Skokomish”, Round([Redds]*0.7175*2,0), IIf([STHD DIP]=”West Hood Canal”, Round([Redds]*0.7175*2,0), Round([Redds]*0.81*2,0)))
I have a nested IIf expression to evaluate a field where two...
I am trying to allow users to filter a set of records by date. My reference to the filter control is as follows:
If Nz(Me.DateFilter, 0) > 0 Then 'TargetType
If Len(Nz(strFilter)) > 0 Then strFilter = strFilter & " And "
strFilter = strFilter & "#Date# = '" & Me.DateFilter & "'"...
Auto filling fields based on values in a form
This is one of those rare occasions where values from a related table must be stored in the main table; These are river mile start and end points that are default values but not always actual values. The purpose of this action is to bypass...
I am trying to incrementally advance my initial date value in a data entry form to save a step in data entry. Here is the code I'm working with:
Private Sub Date_AfterUpdate()
Me!Date.DefaultValue = "#" & Format(Me!Date + 1, "yyyy-mm-dd") & "#"
End Sub
This carries forward the first value...
I have a form with two subforms. I have been able to select records in a main form by clicking a value in a subform. But I am having trouble applying the technique to selecting records in subform "B" based on clicking a value in subform "A" (which is on a Tab Control).
Private Sub...
I am building a database to hold data for fish weir counts. Some weirs run 24 hours and others only trap for partial days. Right now I have a Date field and two time fields: Trap_In and Trap_Out. The idea being that much of the data will need to be totaled by Date, but that trapping hours...
I have a snippet of code (below) that carries values in a form forward during data entry. These values appear in the form on the New record before the record is actually written and I would like them to be red instead of black so the user can easily see that they are on a new record as...
I have a form (Table 1 data) with two subforms (related Table 2 data). Each of the subforms are independent views of the same underlying table (different fields). Setting aside the preferred database design issue of why these are not split into separate tables, the fields in one of the...
I thought is would be simple enough to change my primary field name [SurveyID] and replace the instance of the old field name in my code with the new one [FSID], but now I am getting Run-time error '438': Object doesn't support this property or method
Old code:
Private Sub...
In Form datasheet view Access provides an "every other record" pattern of background color formatting across rows.
Is there a way, perhaps through the use of "Expression Is" in conditional formatting to change this pattern to repeat based on changes in the value of the first column? My goal is...
I have spent hours trying to append some data. The structure of temporary data table was originally copied from the main table and populated with the same exact look up tables so all data types and indexes were identical.
In desperation, I copied my main table and renamed it, established...
I have built a database application which is deployed to a number of remote users. About three times a year each of the users must export their new records to a central database.
In my current arrangement I have a DataStatus Field that is used as criteria so the export queries know which...
I have a unique index based on three fields, two of which are required. The third is not always used but when it is, I would like to allow duplication of the first two if the third is unique.
Unfortunately, when it is null, Access does not view the combination of A;B;Null as unique.
The...
I have a subform on a tab that will requery when exiting the first data entry page.
But I have a subform within a subform on another page that generates a runtime error (Object doesn't support this property or method) with the code I am currently using. I have tried to follow syntax for...
I have a main data entry form with several subforms and recently I started getting mysterious Save Prompts when closing the forms after entering data. But these prompts are regarding form design not data.
I went through my code looking for any save prompt properties but found none. I did...
I am trying to develop an application for others to use but every so often a user locks up the main data entry form by entering a value into the sub form before they have entered the data into the main form that creates the record the subform data will be linked to.:eek:
I would like to...