Search results

Hello, I have one table with employees and positions. Each position has a specific rate which is stored in another table (table2). Since the rates of the positions are changing, I want each time the employee get paid with the correct rate. The problem is that I do not want to lose historic data...

I have created a list box in a form where it displays the data of a the form and binds the click even to show the data on the form for editing. The problem is that is some pcs not all the field are shown and in some other pcs all the fields are shown. What might be the problem?

I have created a form. I want in the bottom of this form to display the table with all the records in it and also when I click on the subform row to bring the data on the main form for editing. I did this but the problem is that in subform it only show the record I am editing it does not show...

I have created a Form and specified it as read-only. The problem is that I want with a press of a button to open as read-write. I can^t figure how to do this. Can you help me pls. Also I want when a change is done to the form to be prompted to accept or reject the changes on the exit of the...

I am using a form to enter some data. I made a specific report which will be filled with the data of the form. the problem is that I want the user when he completes a form to press the print button and transfered his new entry ONLY to the report so to be able to print it. How can I do this pls.

Here what I want to do. I want to use the autonumber facility which will restart by itself yearly in the following way. 1/2004 2/2004 3/2004 4/2004 . . 1/2005 2/2005 3/2005 4/2005 Can you help me on this please?

I have created a database in SQL 2005 Express and I made the connection through server explorer but when I run the application (VB.NET 2005) the myconnection().Open error occurers. "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this...

I am using VS.net 2005. I have downloaded a sable database and I try to connect to it within VB.NET. Unfortunatly I cannot connect to the database. En error saying that I have not install support for .MDF file. I don't know what this is. Can you help me please.

I have created a database for storing, query and deleting data. Now the user wants to delete a row from a table and create two new rows. In my opinion this will need lots of work in order to replace all related queries forms and reports in the form. Is there any whay to do my job more easy in...

I have a code but it seem there is a problem in it. The password do not appear in correct order. I want each year the password to change by itself. Here is the code: Private Sub PASSWORD_AfterUpdate() On Error GoTo err_PASSWORD_AfterUpdate Dim stDocName As String Dim Period As Date Select...

I have create a form from a query which ask me from a value. Later on I want to print this form as a report without executing the query again but to retreive the query from the form I allready executed. How can I do this? Meaning I want to print my form as a report whith the same query or to...

I want to create an application (telephone directory) in VB.NET. I want to share it among 5 computers on the network. Can all of them work on the same application at the same time? If yes how can I distribute the database to communicate with the application. Any complete quite will be usefull...

I have one word document and I want to import at the end of that word document another word document but when I insert it as a file the format of the table in the second word document is distorted and when I insert it as an object in inserts only the first page without the rest pages. Can you...

I have a file with multible lines. I managed to import this file into VB.NET. Now I want to split the file according to the data of each line. e.g. The lines could start with numpers from 1 to 10 (repeated in many lines). I will greate 10 tables (to store lines starting with relevant number) and...

Can anyone explain me what is the use of a web page on access so for me to take advantage of it? Thanks in advance

I am running on a network and I want to create a form in MS Access and work on that form for quiries and updates. The problem is that if I put the file on a share folder then only one at a time can work on the database. Can I use web page on access to create the form and do my job. Do you...

Hello, I am new in this but I have a Question. I have a web site which is on a Unix server with linux software. I have FrontPage Extentions. I think I cannot use the Visual Studio.Net to create my web site and upload it. Can you confirm this to me pls. Thanks in advance

I have this code below but there is an error on it. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 7 And Target.Column = 3 Then Select Case Cells(5, 3).Value Case "Á:0-1650cc" If Target.Value >= 0 And Target.Value <= 1650 Then...

I have created many queries from a table with differend fields in each query. Is there any way to produce a report which will show all the queries together instead of oppenning each query seperetly in order to see the value of each one. There about 30 queries thats why I need this kind of...

I have imported one table witch is split using queries. Later I have created another table with values witch represents values of queries wich needs to be replace with values of table. The attached file is reference. I dont know how to make the queries retrieve the values of the second table and...