Search results

Hello, Gurus. I have a very particular form, that I need to set SPECIFICALLY at Width 28440 and Height 11835, so that it fits in ALL my monitors across the board, my problem is that everytime I save the form at 5.5 inches, it keeps the size perfectly as I saved it: But when I made a change and...

Hello Gurus... I have the following form: My boss has asked me to do the following: Create 4 boxes Stat / Approval Date / Appointment Date / Notify Date I did each one as a text box, thinking I could have done something like this on the On Load Event: If Stat then StatColor.BackColor =...

Hello Gurus. I have a very interesting problem on a query I can't solve. For time purposes, and to make it easy, I'll use 4 fields as Example: InitialDate FN LN ApprovedD Now this query already displays the first 90 days of InitialDate. The Issue: I need: based on those 90 days, limit more...

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