Recent content by DRathbone

Thank you Bob for taking your time to look at that. :D

As request - thanks for taking your time to look at this :o

Not a problem, thanks Bob - give me 2 minutes

Sorry Bob I just input the 'where' on that quote to signify where I thought the search citeria was defined. I use this exact line and its only matching againest the first record in the user table

I thought the criteria was part of the DLookup? ie. User= NZ(DLookup("[username]", "Users", where "[username]= '" & forms!login.txtusername & "'"),"") /open users table , look at username field and find a username that matches the value in txtusername???

Whislt under going testing I have found that this code is only matching a username and password thats the first record in the users table..... how would I loop the dlookup?

Answered my own question - the control was bound to the incorrect column

Wondered anyone could help....... see attached file I'm trying to get the values from the right hand list box show (two fields selected ('location' and 'description')) and once you click "add selected" the list box on the left is populated with a COPY of the 'location' name selected (so the...

I have a blank listbox on a form with a 'add' button beside it, once 'add' is clicked a second listbox appears (had visable = false) on click visable = true. The second list has many values listed within it (based on a query), a second button also appears with the list box '<' - with the...

My recent enquiry sounds like it will help you out http://www.access-programmers.co.uk/forums/showthread.php?t=123694

Wat you want is a main form with a single combo box and search button, then a subform with all required results (based on a query from your DB) then if for example you where searching for productid within the query criteria specify Like "*" & [Forms]![themainfromname]![txtseachboxonform] & "*"...

I've just undertaken a very similar project, designing the tables using normalisation was a crucial process, I had a Asset_general table with AssetID as primary key - within that table are a list of defined fields that computers, software and hardware share such as 'manufactuer', 'purchase...

Super! Many thanks AGAIN LOL

I do infact have referential integrity. I do use.... DoCmd.RunSQL ("DELETE * FROM Asset_General WHERE AssetID = '" & txtAssetID.Value & "';") it returns "Data Type mismathc in criteria expression" AssetID is a AutoNumber should I change to txtAssetID.text?? / .number

Sorry, I'm not having much luck.... Heres my statement: DoCmd.RunSQL ("DELETE * FROM Asset_General AND Workstation_Server_Laptop WHERE AssetID = '" & txtAssetID.Value & "';") "Syntax error in FROM clause" in debug it it returning the correct value so I guess the sql syntax with the AND...