Search results

Hello - I have a form with several sub forms and when one record is deleted from the main form, I would like the records under it to be deleted as well. This is what I have but most of it comes up with errors as in it shows up red. I got this from a book and have manipulated it to suit my...

Thanks - this is really helpful!

I have the query setup as a field in my table. I would like a user to enter a child's name and see the age so they have an idea of other classes. Do you have a better idea?

I have setup this query but I want the value to show up in my table. Can I do this?

I have followed the instructions from another post (Thank you Brian Whatnot!) but it doesn't automatically update. The ages are there in a dropdown but the age field isn't automatically populated. It also doesn't automatically update. Help!

Hello. I have several databases that I need to calculate the ages for. I have attached it for your review. This specific database has the age calculation in the "consumers" table. The code that I have is "Expr1: DateDiff("yyyy",[Me].[BirthDate],DateAdd(6,"m",[Me].[CurrentDate]))". I have this...

I have tried to save this as an earlier version but Access won't let me. It says "You cannot save this database in an earlier version format, because it uses features that require the current file format." Can someone who has 20007 or 2010 look at this? Thanks!

I have a database that has classes and contacts (students). Each student could attend many classes and each class could have many students. The problem is that I am a complete loss as to how to set this up. I have attached my database so you can see it. Thanks!

Hello - I would like my query to select only the records between two dates. This query should ask the user the dates before the query is invoked. This is the code I have but it only asks for one date. I need both. >[EnterDate] And <[EnterDate] I have also attached the database. Thanks!

Simon - the information that appears on the Consumers form needs to be there. Bob - I don't see a choice of OnChange. Can you tell me where I can find this? Thanks!

This is what I came up with as it pertains to my database. The problem is that I SUCK AT WRITING CODE!!!! Yep - you guessed it - it doesn't work! Can you help? Any help would be MOST APPRECIATED! Private Sub LastName_BeforeUpdate(Cancel As Integer) Dim tmpPC, tmpLastName tmpLastName =...

Please excuse my ignorance. I don't know how to get the detail part (subform of Consumers) to show up in the Visual Basic editor. Can someone please help me here? I have clicked on everything that makes sense to me. Thanks. Tonya

How do I make the Form_Asset Details show?

"Put onopen part of the form..: Sendkeys "{pgup}" " I am sorry but this is greek to me. Where do I put this?

I would like to add a function to either my table or form to determine if the record being added is actually a duplicate. I would like it to ask the user if records these could possibly be duplicates (should list all possibilities) and then allow them to add the record if they decide it isn't. I...

I have several databases that I have inserted tabs with sub forms. When I open the form, I can't see the tabs. I have to use the scroll bar to move the window to where I can see the tabs. Can someone tell me how to make the form so I can see them? Can you also tell me how to add a control key...

Initially - THAT DID THE TRICK!!!! Thank you SOOO MUCH! For not understanding English - you certainly helped me. Thanks again!

Hello. I am having a problem with my subforms. Rather than the ID field populating when you click on a different tab, it does nothing. I know there is code I should enter, I just don't know what it should be. I have attached my database for your review.

I don't know what the problem is - it just does nothing when I click the button. Even with the new code above. Is there a log so I can see the problem? If so, where do I find it? Thanks!

Good evening. I am having problems with my search button. The following is the code attached to the button. Private Sub Command12_Click() If (IsNull(cboType)) Or (IsNull(txtCriteria)) Then MsgBox "Please select search type", vbOKOnly, "please select search type" ElseIf [cboType] =...