Search results

hi ridders and minty i was typing wrong but now its correct. but now access keeps asking for a new module how do i disable the abd have all all my other macro and modules run

ive typed what youve pasted into my database. i cant copy and paste

also im not sure of the sytax to put two dlookups in one exexpression query can you assist

hi none of the code posted worked in the expression builder or where you put code under the text box. i get syntax errors. the last code i posted was the only dlookup to work but i throws a microsoft cant find the referenced form error can you help with this error. there is suppose to be some...

hello i finally have the dlookup working by putting code in the rextbox expression builder but for some reason its throwingan error that it cant find my form. how do i solve this. this is code in expression builder =dlookup("ncpid", "main entry table","ncpid=""&Forms![Enter New Credentials])...

i updated the following code and got syntax error on public statement. the code is not bringing up the forms in the text box when i click in the box for after update. public sub text19_afterupdate() Dim varx as string varx= Nz(DLookup("ncpid", "main entry table"," ncpid='"" & [me.ncpid],"")...

i meant public statement not private

error is on private statement its hightlighted i yellow

public sub new_look() Dim varx varx=Nz(DLookup("ncpid", "main entry table", "ncpid='""))&[Me.ncpid]) then if null (varx) then DoCmd.OpenForm("Enter NewCredentials") else DoCmd.OpenForn("Update Existing Credentials") end if end sub

the statement public sub new_up dim varx is giving me an syntax error and wont let me proceed

i took it out expression builder and entered code in after update and there is and error with private sub text17_afterupdate() this is highlighteded in yellow

sorry i get operand without operator syntax error with the above code. i put brackets around all special characters and still getting error

i rewrote so now in expression builder on form i have the following subx= Dlookup("ncpid","main entry table","ncpid='""& Me.ncpid") then iif isNull(subx) then Msg"the ncpid does not exist" & crlf & "Do you want to add ncpid?" if Msg Box(Msg, vbQuestion + yesno) =vbYes then DoCmd...

i had tutorials dlookup and openform wasnt in there

im an access coder not vba kind of new to vba i only coded one thing in vba one database and it wasnt this complicated

when i run the code nothing happens , it doesnt work at all. it does nothing

Private sub Dlookup () Dim subx Dim suby Dim Msg Subx=IIF IsNull Dlookup("ncpid","main entry table","ncpid='" & [Forms].[Enter new credentials].[ncpid]) then go to Msg("the ncpid does not exist") Msg("Do you want to add ncpid") IIF Msg box(Msg, vbQuestion + yesno) vbYes then...

thank you for welcoming me

hi im ericka im an access programmer for couple of years.