Search results

also do note that it is not wise to have spaces in your table names. at least use an underscore _ ;)

remove brackets from table name , ie : s = DLookup("[Name]", "Asset Register", "RIGHT([Asset Number],4)=" & r)

Function vbaPasswordAfterUpdate() Dim frm As Form Dim SelectName As Control Dim Password As Control Set frm = Forms!frmEmployeeTimesheet Set SelectName = frm.cboSelectName Set Password = frm.txtPassword2 Password.Value = Dlookup("[Password]","tblEmployee","[Employee ID] = " & SelectName)...

ok since u say all the above code r valied however ur true problem lays in [Type of Premium].SetFocus then i guess i should neglect it and move on to your main problem. You say [Type of Premium].SetFocus produce "Run Time error 438 - Object doesnt support this property or method" now did you try...

Basicly i dont know where you are going but all i see r valied syntaxes only 1 problem , you deal with numbers and dates as strings useing ' single quots ' to insert them which might be the case there . now if that didnt help opening your eyes , please post me the structure of the table so i'd...

I hate to see a code that was just copied/pasted at no serious effort at optimizing it , yet her goes how i think it should go :) Private Sub cmdYahoo__Click() Dim objXL As Object Dim xlWB As Object Dim xlWS As Object Dim rst As Recordset Set objXL = CreateObject("Excel.Application")...

also why not cover the error message with a handler ? first trap error message number by adding following code top and bottom of your button sub: On error Goto Err_buttonnamehere_Click Exit_buttonnamehere_Click Exit Sub Err_buttonnamehere_Click: MsgBox err.number resume...

if you are planning on inserting a huge amount of manipulated data and columns in your excel sheet then i suggest u use linked table manager and deal with ur work sheet like a table u append queries to. the way you handle where goes where is easily achieved by introducing a new column as a...

first of all please elaborate on what you are trying to do in this section . For i believe you are being off syntax in here :( Now do note this section from microsoft msdn : If the object you're appending isn’t complete (such as when you haven’t appended any Field objects to a Fields...

1 - You can always add it , set its property invisible 2 - Current event should do , it fires whenever a record is in selection

Press and hold SHIFT key while opening your project. If it's password/security protected , press and hold SHIFT key after entering password.

This is actually not an ms access question , for all to be done client side is to print a report to a shared virtual fax driver over the 2003 server. How to setup one is beyond this forum scope , please consult your mail merge like application manuals :)

This thread keeps getting wierder and wierder http://I.Am/DougSteele is shut down a while now , bad for us the guy died with his secret :)

ok steps 1-5 for the non technicals are an attempt to encript user name an password using both conventional and inventional methodes to give exploiters hard time to decode them. 6-needs elaboration as to "how ?" 7-is vague!

sounds like there might be a smart thought here hidden somwhere , please elaborate :D

Banana arent you the cutest :) Giving the users database password and all. This reminds me of the time when microsoft realized that most attacks and crashes of microsoft isa 2000 are generated by internal users of the network because they were annoyed by bandwidth limititing rules so for a fix...

argggggg ... ok would this do it for u ? strSQL = "SELECT * FROM [Names]" Forms!Names!ListNames.RowSource = strSQL Me.Requery

-We can see the code but which control and which event runs it ? -What do you mean (And try to use access terms) by table1 is connected to Listbox ? -Is your list box bound to a "Control Source" ? -Please elaborate on the need for unlock your list box since it's an output field not an...

Ok so here goes: In my hunt of securing my access application I was confrunted only 1 challenge. And hopefully nobody would even try and think of System.mdw Security permissions to solve it ;) Now the one and only hole that cant seem to be solved by any conventional mean is (Drum Rolls)...

Actually this isnt realy an Access nore VBA question , what you are achieving here is running your pdf file with whatever reader assigned to open such an extension. Now how to achieve your goal is by rather googleing switches for your acrobat reader of choice and manage it to be installed by...