Recent content by Cirrus

I have a make table query that pulls data from a table and a query joined on common fields. When I view the query in datasheet view, 2 decimal places are showing on certain fields. However, when I run the table, the number fields are not showing 2 decimal places unless there are values in...

I just figured it out! This code is working for me. Thanks for your help Paul! Dim varArrayNum As Variant varArrayNum = Me.ArrayNumber Dim varGridNum As Variant varGridNum = Me.GridNumber DoCmd.GoToRecord , , acNewRec Me.ArrayNumber = varArrayNum...

Thanks again Paul. That code also worked well on auto-populating the data from one field. Now, is there a way to have multiple fields auto-populate with data from the last record when the command button is clicked? Some of the field names that I want to pull the data from are...

Thanks for your response Paul. The code works well when I enter in a static value. Can you tell me the code required to equal the record displayed before the button was clicked DoCmd.GoToRecord , , acNewRec Me.TextboxName = <last value entered in the table> Thanks!

Hello everyone. I have a fairly complex access database with multiple tables, queries and forms. Some forms are embedded in other forms. It is a database that I have worked with in the past and it functions correctly. I am now trying to add some additional functionality and I have not been...

Thanks Minty! That worked like a charm - much appreciated!

I have a subform embedded on a tab within a form. When I open the form, I want the form and the subform to open to new records. I have tried the "go to record" macro set to "new record" in various spots (on current, on load, on open, etc) within the form, the tab and the subform - nothing I...

Hi Again Paul - the debug identified the problem for me. The dropdown is storing the ID value rather than the text value so instead of having "None" in the field it has "7" (number 7 in the dropdown). I'll be able to solve the issue now and I'll implement the simpler code as well as that...

Hi Paul - I did try that syntax as well and it did not work either.

Hello All, Database Background: I have a database with two tables. The tables are linked together via a common field. The tables are then joined in a query that feeds a form. What I'm Trying To Do: After updating a field in table 1 in the form, I want a field in table 2 to be auto updated...

I figured this out. The error was in the query - more info was needed for the query to find the imbedded form (which is also embedded on a tab). The updated criteria code is: [Forms]![FORM - Enter Fire Veg Information]![SUBFORM - Enter MacroPlot and Veg Plot Info].[Form]![Enter Specific Veg...

Thanks for the link AlexN. I have followed the video and then made the changes for use in my subform. My code in the Row Source is as follows: SELECT CommonName FROM [LOOKUP TABLE - Veg Species - Species Name] WHERE SpeciesType = [cmbSpecies_Type]; I can select from the first dropdown menu...

I have a cascading combo box working fabulously in a form. However when I embed that form into another form, the cascading combo boxes quit working. After doing some searching around on the web I think my issue is either in the query that the dependent combo box references and/or in the "after...

Thank you for your comments Micheal but I am new to writing code in Access and I'm confused by the use of ISNULL since none of the data I want to evaluate contains null values. I will also need some more direction on how each of values in the sample code relates to my data. Sorry for the need...

Thank you for your reply Michael. I have tried including a WHERE clause in my query and it doesn't look like it is going to work in this case since I don't want to eliminate any records I only want to ignore certain values within the 8 columns of data. I must analyze every row of data and the...