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
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
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,...
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,...
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...
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...
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
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
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...
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...
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
View Answer
| Jun 8 2009 10:20 PM GMT
Microsoft Access, Microsoft Access forms, Database programming
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
View Answer
| Jun 8 2009 10:20 PM GMTMicrosoft Access, Microsoft Access forms, Database programming
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...
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...
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...
Answer Question
| May 26 2009 8:48 AM GMT
Crystal Reports Database, Database applications, Database connectivity
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...
Answer Question
| May 26 2009 8:48 AM GMTCrystal Reports Database, Database applications, Database connectivity
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?
I am developing a application. And I want some suggestion regarding LINQ and DAL. Which one is best and why?
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 ?
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 ?
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...
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...
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.
How to get delete history from a schema? Application requirement is to get the username ,primary key,date for the deleted records from tables.
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...
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...
How to connect Visual Basic 6 to Oracle 11g
how to connect vb6.0 to oracle11g ?? what are the steps??
how to connect vb6.0 to oracle11g ?? what are the steps??
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...
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...
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
I want to add a column to an existing table where its values should be unique and auto generated in a sequential order
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.
we are connect the database with the help of oledb data adapter.data are updating on screen but data not update in backend.
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?
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?
