|
Thanks for the reply.
The form unfortunately includes a Tab control with 7 tab pages on it, each of which has a bunch of controls. I could problably reuse most of the controls on the diffrent tabs, at the expense of lowering the readabillity of my code.
I dont have many options tho, the customer wants exactly the same app, just in .NET.
NB. Dont know if this info is important but, the code was ported from VB6 to VB.net and corrections have been made to make it work.
-- modified at 8:57 Wednesday 16th August, 2006
|
|
|
|
|
Michael Andersson wrote: Tab control with 7 tab pages on it, each of which has a bunch of controls.
Option - you could create the controls on the tab page dynamically when the page is first called. It'll mean more coding but would probably shave some time off.
Another idea would be to create a "Please Wait..." form which is a simple matter of creating a form with a progress bar control and a timer. It's just a simple way of keeping your user informed that your app is actually doing something.
|
|
|
|
|
I have a value in my access databse which is tick and untick , i think the value is YES/NO. In VB i try to set the value but i having this error....
anyone know wat it mean?
Error:
Run-time error '91':
object variable or with block variable not set
Highlight error:
DB.Execute "UPDATE Dono SET InvoicePrint = " & yes & _
" WHERE [NO] = " & "'" & Dorder.dono.Text & "'"
original code:
Dim message, dialog, title, answer
message = "Print Invoice?"
dialogtype = vbYesNo + vbQuestion
title = "Print invoice?"
answer = MsgBox(message, dialogtype, title)
If answer = vbYes Then
DB.Execute "UPDATE Dono SET InvoicePrint = " & yes & _
" WHERE [NO] = " & "'" & Dorder.dono.Text & "'"
MsgBox ("record updated successfully...")
End If
|
|
|
|
|
Hi campbells,
Please check and confirm that you have declared db as a new connection, and when you pass a string into a database , use '[single Quotes] before and after a string ok. This might solve your problem, Again if you find problem, reply me
Regards,
Manowj
Regards,
Manowj
|
|
|
|
|
DB.Execute "UPDATE Dono SET InvoicePrint = " & "'" & True & "'" & _
" WHERE [NO] = " & "'" & Dorder.dono.Text & "'"
is it correct with the Single Quotes i using? i have try to change the value as ON,1,YES or TRUE but not working
|
|
|
|
|
and i cant declared it as new~
i use this
Private DB As Database
is it ok?
|
|
|
|
|
Use the value 1 for "yes"/"true"/"on" and 0 for "no"/"false"/"off".
---
b { font-weight: normal; }
|
|
|
|
|
Dear All,
Currently we are working on a project by using Visual Studio.net as an interface, MS-SQL as data store, and ReportViewer 8 as data view. We want to display our local unicode characters. And it seems that the display on the report is not correct at all.
For your further understadning, we would like to tell you that we are working on Cambodian Character (Khmer Unicode). Our characters are some what different from English. We have consonant and subconsonant which displays just right below the normal consonant. We also have vowels, and sub-vowels which dislay on the left, right, upper part , up upper part, lower part and low lower part of the consonant or even the sub-consonant. The disiplay is OK on the interface itself. But when we view it with report viewer, the character all spreaded out.
I hope someone out there is kind enough to help me with this.
Regards,
Sithy
Sithy
|
|
|
|
|
Please help me. I have a program I wrote in VB.net My database is in Ms Access.
I want to produce a report. I am using Crystal report XI.
Data for the report are in 9 different tables (all in the same database).There is no way I can limit the number of tables. My SQL select statement joins and selects information from all the 9 tables base on a field data_ID that is common to all.
The problem is this:
When data exists in all the 9 tables the SQL select statement works fine, but if data does not exist in all the tables (some table have data , some table may not have data) the SQL statement does not work at all.
I would like the retrieval mechanism to be such that data in available tables are retrieved and displayed in the report, irrespective of the absence of data in another table.
I have tried producing a report that consist of several sub-reports but on printing the final report is more than one A1 paper.
The final report must not be greater than one A1 sheet of paper.
Thank you.
ihe
|
|
|
|
|
Check your joins in the SQL statement and ensure that you show all data in the parent tables.
Example:-
SELECT FROM Id, CompanyName FROM CompanyTable RIGHT OUTER JOIN Contacts ON Contacts.CompanyId = Company.Id
Steve Jowett
|
|
|
|
|
Thank you.
The tables in my database are:
1. BitsNozzles
2. BottomHoleAssembly
3. ComplusoryFields
4. DataIdentity
5. DrillingMudProperty
6. DrillingPumps
7. PressureLoss
8. Reports
9. TotalValues
How would I join them?
Your example:
SELECT FROM Id, CompanyName FROM CompanyTable RIGHT OUTER JOIN Contacts
ON Contacts.CompanyId = Company.Id
Used two tables but I have 9 tables.
ihe
|
|
|
|
|
Which tables link to which now? Post the SQL code you have now and I'll modify it for you
Steve Jowett
|
|
|
|
|
Thank you very much
The tables are:
1. BitsNozzles
2. BottomHoleAssembly
3. ComplusoryFields
4. DataIdentity
5. DrillingMudProperty
6. DrillingPumps
7. PressureLoss
8. Reports
9. TotalValues
It works like this, on starting the program you must supply
1. Wellname (a string)
2. Date (DateTime)
3. report type ( a string)
4. and the values for the ComplusoryFields
The report type may be AM or PM. (AM represents a morning report and PM an evening report. Reports are produced twice a day.).
When you submit these information .The program would do the following
1. The program generates a string (The data_id) and check if this Data_ID already exist in the database.)
2. Save the values for ComplusoryFields into the ComplusoryFields table. This table contains information that almost all the other tables need to calculate some values or the other.
With the Data_ID you now have access to the other tab pages .Each tab page represent a table .You may now save, edit, delete into/out of the database .Each table is linked by the Data_ID
When you wish to produce a report, you click a button. This button would do the following.
1. Run a private sub GetTotal .
GetTotal would calculate the totals from several tables and overwrite the data in the TotalValue table. (There is no need to store calculated values)
I intend to use an Update SQL statement here. Is this right?
2 Run a private sub GetReportData .The sub would get the data from the 8 other tables and the TotalValue table that now contain data for the selected Data_ID.
The SQL statement below is the one I used before your first letter.
SELECT BitsNozzles.BisNozzleRecordsID, BitsNozzles.TotalBitsUsed, BitsNozzles.TotalNozzlesUsed, BitsNozzles.BitsID, BitsNozzles.BitsType, BitsNozzles.BitsSize, BitsNozzles.NumberOfNozzle, BitsNozzles.NozzleSize, BitsNozzles.DataID AS BitsNozzles_DataID, BottomHoleAssembly.BHARecordID, BottomHoleAssembly.HoleOrCasingType, BottomHoleAssembly.HoleInnerDiameter, BottomHoleAssembly.PipeOrCollarType, BottomHoleAssembly.PipeInnerDiameter, BottomHoleAssembly.PipeOuterDiameter, BottomHoleAssembly.PipeAndCasingLength, BottomHoleAssembly.DataID AS BottomHoleAssembly_DataID, ComplusoryFields.ComplusoryRecordID, ComplusoryFields.DataID AS ComplusoryFields_DataID, ComplusoryFields.CFactor, ComplusoryFields.MudWeight, ComplusoryFields.CirculationRate, ComplusoryFields.CurrencyForMudCost, DataIdentity.IdentityRecordsID, DataIdentity.Measurement, DataIdentity.DataID AS DataIdentity_DataID, DataIdentity.WellName, DataIdentity.DataDate, DataIdentity.ReportType, DrillingMudProperty.DrillingMudRecordsID, DrillingMudProperty.Alkanity, DrillingMudProperty.DataID AS DrillingMudProperty_DataID, DrillingMudProperty.API, DrillingMudProperty.Chlorides, DrillingMudProperty.FlowLineTemperature, DrillingMudProperty.Gel0Mins, DrillingMudProperty.Gel10Mins, DrillingMudProperty.HTHPFilterates, DrillingMudProperty.MBT, DrillingMudProperty.YP, DrillingMudProperty.PV, DrillingMudProperty.MudWeightIn, DrillingMudProperty.MudWeightOut, DrillingMudProperty.Water, DrillingMudProperty.Solids, DrillingMudProperty.Oil, DrillingMudProperty.AveROP, DrillingMudProperty.MaxROP, DrillingMudProperty.VIS, DrillingMudProperty.ShaleDensity, DrillingMudProperty.ShaleFactor, DrillingPumps.DrillingPumpsRecordsID, DrillingPumps.PumpNumber, DrillingPumps.RodDiameter, DrillingPumps.StrokeLength, DrillingPumps.Efficency, DrillingPumps.DataID AS DrillingPumps_DataID, DrillingPumps.PumpOutPut, DrillingPumps.PumpSize, DrillingPumps.LinearDiameter, DrillingPumps.PumpType, DrillingPumps.PumpStatus, PressureLosses.PressureRecordsID, PressureLosses.DxC, PressureLosses.DataID AS PressureLosses_DataID, PressureLosses.EMWLOT, PressureLosses.EstOverBurden, PressureLosses.EstFratureLoss, PressureLosses.EstPorePressureLoss, PressureLosses.MWDPressureLoss, PressureLosses.PipeRunSpeed, PressureLosses.CasingShoePressureLoss, PressureLosses.DxTrend, Reports.ReportRecordsID, Reports.ADT1, Reports.ADT2, Reports.Operator, Reports.Contractor, Reports.TVDDepth, Reports.MDDepth, Reports.DataID AS Reports_DataID, Reports.Rig, Reports.Operation, Reports.ImagePath, Reports.SpudDate, TotalValues.TotalRecordsID, TotalValues.PropertyName, TotalValues.TotalValue, TotalValues.DataID AS TotalValues_DataID
FROM TotalValues INNER JOIN (Reports INNER JOIN (PressureLosses INNER JOIN (DrillingPumps INNER JOIN (DrillingMudProperty INNER JOIN (ComplusoryFields INNER JOIN (BottomHoleAssembly INNER JOIN (BitsNozzles INNER JOIN DataIdentity ON BitsNozzles.DataID = DataIdentity.DataID) ON BottomHoleAssembly.DataID = DataIdentity.DataID) ON ComplusoryFields.DataID = DataIdentity.DataID) ON DrillingMudProperty.DataID = DataIdentity.DataID) ON DrillingPumps.DataID = DataIdentity.DataID) ON PressureLosses.DataID = DataIdentity.DataID) ON Reports.DataID = DataIdentity.DataID) ON TotalValues.DataID = DataIdentity.DataID;
would changing all the INNER JOIN to OUTER JOIN help?
ihe
|
|
|
|
|
Yes, change the joins to OUTER rather than INNER.
An OUTER JOIN is one in which each row of the result set does not necessarily have to contain a row from both tables begins joined; one or both tables are retreated as optional.
An INNER JOIN relates each row in one table to one more corresponding rows in another table. Each result row from an inner join represents the combination of values from two related rows, one from each of the tables being joined.
Steve Jowett
|
|
|
|
|
Thank you I will try that and get back if an error occurs.
ihe
|
|
|
|
|
I'm currently working on a project that requires the user to move files from one client system to another for the purpose of synchronization. I want these files compressed/zipped/archived so that the user gets to move just one file (i.e the zipped file) and at the other end, I want to be able to decompress/unzip the file and start necessary processing.
What is the best way to achieve this?
Regards,
Luther
Object-Oriented Programmer
lutherium - feel the weight of object-oriented programming
|
|
|
|
|
|
Hi Manowj,
Thanks for the help. The link was quite helpful. I have however found an alternative means of handling it.
Regards,
Luther.
lutherium - feel the weight of object-oriented programming
|
|
|
|
|
If you are not looking specifically to zip format and want good compression like winrar then try using zlib.dll its open source and free
Their site is zlib.net
|
|
|
|
|
Hello everyone,
During the installation of project, how can i save any file of project in system registry.
regards,
Syed Ali Raza Rizvi
|
|
|
|
|
You can't save a file in the registry. What are you really trying to do with this?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks to reply,
Actually i want that my project should work like "Trial Versions" does.
If project is installed on one machine then it should expire itself after 10 days of installation.
if someone try to install it again after changing the system date then it should check that, has project been installed on same machine before or not? if yes then it should stop installation.
I want to do such stuff for Piracy point of view of project.
Waiting for solution.
Regards,
Syed Ali Raza Rizvi
|
|
|
|
|
Your best bet is to use a 3rd party protection library. I don't know of any off the top of my head, simply because I don't sell my apps to the public.
Google for something like "vb.net developer copy protection library" and you'll come up with a bunch of libraries...
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi,
i want to create font creator uisng vb.net. Fonts are ttf and otf fonts.Like i should create an editor where they can draw the fonts with the help of mouse.But it should be off TTf and OTf characteristics.So can any one help in this to approach.It is very urgent...
Regards
Ravindra
|
|
|
|
|
You could look up the TrueType file format, I believe it can be found at Wotsit's format[^].
Maybe you can find something useful at the FreeType[^] project.
---
b { font-weight: normal; }
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
