Search results for query: *

Hello: I would like to open different forms, based on dates in an unbound combo box on a different form. So, open a form to specify dates and then click to open a form with that date range of records. It is called from the form that is to open. I currently used something I came across online...

Hi Everyone: I am stumped by this issue. I have a form with a button to click . When that button is clicked, another information pop up form opens. But the original form closes and I don't understand why it is closing. I have the same type of form in other areas of the database that does...

Hello Everyone: I have a main form with many subforms placed on tabbed pages, all linked to the main form. I would like to change some the subforms to be opened by a button instead. But the problem is that some of the subforms have not yet been populated, so I will need to pass the main...

Hi Everyone: I need advice on a form and a field with a drop down list. I have a form where the user chooses a item from a drop down list. The list is based on a query which has two fields. One field is a "medication" and the second field is a check box named "disable". So, any item that...

Hello Everyone: I have been searching, but cannot find an answer for this. How can I print one report, many times but with a different footer . Each footer would have a different word, such as "customer copy", "office copy", "admin copy", etc? Thank you, Sophia

Hello Everyone: I have a form to enter data into a table. I want alternate new records to populate the form with an alternate name...either A or B. I assume the A and B will have to be in a new table. Example: New Record Populate A into field Next Record Populate B into field Next Record...

Hello: I have a 2003 Access database that I updated to 2013. It contains a form that has a button that opens another form. But for some reason, it will only run once, until I close and reopen the database. The first form is based on a query. Then the button opens another form. Can anyone...

Hello Everyone: I was able to follow other posts and have a button on my form to send an email with information from the form. I would like to take this further, as follows: 1) Send the email to email addresses on file 2) Keep track whether or not the email was sent, in Access. Any...

Hello: I have created a query from a few tables and have the dates from each table listed. How can I put all the separate dates in one field? The tables all have a Primary key in common. Eg. tblMain -IDNo, date tblOne - IDNo, date_one tbltwo - IDNo, date_two Qry IDNo, date, date_one...

Hello Everyone; I am stumped by this problem. I have used it on other forms, but for some reason it doesn't work on the current form. I have two tables with the same field [Phone_Log], with a one to one relationship. I have both tables in a query and the problem is the form is not updated...

Hello Everyone: I have an unbound form which the user populates with data that they want to find, and it opens another form with the results. For example, they would enter "Smith" and "Third" to find people named Smith with the address of "Third" Street. How can I get the results to be sorted...

Hello Everyone: I am trying to open a form and add a new record with information from the previous form which displayed the data. I have this, which opens a new form, but it is blank. How can I get it to put the data in the previous form's field into the new form's field? Private Sub...

Hello Everyone: I am having trouble converting an animal's age, such as the result of a calculation as 1.3 , to 1 year 4 months. Can anyone tell me how to do this? This is the function that was given to me by DHookum, a long time ago: Public Function GetEstAge(strInterval As Variant, _...

Hello Everyone: I have a query which includes the date. I want to total the number of records with the same date Jan 1 2014 xx Jan 1 2014 xt Jan 10 2014 xu Jan 15 2014 st I want to show Jan 1 2014 2 Jan 10 2014 1 Jan 15 2014 1 Can anyone suggest how I can do this? Thank you, Sophia

Hello everyone: I am trying to separate a field into three fields The data would be like: ABC34433-061513 AB3335-061513 OR ABC34433-0615131 (extra number at the end) The end is the date "061513" equals June 15 2013. The dash will be consistent. How can I separate the date from the data in...

Hi Everyone: I have a form based on two tables (tblAnimals and tblAdmission_description) that are joined by a common field (Pound_Sheet_No). I have a query that calculates the age of an animal (QryDOB). When I add it to the query with the two tables, I cannot update the form. Is it because...

Hi Everyone: I have an unbound form where the user enters a number "cboPS" which corresponds to a record. Another form opens with that number's data. But if there are no numbers that match, how can I get a message box to appear and tell the user. Then have the form stay open for another...

Hi Everyone I am using Access 2003 and I have a query within a query to print a report. From researching other posts, it seems that this is the reason the memo field is limited to the size of a text field. But I don't know how to fix my query so that the memo field is complete. Here is my...

Hi Everyone: I have been using Access 2003 on my Windows XP machine with no problems. Now I have installed it on my Windows 7 machine and I have been getting various error messages. The references on both computers are the same. Some of the messages are as follows: 1) "There was an error...

Hi Everyone: I'm using Access 2003. The text field of 255 is not large enough and I want to double it to about 500. Can I set a size in the Memo field, without running VBA to tell the user that they are limited. For example, a text field only lets you enter 255 characters. That is what I...