Search results

Its giving me the same error when i press enter. Please see attachment. I do have subforms one where user can enter notes and the other where they can only view items they want to purchase. For my query, its pulling the AutoID record (Purchase order) from my search page.

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...

Thanks, you have saved me some time of searching and breaking my head :banghead: looking for a solution!!! :D Have a good day!! :cool:

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

Hello, I used the code: Private Sub Form_Error(DataErr As Integer, Response As Integer) Const conDuplicateKey = 3022 Dim strMsg As String If DataErr = conDuplicateKey Then Response = acDataErrContinue strMsg = "Each employee record must have a unique " _ &...

LOL.... (literally) such a small thing, thank you so much Minty!! Have a great Holiday season!! Denise ♥

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...

Here's the database :o

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, Well i tried using the UAPBalance: IIf(([Month/Year]<#4/1/2000#),([grant]-[current recoup]-[arrears recoup]+[other]),([grant]-[disregard]-[current recoup]-[arrears recoup]+[other])) to the UAP Report filter qry, and updated the UAP Bal text box properties. The balance is not showing...

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...

Omg!!!! Yay!!!! It works ... Im so happyyyyyy :d thank you soooo much for all your help!!!!! you are truly an awesome person taruz!!!! ♥

Hello, Thank you so much Taruz, the balance is now showing (Yay!!!) .... however its not showing correctly based on the CaseID. But were a step ahead now :D CaseID#1 start month is 03/2010 and its continues its balacing from CaseID# 2 start month 02/2000. I need for each CaseID to show...

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]...