Search results

I have a database that was created in Access 2007. I have moved it to Access 2019 with the Windows 10 update. The issue I'm having is when I try to run the macro it should open a form to look for a file. It does nothing. I must admit VBA code is by far not my strong suit but here is what I...

Good evening. Alright now I feel like something off the Adams Family but down to business... I need to create an update query that updates two fields. One is a fiscal year (FiscalYear) field. The fiscal year runs from July 1st through June 30th. The calendar year (CalendarYear) is your typical...

Can you limit the pages to print based on if there are records in the subreport portion of the report? For example... I may have 20 records in my contacts folder. I may have 100 assets but I only want to print the report based on the assets that are checked out. Thanks! Tonya Nichols

Good afternoon. Can you make different subforms appear based on whether or not a check box is checked? Thanks. Tonya Nichols

I have a form that is attached to a query. I want this form to add an Attendance ID, the consumer ID and child ID will be automatically entered because the Attendance ID is an autonumber and the other two are linked to parent forms and will be filled in based on the ID's of the parents. The...

I have a query that I want to actually populate a table with information. This database is a contact database that has classes that the contacts / students will attend. I think the AttendanceID should be a new record because each contact can attend a class. Each contact can attend many classes...

I have a database with classes and contacts (students). I also have an attendance table that I would like to store the attendance of classes. I would like to use DLookUp. Well at lease I think I do. The thing is - I have tried to set it up and I get an error. The following is what I have...

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

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

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

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.

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

Good morning. I have a dropdown that I want employees to use to select their name to add time. The following is what I have: Private Sub Combo18_AfterUpdate() Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst "[Employe Name] = '" & Me.cboName & "'"...

Good afternoon. I would like to create a dropdown to select an employee. When I do this (I have a main form and a subform), it won't change the data in either the main form or the subform. Granted, I am most definitely doing this wrong. (Obviously! Or I wouldn't be here right?) The subform and...

Hello. I am using Access 2007. I am creating a time tracking database and I want to create a calculation based on when the week ends. It should give the total number of hours worked within a week and refresh as records are entered. Our week starts on Monday and ends on Sunday. Well this is how I...