General Access

Oct 6, 2006

Alright I have two tables, one is a user table, the other is one that holds the users roles. A user can have multiple different roles (up to 9). If you do a regular join on the tables you will get one that shows all the user information repeated each time for the number of roles they have. What I would like to do is design a form or something where the user can specify which role (1-9) they are interested in and the system will display all the users with that role. So for example show me the users that only have role 1 and no other role. I did this manually for one role by the following
1) Joining the two tables.
2) Setting a count to see which users have more then 1 role.
3) Eliminate any users the had more then 1 role.
4) Specify which role I want to display.

So is their some type of front end I can create where the user can specify what role they want to filter for with and without the exclusive roles?

View Replies


ADVERTISEMENT

General :: Only Open MS Access Form Without Access Running In Background?

Aug 7, 2013

I have made a form on access which will be used by other employees within the company, however they have never used access before and they are wanting to access only just the form as I feel with Access and all the tools in the background will confuse them, plus I don't want them editing the data base its self.

Is there a way to only bring up the form, unless I obviously need to edit the date base.

I've done some research on Google and it seems I need to use:

SW_SHOWMINNOACTIVE

However I can not seem to find how I would use this or where?

and also if i did find a way to only bring up the form, how would I be able to switch it from that veiw to the veiw I edit in?

View 2 Replies View Related

General :: Access 2010 And Access 2003 On Same Desktop?

Mar 5, 2013

is there a way to have both Access 2010 and 2003 exist peacefully on the same desktop. My company uses Office 2010, but my department has an Access 2003 application. As a result, I have to have A2003 on my desktop and use it quite frequently for this one application.

I have some small databases that I really want to move onto A2010 so we can take advantage of SharePoint functions, etc. Is there anytning I can do to be sure that the .mdb and .mde open in A2003 and the new .accdb opens in A2010, without getting errors and the Windows installer going through the Office installation process for the respective version? I've gone to the file locations and set the "Open with" setting to the respective version.

View 4 Replies View Related

General :: How To Lock Access DB

Jun 6, 2014

how to lock access DB Tables ,Queries, Report so other's can not import them to other access database (without encrypting my database with password ).I've noticed when forms have VBA codes it cant be imported if they locked by password(VBA) !

View 7 Replies View Related

General :: Access Db Conversion

Oct 29, 2014

What steps do I need to take in order to convert a 2007 database into a 2010 database

View 4 Replies View Related

General :: Using MS Access To Control SAP?

Mar 6, 2014

I am trying to write a code that will run through one of my tables and copy a value from that table and then open SAP and run a search of the value, then save an excel copy of the results of the search, and repeat for each value in the table.

I am not asking for the code for the entire thing, just the code to access SAP similar to the way you open up other applications like internet explorer.

View 2 Replies View Related

General :: Send SMS From Access

Apr 10, 2014

how send SMS to phone by using text from access form.

View 3 Replies View Related

General Question About Access 2007

Feb 5, 2008

I have a database that works fine on access 2000. The problem is that when I open it in Access 2007 the switchboard does not display correctly and my command buttons do not work. Also, my field that autofill from a combo box do not fill in. I am assuming that access 2007 does not recognize the code for all of these. If this is the problem does anyone know of a reference that can be used to change the code to work.

Also, thought I would mention that I opened it in Windows Vista. I have read about problems with Vista. I have not tried opening the database on a computer running XP.

Just wanting to get working now in case my company changes over to Office 2007 in the future.

Thanks for any info.

View 6 Replies View Related

General :: Importing Text Into Access

Apr 17, 2013

creating a import form into access.File format is txt (tab delimited)

Ideally I need:
- a box to enter the file name
- a box to enter the path
- a import button to push

I have seem some comments saying you have to creat a transfer text.However I have no knowlegde of Coding, opening or closing statments..

View 1 Replies View Related

General :: Pictures For Access Database?

Jul 2, 2012

Where I can get some better pictures for my access database. The standard ones are really not all that great. I am looking for a stock pile of pics that I can place in my files so that I can draw upon them whenever I am designing my database.

I just havent had much luck designing buttons in GIMP.

View 3 Replies View Related

General :: Automatically Add A Checklist To MS Access

Apr 21, 2014

I have done 5 videos (total running time -about half an hour) demonstrating how to add a checklist to MS Access.Here is a link to a YouTube Play List of the 5 Videos..Automatically add a Checklist to MS Access

View 7 Replies View Related

General :: XSL Transform Only Allows Access To Import Last XML Value

Dec 10, 2012

I'm trying to import an XML file into my access database using an XSL Transform (I only need certain bits of data), however when I import the tables and field names come through fine now but the only values that come through are the last values listed in the XML file... for instance when i import high there would be 10 high values but only the last one comes through.I would obviously like the "Day" field to be a date/time field in access, and the high and low to be a number field in access... but this is back-burner to solving the real issue listed up top.This is my XSL file:

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="Transform Link (I don't have 10 posts yet and can't post links)">
<xsl:template match="/">
<Weather>
<xsl:for-each select="response/forecast/simpleforecast/forecastdays/forecastday">

[code]...

View 2 Replies View Related

General :: Copying From Excel To Access

Jul 10, 2015

I have a field in a table that we copy the text from an email into so they can be associated with a client. These could be many paragraphs.

All is fine when I copy right from the email in Outlook into the field in Access. The email is copied exactly as it looks.

To make my life "easier" I do multiple at a time by copying the info into Excel and the copying multiple records into the Access table at once. Saves me having to keep searching for what client the record should be attached to.

But when I do this second method the email in the Access field looks like one big long sentence. Kind of makes it difficult to read at a glance.

I copied the data out of the Access field and into word to check if the returns were still there. They were.

I'm guessing that it has something to do with when I copy it into Excel the individual lines are no longer returns but line breaks. And then Access gets confused.

If not, I'll just instead of putting them in Excel I'll put them directly in Access from now on.

View 11 Replies View Related

General :: Importing 850 Fields Into Access?

May 24, 2013

How would I go about importing 850 fields into access (Multiple tables) with its 250 field maximum?

View 8 Replies View Related

General :: Implement Pop-up Reminder From Within Access

Oct 26, 2012

I'd like to know how to implement a pop-reminder that runs reminding the user of the database of :

1. some to-do actions for the current day or, for example, a week ahead of a certain event, that is related to some date previously entered in a table.

2. this should be within the access database.

3. I saw something like that in the [URL]... website, but actually couldn't understand it.

View 12 Replies View Related

General :: Way To Create A Audit Log In Access?

Dec 14, 2012

Is their a way to create a audit log in access?I have a log-in screen on my db and every time a user logs in i want it to be recorded. is their away to do it?

View 14 Replies View Related

General :: Lotus Approach To Access

Jan 22, 2013

Is there an easy way to import a Lotus Approach DB back end and front end to Access 2010?

View 5 Replies View Related

General :: AUTOFIT Columns In Access?

Apr 7, 2014

How to AUTOFIT columns in Access (2013) ...

View 1 Replies View Related

General :: Open Accdb Without MS Access?

Aug 14, 2012

I have MS Access on my PC however wish to move the accdb file to a network location to allow other network users to have access to it.

Unfortunately a few of the other users do not have MS Access. Is it possible for them to still open the database without any admin or background - I would like them to be able to use the forms and 'front end'.

View 3 Replies View Related

General :: Link Access To Word

Apr 8, 2013

If I have a link setup from an access 2010 table to a word 2010 document, is there a way to export the hyperlink address in the table to word as an executable link. Rather than having to insert the link manually as a hyperlink.

View 1 Replies View Related

General :: Getting Access To Search In All Fields

Feb 1, 2014

I'm using the Access Find command from the ribbon.

Problem is Access searches only the field that has the focus.

I must first click on the field and then use Find.

Any way to get Access to utilize Find to look in all fields?

I have set General search in the options.

View 8 Replies View Related

General :: Lock A Table In MS Access?

Aug 29, 2014

Is it possible to lock a table/macros/forms/reports in MS Access?

View 3 Replies View Related

General :: Printing Reports To PDF Access Only

Jun 30, 2014

I have limited users to not show the ribbon, but I need them to be able to print of reports or export them as pdf files how do I give them access only to do this ?

View 3 Replies View Related

General :: How To Set Up Access Database As Back-end Only

Aug 8, 2015

I plan on using Excel as the front-end and Access as the back-end only. (all queries and forms are in Excel). A single Access database will be queried from multiple Excel files that will be located on the share drive (Linux server). Access tables contain memo, text and number fields. Data will be sent to Access tables and records will be appended/deleted; all via Excel.

There will be multiple users interacting with a single Access database via multiple Excel files located on the shared drive. Users will be interacting from different workstations with Windows 7, all have Access 2010 and Excel 2010 installed.

This process works for me from my workstation but I am not sure what will happen when other 4 people will be sending/appending/deleting records to the same Database? How do I make this work? What settings do I need to check in Access to make this possible?

View 6 Replies View Related

General :: Communicating Between Different Access Databases

Jul 31, 2014

I have an access db as the backend with the tables. Then multiple front end access dbs that link to the tables (as external sources). The front end dbs are setup with different forms on a per user basis, depending on their role. From my user db I want to be able to request information from another user. I want something in their db to pop-up and request the information.

I was thinking about approaching it using the datamacros. I thought maybe each front end db could have a messages table that the main db and other front ends link to. Then whenever they add data to your specific table it would respond and ask the user for the information. The info would then populate back into the message table where it could be retrieved by the requester.

Example: User A opens A.accdb and has a table called A_tbl. User B opens B.accdb and has a link to A.accdb.A_tbl. User B adds a record to A.accdb.A_tbl with Field1 = "what is your name". User A receives a pop-up with the info from Field1 and responds in a textbox for Field2. User B can then look at A.accdb.A_tbl and see the response as Field2.

Another option I thought of was simply trying to get one db to run a form/macro on another db remotely.

Example: User A opens A.accdb and User B opens B.accdb. User A clicks a button on one of his forms and it opens B.accdb.FORM in the session of User B. User B fills out the form and submits. User A retrieves data from shared tables as normal.

View 2 Replies View Related

General :: How To Store PDF File In MS Access

Jul 6, 2013

how could I store files such as PDF inside MS access.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved