Search results

This morning two tables were deleted from a database. The database failed to back up over night but I was able to import those two tables from a previous version of the database. My question is, looking at the object dependency between these old and new versions of the database, it appears the...

I need to create a loop for the following command to be completed 23 times. I'm new to the looping and I'm not sure how to write the code for this. I need to go through 23 fields (Time1, Time2, Time3,.....Time23). Can anyone help me with the coding to create the loop? Thanks! Me.Time1.Visible...

Good afternoon, I'm trying to create a report that does the following: If the term "Other" is selected in the Time1 field, then the Time1 field will not be visible, but the field Other1 field will be visible and if the term "Other" is not selected in Time1 field, then the Time1 field will be...

So I have searched through the forums and tried numerous things to fix this code, but the line I have bolded below continues to be highlighted yellow and I keep getting the Runtime Error 3144. Any suggestions on what is wrong with the code would be greatly appreciated! Thanks in advance...

Good afternoon, I've been searching around and haven't found the exact answer to help me out with my problem. I have a query that has multiple IDs and different information in numerous fields. For example: ID Field1 Field2 Field3 1 x 1 m 1...

I have two queries: 1. a sum of payments by individuals 2. a sum of charges of individuals. I want to combine these queries to create a report that shows the sums for each person of the charges and payments and calculate the balance. However, it is only showing me those individuals that have...

Hopefully someone will be able to see something that I'm not after two days of trying to solve this problem. I have a shell of my database in the below link for reference. I am trying to create a query for a report that will allow me to track charges and payments per client. Each charge has a...

I need to build an expression that not only filters out the 9 in a column, but also the number 14. How do I build this expression to make it work for both 9 and 14. Currently it works just for 9. How do I make it work both numbers? RegularPayment...

I have been fighting with this code all day with numerous error messages and not fix. I find a lot of previous questions, but non that really help me. I have a Navigation Form and I have a subform with a subform in it. The code for the control button to add a photo is below. The latest...

I have a unbound object in a subform call imgPicture. I want the user to be able to click a command button to choose a picture to change the picture in imgPicture. In the code below everything is working except the immediate change to the picture. For the picture to update I either need to...

I have searched through the forums and unless I'm not performing the right searches, I'm not find the answer, so I apologize in advance if the answer is out there already! I have a query pulling data from two other queries (qry_Reports and qry_Surveys). Clients may have more than one ReportID...

I need to design from scratch a Facility Maintenance database that tracks inventory, repairs, preventative maintenance, costs, requests, vendors, etc. I am trying to find some template examples to give me ideas on how to proceed. I have already viewed the vehicle maintenance template in...

I am trying to develop a report that when the user selects the report from a combobox, the report will prompt for parameter questions and then open. I have a list of counties that I want to be able to query for as well as dates. Is there way to have a box open with the list of counties to...

I have a subform in datasheet view for tracking calls from clients. The Client Name is a combination of the first and last name. I want to create a text box that allows me to start typing in the client name and it will filter for only those Clients that match. Currently, I have the following...

I have the following Event Procedures in a form: Private Sub PrimaryDisability_Change() Select Case Me.PrimaryDisability Case "Other (Specify)" PrimaryOther.Visible = True Case Else PrimaryOther.Visible = False End Select End Sub Private Sub SecondaryDisabilityYN_Click()...

I have searched the site and the internet, without finding an answer to my problem, I'm hoping that someone can help me find a solution! I have created a Access 2010 database to track applications/reports deadline dates. I would like to set up an automatic email to be sent to my outlook 2010...