Search results

I did manage to use the validation rule on the filed property to get the desired effect. Thanks Dave. But can I perform the same with VBA script? I think writing code with VBA rather than altering validation rule on the property pane would prove more flexible in the database. I am at a loss as...

Thanks John. That works. But the problem is the form in question is one of seven tabs form. So even if there is no need to fill in that particular tab form, on saving any of the other forms, the msgbox appears asking to fill in a,b,c & d. Any help on how to avoid this?

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

Thanks for the reply. I did find this old forum very useful. Re: disable shift key at startup! just took a look at the code i used to see how long itd take me to create an example file, but it looks like thats not necesary, youll need to create a button to run this code. if you dont want the...

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

I think I got it! On field update (that is, the source field), I've added the following code: Me.FieldNameTarget=Forms!frmName.FieldNameSource This did paste the typed letters from the source to target as required. Furthermore, quick look at the table led me to think any alterations on the...

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

You are absolutely right!! Thanks again.

Thanks guys. We have a database system in our hospital called Telepath that enables you to enter date as ddmmyy without the / (eg: 310112) and it will convert these to 31/01/2012 on loosing focus. Is there way of doing this in Access 2010? I know it's a bit petty, but I think will help the user...

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?

With regard to referencing the textbox from a form as you had described above ([Forms]![frmParameter]![txtSearchID]), is it possible to reference a field in a report which is already displaying into the criteria of a query field? For example, in my case, the Patient ID displayed in a generated...

Once again many thanks to you vbaInet. Sometimes I may have data in all eight of my reports, as such all eight will be printed. Do you think it is advisable to add DoEvents to be added between each print DoCmd? eg: Public Function OpenMyReports() DoCmd.OpenReport "Reportname1" DoEvents...

Thanks guys. Codes suggested by Simon MT didn't work for me as the empty report still displayed. But just adding cancel=true & error catches did the trick as explained by vbaInet. I am actually printing reports that are specific test results of individual patients. Each patient has his/her...

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