24 hr clock in Microsoft Access
Microsoft Access allows you to open your table in datasheet view, select FIELDS from TABLE TOOLS and select from the drop down MORE FIELDS and then select TIME 24 so you can use military time. Problem is when you attempt to type in military time, it shows a calendar on the side and only allows [...]

Answer Question   |  June 5, 2013  8:08 PM
Microsoft Access, Microsoft Access features

SharePoint 2010 Capabilities
Using SharePoint 2010 can I create a page with a template of fields that users can fill out (system change requests) and submit generating an email to a dist list? I also want the page to store the request information, so those can check back on status of their system request changes. I have read [...]

Answer Question   |  March 27, 2013  1:03 AM
Microsoft Access, Microsoft SharePoint

How to merge all MDB files
I have more than 100 Access 2003 .MDB files and all the files have same structures and tables. I want to merge all to one MDB file.

Answer Question   |  March 22, 2013  4:47 PM
MDB, Microsoft Access

Best way to set up longitudinal database
Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester – but on a larger scale – who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and some [...]

Answer Question   |  March 14, 2013  2:25 AM
Microsoft Access, Microsoft Access database

Updates in Access
Can multiple users make updates in Access simultaneously?

Answer Question   |  March 13, 2013  3:19 PM
Microsoft Access, Microsoft Access updates

Finding a specific record with user input
I am very new to Access, but have used Approach in the past. When I used Approach, I could create a find in a form, user would be able to enter the find criteria in the blank field. I can not figure out how to do that in Access. Help!

Answer Question   |  February 4, 2013  12:55 PM
Microsoft Access, Microsoft Access forms

AS/400 pass through query from Microsoft Access
I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN 2012336 [...]

Answer Question   |  January 24, 2013  2:45 PM
AS/400, Microsoft Access

Questionnaires List
I managed to received on MDB files that contains various examination questionnaires. I believe that its possible to take and retrieve answers inside from the file itself. Can someone tell me how?

Answer Question   |  January 21, 2013  4:49 PM
MDB, Microsoft Access

TIME String using Variable H (0 to 23) & M (0 to 59)
Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO “IBNserv”.”ChkMe”(“Clt”)>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST(’12:14:00′ AS TIME) STATUS INSERT INTO “IBNserv”.”ChkMe”(“Clt”) VALUES CAST(’12.14.00′ AS TIME) Updated 1 rows. Query execution time [...]

Answer Question   |  January 14, 2013  10:37 AM
DB2 10.1, Microsoft Access, Microsoft Access database

About database connection
How to connect Visual Basic 6.0 project to the MS Access ACCDB file for save the data?

Answer Question   |  January 9, 2013  10:25 AM
ACCDB file, Microsoft Access, Visual Basic 6.0

If logical function in MS Access
I have to use IF logical function in MS Access.

Answer Question   |  December 17, 2012  8:29 AM
Microsoft Access, Microsoft Access function

Table setup
I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date – Quote # – Customer – Cust Quote # – Part # – Part Name – Quote Due Date – Qty – [...]

Answer Question   |  November 19, 2012  11:39 PM
Microsoft Access, Microsoft Access spreadsheet

Cannot find tables
I am working with a ms access file. When I look at the objects in the access objects window using a category of “object type” I only see one table, when I use the category “Tables and views” I see three tables, these extra two tables are in the dropdown list if you try to [...]

Answer Question   |  October 12, 2012  6:16 PM
Microsoft Access, Microsoft Access tables

editing in grid forms
How do I add,edit,delete in gridforms with Microsoft Access?

Answer Question   |  August 22, 2012  4:16 PM
Microsoft Access, Microsoft Access gridforms

AS/400 Profile getting disabled by MS Access
We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400′s in to MS Access. The other [...]

Answer Question   |  June 8, 2012  2:15 PM
iSeries, Microsoft Access, ODBC

Access, Searchable Combo Box within a Form?
Hello, I’m trying to create a combo list box in an access form that has all 12 months (January, February……etc,) listed and depending on the selection will bring up only that particular month within a range of dates. I don’t want it to look at the day or the year, but only the month. Example: [...]

Answer Question   |  May 25, 2012  4:48 PM
Database, Microsoft Access, MS Access

VB 6.0 Database
Hi guys, I have a question about vb 6.0 database. I used ms-access to connect the database with vb project. the component I used adodc. when I try to move the project to another computer the project will say misplacing the database it lost the pathe of the db. Is there anyone can help me [...]

Answer Question   |  May 3, 2012  8:02 AM
Microsoft Access, VB 6.0

Access datasheet
Can I export a parts list from BPCS to an access database? 

Answer Question   |  May 1, 2012  12:24 PM
BPCS, Microsoft Access

vb.net 2008 login using ms access
hi guys,ive been working on trying to create a login form. ms Access side: -used a logininfo.mdb database with columns :username,password,job vb 2008 side: -login form with clerk rad button,manager rad button,username text box,password textbox and login button now the challenge im having is that only the “Clerk” can login properly,ive used the same code [...]

Answer Question   |  March 23, 2012  10:27 AM
Microsoft Access, VB.NET 2008

Query for records that have certain numbers in them
I have a table with 4 fields and 100 records(rows), with numbers in each field. Example would be: In Record One Fieldone has 87 fieldtwo has 94 fieldthree has 32 fieldfour has 99. than Record two has numbers in each field: Fieldone-94, Fieldtwo-33, Fieldthree-102, Fieldfour-44. I need to create a query that will show records [...]

Answer Question   |  March 5, 2012  4:00 PM
Microsoft Access, Microsoft Access queries