Search results
-
R
Displaying the wrong row of data from combo box
Thanks Cookie, I forgot about that. -
R
Displaying the wrong row of data from combo box
I have a combo box that when I select a record from it I want it to populate three other fields plus the combo box field, which it is doing fine. Except when I have duplicate fields. Such as I have a field named MFGORD which the combo box is sorted by, there are two records with the same value... -
R
Can't get into design mode of report for logged In user
Thanks for the reply, the database is on a Shared network with full rights to it. All the databases he has tried are ones he has been using daily until today. I can't figure out what has happend or what he may have done to mess it up. -
R
Can't get into design mode of report for logged In user
I have a user who, in any database he goes in and tries to open a report he gets "Action has been canceled". I tried to go into the design of that report and it just doesn't do anything, no error nothing. I tried to go into some code in a form so I could see the reference list and then it... -
R
Drop Down list picking wrong row
I have a drop down list in a form I've created that is based on a query, it has 11 fields in the drop down and is sorted by a customer Name, Customer number and suffix. All 11 fields are used to populate fields on the form. In the drop down there are rows with duplicate Customer Names and... -
R
Problem using DLookup
I tried using the " & Forms![ABM KB SETUP SHEET]![Part #]) and it still said "You canceled the previous operation" Run Time Error 2001". So I thought maybe it's the special character So I changed Form Name to Part and the code to read Dim strECN As String, strItemid As String strItemid =... -
R
Problem using DLookup
Thanks, and I know about the spaces and special characters, but this database is one I took over from someone else, there has been so much delevelopment on it I was afriad I'd miss something if I started over and renamed things, but maybe I should anyway. Thanks for the reminder. I will try your... -
R
Problem using DLookup
I am having trouble getting Dlookup to run. I have used it in the past without any problems but in this database I keep getting a runtime error 2001 You Canceled the Previous Operation. The code I'm using is ME![ECN] = DLookup("[ECNNBR]", "tbl MFDI", "[Part Number] = Forms![ABM KB...