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.
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.
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.
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.
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.
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?
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?
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
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.
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
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?
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
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?
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?
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
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.
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
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?
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?
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:
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.