Search results

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"?

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...

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 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]=" &...

I have got a form with multiple textboxes and comboboxes. These boxes get their data either by manual input from users or from other tables. The data from the boxes should be written to other tables with the push of a button. How can I do this?

Hi, I got a form called "Make quote". In this form a user can select a product from a line of fields. This "line" contains: article code, product, price and quantity the customer requests. Each single quote can contain a very different amount of products. Some quotes just have 1 product, other...

- I have a table "Quotes" with fields "UserID" and "Quotenumber" - I have a form "Make quote" with a textfield "txtQuotenumber" and "txtUserID" With the following code "txtQuotenumber" gets the highest quotenumber for the current "txtUserID" from the "Quotes" table...

Hi, I'm currently working an a quote database (see attachments). Prices etc. have been edited because the real prices of course may not be visible to everyone ;-) Now, I'm pretty happy with what I've accomplished myself until now. Despite this fact, I'm now running in to some things I don't...

Hi everyone, My name is Remco and I'm from The Netherlands. I'm a 23 year old student Commercial Management and graduating in April 2013. I'm kind of new to Access but I'm familiar with the basics. I also got the (very very very) basics of VBA code.