Search results for query: *

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...

Thank You very much, That is exectly what I wanted A star from me

Hello ... I have a list box in a form and I want the First line to be always selected automatically. How can i do that? Thanks

Hello Everyone.. I have a listbox and I want to find the max value from a specific column... Thanks..

That was very helpfull. Though if you see my Loop I choose the value in List Box which is been taken from a specific column by using the Bound Column property. And my purpose is to do the Loop without selections on the List Box. For Example in the Got Focus Event. Thanks..

Hello I have tried the following code. No success. Any Ideas? I want to find from my List Box a row with a value "September". Dim idx As Integer Dim counter As Integer For idx = 1 To Me.List605.ListCount - 1 counter = idx If Me.List605.Value <> September Then Do While...