Search results

I am running an Autoexec macro, that runs my maketable queries, update queries and delete queries, then it runs the transfer spreadsheet macro to a folder that I have created on the root of C on my local computer and then the last thing Autoexec does is close my database. I have all this run...

Can anyone tell me where to find the Microsoft Hierarchal Flex Grid Control in Access 2000/2002?

I am writing a database to keep track of medication carts. I have an OLE object box to allow for pictures of the medication carts. Right now I have around 35 records with 2 pictures (OLE objects) for each record. I want to have a user be able to double click on the picture and have it open up...

I have a report that has many fields. Of course, I don't want every field to print if it is null, the report would be long and ambiguous and nasty. Is there a way to skip a field and have the next field (if not null) print in the same position?

Does anyone know how to open Windows Explorer programatically (VBA)? Thank you.

Is it possible to pass criteria to the criteria part of a query field from Code? I'm trying new things. If so, can someone show me an example. Thanks.

I am trying to use the InStr variable to search through an ADO recordset. Problem: I get a type mismatch error within my code when trying to run the ADO in a recordset. Another thing, when I just type in a string, and use the InStr variable, it works. I'm thinking, maybe you can't use the...

Problem: I have a user that wants to be able to select phone calls that were received during a certain time period (i.e. #10:00 PM# to #04:00 AM#). As you know, queries will not select the records between these times with a Between (StartTime) And (End Time) Statement, because it crosses...

Has anyone ever had the need to create an index or table of contents from an Access report, like you can do in Word? I can save the access report as an RTF to open in word, but wouldn't it be nice to be able to just create one in Access? If anyone has ever attempted this, or knows something...

I am currently employed with a healthcare network, and I am tracking vehicles and deliveries. In my destination field in my location table I have numerous destinations for one run. For instance, I have 12 destinations for the 12:00 run. I am trying to create a form that will not only show the...