Search results

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...

Thank you but this results in all of the fields with the Carry Forward tag being changed to red for all records. I am trying to just change the floating text in the New Record to red. My original approach seems unworkable so I am now trying to use the New Record property: Private Sub...

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 solved this by adding the filter to the Record Source instead of the Filter Property.

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...

No, the copy was structure AND data. And it worked. That's why it was so frustrating. There was no difference between the original table and the copy that successfully appended the records. I then closed, compacted and re-opened the database and was able to append the records to the table...

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...

Thank you.:)

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 really appreciate the help. I think I had a Sample Form, but lost it copying it back and forth from test DB's to the final application. I also appreciate your critique of my project. I'm not a programmer, just a biologist trying to program. I have lot's of parked code, possibly some...

To my knowledge my code does not open any of these forms, but it does requery them. The database does not have a front end. It is a stand alone for remote users. :)I am attaching the DB here in case anyone would be willing to look it over there is a bit of code in various places and a few...

Offending Code? This Save Changes prompt occurs after data is entered into the form but it is a save changes to form prompt for some of the subforms and one table which I have not entered data into. My main form is set up so that the subforms are inactive until the necessary data is entered...

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 put this on OnDirty: Dim lngRecNo As Long lngRecNo = Me![ID] Me.Requery Me![ID].SetFocus DoCmd.FindRecord lngRecNo, acEntire, , acSearchAll And it seems to work as Needed. I used Enabled instead of Visible just to let the user know the Control is there. Hopefully, I have this solved...

Thank you Bob. This works well, but I have to back out ot the record then re-enter it before the control appears. Should I requery the form on update?

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...