Recent content by Clownfish1980m

I am wanting to get my hands on a database like what you created. Could you send me a copy? I am wanting to use it to competency assess new personnel. Thanks

:) Working with access and the great folks on this forum to get assistance as well as great ideas for adding features to database design, I just want to share what I was able to accomplish in hopes it will help others wanting to do the same. I created a list box to show all the available...

You are probably correct. I am trying to research how to create the email address table and how to get it to loop through the table and populate a macro with the addresses and send the report. DLookUp seemed to work but only captures the first name in the table and proceed to the second name...

I have now gotten half way to my goal. I have created a form with a list box that shows all the Macros available using the following code: SELECT [Name] FROM MsysObjects WHERE (([Type] = -32766) AND ([Name] Not Like "~*") AND ([Name] Not Like "MSys*")) ORDER BY [Name]; Now I am...

Question: How did you create a list box of available reports? I would like to do the same thing except maybe have one list box to select a report and then a command button to preview the report. Ken

I created a macro using SendObject. I entered every email address. I built a button under switchboard that activated the macro to send the reports. I also made each report cancel on no data so blank reports would not go out. This has worked but I am trying to build this for other users in...

I created a table called POCtbl which contains the [Location], [POC Name], and [Email] fields. I also created a POCqry. Using DLookup I used the following code in the “To” field of the macro. Each macro sends a specific report to that location and a location may have more than one POC...

Thanks. I will research the DLookup() and see what I can create. Ken

The users don't have access but the adminstrator (myself) does. What I need to do do is somehow have the ability to update the email addresses I have assigned to each macro. Running them is not problem as I have the reports being run from swhitchboard. I just need a way to update the email...

I have created a database that uses macros to send reports out to specific locations. The issues I have is I have the database extension as .accdr with all short cut keys disabled to a point it prevents users from tampering with the programming and the data. What I need to do is create a...

I have tried to research this but can’t find exactly what I want to accomplish. I have created a database for my wife whom is working as an independent consultant. She visits various practices and provides support on the EHR systems. She wants to have a report to take with her identifying the...

ghudson, I like the idea of a choice of either preview or print. What event property do you put the coding (i.e. onOpen, onUpdate) ? Thanks Ken

What event procedure would I put that under? Can I put both codes in so that I does the whole file at one time? Thanks Ken

This is an unusual problem. My wife downloaded a file from the Virginia State Immunization Registry and wants to upload the file into their electronic medical records. It downloads the file into Excel except it added an “A” or “N” in front of the first name. We tried to use the “find and...

Here is what I have Private Sub Report_Open(Cancel As Integer) If IsNull([Contacted_Date]) Then [Text109] = Now() - [1st Tx Date] End If I figure that if there is a contact date than the field will be blank. Ken