Search results

Looping the controls? I honestly do not know how to do this, LOL Private Sub AuthNumber_BeforeUpdate(Cancel As Integer) If DCount("*", "dbo_tdAuthorization", "[AuthNum]='" & Me.[AuthNumber] & "'") > 0 Then ' MsgBox "Valid Auth Num entered." If DCount("*", "dbo_tdAuthorization", "[MemberID]=" &...

OK So far I have this: Option Compare Database Private Sub AuthNumber_BeforeUpdate(Cancel As Integer) If DCount("*", "dbo_tdAuthorization", "[AuthNum]='" & Me.[AuthNumber] & "'") > 0 Then MsgBox "Valid Auth Num entered." Else MsgBox "Auth Num doesn't exist in CYBER." End If End Sub Private Sub...

My apologies for not seeing this sooner. I tried this and it's bombing Private Sub AuthNumber_BeforeUpdate(Cancel As Integer) If DCount("*", "dbo_tdAuthorization", "[AuthNum]='" & Me.[AuthNumber] & "'") Then MsgBox "Auth Num exists!" Else MsgBox "Auth Number doesn't exist...

Private Sub AuthNumber_BeforeUpdate(Cancel As Integer) If DCount("*", "dbo_tdAuthorization", "[AuthNum]=" & Nz(Me.[AuthNumber], 0)) > 0 Then MsgBox "Auth Num exists!" Else MsgBox "Auth Number doesn't exist in CYBER." End If End Sub This isn't working for the Auth...

For the Authorization Number validation how do I do it if the data type is short text?

I corrected the field and control name references so the code reads like this now: Private Sub MemberID_BeforeUpdate(Cancel As Integer) If DCount("*", "dbo_tdMember", "[MemberID]=" & Nz(Me.[MemberID], 0)) > 0 Then MsgBox "Member ID exists!" Else MsgBox "Member ID doesn't...

This is what I put in the BeforeUpdate EventProperty attached to the Member ID field control of the form: Private Sub MemberID_BeforeUpdate(Cancel As Integer) If DCount("*", "dbo_tdMember", "[MEMBERID]=" & Nz(Me.[MemberID], 0)) > 0 Then MsgBox "Member ID exists!" Else...

Hi there , Thank you for your quick reply. The field is actually spelled MEMBERID on the table and yes, it's a number field. :) This could wouldn't go in the AfterUpdate event property? Also, what is DCount? is it a built in function? Do I just copy this into the VBA module attached to the property?

Hi, I have a form control that I would like to validate to see if the value entered by the user exists on a SQL table. I tried using a macro but it's not working and I know it's probably better to do using VBA - something I am not good at! I can code basic routines but nothing crazy. 1. I...

Hi Pat - I am not sure I understand this syntax. Is there a parenthesis missing? Where (SomeDate Between Forms!YourForm!StartDT) AND Forms!YourForm!EndDT OR Forms!YourForm!StartDT Is Null)

Hi there - I entered the following criteria for the Date Processed field of my query Between Nz([Forms]![frmClaimsReviewQueueMAIN]![StartDateRange],#1/1/1900#) And Nz([Forms]![frmClaimsReviewQueueMAIN]![EndDateRange],#1/1/1900#) Then I entered the following on my form and clicked Search but no...

Hi there - Thank you for your quick reply! Here's the SQL version of my query for your review. SELECT tblClaimsWorkingTable.ID, tblClaimsWorkingTable.ClaimNumber, tblClaimsWorkingTable.AuthNumber, tblClaimsWorkingTable.DateOfServiceFrom, tblClaimsWorkingTable.DateOfServiceTo...

Greetings, I have a Form in my Access database that is based on a query. My form consists of multiple textbox controls and the goal is to allow the user to enter either the date range start and end values, and/or Fund Year and/or Fund Name Listing. My query selects records from my table with...

Hi Ranman256 - FYI I am not doing this via VBA code. I am manually using Access features and form commands. Isaac - I can't seem to get each tab to operate as it's own form. I tried saving each funding type as its own form and them pulling them in as sub forms but it doesn't seem to work. Ugh.

Hi - I have a tabbed form in an Access database I am designing for process claims. Each tab represents a different fund type. My main table will contain the individual claims. I also have a table that contains just the funding type names. Each tab contains an identical form with all the same...

Thank you all for your assistance! I was able to update the export specification file. Thank you for the YouTube video it helped!

Thank you for your reply. I have tried to recreate a new scheme file but when I do it expects me to run it through the Saved Exports window. I need it to run automatically through the VBA module above. It's still not working the way I want it too. So frustrating.

Hi - I have a macro that is attached to a command button on my form that runs a step that executes (run code) a function called ExportData() a colleague created a long while ago. It exports the main database table to a txt delimited file that feeds a process to our SQL tables. Mind you this has...

No, the save is a straight Macro generated using the command button feature in the Design view window. It automatically generates the macro for you.

No. actually the database is only used by him to track his deliverables.