Search results

  1. F

    Show where count = zero

    Have developed an Access dB for logging and reporting on support issues. The following query is used to show how many issues are raised in a specified time period. SELECT ISSUES_BY_SYSTEM_AREA.report_category, Count(*) AS instances FROM ISSUES_BY_SYSTEM_AREA GROUP BY...
  2. F

    Both text and icon on a command button

    How do you make both the text and the icon visible on a command button? If the 'Picture' propery is set, I can't see the text.
  3. F

    Enter current date and time

    How do you automatically populate (a) field(s) with the current date and time when a new record is created?
  4. F

    How to record the OS username

    How do you get Access to pick up th OS username currently logged in to the database? For example I'm logged on to the PC as FLESTER and I wnat that recorded in the dB.
  5. F

    Record OS username

    Have developed a support database in Access. I need the dB to automatically pick up the username of the user logged on to the PC. Thus if I'm logged on to the PC as FLESTER, this username wil populate a database field. Any ideas?
  6. F

    Link a Textbox to a Combo Box

    Developing a dB to log support calls. Main form has a combobox where user's name is selected. I want to add a text box which will automatically show the user's company when name selected. Control source for Combo contains tblUsers.name I want txtCompany to automatically show tblUsers.Company...
Back
Top Bottom