Search results

My Access database sometimes will not open when you click. Right mouse click to open also becomes unresponsive. When I restart the PC, then it will open on clicking, but only for a few times. Thereafter, it just becomes unresponsive again without any error messages. Keep restarting the PC to...

I have a database containing patients with blood test results. The table is called tblDatabase and the relevant fields for this discussion are Firstname, Surname, DOB, and SampleDate. Data entry is done through a form called frmDatabase. Some patients have their tests done repeatedly. While...

I have a single database producing the same report template for different clients. But one of the clients now wants his company’s name displayed in the header section for his reports. How do I do this without affecting other’s report format?

I have a form used to run a report. I have managed to output the report in pdf form by using the following VBA: DoCmd.OutputTo acOutputReport, "rptPrnAuto", acFormatPDF, "C:\Users\Shree\Desktop\NKToEmail\AutoAb.PDF" But I want to replace the generic AutoAb.pdf with the Firstname and surname...

I want to click a button and various reports are automatically saved to my desktop folder in pdf format. I can get to output pdf but have to manually save into the folder for each report. The code I had written isn't saving at all.... where am I going wrong with this code: Private Sub...

Hi, can someone please remind me how I can close a parameter query without having to close the entire database and reopen again? [Alt] [f5] ?? Many thanks.

Please help: I have three fields in a form; Basal (this is the background reading of a blood test) Ctl50_1 (this should give the highest reading in all patients tested and must be more than basal) Ctl25_1 (this must be a value less than 50_1 but more than basal) Ctl12_1 (must have a value less...

I have a database with a form containing three fields (Basal, ctl50_1 and ctl25_1). The user will have to enter blood test results(numerical) to all of the three fields per patient. I am bit of a novice at VBA, but here is the code I wrote to ensure that the ctl50_1 value is always higher than...

I have a form where the user has to enter numbers in four fields. If we assume these number fields to be a, b, c and d. But I need to ensure (b-a) is higher than (d-c). So after update of the last input filed, I wrote the following vba: Dim a,b,c,d As Double If (d - c) > (b - a) Then MsgBox...

I have an access 2010 database all complete with a user friendly switchboard form that open upon clicking an icon. But I don't want any users to press the SHIFT key and enter and alter any design settings. Is there anything I can do so that upon SHIFT [Enter] press, the user encounters a...

Auto-fill multiple tabs within a single form. I have a form populated with six tabs. Each tab represents a patient test. One field contains the sample barcode ID which may be the same also for another test. Is there a way to automatically on update to copy and paste the long barcode ID from the...

I have a form field asking to imput a date. At the moment I am forcing the user to input date as dd/mm/yyyy via inputmask. But is there a code I can use so that even if the user type in dd/mm/yy in the box, on update it will convert this to dd/mm/yyyy format?

Previous threads in this forum have extensively discussed many ways of printing subreports whilst ignoring empty subreports. Interestingly, I came across another thread few years ago describing multiple reports printing using standard module. The VBA script can be, for example: Public Function...

I have 7 subreports housed in the parent report footer section. I wish just to print only those subreports with data. I did manage (with the aid of previous threads from here) to make subreports with no data invisible, but the parental report header and footer remains in these suppressed sheets...