Search results

Hello, I have a production machine that writes its output to a CSV file every time it produces a good part (several times pr. day). It can produce identical part which means that the mashine will not put in another line in the csv, but just update the no of produced parts. I had to rename the...

Hello, I´m fairly new at this, so please bear with we. I have a form where I would like to add a "Print Current page" button, but the print should be formated according to a standard print report I created. In the form there are to fields that makes the entry uniqe from other pages of the...

Hello Again, Now it is my syntax in the VBA that is wrong. I have no clue when to use " & ´ ect. Can someone link to a beginners site for VBA users ? Next question.... Where is my mistake in the following, the error is somewhere in the Dmax( function or Nz( function : :D Private Sub...

Hello Forum, I have this problem. I have this project DB where I have a problem recording tool. Each problem has an ID (P-key), but it needs to have problem ID as well. The problem ID must start from 1 and continue towards x at each project. To describe the above with an example: ID...

What happens is that when I open the form in normal view (not design) and want to select a value in the dropdown list of the first combo box. Then list is shown, but when I click nothing happens - no value is selected, it doesn´t close the list, nothing. The combo is bound to a query as shown...

Hello, Unfortunately I have used some functionality that is not compatible with 2003. :-( But here is some screenshots and code.... Option Compare Database Private Sub Hovedaktivitetognr_AfterUpdate() Me.Underaktivitetognr.Requery Me.Underaktivitetognr.Locked =...

Hello, I have now spend hours and hours trying to make my first cascading combos, but now I need som help. In the form FORM_Underark_aftaleseddel I have tried to make cascading combes in the last two cells Hovedaktivitet and Underaktivitet, but when I try to use the form it will not let me...

Hey, Still working on my first db. :-) I have attached the db. I have two tables where TBL_Underaktiviteter (tbl_sub) is a subtable to TBL_Hovedaktiviteter (tbl_main) - meaning that if you choose the value 200 in tbl_main I can limit the possible outcome of tbl_sub. So fare so good. In...

YES YES YES it works! I have tried tried and tried, but no success untill now! Thanks!!!!!!! Keeperen

Hello I'm a newbie, so go easy and overexplain :-) I have made this DB (attached) where I want to put in a Dlooup command in form. The form is For_T_Aftaleseddel and the field is Faktureret beløb. Currently my Dlookup command looks like this...

:-( I can't. It says that different features and calculations will be lost if I save my 2010 Access in a 2003 format. But thanks anyway :-(

Still same error. Please see attached. What do I do wrong ?

So you are saying calculate the value in the tabel instead ? But is that possible when you are talking about a tabel and a subtabel - one to many. When I try to calculate the field in the invoice tabel I cannot seam to access the subtabel... How do I do that ?

Hmm, I have tried and tried to finde a solution to the error that is typed in the field, where I typed in the Dlookup() command. It says #Navn? How do I solve that ? In advance thanks. Keeperen

Hello, Have tried to do what you described, but I cant seem to get it up and running. In the tbl T_aftaleseddel this i a columb called Faktureret beløb these are the cells that I want the summed up value of the sub tbl Tbl_Underark_aftaleseddel columb Salgspris within the different values of...

Hello, I have 2 forms based on 2 different tables that have a one to many relationship. When I open the parent form I want to be able to push a button that opens the subform that corresponds to the parent form only. I got the button covered, but how do I make the subform show only the info...

Hello folks, Newbie question: I have 2 tabels. One with info on an invoice and one that is a "sub" table to the other where the price on the invoice is devided into cost manhours, cost material, Admin cost and so on. The way the users are intended to use this DB is that they select the...

Hey, I'm new at this and do not know if I posted this in the right toppic. Anyway I have an invoice where the total cost cell is the sum of a number of cells in another tbl. Example: Man hours 200£ Plasterboard 200£ Administration fee 10£ Total cost: 410£ In other words with each invoice...

Hello all, I have just attended a beginners course in Access 2010, but I have not yet done my first DB except from during the training. I work at a house construction company where I have a task of constructing a DB for handling the economic side of a project. I´m ok skilled in excel when it...