Advertisements Here is my scenario: I have a database for projects I manage. In this database, I have a table for Projects (tblProjects) and a table for Hot Notes (tblHotNotes) that look like this: tblProjects: ProjectID ProjectName tblHotNotes: HotNoteID ProjectID (fk) HotNote HotNoteDate I also have a continuous form called frmProjectList that lists all projects… Read More MS Access: when working with Continuous Forms, how can I run a query that filters by ID of each record and display result in Textbox?

Advertisements Quick question, assuming that I have two access databases with tables that have exactly the same headers, how would I go about appending data from DATABASE1_TABLE_A to DATABASE2_TABLE_B using VBA (executed from DATABASE1). I tried the DoCmd.CopyObject "DATABASE2_DESTINATION", "TABLE_B", acTable, "TABLE_A" which works, however it overwrites existing DATABASE2_TABLE_B rather than appending data to it.… Read More MS Access to MS Access data transfer without overwriting

Advertisements I need to breakdown the two subqueries by File_Date. Now it’s just giving me the total number of records per Service_Code. SELECT [Request File].File_Date, Count([Request File].SSN) AS [Borrower Count], Sum([Request File].Discharge_Amt) AS Total_Discharge_Amt, (SELECT Count([Request File].SSN) FROM [Request File] WHERE [Request File].Servicer_Code="500") AS 500_Count, (SELECT Count([Request File].SSN) FROM [Request File] WHERE [Request File].Servicer_Code="579") AS… Read More Subquery Totals in Access

Advertisements I have a login form. I have a username and password text box with a login and close button. I would like: Text saying "username" in the username and "password" in the pass field. When clicked on the text disappears. If clicked on and you focus on something else without typing anything, it will… Read More Microsoft Access – Placeholder in Textbox VBA