Code:
Private Sub Form_Load()
Text9.value = DLookup("oleku_nimi", "[Arvete olekud]", "oleku_id= " & Me.oleku_id)
End Sub
tujurikkuja
Last Activity: May 17 '12, 09:58 AM
Joined: Apr 15 '12
Location:
-
Run-time error 3075 using DLookUp
This should fill a field on a subform. When I run just the subform then it works fine. But when I run it from the main form then it gives me run-time error 3075 pointing to 'oleku_id= ' saying that it is missing an operator. I already tried referencing the Me.oleku_id differently:... -
Weirdly enough the code goes red and starts popping up messages about the date/time not being a date. -
DLookUp function doesn't want to work with my code
...Code:Private Sub Command11_Click() Dim strSQL As String Dim criteria As Integer Dim ete As String Dim row, place As Integer ete = Me!etenduse_nimi row = Me!Rida place = Me!number criteria = DLookup("[broneeringu_id]", "BroneeringudQ", " etenduse_nimi='" & ete & "' AND rida=" & row & " AND number=" & place & " AND Toimumisaeg=" -
Finally got a decent solution. It was DLookUp function. Got everything done in 2 minutes after i found out how to use that and what was the syntax.Leave a comment:
-
Ooh I understood now what you meant. Not the values are "0" and "1" but the query should give 0 values or 1 value.Leave a comment:
-
My Clientbox should give values from 1 to n. So simply 0 and 1 are out of question. Sorry for double post...Leave a comment:
-
Well the combobox value should be from 1 to n.Leave a comment:
-
Don't understand what you mean by querybox.Leave a comment:
-
Okay. I'll give that a try. But the query has to take one attribute from combobox. Doesn't that affect the result? Can I save that kind of query as a query in Access? I mean does Access let you save a query that includes a reference to form object.Leave a comment:
-
Can you use eof for finding out if the recordset is empty?Leave a comment:
-
This code is missing the part that checks for a record that is in state "1". This far I got by myself. The real problem was how to check the properties of a record.Leave a comment:
-
Well that's why my original idea seemed so good that there is always only one receipt in state "in creation" for each client. Because if there isn't any, new one will be created. But if there is one then this receiptID is being used until its state will be changed to something else and then it means that new receipt has to be created...Leave a comment:
-
How to use SQL query in VBA function?
I am using Access 2010. I have a database that consists of bookings, receipts, clients and so on. I have made a form for booking tickets. The first field I have on my form is a combobox where a user can choose the username. And the second (receiptID) field should be filled automatically after the user has chosen appropriate username. I have an idea how to fill that field but what i don't have are the skills.
My Receipts table has these fields:...
No activity results to display
Leave a comment: