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 dencom 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: jreynold
  • Content: Threads
  • Order by date
  1. jreynold

    trouble with tables

    I am rebuilding a database for my small construction company. I did the initial design of it but it has been a while since I have worked on it. I am having trouble wrapping my head around the following issue. I've read and reread the article by Paul Litwin, "Fundamentals of Relational...
  2. jreynold

    creating folder with permissions

    I want to use access to kind of keep my files organized. I own a contracting company, each project has a folder, each "job folder" has a folder in it called "admin", that only specific users on the server can access. Two questions, is there a way to create a folder with permissions already in...
  3. jreynold

    Filter code slow & an error

    I apologize in advance for the ridiculous length of this post, but i figure the more info the merrier! Okay, I have a continuous form that I am trying to upgrade to include an unbound textbox which will filter the records in an "As you type" format. I tried using Allen Browne's coding, but...
  4. jreynold

    same event on lots of fields

    I have a continuous form [ProjectList] with 16 different fields on it. I would like to be able to double click on any of the fields and open a tabbed single form to a particular tab. I have code to do that below. What I am wondering is what is the best way to repeat the same event for lots...
  5. jreynold

    All Code is gone

    [sad] So i've been working on this database MSaccess 2003 and all my code disappeared. Gone. No modules, no class objects, there is nothing left. I was working on a form, closed it, opened it back up and poof, no buttons worked. They didn't work because the code had instantly disappeared...
  6. jreynold

    Open Hyperlink with default browser?

    I have a user who wants a button to open a link in Firefox (His default internet browser) rather then IE. The code for my button control is below, and is pretty handy. It creates a url for google maps for a location when given the address, state and zip code. Private Sub MapItButton_Click()...
  7. jreynold

    Data "flashing" when cursor over label

    I have a form with three sections. I labeled each section with an unassociated label Project Information: Project Status: Project Notes: The labels are for ease of viewing purposes only. When the form is viewed in "Form View" all the controls showing data flashes for a split second. It does...
  8. jreynold

    Lots of If..Then's

    I'm writing a sub to filter the results on a form. Right now I have two filters, but would like to add more and am unsure of the best way to continue. I want to add combo boxes for 5 more filters. This is going to turn into a lot of nested if statements if I continue going like I am...
  9. jreynold

    Hiding Sensitive Data

    I'm stuck.... I'm expanding my company's database to include some sensitive information that I do not want all users to have access to. I want to have one form that both the non admins and admins can use. Admins would see all the data and non admins would just see an XXXX or something in...
  10. jreynold

    Multiple Users Issues

    Probably something pretty simple, but looking through the forum and my "Access for Dummies" bok isn't helping. I have a database on a network drive. We have a total of 2 users, soon to be 4, and do not log in, everyone looks at the same tables and forms. If I have the db open, the other user...
  11. jreynold

    Employee table --> 2 fields in Project Table

    As you will gather by my question, I'm a newbie trying to create a database for my company. We are a contracting firm and have many projects and many employees. I have an Employee table with each employee and information. EMPid(pk) EMPfirstname EMPlastname I have a Project table with each...

Part and Inventory Search

Back
Top