Database Programming Questions and Answers

Recent IT Questions

1 - 20 of 124
<<PREVIOUS 1|2|3|4|5|6|7 NEXT>>

re: visual foxpro program

I am trying to make a database file. It has 2 fields: employee and firstname. How can I write a program so that when I look at a form I see employee picture and firstname. thanks. royt

Answer Question   |  Jul 14 2009  1:56 AM GMT
Visual FoxPro, FoxPro, Database programming
asked by Royt

  5 pts.

data copy - paste from the same table not showing in a subform

I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform,...

asked by Tcharlton79

  20 pts.

How to show two query results in one Microsoft Access report

I have two queries saved, one shows the record that match a criteria and the othe query shows the record that do not match the criteria. ie. query1 in the feild lastname the criteria is "jones" in query2 in the feild lastname the criteria is Not"jones". What I want to have is a report that shows...

View Answer   |  Jun 18 2009  9:55 PM GMT
Access 2003, Microsoft Access, Micrsoft Access reporting
asked by Leilo

  5 pts.

Getting value of 3rd col when we enter first two col values

I hv data base with 3 cols. i want to wrte a formulae like when ever i giv two values the third value should automatically come

View Answer   |  Jun 15 2009  11:12 AM GMT
Database programming
asked by Swapnilsurve

  15 pts.

Update Microsoft Access database from VB6

Using an MS Access database. From a list box I get a record into a text box. Once it is edited it shows in the listbox but the original is there. I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and the new version there? I...

View Answer   |  Jun 10 2009  10:44 PM GMT
Microsoft Access, Database programming, Visual Basic 6
asked by Codeless

  5 pts.

Toggle button in Microsoft Access form

Hi, in an access form I have included a Toggle button which when "on click" imports an excel spreadsheet. What I want is to block this toggle button after clicking it the first time so if someone clicks on it again, it won't import the same database. Thanks

asked by Codino

  10 pts.

Recordset not Updated as per query and not giving any error

Dear Sir, thanks for your reply for my earlier query, What I am trying to do is i am editing RM item rate in RM master file.. my code doing it correctly, secondly i am updating bill_detail file for rate where that RM code is used in bill this also my code doing correctly, but third one where i am...

Answer Question   |  May 28 2009  10:11 AM GMT
Visual Basic 6, Database programming, VB 6
asked by RajeshP

  20 pts.

Crystal Reports database

I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .\SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase's name is "Database.mdf" . Why i am not able to see it ? My...

asked by Softdeveloper

  10 pts.

LINQ vs DATABASE Factory(DAL)

I am developing a application. And I want some suggestion regarding LINQ and DAL. Which one is best and why?

Answer Question   |  May 21 2009  8:42 AM GMT
.NET development, LINQ, Data Abstraction Layer
asked by Hunterz

  5 pts.

Ajax database lookup in ComboBox

i used ajax combobox in form , i have below some more field import from master form once refresh after ,dblookup field is going to defelet. so what can i do ?

Answer Question   |  May 20 2009  1:51 AM GMT
Ajax, ComboBox, Database programming
asked by Ajaxraju

  50 pts.

Finding nth most recent action with SQL

I am trying to determine the date on which a certain number of things have happened cumulatively, eg I have a varying number of buyers each month. I want to find out on what date of that month, those buyers make their 3rd purchase. My SQL doesn't seem to support TOP or ROWCOUNT so I would...

View Answer   |  May 18 2009  10:11 PM GMT
SQL query optimization, COUNT statement, SUM statement
asked by Munona99

  5 pts.

How to get delete history from schema

How to get delete history from a schema? Application requirement is to get the username ,primary key,date for the deleted records from tables.

View Answer   |  May 14 2009  5:57 AM GMT
Database schema, Database programming
asked by Sureshborse

  5 pts.

How to pass array in MySQL procedure parameter

how to pass array in mysql procedure parameter

Answer Question   |  May 12 2009  7:13 AM GMT
MySQL, MySQL Stored Procedures, Database programming
asked by Guptarun

  5 pts.

How to use DateDiff to calculate costs?

Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod with the...

View Answer   |  May 11 2009  10:16 AM GMT
DATEDIFF, Microsoft Access, Database programming
asked by Dontgetit

  105 pts.

How to customize my own database?

HOW CAN I CLONED MY OWN DATABASE THAT CAN ACCESSS ANY INFORMATION

Answer Question   |  May 2 2009  1:51 PM GMT
Database programming
asked by Uy

  5 pts.

How to connect Visual Basic 6 to Oracle 11g

how to connect vb6.0 to oracle11g ?? what are the steps??

View Answer   |  Apr 30 2009  6:45 AM GMT
Visual Basic 6, Oracle 11g, Oracle connectivity
asked by Rupeshit

  5 pts.

Microsoft Access database update question

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 database...

View Answer   |  Apr 29 2009  3:29 AM GMT
Microsoft Access, Linked database, Database programming
asked by Tgoody

  30 pts.

Unique ID for existing table

I want to add a column to an existing table where its values should be unique and auto generated in a sequential order

View Answer   |  Apr 20 2009  11:15 AM GMT
Database design, Auto increment, SQL
asked by Ragas

  60 pts.

Database connection with OLE DB

we are connect the database with the help of oledb data adapter.data are updating on screen but data not update in backend.

View Answer   |  Apr 9 2009  7:26 AM GMT
Database connectivity, OLE DB, Database programming
asked by Katni

  5 pts.

Loading image into MySQL database from Excel file

I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

Answer Question   |  Mar 30 2009  11:57 AM GMT
MySQL, Microsoft Excel, Database programming
asked by Wlm49hv

  5 pts.

1 - 20 of 124
<<PREVIOUS 1|2|3|4|5|6|7 NEXT>>