Interface To Allow Users To Create Ad-hoc Queries

Oct 20, 2005

Hi All

I'd like to implement something in an app to allow users to create their own ad-hoc queries from a specific number of fields from specific tables, without allowing them full access to the query designer.

I can see how to do it (a form with code that creates the SQL), but I wondered if anyone had done something like this before and had any tips or even any existing code. Have searched and can't find anything, but I suspect I'm searching on the wrong keywords.

Dave

View Replies


ADVERTISEMENT

Data Entry Interface (Create New Record) Help

May 1, 2005

Could anyone of you give me some sugguestions on designing a nice/efficent Data Entry interface (Form design) for adding new records?:


I have bound a Form with a table and linked all the textbox with the relevant fields in the table. I created a add new record button through the wizard provided by MS-Access as: DoCmd.GoToRecord,, acNewRec.

While, each time when I opened that Data Entry Interface, the current always pointed to the first one rather than leaving the blank field for data entry. Even I changed the value in those textbox, the system didn't create a new record in the table at all, only modifying the first record.

I know how to write the VBA code to open table and add new records by retrieving data from the Form interface, but I wonder whether there is more efficent solution by combining the default function/facilities from MS-Access itself and some VBA code. Also, it can have some validation before storing data into the tables.

Many Thanks

View 1 Replies View Related

How To Create Users In Form

Apr 21, 2005

hey guys,

i just needed a guide on how to create a form with different users in it.

also, is there a way in which i can create a button that will open the wizard to create a report ??

[guess wat, no deadline.... but that doesn't mean dont answer ;) ]

hope a reply soon..

thanks in advance.

View 14 Replies View Related

Tables :: Create Log For Table To Capture Changes By Users

Mar 2, 2015

Is there a way of creating a log to capture changes in a table by users?

In a current database that I'm taking over, there was a lot of records deleted from the main table and now I need to figure out what happened.

So, if I would be able to have a log that records all the actions taken by users, I could at least see who did what.

View 13 Replies View Related

How To Create Users And Permission In MS Access 2010

Apr 29, 2013

how to add security features into My Access database. i.e create users with permissions/login.

View 1 Replies View Related

Forms :: Capture Users That Create And Edit The Records

Aug 27, 2013

What is the best way to capture the users that modify the records in the database?

Let us start from User Log-in Form After log-in, Main Form will open The main form has various menu (example Add Customer) Once I open the "Add Customer Form", I want to record the username in the Createdby/Editedby Field automatically.

View 5 Replies View Related

Forms :: Create A Form Which Allow Specific Users To Book A Seat At Football Match

Apr 4, 2014

I'm currently trying to create a form which allows the specific users to book a seat at a football match.

I've created all the relevant tables, but I'm struggling on how to interpret the data into them to make the form work. I am new to this sort of design, this design is currently for my university dissertation and I am struggling to get it completed in time.

I have attached my document below to show how far i have come.

View 1 Replies View Related

VB 6 Interface

Feb 17, 2007

is it possible touse visual basic 6 for example to create an interface for the finished access database so that I can create an install application for users that do nothave Access.

in other words, I want to have a standalone application through VB 6 that will manage the database application.

regards

View 1 Replies View Related

Web Interface

Mar 24, 2007

I need to develop an intranet site to allow not just read only but write access using either Access 2002 or 2007 (maybe). Does anyone have any advice to which is the best tool to use? I have Dream weaver MX already but I’m not that good with it, I have been looking at CodeCharge Studio 3.1 online Has anyone used it?

Thanks.
:)

View 2 Replies View Related

Interface

May 18, 2007

Hi People,

Another question,

My database is looking good now, but I have one question, I dont want users to view it as I do, i.e with all the wizards etc, so how do I create an interface which does not allow the user to view the backend?

View 1 Replies View Related

Interface

Oct 26, 2005

I want to create a form and connect it to a MS Access database.
Moreover I wish that whatever entries I make in the form they get transferred to the corresponding fields in the Access database.
Any link for a similar thread will be highly appreciated

View 1 Replies View Related

User Interface

May 16, 2006

Hi:

Is any way to modify the shape of a table, to make it a little more friendly for the users ??

Thanks for your support.

Nestor

View 1 Replies View Related

Using Access With A Web Interface

Jul 26, 2006

I want to use my browser to view/edit some data in a mdb file. Can someone point me in the right direction of what I need?

Thanks,

Dave

View 6 Replies View Related

External Interface Or API

Oct 24, 2007

Hi All,

I am not an Access developer so please forgive my ignorance!

We have a Quality Assurance (QA) database (Access 2003) that has a "Project" table.

Currently our QA person has to fill in project data (e.g., project name, project manager, start date, etc.) from within the Access database. I can automate this process by providing the project data from an external source.

Does Access have any integration capabilities which allows it to receive external data, like:

- a command line interface for doing SQL inserts (like isql.exe)
- a formal API

I see examples of ODBC use in the manuals, but they are from within Access to connect to an external DB. I want to connect and insert into Access from the external source.

Push into access versus pull into access.

TIA,
Matt

View 6 Replies View Related

Multilingual User Interface

Jul 12, 2007

I have just started a new job in Italy!! One of my projects is to create a database for the companies infomation. I have never used Access, and its in Italian, i have zero italian and im finding it difficult to start. Does any one know how do i activate Multilingual User Interface and does it come with all Microsoft Office software...does it have to be installed or is it installed automatically

View 5 Replies View Related

Interface Unresponsive After Running Query

Apr 3, 2012

I am executing a somewhat complex query. The query joins a local table to a third party linked VIEW table and then performs a crosstab transform to display the data in a meaningful way. I have a few other local table joins as well. The query takes about 5 seconds to run.

~20k records are displayed and the interface is COMPLETELY lagged/locked up. I click a record and access will start timing out. Scrolling down is nearly impossible... why would it still be unresponsive even after the query has finished executing?? isn't it just a result set and the interface should be fast?

View 2 Replies View Related

Wizard Style List Selection Interface

Aug 15, 2005

I would like to create a "wizard style" interface to allow users to Select items (staff members) by moving them from a list of "available" staff to a list of "selected" staff (and back again if they change their minds :rolleyes: ). - e.g. Like the Report Wizard, where you move table/query fields between the "Available Fields" and "Selected Fields" lists.

Does anyone have anything to help me out with this, that they could "lend" me ?

Of course I am stuck using AC97.... so I may need to borrow a hammer and chisel as well :D

View 1 Replies View Related

File Interface From Different Source To Access Database

May 12, 2013

We having this Human resource system that the company will be using however, the current payroll application will still be used as normal but the update will not be done on the same application.At the moment the current set up is that there a three database linked together that makes up the payroll application but for now one of this database will not be pupolated with data as it will now come from another source all together via extraction or file interface which is the new HR software.

The only problem I'm facing is some of those fields that i will need to transfer over to suit the current set up of the payroll application is not included on that new software file extract and i dont know where to start or what to do because abviously the file interface should consists of this mandatory field.Without seeing the relationship of what I'm talking about do you think its worth continuing this project as those wanted field are not included?And how can we go without these mandatory field?

View 1 Replies View Related

Users Want Ad Hoc Queries/reports

Jun 14, 2005

Hi,

How can I separate my application so the users can still use queries and reports on a db? I don't want them touching the tables or application directly so it looks like I need a way to create a separate application or something along those lines that is linked to the tables that the users want to query. Any suggestions?

Thanks,

scratch

View 11 Replies View Related

Serial Cash Drawer With Kick Back Interface

Nov 8, 2005

does anyone know how to get a serial cash drawer with kick back interface to open through Access?
any help or a point in the right direction will be hugely appreciated

View 2 Replies View Related

General :: Creating User Interface For Internal Database?

Apr 15, 2014

I am looking to design and create a user interface for my database. Preferably hiding the standard access interface and upon opening the database have a pop up form with buttons to direct users to forms queries.

View 3 Replies View Related

How To Control Tables Added To Relationship Layout Interface

Feb 12, 2012

Have a look in the attached screenshots

I'm wondering why the relationship interface is still missing many tools that perform the work more efficiently. The interface misses the following (comparing with what we have in the ArcGIS software)

1. Pan tool
2. Zoom in/out too
3. Zoom all tool
4. Automatic arrangement

View 2 Replies View Related

Prevent Users Accessing Queries

Oct 4, 2005

Hi,

I have an Access 2000 database and I have hidden the database window in the startup options. I have also saved the database as a .mde file.

However, if a user opens the database while pressing the shift key they can still get access to the queries and tables in the database and can change them.

Is there anyway to prevent users getting access to the tables and queries?

Thanks

View 2 Replies View Related

Stop Users Using Tables In New Queries

Apr 27, 2007

Hello all,
I am setting up an access 2003 database in a Client/Server configuration. All dat entry is done through queries, forms are not used. I am wondering if it's possible to prevent users in the client database (Or a copy of it) from creating new queries that hang of the linked tables. I want them to hang new queries only from existing queries. This way I can be sure that what they see is always appropriatley filtered. Any ideas?

View 3 Replies View Related

Users Can Access Database But No Queries Or Buttons

Mar 20, 2006

I have an access database that is used as a front-end application to a sql server 2000 database. Users have adequate permissions to access database and functionalities but a few are receiving the following error message:

"Connection Failed. Invalid connection string attribute."

View 4 Replies View Related

Hidding Tables, Queries, Forms, From Users

Dec 7, 2004

Hi. I manage to create Users and permissions with no big problem.
But before do that, i thought that when i created those permissions some of the users which they will
work for, they will not have even a view of TABLES QUERIES FORMS e.t.c
How i can hide that from them?
I did that by Properties and set the option button to Hidden, but imagine if you have 50 to do that.
Then if i go back to do some modifications then is necessary to unhide in order to check.
Is another easiest way of prohibiting users to view.
Thank you.

View 1 Replies View Related







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