| Validate on user ID, Password and Combobox |
Asked by BryuMaGh, Mar 23, 2017 08:12 AM in Access
I want a user to enter the login details and then select a category from a combobox that makes him access information in the database if the Login...
| Using Access query in a report |
Asked by hwinceFL, Nov 22, 2016 10:15 AM in Access
In Access 2007 under MS 10 x64, I run my query sorting two of multiple fields in a table, which gives expected results. However, when I use that...
| Help with VBA coding |
Asked by hwinceFL, Nov 8, 2016 01:34 PM in Access
This is to request help with VBA coding not working as expected. I am using Access 2007 under MS Win 10 x64. I have a tblAssets (Inventory) with the...
| Excel help |
Asked by Rikest, Sep 28, 2016 12:45 PM in Other Databases
What's wrong with this formula
=IF(C19=10.1,"Job 1",IF(C19>10.1<11.5,"Job 2",IF(C19>=11.5,"Job 3")))
| 2013 Access search ability |
Asked by mswiernik, Apr 22, 2016 10:38 AM in Access
I have a database of our inventory that will be shared with technicians and support staff. I already have it set up with permissions, login and...
| Need help with form updating table content |
Asked by hwinceFL, Apr 1, 2016 08:09 AM in Access
I am using MS Access 2007 under MS Windows 7 Home Premium. I am having a problem with updating a table record in my Lending Library system. I have a...
| Problem with access database |
Asked by samedo, Feb 29, 2016 04:14 PM in Access
QUESTION: Hi Scottgem,
I've been trying to find an awesome place and community like this. I'm tired of seeking endless people that can't help...
| Access Macro putting a value rather than a field name |
Asked by alipezu, Feb 22, 2016 09:31 PM in Access
I want to track changes from "tbl1BusForDriver" in "tblAuditTrail". For that everything is working perfect for me except one thing. And the thing is...
| Help with multi-table query results to populate a form |
Asked by hwinceFL, Nov 17, 2015 05:15 PM in Access
I have three tables each with primary keys with relationships to another table in which each of these fields is a foreign key. I have attempted to...
| I want display the data stored in text file in java without jdbc |
Asked by janapalasunil, Jan 21, 2016 12:58 AM in Other Databases
The text file contains emp details like eid,ename,age,doj,sex,designation
Each field has multiple data I want to display it
Can you help me with...
| I want to enter multiple employee details and store in text file without jdbc |
Asked by janapalasunil, Jan 20, 2016 11:21 PM in Other Databases
The emp details are
When we execute it
It should ask for enter details and after completion of one employee...
| How to move Microsoft office 2007 database file to another computer |
Asked by Eddiemillion, Nov 5, 2015 07:51 AM in Access
I have just finished my database and wants to deploy it to another computer.I past it on the c:\user\user\documents directory, when I launch the...
| Help with run-time error in Access 2007 |
Asked by hwinceFL, Oct 28, 2015 06:59 AM in Access
I am getting a confusing error in my use of moving one form to another. First, a user (me) logs in by selecting his record from a pull-down list and...
| Help needed in handling lending library borrowers |
Asked by hwinceFL, Oct 22, 2015 04:27 PM in Access
I have a table of existing borrowers of our lending library. I am asking for help in how the librarian(s) can determine that a customer's record is...
| Microsoft access (Scottgem) |
Asked by mat11281, Oct 7, 2015 09:29 PM in Access
Hi Scott - I was talking to you on the allexperts
I am still having some issues. Can you pm me your email?
| Help with VBA code |
Asked by hwinceFL, Sep 19, 2015 08:17 PM in Access
This not really a Quick Answer; it's more a Slow Question.Like Lisa, I need help with VBA (rather than VB) coding since I'm using Access 2007 under...
| Access true or false |
Asked by swolcott1996, Sep 30, 2015 06:39 PM in Access
Does the table analyzer reduce the amount of redundant data by seeking duplicate entries in existing tables?
| Is there a way to create an audit trail in MS Access to tell who ran a report? |
Asked by NPlouffe, Aug 5, 2015 05:23 PM in Access
I need to create an audit trail that tracks who ran a particular report in my Access database. It needs to track the user, the person they ran the...
| How do I replace "#Type!" with "?" in relevant field? |
Asked by sjk633, Jun 18, 2015 10:39 PM in Access
Using Access 2010, in limited field space on a report, I have reduced relevant name of volunteer offering assistance to first-name &...
| Forms in MS Access |
Asked by Maniac0683, May 26, 2015 02:46 AM in Access
I setup a table with All of the different fields we need to keep track of maintenance in access, and setup various forms depending on what piece of...