How do I colorize one character in a field in a table? I want the letter “O” to be in red for one customer and blue for another customer in the same column but different rows.

  Greetings All:   I have a quandary with Open Office.  I am trying to get a small contact database to print labels.  I have tried to export the data, and found no way to create a template using Avery 5160 labels and import data to the template.  No can do.     It appears…

So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn’t recognizing the linked data from the other tables that it needs to. For this…

Hi all. Why would an access database save to a new file each time it is worked on? Mine keeps saving to db1, db2, db3, etc.

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…

i have created a table in access to manage the house rent.i want to create report only for particular customer rent detail. the customer id is retrived from the table and stored in combobox in one form.when i choose particular id from the combo box, the respective details of the particular id should be print…

I am in the process of developing and internet web site, and do not know cold fusion. I have a database in access that I want customers to be able to search. There will be three levels of search and I am using dreamweaver 8 for designing my web page Instead of coding every link…

How can i express the percent margin in a query? I have a field PurchasePrice and a field Salesprice. the field Purchaseprice is the price at which we buy the products and the field salesprice is the field at which we sell the products.I tried to substract the salesprice to the pruchase price and divide…

A user on Twitter, @garyvee, has a question for the community: Whats the best solution for ODBC on Linux ? And is anyone actively working with it? The direct link to his question is here.

Hi, I am currently having a experience of around 3 years of software development and support. Currently I am working for a banking company. I want to do an MBA program. I want to stay in IT. What should i do? should I go for MBA programme (part time) or some other professional course. If…

Provide a sample code to how by using VB 6.0 connectivity can be done by Daat Control tool with the database SQL Server 2000

I want to code loading a single page subfile through Embedded SQL. How do I handle the page up and page down key in that program?

Hi friends, I studied B.com and MBA finance and having 3 years experience in finance and accountsing with tally & Oracle finace.Now planning to learn SAP FICO can you please tell me about SAP FICO consultant career for me.   

I Have Data Dynamic Active Report Activex, When I load designed Report from vb6 I can show a evaluation message in yellow backgroun How to remove it and also when I give print 1 page printer will print 2 page (With blank page) How to solve this problem or how to hack this proble

Dear Friends, I am facing a strange problem in the ESB. Here is the issue description. When a ESB is made to call a webservice, where the webservice throws a RuntimeException inside its implementation, the ESB captures it, wraps it and shows it as ESB Exception. In this case the SOAP response from the webservice…

We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don’t need to go into now, we have to change all of them to a different format – yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of…

Hello – I’ve got a process that loads 56million rows daily (via bcp) into a table, maintaining this data for 30days.  Our company is too cheap to pay for semantic partitioning so i’m wondering if anyone has any ideas on how to make queries respond in a semi-timely manner.  There’s one date column, and two other…

Using the datasheet view, when sorting on a field with or without a dropdown menu, select a choice and then no data appears, even when there is data in the list.  This is a repeatable problem.  Has anyone else experienced this problem?

I am running Access 2003 on Windows XP. In the page setup of a report, you can set custom page size and specific printer, etc. I have a PC that the page size will not save with the report. I have two other PC’s that it works on. Has anyone had this problem and found…

I am running Access 2003 on Windows XP. In the page setup of a report, you can set custom page size and specific printer, etc. I have a PC that the page size will not save with the report. I have two other PC’s that it works on. Has anyone had this problem and found…