Search results

iv looked everywhere on the forum but no one has an answer! i need to export names and contact info to outlook without using saved export! PLEASE HELP!any tid bits or maybe a link to some base code to work off of.

lave it count every time it loops and lopp up the last "x" records.

Why not any spaces? i have not run into any troubles with that yet

HA Changed To If Me.Password.Value = DLookup("[Password]", "[User Name]", "[User Name] = '" & [User Name] & "'") Then SaiCurrentUser = [User Name] And it worked! thanks man!

Its telling me that my password is wrong, i took off the input mask and its right. This works under my login button. Private Sub Password_KeyDown(KeyCode As Integer, Shift As Integer) On Error GoTo ErrorRPT Static LogonAttempts As Integer Dim SaiCurrentUser As String...

So: Private Sub Password_KeyPress(KeyAscii As Integer) On Error GoTo ErrorRPT Static LogonAttempts As Integer Dim SaiCurrentUser As String SaiCurrentUser = "" If KeyAscii = 13 Then If Me.Password.Value = DLookup("[Password]", "[User Name]", "[User Name] =...

I have a login screen and i want to have it so when the user presses the enter button in the password box it logs in. i was trying to lookup the key press event but im not sure how it works.

You are not specifying what table to select

insert this as the code as the button that opens the form DoCmd.OpenForm "Your Form Name Here", , , acNewRecOr Put this in your onload event: DoCmd.GoToRecord , , acNewRec

duh....i named the function and the module the same thing........

Ok in my module i have: Public Function ErrorRPT() Dim rserror As DAO.Recordset Dim db As DAO.Database On Error GoTo Errortxt Set db = CurrentDb Set rserror = db.OpenRecordset("Errors", dbOpenDynaset) GoTo Endsubtxt Errortxt: MsgBox "The program has encounterd a error! The error has been...

Nice works like a charm! Thanks again!

thats a good idea ill try it thanks!

how do i make a module send a e-mail at 4pm every day? i know how to format the e-mail and i can make a button that dose it but i cant make it automatically send it.

http://www.access-programmers.co.uk/forums/showthread.php?t=99777 look at post 9 this will show you how =D

Hello I want to try to learn SQL im new to programming in general i have learned alot of vba for access and i want to do more with querys and learn SQL. is it more difficult than VBA? where are some good free online resources?

Not fammiliar with SQL this is what comes up in SQL SELECT [Main Inventory].[Product Type] FROM [Main Inventory] ORDER BY [Main Inventory].[Product Type];

how could i create a query like that?

Challange Hummm how could you make that so it dose not requre a code change if a new type is added this is what im thinking: Private Sub Command16_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim rsType As DAO.Recordset Dim MType As String Dim TypeCount As...

Ok i have 1-X diffrent Machine types (around 30 or so) i want to make a report that counts how meny on each machine type there is. First shown on a form then in report how do i count them in report view (like =Count([control])??? or somethig along those lines.) and counting each type and...