99 Discussion / Question Topics
Remove Filter I saw many project resize with change screen resulation. I mean I work with my project in 800 by 600 pixel resulation. when I run It 1024 by 768 pixels then its many control change. but I want it match with changing resulation. example: I have a image control with … | |
In my access file I write code in query [CODE]SELECT AccountInfo.incategory, Sum(AccountInfo.InAmount) AS TotalAmount FROM AccountInfo WHERE (((AccountInfo.Date)>=#1/1/2009# And (AccountInfo.Date)<=#12/31/2009#)) GROUP BY AccountInfo.incategory; [/CODE] It show the total amount between 01-01-09 to 31-12-09 and it show in report. but in vb6 I want I select this two date and the … | |
my data report is portrait. how I change it in landscape. | |
I made data report with condition. I want to input a student id number in a text box and press a button to show all data of this student, but a problem when i input a number in the text box (and press the button) for show the report a … | |
in msflexgrid I have one fixed row. and 5 or more data show in 5 row. If I write code like:`txt1.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 1)` then when I click on a row then only one text box show that data. but I want I click a button then all data of … | |
a msflexgrid show my data. I write code in msflexgrid_click():[QUOTE]txt1.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.RowSel, 0) txt2.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.RowSel, 1)[/QUOTE] for show data in textbox. but one error msg show: "run time error 381 subscript out of range" what I do now? | |
When I open a project in vb6 then show a msg: and tell me to see a log file. and the description of log file is below: Line 29: Class b8Controls4.b8Line of control b8LLogoB was not a loaded control class. Line 116: Class b8Controls4.b8ClientWin of control b8CW was not a … | |
in my database I enter three item in 'Item' field. paper, pen, pencil. in my vb project i have three text box. here I want these three item show in this three text box. how it possible. | |
I made a cross tab query. please see the attach file. the sum of category show in textbox in my project. like: Stationary = 2000.00 Machinery = 5000.00 Salary = 2200.00 here I can write sql command like:[CODE]select sum(stationery) from table1 [/CODE] but here I know the category"stationery" so I … | |
my form window sate (property) is maximized. this is run maximized before. but today it run normally. but when I manually maximized it then it would maximized. what problem with it. | |
I made a Data report. I write code like: select *from table1 where date1 and date2 between dtpicker1.value and dtpicker2.value but the data not show in report. but when I write like: select *from table1 where date1 and date1 between dtpicker1.value and dtpicker2.value then data show. what problem? another thing … | |
I made a datareport. I select a date from dtpicker and the datareport show that date data. here I want the selected date (by dtpicker) will show in the report. like: 05-06-09 or from 01-06-09 to 05-06-09 any body help me please. | |
In a data environment I write code like: select ([exam fee]*[other fee]) as total from table1 then it work, but when I write like below it not work: select sum[exam fee] as total from table1 what problem with it? | |
which procedure I write this code: option1.value = true then text1.enable = true else text1.enable = false | |
How can I show my data in a combo box. I need help . anybody help me. | |
at 1st: class name entry in a text box (by add new button). access file is store it. then in a another form (when a student admitt) enter all data of this student (in few text box) without class name. when I want to entry the class name then I … | |
I made a queiry. but every data show in this queiry double. I mean every data show two time in this queiry. why this problem occured. any body help me please. | |
I made a database project. when I run it another pc it was run. but when I see the report (in my project) it show a error msg. it is : error number: 713 application defined or object defined errro. another thing it is exe when i run it another … | |
I made a project (exe). I want when a user use it , after 6 month or 1 year it will expired. I mean the exe is use for 1 year. after 1 year it will show a msg. like: demo version for 1 year. contact with author. | |
I attach a file. In this file I make a querie. all the (data) field of both tabel show in the querie. I want all data will add up in querie. I mean a calculate field. like : (200,200,300) this amount was in both table. in querie it will show … | |
I want to make a data report. I write a name (like: taher) in a text box then press a button and then (taher's) all data will show. how it possible? I want it many ways. like name, ID, date. I mean I write name or ID or date and … | |
I made simple database project. just add a data and see it. but when I run it another computer it show a massage. massage is below: 'E:\Vb6\New folder\db1.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected the server on … | |
I want when I write some text in a textbox it direct pass in data report. I mean generally a data report connect a database and show data from it. but here I want I write and it pass that time data report. | |
I made a datareport simple. just connect. but I want to make it with condition. I have 2 dtpicker for date. I want 1 day report or weekly or monthly report by dtpicker. example I want 03/11/08 report or 01/11/08 to 03/11/08 report. But I dont know how make it. … | |
If I click a button how my computer will be open? I want I click a button then my computer will be open. help me with my computer, control panel | |
I make two table in ms access. both of two table has like 'student name' column. when I enter a name it save in table1. Now I want this name will save in table2 automatically. I mean I don't enter this name in table2, but it will store this name … | |
1. I work with a database project. Now I want to show all data (from a table like 'student name' column) in a combo box. how can I do this. I connect the database by system DSN and adodc control. plese any body help me. 2. If I select a … | |
I made a database project. when I run it another pc and press the Add New button (in my project) it show this msg. Run time error - 91 Object variable or with block variable not set. I connect the backend database by data sources(ODBC)> system DSN. I write code … | |
I add some data in a form by text box. a acsess file store it.then I close this form and open another form . that data show in this from by datagird or msflexgrid. but my problem is when I add some data and close that form this data not … | |
I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like name | address | date this 3 fields in table1 Roll | Class | date … | |
I work in a project with 12 chekbox(12 monthname) and a textbox. when I check a box a month name like "january" show in textbox. when I check another checkbox "February" show in that textbox after january. like "January February" as like same 12 checkbox. but when I uncheck any … | |
I attach a file what was send by Shaik Akthar. I work with it a new access file. He use Table, I use querie. But it not work.I modify some code like: MSFlexGrid.FormatString = "<DATENOW|<NAME|<DIAGNOSIS|<REMARKS" MSFlexGrid.FormatString = "<Student ID|<Student Name|<Jamal|<Roll No" Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\DB2.MDB" … | |
I work with a student database project. when I click Add New button a massage show. I write code in add new button was "adodc1.recordset.addnew." massage was "Multiple - step OLEDB operation generated errors. check each OLEDB status value, it avaiable. No works was done." when I press ok another … | |
I have 4 text box in a form. when I click a button another Form show with a MSflexgrid. when I click in a msflexgrid the data show a text box of another form. I write code: form1.Text1.Text = MSFlexGrid1.TextMatrix(MSFlexGrid1.RowSel, MSFlexGrid1.ColSel) But I when I click msflexgrid the same data … | |
I shutdown my pc normally. when I again start it , CPU was run but no display show in monitor. I disconnect all hardware connection and clean all hardware like AGP, RAM others. then again connect all hardware. start the pc and now display show in monitor. But when I … | |
12 months name (12 check box) in a form. when I check a box it will store in backend access file. 1 adodc control also in this form. when click a button this form was shown. this month was store for that button like salary. example: a man paid his … | |
I have a datagrid to show data from backend access file. when I click a button it was show. I want I click on a data and it will show in a text box of other form. anybody can help me. | |
I use datagrid to show data and use adodc control. but when connect between them a msg show "No compatible data source was found for this control. please add an intrinsic data control or a remote data control to the form." Is there any proses to connect between them? | |
I want to change the format of Dt Picker. I write in format property dd/mm/yyyy. But it show 30/00/2008. why the month didn't show. any body help me to change the format of Dt Picker. | |
what is module and class module. I want to learn about it . anybody help me clearly. | |
I put 2 dtpicker in my project. both are for search data from backed access file. like (1st dtpicker) i select a date 16/08/08 and (2nd dtpicker) 16/09/08. i want to find data last a month or any few days. i mean i want to find a period data like … | |
what difference between access and sql. i use access in a database project not sql. what what problem i will faced for not use sql. or what advantage i will get for using sql. | |
what is .dll file. how it is work and how can i make it. please any body help me | |
I saw a project where was a (like) combo box. when it was click a mini calendar show and today date is marked with a red oval. Please tell me how i make it. | |
i made a project. i want to release it. but i want to release a trail version of it for 15 days. any proses. please help | |
I make a project with a access file with back up. But I want to create same file from my project. I mean when I need i make the same file from my project. help me | |
i put a image box with a image. my screen resulation is 800 * 600. but when i change it to 1024 * 768 the image show small. i want the image will change with the change of screen resuation. help me | |
i using acsess 2003 or xp. but when i click in record source property to show the table a massage was shown. but when i use office 97 then there was no problem | |
I use data control to link access file by data properties not code. use simple code like move next etc. I use find next to find data. but when i want to find i write the criteria like Name = taher. But i want I write only taher in find … |
The End.