Search results
-
K
form to form value
I have a form (main) that has a command button that opens (bulk) another form (specific record) based on field [IDnumber]. How can I double click on a field on the bulk form and have it populate a field with that value on the main form? I can make it work if it's on the same form but not to... -
K
Event Next Record
What event would I use if I wanted something (empty an unbound field) if I go to the next record? -
K
combine fields with return
I actually put it in a command button onclick. Works just as I need. Thanks again... -
K
combine fields with return
I see. I will try another way then. Thanks. -
K
combine fields with return
How do I break this line into two lines. I tried _ with shift enter but I get an error. ="Username: " & [Username] & Chr(13) & Chr(10) & "Password: " & [password] -
K
combine fields with return
I would like to combine four fields (path, password, username, name) into a unbound text box. But I would like them to be stacked. So, need a return after each field. I tried Chr(10) Should look like this... path password username name -
K
Multiple Dates
I'm using the following code in a query but can't seem to get what I need... Date: IIf(Not IsNull([Manalysisdate1]),[Manalysisdate1],IIf(Not IsNull([Manalysisdate2]),[Manalysisdate2],IIf(Not IsNull([Manalysisdate3]),[Manalysisdate3],IIf(Not IsNull([Manalysisdate4]),[Manalysisdate4]))))... -
K
less than date
I'm working with a datesent field in a query. I do not want records from today and less than 14 days. So, I don't want to see records from 3/18/22 to 4/1/22 Not Date()-14 like this? -
K
lngLookup in multiple fields
Well, the code I'm using now works perfectly. When a user inputs a value in that field and it already exists, I get a message. I'm not looking to redesign, just to want to know if I can make it look at the value in the other fields too. -
K
lngLookup in multiple fields
I'm using the following code to check if a number exists. How can I change it so it looks in the other fields too? Other fields: Msamplenumber2, Msamplenumber3 and Msamplenumber4 Private Sub Msamplenumber1_BeforeUpdate(Cancel As Integer) Dim lngLookup1 As Variant lngLookup1 =... -
K
Not Null Query
This is what I'm looking for... Seems like it's still not clear. Sorry. In my query, I don't want to see records that have ALL three fields with a value. If ALL three have a value in those fields, I do not want that record returned. All other combinations I want to see those records.