Search results

Here is one for the books, I would much appreciate your help understanding the WHY.. Disclaimer: - Some fancy code was copied from @arnelgp , @Pat Hartman @isladogs and some other wonderful programmers I appreciate. - ALL data contained in the DB is 100% FAKE is test data. I created a very...

Hello ALL. I have a new request from my boss, and I can't solve it, here is why: The form I am referring is called from a search form [ALL FORMS ARE BOUND TO A TABLE] Search Form is bound to the PatientID since I need to find the patient first in order to create a new Authorization [or many]...

Hello Gurus: I have an issue [at least it is for me].. This is my Form: The Fields [Name, Last Name, DOB and Phone], are taken from the Search form is coming (I search for the Patient first) then I move the data to the txt Fields to be displayed, this is the code I use on the SEARCH Form...

Hello Guys.. Is there any way to make sure that when my user opens the DB, this opens in the monitor they want..????? [ they have 2 monitors, a default and secondary] I have been bugged all day with this question, because the app always opens in the default monitor and most want to open it in...

Hello All: I have the following SQL: Private Sub RefreshButton_Click() ' ' Code courtesy of @Arnelgp [AWF] ' Update courtesy of @MajP [AWF] ' Shout out to @theDBguy for his awesome knowledge [AWF] ' Dim sql As String Dim i As Integer Dim Db As DAO.Database If...

Hello Gurus; I am almost finalizing my project, is not perfect but is mine thanks to the help of many of you, but I have an issue and I don't know what to do: Here is the part of the form: The user adds all those records in the ADD RECORD Form, that part is working fine. Before those records...

I have the following button that refreshes my form IF the EU changes the dates, so far it was ok, until my boss decided to change a bit: Now She wants to ADD a field we call [STAT] is a CHECK BOX, I need to add this to the equation: In my vision when the user use the check mark I want to see...

Hello Gurus.. I have a form that when opened Opens a Sub Form containing some useful data for the user, I really as ADMIN do not need that data, and interferes when I try to perform maintenance on the DB, for some reason even when I close the Form something is left Open and the laccdb file is...

Hello everyone, I've been working on a simple form, but I can't determine why it's out of sync when it first opens. For some reason, the selected record in my sub-form doesn't synchronize with the combo box record, but this only occurs upon opening. If I reselect the record or any other...

Hello ALL: I am using a form that I've been able to use thanks to @arnelgp in 2 different routines, works perfect, but I have an issue now.. I created a Query and I base the form on that Query. SELECT PatientT.PatientID, PatientT.PLastName, PatientT.PFirstName, PatientT.PDOB, PatientT.PPhone...

Hello all: I need ADVICE, I have a form that will be opened thru a menu, this form has 2 purposes: - Open SearchF and then once a record is chosen, open a form to edit PersonF. - Open SearchF and with the INFO of that record, fill CompleteRecordF to add data. PersonF only has Info that is...

I am using: Forms("FormName").ShortcutMenu = TempVars("SCM").value FormName is the Name of the SUB-FORM, not of the MAIN FORM. It works with the main Form, but not for the Sub-Form, the only way I've found to disable the Sub-Form sub menu is to go directly to the property tab and disable...

Hello All: I got a problem with this statement: Dim strSQL As String strSQL = "UPDATE PatientT " & _ "Set AuthCanceled = True " & _ " Where PatientID = " & Me.PatientID Debug.Print strSQL CurrentDb.Execute strSQL, dbFailOnError MsgBox "Wait.." This is...

Hello All: I've been trying to fix a very small routine I had IN A FORM CALLED [ PatientEditF ]. I was instructed to correct my code to do it under the " Form_BeforeUpdate " for my routine checking my data. I did, and I rebuilt the whole form, ground up. Now I am receiving the Runtime error...

Hello Gurus: I have an issue with my LOGIC to create a routine where: The Form is a bound form, that contains already some data. So when I close the form I need to check 3 dates If the user decides not to fill the dates is easy to check: IsNull(MyFirstDate) so I know the date(s) where left...

Hello Gurus: Thru trial and error, and with lots of help from many of you here and some other places in the Access world, I was able to proudly create my own message box. While I thought it was working fine, I found out that was actually failing with a strange behavior I was not aware, so I...

Hello Gurus.. After a few minutes I decided to post this here, since the issue will be handled at the end by VBA.. Issue: I am working in an application, where a specific number of records will be displayed in the form footer of my Main Menu on a Sub-Form: This SubForm is created Using 2...

Hello Gurus.. I just came across a weird issue, and I don't know if anyone has a logical explanation for this weird behavior. I have been working with Colin's @isladogs "Centre Form On Screen" which is a great article, until I was just checking how things moved around the module, just as...

Hello Gurus. I am doing a simple test with OpenArgs [Learning] I am creating a very simple Customized MessageBox, something so simple without any extreme or complicated code. since it will be a message box, must be MODAL by default so that the user is forced to click YES or NO. So I found out...

I have a form [F1], that contains a sub form [FSF1], the sub form has the results from a query [QueryView], will usually contain about 50 to 100 records. [FSF1] is placed on the Sub Form as CONT Form. Problem: To make that [F1] work faster when I open another form [F2] I HIDE the form [F1] When...