Search results

  1. T

    Code Newbie

    I am working on a database that I didn't create. I was asked to create a report which I though wasn't a big deal. However the database is setup completely different then what I am used to and everything is written in code. What I have so far is the end user choses a Quarter date, either 1, 2, 3...
  2. T

    How to edit a Macro?

    I created two data macros in Access 2013. I created these Macros by having my table open and then I went to the ribbon and selected Table. I then used the AfterInsert. The first Macro was an AfterInsert Macro, and the second was an AfterUpdate Marco. I closed out of them and thought I could...
  3. T

    Textbook error?

    I am adjunct currently teaching Intro to Databases. An example in the text books for creating new views in SQL in Access 2013 is as follows CREATE VIEW Games AS SELECT ItemNum, Description, OnHand, Price FROM ITEM WHERE Category='GME' When I run the query it gives me a syntax error in the...
  4. T

    Archiving Data from Multiple Tables

    I have a database with employees. The tables are as follows: Deptdatatble Depttble Emptble HRtble Servicetble Servicedatatble Archivetble Classestble Classdatatble At certain times, I want to archive employees out (lets say they are terminated). When I do this, something strange happens. If an...
  5. T

    Archiving Data

    I have a database with 14 tables. Periodically, (like once a year) we like to archive the data into an archive table (within the same database). This works well if the person we are archiving has data in the main related table. However, the issue I am running into is if we have an employee that...
  6. T

    Sort not holding

    I have a an unbound field that allows me to search for an employee. I would like the drop down list to be alphbetized, however, it doesn't hold the sort. I have completed the following steps. 1. Right clicked on the unbound field 2. Selected property sheet 3. Selected row source (which brings...
  7. T

    Can't edit a Group by Query

    I have a query where I group by EmpID, so duplicates do not show up. In this query I have two fields with no data. These fields are to be filled in after the query is run in a form. However, these fields are not editable due to the group by feature. Any work arounds for this? I tried two...
  8. T

    Set source of Control Box to Subform

    I have a subform called DD subform I have an unbound combo box named Target How to I set the control source of Target to reflect my DD subform? In control source, my only choices are the fields related to the subform, not the subform itself.
  9. T

    Report asking to enter a parameter value

    I am running a report but it is asking me to enter a parameter value. Can anyone tell me what is going on? When I go to debug it takes me to the bolded line. That is what my report is called. Thanks in advance to any help you can give. Private Sub Command12_Click() Dim res As Recordset Dim...
  10. T

    Pulling out my hair! Help with creating macro

    I am updating a database from Access 1995 (yes) to Access 2007. Due to the macro and calculated fields, I can not update this database to 2000, then to 2003, then to 2007. It simply won't update. So I am re-creating the database. I have a form that takes the results from option buttons (which...
  11. T

    Sort not holding in form combined field

    I have a field on a form called ChemID. This field is made up of two fields, ChemID and ChemName. Only ChemName is displayed. I have a query assoicated with the form that sorts by ChemName; however, the form always displays the original sort of ChemID. Any help would be appreciated. Here is the...
Top Bottom