Search results

I have a list of attendance information for a school that I want to group by student and attendance date, and then check to see if there are consecutive periods on the same date for that same student and count them if they exist. Here is sample data: A B C D 1...

I have been trying to get this to work for days, have tried different examples from this forum and elsewhere and don't know what I am doing wrong. I have one combo box for Module and another for Tool. I want the Tool combo box to only list the Tools for the Module selected in the first combo...

I have a table that has multiple date fields. I need to compare three of the date fields and return the most recent date. Here is a simplified example of my Main table (tblMain): LName FName Date1 Date2 Date3 How can I find the most recent date between Date1, Date2 and Date3? I will also...

I created a test database to test sending email from Access. Everything works great on my test database on C:. When I copy the form/code/query to the database on our network I get this error: "The expression On Click you entered as the event property setting produced the following error...

I have the query below that I need to change to remove duplicates in a field "tblCalls.CN". I have done this in other queries in this same database adding "SELECT DISTINCT tblCalls.CN," to the front of the query statement but that does not work with this query. This query is different in that...

I have buttons on a form that run a query to filter the records and then open another form to display the records. I just added the following code on the second form to show a "No Records Found" message when the query returns no records: Private Sub Form_Load() If Me.Recordset.RecordCount = 0...

I have many databases on our network in Access 2007 that are used by multiple users. Most are fine, but one much-used database keeps making [databasename]_Backup.accdb files. This has been happening for sometime now. Today though there is ALOT of lost data in the database. The new database...

We have a telephone directory report in Access 2007. We would like to add a link to each staff person's photo. The photos are in a different location on our network, in our K: drive. On the Access phone report, the text box holds the field StaffName and the text box is named txtStaffName...

I have a text field that contains numbers that I want to change to a numeric field during a make table query. (Please note that I do not not have the option of changing the original table's data type.) (Also, I'm using Access 2000.) I've been searching forum posts and see people changing data...

I have been asked to find missing records in a table for a purchase order number field. The ultimate goal is to give the user a report showing a list of these missing purchase order numbers. An example would be if the table has purchaser order numbers 00001 and 00003, but not 00002, they would...

I have been searching thru these posts for help on rounding but haven't found an answer for my situation. I have a Form with unbound text boxes whose calculations that are rounding. All of the text boxes are unbound and are NOT fields that come from a table, so I can not set their field type...

I have a form where the user will do data entry. This form also contains a subform. I have a long If/End If statement that checks the user's data entry for errors. I then want to look at the subform to check to see if the user's data entry conflicts with the data on the subform. I can get my...

I have a button on a form that, when pressed, is checking the data entry done on the form by the user. I'm using If..Then statements. I need to include in all this a way to check each record of the subform as well for any conflicts. I am unsure how to include a loop inside of the If..Then...

I am building an equipment check-out database. On the check out form I have the user fill in check out date/time and projected return date/time. On the check out form I am also displaying in a subform any reservations for the selected piece of equipment. Upon pressing the Save button, I want...

I have a report that consists of a letter on page 1 and a certificate on page 2. This report runs many of these page 1/2 combinations at a time. I want to put my agency address in the page footer and have it only appear on the letter (page 1) and not the certificate (page 2). The agency...

I have code on a button in the On Click Event that fills a report title and gets data from a table. I get a type mismatch error on this line and believe it is having a problem with the "Like" operator. I took this code directly from the SQL statement from a query...why does it not work? How...

I have a form that has (among other things): 1) a delete button (to delete a record) 2) a Search Payee box (that lists all payee names) 3) an SSN text box I have code in the "On Enter" event of the SSN text box that pops up a message box asking which way to format the SSN (regular or as tax...

I am working on my first bound application between SQL Server and Access 2000. I am using a manual to try to set this up. The manual has given the following code to link one table/relink all tables. I assume I should run the relink all tables code every time a user opens the database ... but...

Does anyone know where I can find a list of error codes for Access? A user had a problem in one of my databases today. When I compacted/repaired it using Access' utility I received these errors in a table called MSysCompactError: -1206 Could not find field 'Description' -1053 Could not find...

I have two forms where the user can choose what should appear on the report. For example, the user can select a date range or a date type. On these two forms there are several text boxes that fill using VB Code, depending on what is chosen on the form. One of these text boxes (txtReportTitle)...