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...
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...
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...
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...
[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...
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()...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.