Search results

  1. C

    Help-Test with questions from diff categories

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

    Open System Reports from a Form

    :) 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...
  3. C

    Question Open Macro in Design View Command Button

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

    Question Open Macro in Design View Command Button

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

    Print Reports Chosen From Listbox

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

    Question Open Macro in Design View Command Button

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

    Question Open Macro in Design View Command Button

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

    Question Open Macro in Design View Command Button

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

    Question Open Macro in Design View Command Button

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

    Question Open Macro in Design View Command Button

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

    Report filtered by combo box

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

    Default View Print Preview

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

    Remove Letter from Field

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

    Remove Letter from Field

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

    Report Calculations

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

    Report Calculations

    We are getting closer. I can now open the report it is blanks. When I clidk on the text box and it changes to "NA" even if there is a contacted date there. If I click it again it changes to the Now()-1st Tx Date value. What event should I put the coding under? I have under On Enter. Ken
  17. C

    Report Calculations

    I got it backwords in the original part but this is what I tried and I get Compile error: syntax error. Private Sub Text109_Enter() If IsNull (Contacted Date) Then [Text109] = Now() - [1st Tx Date] Else [Text109] = "NA" End If
  18. C

    Report Calculations

    I have a database containing two fields; one is “1st Tx Date” the second is “Contacted Date”. When an individual received a product the 1st TX Date field has a date input. Once oral confirmation is made they have received the product, a date is added to the Contacted Date. On a report I have...
  19. C

    Question Message Box Warning

    That works great. Thanks so much. Ken
  20. C

    Question Message Box Warning

    MStef you made me think and you are correct. I could build an "if then statement" that when a status is selected it will automatically put in today's date to show when the midicaiton was added or changed. That solves the need for a message box. Thanks
Back
Top Bottom