Search results

Let me put some VBA/Access in the discussion to make it more relevant to forum. We frequently test conditions using something like “ … = True” and “ … <> False” to achieve the same purpose. Using this clue, I reword the question - Is it possible to be a Moslem without believing in Koran or...

or Christian without believing in Bible! There are many more religions that have religious books as their base and same thing may apply to them.

Can somebody share experience of using Access ADP application with 1000+ users?

Banana has given good insight into the Access/SQL Server security issues. I would like to share what I have been using for ADP project. I have been using ADP since about a year now and I have implemented 4 projects. For managing security, I use a separate database called login-control which...

I have not been able to identify which marketing models are most cost effective for UK based small business engaged in developing small software solutions for UK clients? I know what will work in India or Saudi Arabia but I am still clueless what marketing model will work in UK and USA without...

I have no idea how to approach the following requirement. I have few Access ADP projects where Execl and JPG files are to be read and written to a sharefolder using a Windows username and password i.e. not current login user/password. The requirement is the there will be only one user account...

Using VBA, I am creating a PowerPoint Presentation (PPT) from Excel Workbooks. The created PPT's master slide has a ComboBox. This ComboBox is to be used for jumping to a slide selected in ComboBox. Therefore, the ComboBox is to be populated with slide numbers and titles before the PPT is...

To make things more clear, attaching a sample view of the ExcelSheet. This sample view provides functionalities similar to MS Project i.e. arranging data in hierachical view having group tasks and simple tasks, inserting, deleting tasks/group tasks, shift a task or group of tasks to right or...

jal / Banana, Please think in terms of MS Project's Tasks collection and task objects as being displayed in Gantt Chart view with provision to change values in cells i.e. fields. Just think how it can be simulated on an Access form. I have used MSFlexGrid for simple jobs. It requires...

Hi jal, I undersatnd that Three View control can create hierarchical views of one column data. How custom columns be added to a Tree View Control? How to simulate the group like task for tree view nodes? Ashok

I have few applications in MS Excel using VBA. These applications simulate Hierarchical Views of the data with following characteristics. 1) Indented values in a Column simulating a tree view of rows 2) Group level rows have formulas to sum or other calculations 3) Inrease or decrease to...

Thanks and regards to jal and boblarson. Qualifying has resolved the problem. Ashok

In Access ADP project, I am trying to copy an Excel Chart to a JPG file using the VBA code. This code runs for first time after opening the Access project but gives error if rerun. The error occurs at the following line in Sub CreateJPG. ActiveChart.ChartArea.Select The error number is o...

Purvis / jal Thanks for the helpful explanations. I got it now. It's the T-SQL and not the ADO. Today, I have also tried on similar lines and was able to make one query work. However, It has created additional work for me as now I have to examine each query and make modifications if...

Purvis Thanks for correcting. It is infact LEFT JOIN. I have to convert an Access 2003 mdb project to adp /SQL Server 2005. This project does not have any documentation, it is not clear to me what each such query is intended for. There are many queries that have like ' Where (C1<>C2) Is Null...

I have to migrate DAO queries to ADO. I am having prolem in finding the equivalent of the following which is frequently used in WHERE clause. Select ..... From table1 left inner join table2 on table1.colum1x = table2.column2x and ... Where ((table1.colum1x <> table2.column2x) is Null) or...

I am currently using Access 2003 ADP and SQL server 2005 Express. In this conbination, I can not make changes to SQL Server 2005 objects such tables, views, procedures etc from within Access 2003 ADP. I am forced to used SQL Server 2005 Express Management Studio. However, I can not set Access's...

I have an Access 2003 APD project that currently runs on SQL Server 2005 Express with no other named instance on the same computer. Now, I have to migrate this project to SQL 2005 vertual server. Can somebody tell me with the possible issues and resolutions if the vertual server is a named...

I suggest to do it this way. It involves copying VBA code to Excel workbook' module1. You may find it interesting if you are doing it first time. Basically you are creating a Excel workbook that has VBA Code, a Button and Data copied from Access tables. 1) First write Excel VBA code to create...

LPurvis, Thanks for the feedback. Ashok