resize contol in Access print view
[table style="border-collapse: collapse; width: 347pt;" border="0" cellpadding="0" cellspacing="0" width="462"> [col style="width: 347pt;" width="462">[/cOLIST] [tr style="height: 69pt;" height="92"> [td class="xl63" style="height: 69pt; width: 347pt;" height="92" width="462">I am using ms access to devlop several reports.  Text boxes are having one property i.e "Can Grow" , which is used to set the height of text box as per [...]

Answer Question   |  December 17, 2009  9:09 AM
Microsoft Access, Microsoft Access printing

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

export VB6 report in pdf format.
i am making a project in vb 6 using ms access as a database. i am making report in crystal report and want to export that repot in pdf format.

Answer Question   |  January 21, 2010  4:47 AM
Access Database, Crystal Reports, Microsoft Access, VB6, Visual Basic

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

Microsoft Access Report
I am able to alter one of my access reports, but everytime i try to exit and save it the report will not close untill i say no to save changes has anyone got any ideas as it is driving me insane

Answer Question   |  November 30, 2009  10:49 AM
Microsoft Access

Best way to create a large access databases.
I am new to access databases, as I am sure everyone says there first time. One thing I do know is that the database I will create will be very large and I Would like to know is it better to break up the database in to several linked databases together or just have one and live [...]

Answer Question   |  November 30, 2009  7:40 PM
Database, Microsoft Access

PHP and MS Access Database
I’m trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache’s error log file: “[strong]PHP Fatal error: Uncaught exception ‘com_exception’ with message ‘Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was canceled.’ in C:\WAMP\httproot\x1.php:6nStack trace:n#0 C:\WAMP\httproot\x1.php(6): com->open(‘DRIVER={Microso…’)n#1 {main}n thrown [...]

Answer Question   |  January 22, 2010  5:22 AM
Access Database, Microsoft Access, PHP

To trap the item name of more than one item selected in list control
1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data [...]

Answer Question   |  November 19, 2009  7:40 PM
Microsoft Access, SQL, Visual Basic 6.0

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

Erro in Subform in Ms Access Reports
Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but [...]

Answer Question   |  November 16, 2009  7:34 AM
Access reports, Microsoft Access, Microsoft Access subforms

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

Access Form Printing Problem
I have designed a set of forms in Access.  One of the forms prints the form in total.  However tow of the forms will only print the header and footer and does not print the data input portion of the form.  What am I missiong in regards to why I can’t get these two forms [...]

Answer Question   |  November 11, 2009  11:03 PM
Access forms, Microsoft Access

Migration from Paradox to MS Access or VB.Net/MS SQL
We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated.

Answer Question   |  January 23, 2010  9:11 PM
Access 2003, Microsoft Access, Paradox 11, SQL, VB.NET, VB.NET 2008, Windows Server 2007, Windows XP

COMBO BOX (IN VB) HOW BEHAVE LIKE MS ACCESS
HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE SOLVE IT NB : THIS [...]

Answer Question   |  January 23, 2010  7:24 AM
Microsoft Access, VB, Visual Basic

VB
Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form’s Combo — when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 [...]

Answer Question   |  October 21, 2009  4:26 AM
Microsoft Access, VB, VB 6.0, Visual Basic

Master/Child Link problem in Subform
Hi, I needed to add a new table to my database, so I added it and created a one-to-many relationship with the parent table. I then created a form and used the subform wizard to make it into a subform. The Master and Child links are the primary key in the parent table and the [...]

Answer Question   |  October 9, 2009  11:46 PM
Microsoft Access, Microsoft Access subforms

copy 1.2 GB mdb from pc to network
When copying 1.2 GB mdb from pc to network, it seems that the copy created in the network is corrupted although I am not able to tell by looking at the size of the file. Does anyone have an experience of copying a big mdb file from pc to network?

Answer Question   |  April 19, 2012  6:04 PM
Exchange MDB, MDB, Microsoft Access

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

Access for Windows 5.4
On one of my PC that uses Access for Windows when I start the Display I also start the printer and it seems to blink the printer screen when starting. So times it just blinks and blinks and bli.nks. I loaded the latest fix, but it only happens on this one machine.

Answer Question   |  September 25, 2009  5:11 PM
AS/400 printing, iSeries, Microsoft Access