Search results

as it is now i use only DoCmd.OpenForm "FormC", i dont have much ,,,, after that. Now i just put , "form_a" behind it? Openargs is the args you put behind the form you are opening?

now we're making sense yes.. Thats what i want. But i've never used openargs before. Do i just make a Integer, and make it openarg? Lets say Set T As Integer, and set T = 1 in the Form A, and 2 in Form B. and then i can check if T is 1 or 2 in form C where i want the difference. But where...

i'm typing this into a control =[LevNavn] & vbCrLf & [LevAtt] & vbCrLf & [LevAdr] & vbCrLf & [LevSted] This doesnt work. There gotta be a way to use more than one line in a textbox. Any suggestions?

thanks sir. But its not quite like that, i dont want to type in a value, or display another value, i simply want a little bid of editing in my SQL string if i enter from A or B, because it has to read from a controll from A if it's opened in A, and it has to read from a controll in B if it...

It's still the case. If statInt > 0 Then If sendInt > 0 Then If IsNull(Me.Send) Then sMsg = sMsg & "Ny Status: " & DLookup("[Status]", "Status", "[StatusID] =" & Me.NyStatus) Else sMsg = sMsg & "Ny Status: " & DLookup("[Status]", "Status"...

how do i do that? I could also just make a variable that war true if i opened it from one form, and false if i opened it from something else.

Private Sub Kommando23_Click() Dim strSql As String Dim A As Variant Dim B As Variant Dim C As Variant LevNavn = Me.LevNavn LevAtt = Me.LevAtt LevAdr = Me.LevAdr LevSted = Me.LevSted FakNavn = Me.FakNavn FakAtt = Me.FakAtt FakAdr = Me.FakAdr FakSted = Me.FakSted Kommentar = Me.Kommentar C =...

I found a way that made me not have to stop the code, but now it complains about the fact that i stopped the last operation. Runtime error 2001. Why is that? is it really a problem that i open a new form before a code is done running?

What is openargs?

I have a form i want displayd when clicking a button in two different forms. I have Form A, B and C. I want there to be a button in both Form A and B that both opens the Form C. But heres the thing. I want the C to difference between being opened from A and B. If i open it from A, i want...

but can i then make it start again if i press a certain button in the new form that i've opened?

I have a fairly long if-code. some places in that if, a form should open If Something Then DoCmd.OpenForm End If The thing is, depending of what i do in the new form that i open, i would continue the code, or not. Not continue that if, that wouldnt make sense, but i have something that...

Cant i use DLookup from a table that is not the recordsource of the report? I want to DLookup("[Field in another report]", "AnotherReport", Field = " A field in my recordsource)

Ah.. ok. Yes. Then i understand. But for my purpose, i just as well use first.

Field A is the primary Field B has 3 different values Field C and D has a standard value for each value of B. Lets say B has values 1 2 and 3. Field C and D is equal for each B. But they could not have been. And i just show one record for each value of B. If C and D had different values...

This is for display-purpose. I have a table i can read from, and i want to use DLookup to display 4 of those values in one textbox, but with 4 lines. Only for display.

wouldnt that be a problem if C and D had different values for one value of B? I have to use an expression, and i picked first. Since i know they are all alike for each value of B.

PK? And wouldnt i need 4 fields for each adress?

Can i make 4 =DLookup in ONE texbox with 4 lines. I want each lookup in seperate line. i reckon i dont use vbCrLf in a controll?

Yes.. it would be likely that up to 100 records would have the same adresses. So i think an autonumber-table would make sense. I dont need the ability to search for any of these, just want it to display in a certain form. The invoice and delivery-adress would often be the same, yes. But not...