Search results

  1. D

    Need help to speed up my text import

    I have a big messy text file that I need to import and extract information from to go in to two tables. These are our mainframe security access rules and I need to compile the information from this file in to a database so that I can see who owns and has access to what screens. The file is...
  2. D

    Reliability

    We are developing an Access 2002 database that is going to be used as a problem tracker for technical system issues. It will be used by about 20-30 people. At normal levels, about 7-10 people will be actively using it. The database will be stored on a Novell shared server. The tables will be...
  3. D

    Help on table structure

    I am doing a database that keeps track of mainframe security access. If someone goes to a certain screen on our mainframe, their ID must pass verification on some behind-the-scenes access "rules". I am documenting what each rule does, what mainframe system the rules are for, and what rules are...
  4. D

    Need help to shorten a query

    I have a lot of "Or"s in my query. I know there must be an easier way to write this, but I'm too new to this stuff. I was able to save the query, but now I can't go back in to design view because it says I have exceeded the 1024 character limit. It just takes me to the SQL code (see below)...
  5. D

    Table structure

    I'm trying to import a messy text file in to a table so that I can run queries. How should I cleanup and organize my table? The information is a data security report that shows what kind of mainframe access each area in the company can have. When I import the file, it comes in as one column...
  6. D

    Delete a record if certain text is not found

    I want to cleanup a table by searching record by record for the text "HGIO". The text may be inbedded within other text. If it is there, go to the next record, if not, delete the record. I'm new to VBA in the Access environment, so any help is appreciated. Running Access2002. Thanks This...
  7. D

    Turning off alerts

    I have a macro that runs some delete and append queries and I want to know how to turn off the message boxes when it asks you if you "are sure you want to delete...." I know how to do it in Excel VBA, but I can't find the equivalent in Access. Thanks.
  8. D

    elapsed time in hours

    How do I format the elapsed time between two Date/Time fields? The hours will only go from 0-23 but I want it also to display hours greater than 23. What are my options? TIA
  9. D

    Need help with code on Access 2002

    I've been used to Access 97 and just went to Access 2002 and need some help on a basic issue. I'm trying to create and open a recordset, but I'm getting errors. Here's the partial code. Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("Holidays", dbOpenDynaset) These are the...
  10. D

    Displaying a table based on a value chosen in a combo box

    I don't have experience in Access, but I'm trying to learn. I would like to be able to display the records of a table on a form. I have a combo box to choose which table I want to display, but I am not sure where to go from there. Please step me through the process. Thanks in advance. Let...
  11. D

    Simple Delete Query

    I'm an Access newbie. I have two tables that have a one-to-one relationship. What I want to do is delete all records from Table 2 where the first field is present in Table 1. So in Table 1, I have an employee number listed. I want to delete the entire record in Table 2 with the corresponding...
  12. D

    Filtering records

    Access rookie. I want to run a query that filters records. Basically I have a field in a table that has text records. Some have a format of E#####, or C######, (an E or a C, followed by 5 numbers) while others have random formatting and lengths. I want to have my query only show the records...
Back
Top Bottom