MS access Program / module
Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY...
Hello everybody, my self is Imtiyaz, i made a small database programm for challan in MS Access, but i am facing one problem in it... if u have seen any challan, it has few boxes like, crore, lacks, thousands, hundred, ten.....and when you put a figure like 20536, at that time in that boxis TWENTY...
10 pts.
How we send check box's value to data base in VB.NET?
How we send check box's value to data base in vb.net?
How we send check box's value to data base in vb.net?
How to show selected item from DataGridView shows in ComboBox
how to show selected item from datagridview shows in combobox
how to show selected item from datagridview shows in combobox
Trigger statement
sample trigger : create trigger trig_sample on table for insert,update as update table go now, the statement inside the trigger is to update the same table . will the trigger keeps on firing and thus cause and internal error??
sample trigger : create trigger trig_sample on table for insert,update as update table go now, the statement inside the trigger is to update the same table . will the trigger keeps on firing and thus cause and internal error??
Form having the link for multiple databases
INSTEAD OF OPENING THE FILE OF EACH DATABASE WHICH I WANT TO LOOK,I WANT A FORM PAGE FROM WHICH I CAN ACESS ALL MY DATABASE INSTEAD OF OPENING EACH DATABASE SEPARATELY. CAN YOU GIVE ME SOME TIPS ON THIS? ONE MORE THING I DONOT WANT HYPERLINK
INSTEAD OF OPENING THE FILE OF EACH DATABASE WHICH I WANT TO LOOK,I WANT A FORM PAGE FROM WHICH I CAN ACESS ALL MY DATABASE INSTEAD OF OPENING EACH DATABASE SEPARATELY. CAN YOU GIVE ME SOME TIPS ON THIS? ONE MORE THING I DONOT WANT HYPERLINK
Adding prefix to records
Hi, I have a simple database for some products that has some SKU numbers... ie SKU 1001-01076-0000 1001-01120 1001-01120-2100 1001-01120-2400 1001-01121 1001-01121-2100 What I want to do is add the prefix "GF-" in front of those SKUs. This is a database that will continually get sent to me, so...
Hi, I have a simple database for some products that has some SKU numbers... ie SKU 1001-01076-0000 1001-01120 1001-01120-2100 1001-01120-2400 1001-01121 1001-01121-2100 What I want to do is add the prefix "GF-" in front of those SKUs. This is a database that will continually get sent to me, so...
Compile Error
I am trying to prevent duplicate job orders from being entered for the same employer. The employer is in the main form and the job order is in the subform. I have this code attached to the "beforeupdate" event of the control on the subform but I get a compile error: wrong number or arguments...
I am trying to prevent duplicate job orders from being entered for the same employer. The employer is in the main form and the job order is in the subform. I have this code attached to the "beforeupdate" event of the control on the subform but I get a compile error: wrong number or arguments...
Setting isolation levels with hibernate and DB2/AS400
I am using hibernate with DB2/AS400. When I set any isoltion level other than '0' in the hibernate.cfg.xml and try to insert/update data in the table on DB2/AS400, The Exception '' could not update :" occurs. Update is succesful for isolation level 0. Please guide how this can be solved. ...
I am using hibernate with DB2/AS400. When I set any isoltion level other than '0' in the hibernate.cfg.xml and try to insert/update data in the table on DB2/AS400, The Exception '' could not update :" occurs. Update is succesful for isolation level 0. Please guide how this can be solved. ...
Access database management
Hi guys I am managing a database and need to know if there is away of moving 'completed' records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having...
Hi guys I am managing a database and need to know if there is away of moving 'completed' records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having...
Switch/Case statment in access
how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow: Field Name: Directions in this field i need to write codes like: TAm Field Name: Translation here i need to read TAm as T=Take, Am= Morning. the problem i have more than 200 codes, which they have to be...
how i can use Switch/Case Satatment in Mic. Access 2003, am working on database as follow: Field Name: Directions in this field i need to write codes like: TAm Field Name: Translation here i need to read TAm as T=Take, Am= Morning. the problem i have more than 200 codes, which they have to be...
Can we extract the data from a input file and then map that data to an existing pdf document
Hi, Can anyone tell me whether it is possible to extract the data from an input file or the database and then map that data to an existing pdf document in delphi.If not possible in delphi ,please tell me which language best suits for this.Kindly provide pointers.Thanks in advance.
Hi, Can anyone tell me whether it is possible to extract the data from an input file or the database and then map that data to an existing pdf document in delphi.If not possible in delphi ,please tell me which language best suits for this.Kindly provide pointers.Thanks in advance.
Excel 2003.novice user wants to set up database for research
Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don't know what it's called. can I do something like this to then use it to make queries for certain data?
Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don't know what it's called. can I do something like this to then use it to make queries for certain data?
MS Access Forms
I created a database in MS Access with 2 simple tables and 2 or 3 related queries. I also created a form which I use for data entry. I based the form on a query that uses two tables (related by one field) and an additional column for an age calculation. I was happily entering data via my form...
I created a database in MS Access with 2 simple tables and 2 or 3 related queries. I also created a form which I use for data entry. I based the form on a query that uses two tables (related by one field) and an additional column for an age calculation. I was happily entering data via my form...
Problem deleting an object(form) in Access 2000
When I try to delete a form that is visible in the object list a message 'could not find the object' is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas....
When I try to delete a form that is visible in the object list a message 'could not find the object' is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas....
Latest date SQL
Hi I am Trying to grab only the latest date from a uniquie stock number wich has mutiple dates? All i want to show is the lastest date against the stock number. Bear in mind that theese are comming from two different tables. Any Ideas
Hi I am Trying to grab only the latest date from a uniquie stock number wich has mutiple dates? All i want to show is the lastest date against the stock number. Bear in mind that theese are comming from two different tables. Any Ideas
Highlight Keywords in Access 2003 Forms
I have a searchable form in Access 2003. Users can type in a keyword or phrase to filter records. Is there a way of highlighting the keyword or phrase used in the set of filtered records?
I have a searchable form in Access 2003. Users can type in a keyword or phrase to filter records. Is there a way of highlighting the keyword or phrase used in the set of filtered records?
sql
is it possible in vb.net to read two database(access) with one sql? like select * from databaseA!tableA union select * from databaseB!tableB what connection type to use ty in advance
is it possible in vb.net to read two database(access) with one sql? like select * from databaseA!tableA union select * from databaseB!tableB what connection type to use ty in advance
VBA-question
How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.
How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.
Calculation Combining Fields, Not Adding
Hello, This should be really simple. I have 3 fields that calculate correctly on a form and insert the calcuation into a table. (I know, NEVER store a calcuated value, but I have a reason for doing it.) Now I'm trying to add those 3 fields and am getting an incorrect sum. Here is my string: ...
Hello, This should be really simple. I have 3 fields that calculate correctly on a form and insert the calcuation into a table. (I know, NEVER store a calcuated value, but I have a reason for doing it.) Now I'm trying to add those 3 fields and am getting an incorrect sum. Here is my string: ...
join tables with nested select count and group by
hi i am having three tables : state, agencydetail, parentdetaills i am running following queries but i am getting wrong result plz help me out where is the problem select state.state,count(ag.agencycode) as registag,count(ff.agencycode) as reportag,count(inp.regno) as...
hi i am having three tables : state, agencydetail, parentdetaills i am running following queries but i am getting wrong result plz help me out where is the problem select state.state,count(ag.agencycode) as registag,count(ff.agencycode) as reportag,count(inp.regno) as...
