Recent content by andyukcy

i want to print on a paper with a specific backround, some data from an access table which i connect to my vbproject and some data that i calculate in my form. this data are in a list

how can print data from a soure, data that i calculate in the form with a backround image? thank you

I know this is mentioned a lot of times .. and you ppl gave the same solution over and over again .. however, as the solution is so simple, it is easy for someone knowing access to find the way to enable the shift key again. Is there a way to further secure the database? I have also locked...

Thank you everybody for your help. I have managed to find the solution .. now that u helped me understand what i was looking for.

hmm i do not want it to stay with the db!! I couldnt find the code to chack on load of the main form whether the computer has a preset registry key

Thank you for your replies. The database is not in a network. You told me to write some code to check for the value of a hard coded registry key ... any examples of such a code? Andy

Hi! I have a database that i give to my customers. I want to add a registry key to the computer i personally put the database on so that even if my customer copies the database and puts it on another computer it doesnt work. Only i have to know where and what registry key i have to enter to the...

Private Sub Student_Id_BeforeUpdate(Cancel As Integer) Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst "DatabaseCustomerId=" & Me![Student Id].Column(0) & "" If Not rs.NoMatch Then MsgBox "Customer already treated" Cancel = True End If Set rs = Nothing End Sub

I get a "User defined type not specified" error message at Dim rs As DAO.Recordset

SQL code of the subform's RecordSource SELECT payments.DatabaseCustomerId, Customer.CustomerName, Customer.CustomerSurname, payments.PaymentId, payments.Amount, payments.Information, FROM invoice INNER JOIN (Customer INNER JOIN payments ON Customer.DatabaseCustomerId =...

Hi ! I have a subform showing in datasheet. There, i have a combobox where i select customers. In the next line, i do not want the user to be able to select the same customer as thsi would create duplicate data. How can the drop down menu of the second lise remove what was selected in the first...

I have a subform withing a form. The subform is for payments made by our students. I have a text field called tot_amount which calculates the total amount. In the main form i have a text box which is called total and takes the value from the tot_amount =[paymentss]![tot_amount] Unfortunately i...

how can i put the symbol of infiniti on a command button of access?

hello, I have about 2000 emails in my inbox from customers who contacted me from time to time. As X-mas approach i would like to send all of them an e-mail X-mas card. How can i add all addresses to my address book ? thank you andy

Hello Everyone... I have a database which keeps the number of points each of my players scored in every basketball match. I have a table named "players" and another one called "match scoring points". In the "match scoring points" form, i want the easiest way to enter the number of points scored...