Still having trouble with IIF in Access 2007
If I type in the criteria block Is Not Null [Br _extended=”true” />then only those people who have a position assigned to them are listed and the position is listed. These are the people who get 25 points. What I need to do is to replace the position with “25″ in simple terms, if any [...]

Answer Question   |  February 15, 2010  6:15 PM
Access 2007, Data base design, IIF, IIF function, IIF statement

MS Access 2007, IIF and Null expressions
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. [...]

Answer Question   |  May 9, 2013  1:25 PM
Access 2007, IIF, Microsoft Access, Null Expressions

Trouble with IFF MS Access 2007
Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometime contains a values but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25” I Believe [...]

Answer Question   |  February 16, 2010  1:30 PM
Access 2007, IIF function, Microsoft Access

Access 2007 form creation
[strong]KVS: [/strong] [strong]Q: [/strong]Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i’m not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now when they click on that button [...]

Answer Question   |  January 28, 2010  9:19 PM
Access 2007, Access 2007 form creation, Access Forms Database

Edit a text file with VBA
Cheers, I have large text file that needs to be edited to run a job but I would like to automate the process.  How do I open a file and replace line 132 of (which is about mid of the file) that file? Thanks, Bob

Answer Question   |  August 26, 2010  3:18 AM
Access 2007, Text manipulation, VB, VBA

Is it even possible to store calculated data in access 07
my employer asked me to build a database to do payroll. the forms are complete, the expressions work, but the calculated fields do not store in the table like they should, such as net and gross pay. is there another way to do this? i am in serious need of help. thanx

Answer Question   |  February 4, 2010  3:32 PM
Access 2007, Access 2007 forms, Microsoft Access 2007 Reports

Access 2007 form creation
Hi There, I have created a transport database for my organisation where employees can req for transport when needed. But i’m not good at Access 2007. I need help on below list of queries: 1. I have created button for employees to submit their request, now when they click on that button a message should [...]

Answer Question   |  January 29, 2010  12:10 PM
Access 2007, Access forms, Microsoft Access

PICTURE STORE IN ACCESS 2007 DATABASE THROUGH VB
KINDLY TELL ME HOW I STORE PICTURE/IMAGE IN ACCESS 2007 DATABASE THROUGH VB CODE     ANANDA DEBNATH INDIA, DELHI  

Answer Question   |  January 24, 2010  7:33 AM
Access 2007, Access Data Store, Microsoft Access, VB

Help with Database Structure
I need to create a databse that keep track of a Item # and associated with that Item# is 2 type of people. DonorID and OwnerID. Both these type of people i want listed in the same Table. So far my structure looks like so. [strong]tblItems  [/strong]                  [strong]   tblPerson[/strong]        Item#                           PersonID(want linked to DonorID & OwnerID) Description                    LastName DonorID([em]dropdownList[/em])    FirstName [...]

Answer Question   |  January 7, 2010  5:19 PM
Access 2007, Database design, Database structure

duplicating records in Microsoft Access 2007
Why are all of my records duplicating themselves in the format part of my access database? I am not entering them in duplicately, they are duplicating themselves.

Answer Question   |  December 30, 2009  12:38 AM
Access 2007, Microsoft Acccess

insert an access image into a crystal report
A .bmp in a field on my access db; I want to display the image in my crystal report. I’ve looked at some forums but the suggestions don’t getg me anywhere. any help would be much appreciated. Thank you

Answer Question   |  December 15, 2009  10:29 PM
Access 2007, Crystal Reports, Crystal Reports XI, Microsoft Access

Edit .accdb from multiple workstations
How can I input data in to a database file using microsoft access 2007 from multiple computers at the same time. From my understanding I need to have SQL Server running in order for me to do this, correct ? Also if I do need Sql server can it be installed on a Windows Xp [...]

Answer Question   |  December 12, 2009  3:14 AM
Access 2007, Access Database, Microsoft Access, Windows XP, Windows XP SP2

SQL Query to return a single value for each record based on max FIELD, not max record
I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc [...]

Answer Question   |  December 24, 2009  7:59 AM
Access 2007, Microsoft Access, SQL, SQL Query

Database being auto duplicate when exit.
hi you, i’ve created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an auto duplicate database created e.g [...]

Answer Question   |  January 5, 2010  7:23 AM
Access 2007, Access Database, Microsoft Access

Access 2007 IIF statement in query criteria
This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn’t checked, return all the fields whether they have text or not…Pretty basic filter I thought Seems like I’m getting close but can’t seem to [...]

Answer Question   |  November 14, 2009  5:04 AM
Access 2007, IIF statement, Microsoft Access

EMAIL From MSAcess 2007 to Oulook/Exchange Server
My mail email routine for sending emails with a .doc attachment work fine using MSAcess 2003 but don’t work using MSAcess 2007

Answer Question   |  November 5, 2009  1:13 PM
Access 2007, Exchange 2007, Outlook, Outlook 2007

Forms in Access 2007
I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How [...]

Answer Question   |  June 30, 2010  7:55 PM
Access 2007, Access forms, Microsoft Access, SQL, Visual Basic

Capture SQL Server logged in db User name in Access 2007 Accdb
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way to ”capture the SQL Server logged in user name” in the Access code?  Probably in [...]

Answer Question   |  August 27, 2009  11:14 PM
Access 2007, Access 2007 security, Microsoft Access, SQL Server 2005, SQL Server 2005 security, SQL Server security

ACCESS 2007 and SQL Server 2005 Schema Updates
We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP – that is, as reports are added, [...]

Answer Question   |  August 13, 2009  2:56 PM
Access 2007, Microsoft Access, SQL Server 2005

T-SQL query to ACESS 2007 database
I need examples of T-SQL queries running on SQL Server 2005 that retrieve data from a MS ACCESS 2007 Table. Any explanations are appreciated. Thanks

Answer Question   |  August 11, 2009  6:32 PM
Access 2007, Access Database, SQL Server 2005, T-SQL, T-SQL Stored Procedures