Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kimmer7389
  • Content: Threads
  • Order by date
  1. kimmer7389

    Change Dates in an Access Query from Access form and overwrite data in existing Excel file

    This is what I am trying to do: On an Access form: 1. User selects a start weekending date from a combobox 2. User Selects an end weekending date from a combobox. 3. User clicks a button to start the process. The process runs a query in Access with the dates the user selected and overwrites...
  2. kimmer7389

    Concatenate many records into a text field

    I am trying to Concatenate many records into a single text field on a report. I have 2 tables. tbl_Procedures PK - ProcedureID - Autonumber Procedure - Text tbl_ProcSedationFinal PK - MRN - Number Procedure - Number I would like for all the procedures to be listed...
  3. kimmer7389

    Sum Total Yesses from several different Fields

    I thought my Access skills were better than this. Glad this site exists to get me unstuck. Sometimes my brain pauses. I have a report that lists several different fields and the counts of yesses and nos. It looks like this. Field Yes Count No Count Field 1 2 3 Field 2...
  4. kimmer7389

    Count or Sum if field 1 = yes and field 2 is <= "01:00"

    I have an Access Report and I am trying to display a total if the Count or Sum (Have not gotten either to work) of Lav Values completed = yes (1) AND Total Hours are less than are greater than "01:00" I have written an expression...
  5. kimmer7389

    Dynamically change X axis on chart

    How do I change the X axis on a chart to only show the months for the date range entered? The data is displaying the correct data points but my x axis is showing all the months and years ever entered into the database
  6. kimmer7389

    Reports and Charts

    I have a report that is sorted by Unit and then Date by Month. The report is displaying all of the records correctly. The users can select a Unit and enter a range of dates from a form to filter the report. The filter is working on the report data. Here is the problem... I would like to have...
  7. kimmer7389

    Permission to only a column in a table

    Is it possible to give a user permissions only to a particular column in a table? Kim
  8. kimmer7389

    Active Directory

    Can you use Groups and Users from Active Directory for permissions to an Access Database? I know how to set up workgroups and permissions through Access but I was just wondering if you could pull the users in through Active Directory. Thanks Kim
  9. kimmer7389

    Tool Bars and Menus

    I am new to windows applications and C# both so please don't be to hard on me. I am designing a Windows application using C#. The main form has a file menu and a tool bar. I can open other forms from my file menu without any problems. I want to open forms from my tool bar using the same...
  10. kimmer7389

    WorkFlows

    I have built a workflow and a subwork flow. How would I take a form and all its data and pass it to the subworkflow? Would I need to build another form and another table for the subworkflow?
  11. kimmer7389

    Disable mouse scroll

    I would like to disable the mouse scroll on my Access forms. Does anyone know how to do this?
  12. kimmer7389

    Save Report to file and E-mail report from button on a Form

    On a form I have 2 buttons. I would like for the the first button to allow users to e-mail a report based on the ID number of the form. I would like for the other button to allow them to save a report based on the criteria of the form. This is the code I am trying to use to Save the report...
  13. kimmer7389

    Set all fields in a row to "grow"

    I have a report that has 6 fields in each row. I have borders set on all of the fields. The report is actually a checklist and I need to have the borders on each field. The problem is when one of the fields grow (expands) the other fields do not. The other fields are set to grow and I have...
  14. kimmer7389

    Lock a Record on an on click event

    I have a form and after a button is clicked I want only that record to lock so that it can not be edited. Is it possible to lock a record on an on click event on a button?
  15. kimmer7389

    How do you display a field on an After Update

    How do you display a field on an After Update? I have a combo box on a form and after I update it I want a check box field to display.
  16. kimmer7389

    Form Results to a .csv File

    We have 3 servers. Development, staging, and production. I created a form. I have it submitting the results to a .csv file using Frontpages web bots. I have read and write permissions set up on the directory where the .csv file is. The .csv file is in the same directory as the form...

Part and Inventory Search

Back
Top