Search results

Hi everybody I created this query (pic-3) to count down the quantity of any prescribed item and it is working fine and updating the table (pic-1) Now what I want is this: When the user want to update the quantity combobox (pic2), I want to show him/her a message box saying either "There is...

Hi all, I used the below code for mandatory fields in many subforms, it is working fine but I have one issue: If the user entered any field in a specific subform by mistake and want to erase it and go to another subform, he can't until he/she complete all fields before going to the right one...

Good morning I split my DB without saving a non-split copy as a backup. I do not want to unsplit the DB now because many front end users are working on it already. What should I do !

Good morning everybody Is it possible to display image based on combobox selection in a subform. Thanks

Hi I have a subform in a main form in my split DB. I added three more fields in Backend table (Provider, Date, Store). then I added controls for them in the Frontend subform. Now, I disabled these three controls in the subform then I want the user to enable them with a PW when click on a...

Hi Could anybody help me figure out why my attached crosstab query asks for date range twice. Thanks

Hi I have the following code for the command button to print a record in the subform which lies in the main form: Dim strReportName As String Dim strCriteria As String strReportName = "rptWA2" strCriteria = "P_ID= " & Nz(Me!P_ID, 0) DoCmd.OpenReport strReportName, acViewPreview, , strCriteria...

Hi I need to be able to copy fields from subform-1 and paste them in same fields in subform-2 when I update a comb box in subform-2 using VBA. Please see the below picture Thanks

Hi I have made a crosstab out of a query with UNION ALL. The query is this: SELECT tblDiagnosis.MainDiagnosisID, tblDiagnosis.D_CauseCateg, tblDiagnosis.D_Level, tblDiagnosis.D_Quadrant FROM tblDiagnosis GROUP BY tblDiagnosis.MainDiagnosisID, tblDiagnosis.D_CauseCateg, tblDiagnosis.D_Level...

Hi everybody I am about to distribute the front end of my split DB to users, isn't a good idea to put an error handler in the DB before that, and how could I do that. Is there a not complicated one to put in my DB so it will not crash. Thanks.

Hi everybody, I need some help plz, I have the attached form. I get run-time error 3075 (attached) when I click on print when the form is empty like in the pic. The code under click event is the following: Private Sub Print_Click() Dim strReportName As String Dim strCriteria As String...

Hi Can somebody help me please I added a command button to search for a specific record using ApplyFilter. It is working fine but I discovered when I click on the search command button when the text box is empty, it gives me a specific record. why I don't know.

Hi Can somebody help me to calculate the datediff between the first and last row in a subform as shown in the picture. I want to calculate the difference between the first session (Initial Assessment) 2.9.2020 and the last session (DC) 8.9.2020. The goal is to know how many days the patient...

Hi I have main form that got many fields like patient name, gender...etc and one multi-value combo-box for associated diseases as in (pic1). the combo-box is working fine (Pic1) and I needed to calculate number of associated diseases for gender(M,F...etc) so I created a query (pic2 and pic3)...

Hi everybody I have a main form with a tab control with many pages, and each page has two subforms. One of the subforms is driven from a table that has a multivalued combo box field. When I open the table, all values in the combobox appears, but when I open the main form with the subform...

Hi everybody I have a main form with a tab control with many pages, and each page has a subform. One of the subforms is driven from a table that has a multivalued combo box field. This field does not show anything in the subform in the form view. I tried my best but no luck Thanks

Hi all, I need help please, I have a physiotherapy clinic where the clerk enters the referral date and the phsyio appointment date to calcualte how many days the patient is waiting as a performance indicator. I created a query that calculates the days between all dates in the DB and it is...

Hi everybody, I was able to prevent user from deleting or editing previous records in my subform by entering the following in "on Current" evnet. Private Sub Form_Current() If Me.NewRecord Then Me.AllowEdits = True Me.AllowDeletions = True Else Me.AllowEdits = False...

Hi everybody, I need some help please. In my clinic db I have a main form which got 5 tabs. two tabs of them are my concern, I want the tab that got fields with information to appear each time I click next (jumping between 2 tabs). Is that possible. Thanks.

Hi all, I need some help please. I used UNION ALL to get results from two queries and I Succeeded. Now I want these results to be in a date range, so I want to enter the "starting date" then the "End Date" to have may results in specific date range. This is the original code out of...