Search results

Hi everyone. I need help in the syntax of the DLookup() and I appreciate your efforts I am trying to get a value from a query to place in a form using the DLookup function. This value must meet two criteria: must be on the last date, and, it is the one for the text field that match the specific...

I have a report that prints lab tests. One section has 4 columns that are framed. Only the first control (STest) expands to more than one line. The Can Grow works on this control and subsequently the section expands. I need a code that expands the height of the other three controls to match that...

I have the following code to import an Excel sheet into my Access app. I wrote the code in Access 2003 a couple of years ago and now using Access 2013. It worked fine with both versions till today. It is giving me a "Type Mismatch" error and hangs on the line in red. Any help?? " Dim d As...

I am using the SendKeys command (Sendkeys "%ha%n") . It is working on my Windows 7 Access 2003 but it is giving error on Windows 8. Any suggestions? :confused:

I have a form (FrmAddQuotes) with a tab control and two pages ( quotes for insurance). I am trying to automatically fill the rate field on the quote subform (FrmQuotesAuto), by a rate from the rates table that meets 4 contditions with an SQL statement. here is my code: Private Sub...

I am using Access 2003. I have an application for a medical lab and all is working fine except when it comes to printing the test's results. The problem is with formatting and not with getting the data into it. There are two sets of groups of tests : Main tests (Mtest table) and Sub tests (Stest...