Nebil

Hi guys, i'm having a difficulty to set the path in vb.net.i put the code in the module and every time i run the code it throws error "Could not find file 'C:\Users\Abdueie\Desktop\BMS\Bridge Asset Management\Bridge Asset Management\bin\Debug\Adigrat.accdb'." here's the code Public conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source= .\\Adigrat.accdb;Persist …

Hi all, I am having issue with my datagrid view. I plcaed some code in the 'SelectionChanged' event of the control. What the code does is it assigns items based on index to textbox items. This exception is raised when ever I click on the column header of the data …

Hi, I am having trouble with dropping a temp table. I was using it so many times in other projects but this time it went bad. The only thing different now is that I referred a string value from the main form to another form.The other form populates a dgv …

Hi, I had a little problem dealing with this error. It's raised when i run the application on another pc.But the program works entirely perfect except at two places when closing the forms. Before getting this error I had another error that says: An error occured creating the form. Something …

I am fairly new to crystal report and I need a help. I have a report having two groups,project id and work_item. And I placed 3 sub reports material,labor and equipment reports in the work item group. They pass a value to the main report that is used for further …

Hi guys, I've got a little problem.A part of the project I'm working on reads data from an excel file and stores it in the database. It works fine for 15-20 records but fails after that. I have properly closed the connection and the reader I'm using. But ut doesn't …

Hi, I had a little problem in querying something. When defining a project you use work items. And a work item may use a material, labor and equipment. It may not use one or two of them for that work item when it is defined. So for that work item …

Hi, I wanted to update a table in access db using right outer join.I created a temp table,copy the structure from the destination table and used it to store values from an excel file.And using right join tried to update the destination table making the temp table as a source.It …

Hi, I've got a little issue with a progress bar.I have a label and the progress bar on a form.I've some calculation to be performed and then stored to the database.I wanted to show the progress of this process to the user.The calculation process is on another form.when the process …

I have an excel file that i managed to perform some calculation.It's to know the asset value of bridges in a current year.I have 21 fields in the file.Out of the 21 fields,seven fields are just information about the bridge,the rest are used for the calculation based on various conditions.And …

Hi guys, I just got into a little problem.I just deployed an application with backend db access.It works fine on major OSs being used like win7 and XP. But some functionality related to the database doesn't work properly when deployed on win8. I used a code to delete temp table …

Hi all, I had a little problem when deploying an application having crystal reports as a reporting tool on a client pc. It works so well in my dev pc even installed.Since i'm using Access 2007 i used Microsoft.ACE.OLEDB.12.0 provider. I haven't provided any password or username for the database.But …

I've a problem in getting a record from 3 tables: There are two conditions for getting the records,'project number' and 'current month'.I used this statement to get the records but it results in 3 times the actual record. Any help would be appreciated. "INSERT INTO patempTable SELECT [pay_roll].[project number],[pay_roll].[employee number],[pay_roll].[current …

Dim dr As OleDb.OleDbDataReader = GetData(qry) If dr.HasRows = True Then Do While dr.Read TextBox32.Text = dr.Item("total") If Val(TextBox32.Text) > 800 Then TextBox37.Text = Val(TextBox32.Text) - 800 Else TextBox37.Text = 0 End If TextBox38.Text = Val(TextBox36.Text) + Val(TextBox37.Text) TextBox31.Text = (Val(TextBox33.Text) + Val(TextBox32.Text)) * Val(TextBox34.Text) Loop Else If MsgBox("Fuel allowance …

Hi, I was wondering if there's a way to check an existing id in the main table when using temporary table,then use another id for inserting records.Since it may cause error for using the same id in the main table. Is there a way to do that?

hi guys, I wanted to get a result of a certain field by passing a month and year parameter to access database,the day parameter isn't important.So i used this query and it raised an exception.The record exists but it says there's no data for that column. Any help would be …

Hi guys, I wanted to extract a field from a table by date and two other criterias,but it's giving me an exception. The field that is a long integer data type and i used integer in the code.And the date is also available in the database. Am i missing something? …

Hi guys, I just faced a silly but annoying problem.I was building a database application with vb.net and access. Things were going great but at the last moment,it started to not work properly.I didn't touch the db path as far as i know but i changed the system date as …

I was going to check if a temp table exists and delete the it,since "the temptable already exists" arises if you want to perform another operation. Here's the code i used five statements but it says syntax error in drop table or drop index statement. Any help would be appreciated. …

Hi guys, i just faced a problem when trying to execute the following query.I searched for the exception on the internet and found that using a reserved keyword might raise this issue,and using brackets may solve this problem.But i use brackets all the time in my sql statements but still …

Hi guys, A problem came up when i tried to copy record from the temp. table to the main one.I was copying records to two main tables but one table is empty but the other works fine.Here's the code i used: projcode = TextBox4.Text projname = TextBox5.Text description = TextBox6.Text …

Hi guys, I was wondering if it was possible to create a temporary table. I have a bunch of records to be added to the database.But before doing that i wanted to first put these records on a temporary table,same struture as the main table of course then after that …

Hi guys, I have a form that could be called from 3 tool strip menu items at different times.And from that form you can select an item and proceed to another form based on the selection.Since they share the items this form is holding. Now i want this form to …

Hi all, I was going through a lot of resources on how to populate a dataset.And i kind of got an error when trying to populate the created dataset with 4 select statements. but my sql uses the where clause,the other statements i saw select certain columns and go to …

Hi all, I just came up with a little problem.I used crystal reports for my reporting. And i used five tables for the report.I've used SQL statement to select the records that i want. But crystal reports displays each record (selected by the sql) on a different page which makes …

i have a rich text box that displays items.These items have column names.The column names are loaded when the form loads.They hold values as rows.These rows are appended at a click of a button (when add button is clicked). At the bottom,let me say i have another field(total amount) in …

Hi guys, I'm a little bit confused to declare a certain variable. I defined it under a button.It's in a do-while loop and it stores calculated values while other this are being executed. And i wanted to extract that value using another button.I know i can use a function but …

I wanted to multiply two values from two different tables. I have a quantity filed stored in one table and a unit/rate field in another. How can i write the sql statement based on a condition and store that multiplied result for further actions.

H guys, I just faced a probelm with my code.It raises an exception.This is the code. conn = oSubPayItemDescription.GetDbConnection() cmd = New OleDbCommand("SELECT [sub_pay_item_quantity].[quantity],[sub_pay_item_unit_rate].[rate] FROM " & "[sub_pay_item_quantity],[sub_pay_item_unit_rate] WHERE [sub_pay_item_quantity].[sub item]=[sub_pay_item_unit_rate].[sub item] AND " & "[sub_pay_item_quantity].[sub item]='" & subItem & "' AND [sub_pay_item_quantity].[bridge type]='" & bridgeType & "' " & …

Hi all, I was just using iexpress to wrap up my vb.net project just to make it .exe file. It went fine but when i launched the .exe it's telling me that the database doesn't exist in the file. I put my database file in \bin\debug folder.Now it's telling me …

Hi guys, I just figured out the normalization problem.And i'm moving on to the application. But i'm facing a problem,i needed to check if an id exists in the db when an item is inserted. It's saying the title i just wrote on the article.Here's the code i used. 'Tocheck …

Hi all, I have a project that I'm going to do.There's a table that has to be normalized.i need your solution just to check mine with yours.Here's the table with sample data. I have taken Pay Item as a primary key: Pay Item Description BridgeType Span Unit Quantity 81.02(a)-I Soft …

Hi all, I wanted to load a listbox with items from the database.I just wrote the code using oop. But on the interface i'm not sure how to read and insert the items in the listbox. How can i access the items being read at the client side(interface). Public Sub …

Hi, i'm working on a system rate analysis.I just worte the code using oop. i worte a code that inserts a record into the database.when i try to insert a data nothing happens.Please fix my code. //this code is defined in a class Public Function AddWorkItem(ByVal workitemNumber As String, ByVal …

Hi all, I was going to develop a rate analysis(that does a cost estimate for construction).Previously it was done using Excel.Now i wanted to convert that to vb.net having a database. I need some one to give me a hand on that. Thanks!

Hi guys, I wanted to do a simple calculation using vb.net.That is i would have some values that are used as an input read from excel in the calculation.the values may be changed or used as they are. In the vb side i would have some textboxes that garb the …

Hello guys, I have a problem with data type.I want to store a field with a currency format in access with vb.net.i did it by using the format built-in function in vb.net but it only stores the field in access if it's only in text data-type.If the field is in …

Hi guys,i was using crystal reports in my vb.net project.I read in some books and in the internet that you can create a grand total for some fields like total cost calculation.And using 'sum' you can calculate the total result.well in my case i can't find 'sum' in my crystal …

it's me again i had a code that searches a record based on user option.And i had the idea of creating a single function that accepts a query statement and execute and return it to the caller but i can't come up with anything(not make the code bulky).i have 3 …

Hi guys,i just wanted to know how to export a record when ever a user clicks from a listview and export it to excel by adding a worksheet whenever the record is more than 3,basically excel offers 3wrk sheets. can u help?Thank You!!!

Hi guys,i was having this problem with inserting a record into access database in visualstudio 2010. here's the problem,here's the code bridgenumber = TextBox1.Text.ToString() bridgename = TextBox2.Text districtname = ComboBox1.Text sectionname = ComboBox2.Text roadsegmentname = ComboBox3.Text bridgetype = ComboBox4.Text bridgespan1 = TextBox3.Text bridgecondition = ComboBox5.Text acquisitionyear1 = ComboBox6.Text evaluationyear1 = …

Hi all, I was having a huge problem,i mean i spent days trying to fix it but i get the same exception everytime when i run the app. here's the thing i have a record that is loaded from the database using the listview.it works perfect for the insertion part.but …