Search results

Hello, Getting an error message "Run-time error '2465' can't find the field '|1' referred to in your expression" every time i click my submit button from my form. Here's my code Private Sub Command128_Click() If IsNull([Doc-ID_RQN-No]) Then MsgBox "The eCAPS Document ID is missing...

Hello, Is there away to have the report footer only to display on the first page? :confused:

Hello, I'm trying to calculate the number of days between two dates using the iif statement Fields: [LDW] "Last Day Worked" [ReturnedDate] DESCRIPTION: If ReturnedDate is null, then calculate the datediff "d" between LDW with Now(), if not, then calculate the datediff "d" between LDW with...

Hello, I'm creating a database to track new policies request. I have a form in datasheet view that displays a list for all Initial Review and Draft status. I would like to click (... or maybe double click) on the Policy Name field that will display all fields into single form that is link to...

Hello, I've created a database to track training courses. I'm having issues with selecting multiple trainers. I set up my table to lookup a "List" on the trainer column. I've entered 2 records into my form and it displays 6 records. See attach image. What am I doing wrong? :banghead...

Hello, I need help with my report. My report(detail section) displays the running balance, the report footer calculates the sum per colunm, and i will like to add a text box the displays below the running balance the last balance as the total balance. If you open report, enter 1 as the...

Hello, I'm having issues with my database, I want to run a balance for my subquery for which it will not calculate the Disregard prior 4/1/2000, and calculate it 4/1/2000 forward. :confused: This is what I currently have SELECT [UAP Balance Tbl].CaseID, [UAP Balance Tbl].[Month/Year]...