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
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
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
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
Apr 29, 2013
how to add security features into My Access database. i.e create users with permissions/login.
View 1 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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