Search results

Little bit weird that it does that, but okay, that's Microsoft. DMax() also makes inconsistent numbering doesn't it? Because it just checks for the highest value and adds 1

I got a table with "ID" as autonumber field. However when I have ID numbers: 1 2 3 4 5 6 7 And I remove record 4, then I got 1 2 3 5 6 7 How can I make it fill up the missing "4"?

That did it, thanks :)

Okay, got it now. I now what you mean. I made a form which I wanted to be the form and embedded that form in another form so I got the form I wanted......hahaha.... I now just took the subform to be the number 1 form.

yes, I agree with you that it makes things needlessly complicated, but I really can't see how to do it otherwise..........?

Okay, Well how would the code look like in VBA?

Aan okay. Offertes should display its data. How do I make a LEFT join? Just by changing 'INNER' to 'LEFT'?

So basically I got values in my 'offertes' table which aren't in my 'contactpersonen' table? I read about LEFT join but don't think I completely understand it: Does LEFT join just display me all data in 'offertes', also if it is not corresponding with another table?

I want to display the total amount of quotes in the current month in a graph, but I can't find how to do this. Can someone help me with this? Later on I want to display some graphs of this based on some criteria.

I got a form called "Producten" (Dutch for 'products'). This contains an overview of all products. What I want is that another form ("producten - details", dutch for "products - details") opens when the "artikelcode"-field (artikelcode is Dutch for "articlecode) for a product is double-clicked...

I got a query "Offertes query" (offertes means "quotes") This one is supposed to show me all quotes and for each quotes the already specified fields. Unfortunately the query doesn't load the requested results. Can someone please check why it isn't loading the results?

When I open my form to create a new quote, Access initially creates a new record for it as it should. It then identifies this record by the quotenumber. This works perfectly. However, when I select a customer in the next textfield, the form starts looking up the corresponding record for that...

Well......let me explain it a bit more: - I got a table "users" with fields: userID, username - I got a table "quotes" with fields: quotenumber, userID. Both of these are primary key. - Each user has his own set of quotenumbers causing 2 users to both have quotenumber 3 for example - I got a...

Thank you. What I want to use it for is the following: I got a form where a user can enter data. This data is stored in tables. Next, I want the user to be able to generate a report based on these tables. I also now saw your links about mailmerging but can't figure them out ..... Can you tell...

I want to display a line of text in which I want a function to lookup a value within a form. Is this possible? So for example: "Welcome" [lookup username on login form] "Enjoy your stay."

I want the textbox "Quotenumber" on my form to look for the highest "quotenumber" (in table "quotes") for the current "userID" and add 1 to this. Then it needs to store this value in field "quotenumber" of table "quotes". Example: UserID = 2 (can be read on form) Highest quotenumber in table...

I have a form with textbox "Quotenumber" This textbox is bound to the field "quotenumber" in table "quotes" (in the property field "control source"). Now I want this field to be filled with this code: =DMax("[Offertenummer]";"[Offertes]";"[Offertes].[GebruikerID]=" &...

Got it! :) Just copied the form in your example and edited it. Very much thank you kind sir

I can't seem to get it to work. I can make a subform based on the correct table, but I can't get it to work as you did. Can you explain it a little more to me?

That looks real great.....:-) Exactly what I meant! What do you mean by "DummyTable"?