Israelsimba

Im running an accounting package using crystal reports. all my fields are coming from the table except the totals. the problem is i have a running total where the **total income**-**the total expenditure = net income** for each month. the problem is that the opening balance is supposed to be …

Im using an epson dfx 8000 to print my reports. the printer prints on preprinted stationery and was printing fine until recently after a service nd it now adds a blank line at the top of each new page. this means my columns wont sit properly into yhe preprinted paper. …

i developed a payroll running in VB6 and using SQL 2000 Database, and when i install it on my laptop with windows 7, it gives me an error message 'You dont have permission to perform this operation'. Im logged in as administrator.

im facing a challenge here peple. i will give as much detail as i can. i am trying to come up with code such that when a button is clicked it runs through a field "copiesremainng" in my subscription table and subtracts 1 from every record in that field. this …

Ladies and gentlemen i thank you for your assistance in my system that i have been developing. my organisation is very impressed by it. i was thinking of a situation whereby my system could give a notification when a person's copies he subscribed run out. i mean when the copies …

is it possible for me to retrieve data from different tables then display them on a single data report. i am using a data environment for connection. if its possible how can i do it

i know that a select statement is the best way to go around retrieving records from a database. the problem im facing is selecting a record then assigning a certain field from that record to a variable eg x..... so in simple english, it has to be something like....select clientnumber …

My subscription system is now running though with errors here and there.the error that concerns me a lot is a runtime error that says [QUOTE]multiple steps generated an error check value status[/QUOTE] and points to this code....[CODE]r.Fields("companyphone") = txtcphone.Text r.Fields("companywebsite") = txtcwebsite.Text[/CODE] and this code is in my save button. …

i am trying to make sure that one record is not entered twice into the same database but the code i am using is giving me an error [CODE]Set ri = deSub.conn.Execute("SELECT* FROM individualsubs WHERE firstname = '" & txtfname.Text & "' AND surname = '" & txtsurname.Text & "'") …

I have a subscription system that i have developed. the system is supposed to automatically subtract the number of copies given to a client every monthend as per request they made of the copies required upon joining. my problem is i cant make my code run through my database so …

i have created a database for subscriptions in MS Access 2007. I want to link it with my forms using the code below but its saying unrecognised database format. [B]Dim conn As Connection Set conn = New Connection conn.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=C:\subscriptions2.mdb".......[/B] Now i have converted it to Access 2000 format …

i have been using adodc for searching for a client's details using the client number, but it would give me inexpected errors and bomb out of my programme. i have then resorted to searching using sql. the following code gives me this error::: [I][U]no value given for one or more …

Hello All. i have just finished coding a small subscriptions project for a magazine. My main challenge now is the package is supposed to send emails to subscribers notifying them if their days are due. email notifications are supposed to be sent to clients telling them of the status of …

Hello there!! i am glad for the help i have recieved before which helped solve my problems. my challenge now is that the following code fails to save to my Access 2007 database. it doesnt give me any errors but it does nothing. i want details i enter into the …

Anyone please help. Why is it that [B]Adodc.recordset.save[/B] cannot work. it says...object in the with variable not set.... can anyone tell me what the problem is and is it normal to use [code]Adodc.Recordset.fields "name" = txtname .text;[/code] what is wrong with my code. is anything missing there because i cannot …

[B]i enter text into a text box, when i move to the next textbox, the text i entered in the other text boxe disappears.....this started when i run form after linking my text boxes with the necessary database items.. i used an adodc for connection. before connecting the textboxes i …