| Subject | Date Asked |
|
| POS Database | 7/14/2008 |
Q: I'm trying to make a POS point-of-sale software. I only know using ms access for database. Is ms ...
A: Jeric, Access is a fine database - your most important decision might be which platform to use ...
|
| Calculating a business day | 4/18/2008 |
Q: Do you know a simple method of taking a date and calculting 5 business days from that date? For ...
A: Jill, You didn't say which database you're using. Mysql, like the other databases has extensive ...
|
| Skip Blank Line | 4/14/2008 |
Q: .expert, I have a report, i would like to skip blank line records, how?
A: Hasmukh, It depends. What are you doing specifically? What software are you using? Can you check ...
|
| simple database | 4/11/2008 |
Q: not sure if I've found the right expert, but, I'm looking for a simple database program that will ...
A: Johnny, Have you looked at Excel? This sounds like exactly what spreadsheets are designed for. Also ...
|
| Auto select items in a list box based on a combo box | 4/9/2008 |
Q: . i have a small form based on a query, i have one list box of all names in the list and one unbound ...
A: Yankel, Selecting on the fly is only possible using: 1) javascript 2) Ajax 3) server side ...
|
| ms access | 2/29/2008 |
Q: I have a database from which I need to export data (a query)! The data needs to be exported in a ...
A: Neil, I'm not familiar with MS Access' export options, however maybe this shareware product will be ...
|
| Oracle global variable | 2/18/2008 |
Q: I having an oracle 3 tier design, i have a hp-ux based oracle database, and windows 2003 base oracle ...
A: Ali, While I don't personally have experience with this issue I found a discussion involving what ...
|
| Suggest Database Software | 2/13/2008 |
Q: I have been looking around at some different database software, but have not committed to anything. ...
A: Pat, It doesn't matter which database you use, just as it doesn't matter whether you use Snap On or ...
|
| Query optimization | 2/12/2008 |
Q: Wanna know some of the key points by which we can optimize a big query with so many joins,running ...
A: Deepa, Start with these online tutorials http://littlelink.webtrouble.com/?WMQP ...
|
| access to web | 2/11/2008 |
Q: I have a filter tracking database on access standalone. we put in air monitoring field data. Lab in ...
A: Bob, With all due respect you will either need to get a bid from a programmer like me or have ...
|
| access to web | 2/11/2008 |
Q: I have a filter tracking database on access standalone. we put in air monitoring field data. Lab in ...
A: Bob, If by easy you mean is this something a person with no web development experience can do in a ...
|
| data security | 8/7/2007 |
Q: I want to know about ; how we can secure our data base file, so that anybody can't open it. Can we ...
A: There are two basic things you can do which I am familiar with. First, have an id and password set ...
|
| Maintaining a database on the web | 8/2/2007 |
Q: What programs are available (and what is the best) for a db that needs to be web accessible?
A: There really are a wide variety of options here. From the very simplistic such as my form to ...
|
| Mail Labels | 7/14/2007 |
Q: I have a database completed of 850 names, addresses. I wish to merge this info to mailing labels. ...
A: I would approach this by writing a simple program to print the data out, and then use the newline ...
|
| Inventory Database | 7/3/2007 |
Q: Hey Marty, I have Microsoft Access 2003 and I need to create a database that will store all of the ...
A: Jay, This involves the development of an application. What I mean is that you can input the ...
|
| Building a Database | 6/18/2007 |
Q: I am planning to manage a website that stores client data (information) through forms, and also ...
A: Avneesh, You may be in luck. I have an open source product which takes form data and puts it on ...
|
| SQL | 5/30/2007 |
Q: I am studying IT and have an exam and I know I should know this but I have only just found out there ...
A: Look at http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html and you'll see 12.2.1. ...
|
| database programming | 3/16/2007 |
Q: I am using a vb data project. the database is ms access database. the problem arises when I try to ...
A: What changed to make this a problem? Or is it possible that the data in certain rows was not right ...
|
| Access | 3/14/2007 |
Q: Goodafternoon. Could I ask you one question concerning MS Access? I have one table A table with ...
A: Can you please write back with the table descriptions for the two tables? Also with an example of ...
|
| Too much data for access database | 2/17/2007 |
Q: Good morning. I have been requested to create training db. Been given list of employee names, list ...
A: Lori, I would split this into multiple tables and find relationships between them through ...
|
| SQL date query question | 2/15/2007 |
Q: How would I then get a list like this?: TOTAL_PRICE_PER_MONTH MONTH 100 ...
A: Not knowing how the table is organized can suggest the easiest way would be to collect the ...
|
| SQL date query question | 2/15/2007 |
Q: I have a database which has a list of products, then a list of the price of each product, and then a ...
A: TJ, select sum(price) from _________ where transactionDate like '__/02/____'; assuming the date is ...
|
| powerpoint slides in MS Access database | 10/10/2006 |
Q: Marty, this is difficult to describe. I guess I need a table with slides, but do I need to convert ...
A: Suggest you consider using Open Office http://www.openoffice.org/ to convert your .ppt files into ...
|
| powerpoint slides in MS Access database | 10/10/2006 |
Q: I have a project where I have about 200 Powerpoint slides and need to put them in a database so that ...
A: Phil, Sorry about the false 'can't answer' reply. My mouse has a mind of its own sometimes. Not ...
|
| transferring excel spread sheet into a searchable database | 10/4/2006 |
Q: I am cutting and pasting information from "yell.com" on potential advertisers for my company into an ...
A: Michele, The answer to the questions is a resounding "maybe". It's possible to export data from ...
|
| HR Template Database Design | 10/2/2006 |
Q: I'm looking for a Human Resource Database Schema. I've been looking on the internet, but cannot find ...
A: Louw, Here are several including an Oracle DB demo - as you can see XML is the popular methodology ...
|
| BTRIEVE LOCK FILES | 9/26/2006 |
Q: Good research. Thanks for the tips. I have tried everthing, including DOS emulator modes. I may ...
A: Ted, I'm surprised you're being left high and dry like this, especially given the info I saw about ...
|
| BTRIEVE LOCK FILES | 9/26/2006 |
Q: Do you have BTRIEVE data engine tuning experience? I have a ten year old DOS based accounting ...
A: Ted, Although I am not expert at Btrieve I can tell you that a quick search showed this ...
|
| How to write procedure? | 9/13/2006 |
Q: I need a script for the below raised question or can you give the concept for the below question.I ...
A: This sounds like a merge application. It's a common problem in computer programming. Suggest begin ...
|
