General :: Allow Users To Do Ad-hoc Query On Data In A Table
Apr 3, 2013
I have a form that I've created to allow users to do a ad-hoc query on data in a table. Most of the fields are setup as
Code:
Like [Forms]![Unusual Login Research]![CustomerName] & "*"
where I have a drop-down box with options for: >, <, >=, <= and between. I've tried a bunch of iterations of the same criteria and keep getting the error above. Just as a test, i was trying to at least get the between option to work with the following:
Code:
[Forms]![Unusual Login Research]![ScoreAtLoginCriteria]+" "+[Forms]![Unusual Login Research]![ScoreAtLogin1] And [Forms]![Unusual Login Research]![ScoreAtLogin2]
Where ScoreAtLoginCriteria is the drop-down, set to "between" and ScoreAtLogin1 and ScoreAtLogin2 are integers.
View Replies
ADVERTISEMENT
Jul 6, 2015
I have an Access database which has a linked table to a CSV file.Only one user can use this part of the database that links to the CSV - for other users we get the error 3051 - opened exclusively by another user. How can the csv file be a linked table with multiple users ? The query itself is set to no locks.
View 5 Replies
View Related
Mar 12, 2014
My department and limited the users to only specific tables based on their need and role. However, users have expressed the need to view past work. I do not want to give them access to the table - I am thinking that there should be a way to create a report that shows the data, but how would I set up a search filter option so they can find the one record that they are looking for?
View 2 Replies
View Related
May 15, 2013
I want to create a form where by the user can select the fields he requires and the table is created.
Example: I have a table of subjects like maths, english, french, chemistry etc,
The user can choose what subjects are available in that particular school and therefore a table is created based on the chosen subjects.
Is there any way it can be done even with vba?
View 4 Replies
View Related
Dec 28, 2012
I am trying to accomplish this in a macro. I know I was able to do this in older versions of access.I want to get data from a query and paste and append into a table. When I started to design the macro this is far as I got:
Qry Name: GetData
Table Name Storedata
Macro:
1st OpenQuery
Query Name: GetData
View: Datasheet
[code]...
The ? marks I cannot find any options in the macro actions catalog.
View 6 Replies
View Related
Jul 20, 2012
Exporting data from a table or query, into Word 2010?
I've googled the crap out of it and the only thing I can find is mail merge...which as far as I can tell is used for creating letters and mailling lables or emails.
What I would like to do is click a command button on an invoice which would export company name, province and date, into an existing word template, save it as a new filename, and then close.
View 1 Replies
View Related
Feb 21, 2006
Hi,
I have a table of users somthing like this:
User_ID
Name
Hobby
Favorite_Food
Blah
Blah
Blah
Users can be friends with one another and I need some way of logging this.
My 2 options (that i can see) are:
1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so:
User_ID: 001
Name: John
Hobby: Frizbee
Favorite_Food: Cake
Friends: 002,004,010
2) Making a seperate table with multiple entries for each user like so:
User: 001
Friend 002
---
User: 001
Friend: 004
---
User: 001
Friend: 010
---
User: 002
Friend: 001
---
User: 004
Friend: 001
---
User: 010
Friend: 001
---
The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's.
But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.
My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.
Thanks.
View 1 Replies
View Related
Dec 31, 2013
I have a TABLE with the following data:
- EMPID
- LASTNAME
I have a form with the folliwing data:
- text box for user to enter EMPID, txtEMPID
- LASTNAME
I would like to create a button to initiate a query to do the following:
- once the user enters a EMPID in the form, it will search in the TABLE under the EMPID field...
- if the user enters an EMPID that is in the TABLE...display "Y"
- if the user enters an EMPID that is NOT in the table...display "N"
- a error message box needs to pop up if "Y" to alert the user that "the EMPID already exists and that duplicate entries are not allowed"
One of my main questions is how do I run a query based on the users input and search a table? would the following work in the query?
View 7 Replies
View Related
Apr 22, 2013
I am fairly new to Access and I would like to create a form to allow users to create their own query. I would like to allow users to select multiple fields (perhaps with checkboxes?) from all possible fields in a table to return either all data from that field or narrow their search by inputting certain criteria or choosing from a drop down into a text box. Is this possible in Access and any detailed specifics on how to achieve this?
View 3 Replies
View Related
Jan 5, 2013
My question is this: I have a table where I'm entering employees' hours worked. Basically, it's something like this:
ID WorkerNumberDateworkedTimeStartTimeEnded
121/2/201310:00:00 AM3:00:00 PM
221/3/20132:00:00 AM11:00:00 AM
321/4/201312:15:00 AM11:30:00 AM
421/5/201310:25:00 PM11:00:00 AM
531/2/201311:00:00 AM3:30:00 PM
631/3/201312:00:00 PM10:00:00 PM
731/10/20137:00:00 AM4:00:00 PM
I have a query that (easily) determines how many hours an employee has worked on any given day. What I can't figure out at all, is how to write a query that can figure out how much time an employee had off in between shifts.
Thus far I'm able to run a query that separates this main table into individual workers by their id numbers, but can't figure out how to determine time off between shifts - as the last hour worked one day, and the first hour worked the next day are on two different lines (they are two different table entries).
View 4 Replies
View Related
Jan 29, 2015
When I try to transfer (ctrl c + v) data from a table in Excel to a table in Access it loses format.
Exemple: $ 1.000,00 (Excel) become 1000 (Access).
I need to keep the format to make sure that the code works properly.
View 9 Replies
View Related
Jan 13, 2014
I have an MS Access accdb with linked SQL Server 2012 ODBC tables. I am working on a procedure to copy data from local tables to these linked tables (identical schema). I did a simple
Code:
DoCmd.RunSQL "INSERT INTO linkedTable SELECT * FROM localTable"
This works, but is very slow. Way too slow. (INSERT copies the data one record at a time).
I would like to copy the data in a bulk operation, or operations that I can execute programmatically.
View 1 Replies
View Related
Aug 17, 2012
I have one DB that is used for creating/storing customer ID's, and another DB that is used for creating/storing job information for customers.I have linked the table from the customer DB to the job DB.
There is a table in the job database that holds customer name and ID, and some VBA that generates unique job codes.
Is it possible to have the data from the linked table automatically update into the existing table?
View 1 Replies
View Related
Aug 24, 2014
I have to import a file from an external website into a table (tableA) that I have established. The issue is that I don't need all that data, just specific ones (the website does not allow me to select the specific data to export). I created another table (tableB) to capture the data that I require for my report.
How do I take raw data from tableA to append to tableB the required fields that I want?
View 3 Replies
View Related
Oct 25, 2012
I am trying to implement a username and password system on my DB. What I have done so far is created a table with username, password, permission level and datestamp. So when the db is opened, the form pops up and someone has to sign in. When they hit the 'login' button, there is a field that will populate the time in which they signed in. This will also allow me to see who is logged in. When they are finished, they will end up on the login screen where there is a close button. When they hit the close button, the field with the datestamp will be cleared. This will allow me to know that the user is no longer on the db. Here comes the question, if a user just closes access without hitting my 'close' button, my datestamp field will not be cleared. I have tried using the "onclose" event, but of course i used 'me.datestamp = "" but the form is already closed, so it says 'can not change the value of this field.' How can i clear the value of the datestamp field for a specific user when a user closes the program the "improper" way.
View 3 Replies
View Related
Jul 3, 2012
I am new to MS access. I need to know - how to set authentications to different users. i.e. i have made a switchboard containing login form, and other forms of the database. all i want is to restrict user from accessing my main tables of DB.
When someone wants to enter data, he/she can use switchboard but with the restrictions not to see anything else. only administrator or people with user ID and password can have access to entire DB.
View 3 Replies
View Related
Aug 4, 2013
The database: is for tracking computer issues (this part is complete), also I need to show the on call roster (mostly complete)... This will also have a time sheet that I need to be completed once a fortnight, however I would like it to auto populate the staff members logged information (I will get into that a little later).
Question 1: I do not want the users to log into the database, however I do want the database recognise who they are from their windows logon details.
View 8 Replies
View Related
Jun 14, 2013
I have developed a new database using Access 2003, which I need to roll out across various users. Some have XP, some Windows 7, and each of them has different size screens. I guess I will have to adjust the various forms to size to a particular users screen resolutions and sizes.
Is there any way of doing this within the database itself, or do I have have to adjust each form according to the local users PC specification?
View 4 Replies
View Related
Aug 12, 2013
Currently the system where I work is set up so that everyone has their own front end on the local network. I would like to change this because updating all of them takes a lot of time for me and skill level for users is too low for me to trust them with updating it on there own.
My question is this:
If I were to create a shortcut on everyone's desktop that linked to one front end would this be wise? I can't seem to get a straight answer from anywhere on the internet. I know most places say that it is better to have the actual front end on the staffs computer but that would make my job of keeping the database updated even worse because staff have multiple computers and this isn't my full time job.
If this is okay practice how many users would this be able to sustain? Currently we only have 6 users on the database with there own front end and it works great. I am planning on adding around 10 more users in the future but if needed they could have there own database as they are separate programs.
View 14 Replies
View Related
Jun 1, 2015
I used to have a handy tool called LDB Viewer or something like that with which I could see who is using my database. Now I've upgraded to MS 2010 is there a way to do the same?
View 10 Replies
View Related
Jun 26, 2014
i am having issues with certain users re references, I get weird errors when sending emails through Outlook, is there anyway running some code for me to check a users references?the below is what i have and everything works fine, so would like to check they have these
Visual Basic For Applications
Microsoft Access 14.0 Object Libary
OLE Automation
Microsoft Outlook 14.0 Object Libary
Microsoft Office 14.0 Access Database Engine Object
Microsoft Office 14.0 Object Libary
Mictosoft ActiveX Data Objects 2.5 Libary
Microsoft Excel 14.0 Object Libery
Microsoft visual Basic for Applications Extensibility 5.3
Redemption Outlook and MAPI Com Libary
Windows Script Host Object Model
View 1 Replies
View Related
Dec 4, 2014
I made an access 2013 application. I want to sell licences per users. How can I know how many users are connected in the database ?
Is there an easy way to know that?
View 5 Replies
View Related
Feb 3, 2015
I'm an absolute novice at Access. I have a very simple (yet sufficient) database that lists our company's projects, tasks associated with those projects and when to invoice.
Our company consists of myself and my business partner. We both work from our (separate) homes. Our project files are stored in the cloud. This works well. We have investigated a server in the past, but found it to be cost-prohibitive and unnecessary for our business.
Is there a way that my business partner can have the Access database running at the same time as me, and make additions/modifications? I don't know how this would work in terms of updating/saving.
View 2 Replies
View Related
Dec 9, 2013
I know that Access probably permits around 20 or so users to simultaneously access the database before it start to become unfriendly. However, I have a database that would require 200 or so users grabbing around 1,000 rows of data via an Excel ADO connection to the backend tables.
So they would never need to physically go inside the Access database its self, but instead it would garb data by opening an ADO connection to the database > Grabbing the data > Closing the database connection.
Is this okay to do with around 200 users simultaneously querying the database tables via an Excel ADO connection?
View 1 Replies
View Related
Oct 27, 2012
I am about to allow users to access a database I redesigned for others to use.I am trying to save it as an ACCDE so they can't mess it up. The database is very very simple.6 tables each with only 4 fields or less... and none are related to one another
7 forms.
1 report.
0 queries... it's just a SKU generator.
When I attempt to save as ACCDE I get an error that reads."Microsoft Access was unable to create the .accde, .mde, or .ade file.This error is usually associated with compiling a large database into an MDE file.* Because of the method used to compile the database, a considerable number of TableID references are created for each table.* The Access database engine can only create a maximum of 2048 open TableIDs at one time.* Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE.* However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used."
View 2 Replies
View Related
Jul 30, 2013
I have created an access 07 database and split it to a back-end and a front-end with linked tables.
I wish to deploy it an a network of 4 computers, 3 of which are running on XP. The back-end will be on a computer running on XP. Now, from the instructions I have come across online, the Back-end has to be located on a folder where all users have Red and Write rights!!! And I am thinking, if the users on this network can actually see the back-end since it is on a shared folder where they have all the rights, then does that not compromise the security?
Is there a way of linking to the back-end on a network WITHOUT the users being able to access the back-end?
View 4 Replies
View Related
