Search results

I am using the notinlist event to ask the user if they would like to add new info into the underlaying table. If they do, it opens the form based on the underlaying table. My issue is i would really like to pass the contents of the combo box to the new form via openargs. I have read many...

Hello all, I have been tasked to create a database to track tooling information for my company. I have a solid idea on the process involved and would like some help getting my tables and relationships setup with normalization. I have noticed in the short time I have been learning access that...

I am trying to create a small database to handle tool work orders for our shop. Currently the sum and totals are giving me grief. I am a neophyte with this so bear with me. I have two tables, the first keeps the infomation regarding the work order. The second holds information regarding the...

I have a form that is based from a user input querie. I want it to check to see if the value that was entered by the user already exists in the table, then hide certain fields on the form before it opens. Does anyone have a solid solution to this? I have tried to trap out the querie [Enter...

I have a db with low level security (A table contains a username, password and access level). The database startsup with the login form and asks the user for the input. I would like to know if it is possible (if so where to start) to hide and/or restrict users based on the value of the access...

I would like to know if it is possible to open a pdf file from access in the following way. I have a form that contains and shows a 6 digit number. This number refers to a pdf file in a certain location. I would like to add a button on the form to "view" the pdf, instead of making the user...

I have a simple query that uses IIf to display what I need. Is there anyway to use say a toupper cmd like you when you put > in the format tab? Here is the query statement: SELECT IIf(Left([tblProject]![Tool#],2)="LA",[tblProject]![Tool#],"") AS [Tool#] FROM tblProject WHERE...

In the attached db I wanted to create several relationships between tables. After doing this, it created a table_1 table to show the links. Is this normal?

Subform linked to Main form (Help) Hello, I recently was introduced to access 2000 and have created an Engineer Change Request tracking database. I have one problem though, I cannot seem to have my subforms display only the relavant information that should be passed from the main form. Both...