Recent content by Morten R

Hi, thanks for a adwise:) i wil try to find som posts with conditional formatting. PS. the word date, is an ilustrasjon of this day date:) M.

I need a litle help to make a code. Case: When a spesific noumber of days has expierd the colure turn red in a form. This is the way i tink it must look: When the form load, If [tbl_name];[date]+30<date() And [tbl_name];[status]= "my_status1" Or "my_status2" set [my_formname].[my_fildname]...

Hei, i working with this merge thing. The code i'm using put in bookmarks in a Word doc. I have run in a problem when the bookmark is selected in diffrent order than bookmark1, bookmark2. In some doc i start with bookmark4, and bookmark5 in the top of the doc. It then only take the mark wit low...

Hi, i knowe hove to get this date to com up: create an unbound textbox, in propertys for the box in field standard value putin: =date()

my db i have attached my db in this post. the frm "frm_doc" autostart, and have a description for the problem

Hei, i need a litle help wit an field in my table. Is ther a way to give a user a warning if he try to type in a dublicate value. We are regist letters and give them a case noumber, but sometimes people send the same letter more than one tims. Then the same case get to casenoumber. I need a...

Sorry for that. In a frm showing detals from a query wit information aboute one suplyer and one costimore. I need to have to diffrent comboboxs to select many diffrent type of documents i wil send. (I have control over document merge) But i use a textbox to describe the path to the doc. In the...

Hi,can somone give me an hint howe to link to combobox to one unbond textbox. The comoboxs are selecting to diffrent tabels.

Private Sub Kommando16_Click() On Error GoTo Err_Kommando16_Click Dim stDocName As String stDocName = "yourReportName" DoCmd.OpenReport stDocName, acPreview Exit_Kommando16_Click: Exit Sub Err_Kommando16_Click: MsgBox Err.Description Resume Exit_Kommando16_Click...

Hi, i think u shud use a crosstable query to solve this. Beacuse you have all the data in some tables alredy?

Hi, if you want to show the result of your query as this format: MM.YY, u need to change the property of the field in the query,in the format field in property put in this: YY.MM or MM.YY, i dont knowe what dae format u use. God luck M.

Reprt to MS Word Yes:) send the report to a Word doc. When i open a report i preview i have fond button on the toolbar that send the content in my report to a Word doc. The question is how i make this function om a form? M.:)

Hi, i see its posible to print a report to *pdf. How wil the code be if i want the report to print to a Word document?? I have find this function when the report is in prew modus, is it then posible to make a comand buton wit this function? M.

Block If without End If The code: Private Sub staffopen_Click() On Error GoTo Err_staffopen_Click Dim strInput As String strInput = InputBox("Please Enter the Password", "Enter Password") If strInputBox = "morten" Then DoCmd.OpenForm "skjema_pris", acNormal Else If MsgBox("You entered...

Thanx a lot RG, the DLookup() function makes my day:) The speed is not wery importante, because its a wery smal db whit only 3-4 000 records and 2 users. Thanx aigen!