| Using Access query in a report |
Asked by hwinceFL, Nov 22, 2016 11: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 02: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 01: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 11: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 09: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 05: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 10: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 06: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 01: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 21, 2016 12:21 AM 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 08: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 07: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 05: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 10: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 09: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 07: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 06: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 11: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 03: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...
| Microsoft access- Sequential Numbering |
Asked by Ladyk18, Apr 8, 2015 11:42 AM in Access
So I am trying to put together a form in Microsoft Access that will autopopulate a demobilization number immediately before saving the record. I am...