I've been struggling with a statement I want to create so it can eliminate manual work. I've had to create an audit database. I have the following fields:
Customer
Ops Center (combo box if that matters where the user can choose Global or North America - I might add more at a later date)
North...
I need help identifying the best way to get the results I need. I have a table: it has a field labeled Customer Location and another field labeled Support Location. Basically we want our users to be prompted for the Customer Location and then it finds the match in the table to pull up the...
I created several data access pages and linked to them through our intranet and they were working fine until recently. Now when a user clicks the link all the text pops up; however, the the standard graphics (like the next arrows to move to a new record, sort descending, etc) show as a big X -...
Okay I think I have gone backwards. I have a table with the following fields:
TABLE
Customer
Region - (drop down with canada, north central, west, east, etc.)
Status - (drop down with win, loss, pending decision, etc).
Writer
Comments
(Other informational fields)
REPORT!
What I did was create...
Recently we created several Data Access Pages and posted them on the intranet. However, not everyone has Access installed on their computer. Is there anyway they can view the data access page (page.htm) information without access installed?
I think I may have gotten myself in a bind here. I had done FE and BE security and placed on the shared drive. However, my wrkgroup file and FE shortcut got deleted (my own fault). But there still is one file which I believe to be the original database (.mdb)...but when I open it I get the...
Okay I have split my database into FE and BE (after several attempts before getting it right). I have the FE on the server but am told that it WILL become corrupt. There are several locations and several hundred people so I can't possibly put a shortcut on each persons pc. What do I do? I...
I have finally finished building my database. The problem I have encounterd is security. I seem to get it all right with the different users and their permissions. When I open the file I am prompted for my password and can login. I keep this database on the shared drive. However, when my...
I have a table that contains data people inputed. Some people didn't answer the question. When I run my report there is a blank space where no answer exists. I have set the property of the box to Yes on Can Shrink and did the same for the Detail Header. Blank lines still exist - what am I...
We have a dilemma here. A table was created with all fields and data types we wanted. However, we are at the point of just now wanting to import the information (started backwards)...the problem is the excel spreadsheet doesn't contain the same type of columns as the new access table created...
I have several drop down menus on a form. However, when a user goes to enter a new record the previous entries on the drop down menus are defaulting. I want the drop downs to reset to a blank value for each new record. Any ideas? From reading somewhat similar posts I have a feeling it will...
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.