Search results for query: *

That was what i was looking for, thanks both of you.

Now i got confused Do you mean like this, on top? Not OnFirstRecord; If Previous({field})={field} then true If {field} = previous({field}) Then "Same as above" Else {field} I get a error message from that. And if i just use the formula that you suggested it does the same as using the...

How can i show some dummy text when i have a field suppressed if duplicated. If {field} = previous({field}) Then "Same as above" Else {field}

I've got a userform in Word with a listbox and a textbox which I want to fill with the selected items from the listbox. With the code below I only get the last selected item from the listbox to apear in the textbox. Any ideas to help me out are appreciated Dim i As Integer Private Sub...

Hi all, I'm trying to find a solution to add records from one table to another using a selectbox with different options. Background: I've put together a database to organise a "warehouse" and I want to control outgoing and incomming equipment. On each job I have several items going...

How can I, with code, select a newly inserted picture. I've used this to insert the picture Private Sub CommandButton1_Click() Selection.EndKey Unit:=wdStory Dialogs(wdDialogInsertPicture).Show But how can i select it to use the wdDialogFormatPicture, or is there another way to format the...

Ive used this to insert the picture. Private Sub CommandButton1_Click() Selection.EndKey Unit:=wdStory Dialogs(wdDialogInsertPicture).Show End Sub But how can i select it to use the wdDialogFormatPicture, or is there another way to format the pictures to a specified height and width? JanTore

How can I insert a picture in a Word template using a VBA form. What I'm trying to do is for the user to browse for a picture, select it, add some description and insert it into the document with a preset picture size. And if nessesary repeat the operation for several pictures in the document...

It worked great when I commentet out the load form2 event Private Sub Label1_Click() 'Load form2 form2.fStr_StateQuery = Form1.Label1.Tag form2.Show End Sub [thumbsup] Thank you for all your help I really appriciate it.

I changed the .TAG property but still the same error msg

I get an Error message: Run time error '-2147217908(80040e0c)': Command text was not set for the commandobject

Form2 still opens with the first record in the database. Maybe I've done something wrong?? Here's my code: Form1 Private Sub Label1_Click() Load form2 form2.fStr_StateQuery = Label1.Tag form2.Show End Sub In the TAG property of label1 SELECT maincitys.CityID, maincitys.CityName...

OK, I think I expressed myself badly. On a form I put in a Picture box (picture1) and on that picturebox I put in several labelboxes and made those transparent so they can be "hotspots" cause in that picturebox i have a picture of a map. What I'm trying to figure out is how to get a...

Yes thats what I was planning to do, but the problem is to bind the labels to the database. Ive been trying this: Label1 select Id from Citys where Id LIKE "001" Label2 select Id from Citys where Id LIKE "002" and so on for each hotspot.. then I'm facing my other problem...

Hi, I'm trying to load a dataform from another form using "hotspots" on an image. The question is how can i bind the hot spots to a database record? The picture is a map over a country and the hotspots are cities, and by clicking on a city it loads the dataform which has information...

Hi, I'm trying to load a dataform from another form using "hotspots" on an image. The question is how can i bind the hot spots to a database record? The picture is a map over a country and the hotspots are cities, and by clicking on a city it loads the dataform which has information...

Thanks There will only be 5 people accessing the database at the most, so I think I'll stay with Access for now. By the way, isn't there an Access To MySQL converter program some where on the net, I think I've read someting about that?

I've made an app in VB with ADO connection to a Access database. And I'm wondering if several users can connect to the database at the same time from different client computers if the database is located on a server.

Hei thanks Now I get it.... I did some modifications: ********** Private Sub Document_Open() UserForm1.Show End Sub Private Sub CommandButton1_Click() ActiveDocument.Tables(1).Columns(2).Cells(1).Range.Text = Txt1 ActiveDocument.Tables(1).Columns(2).Cells(2).Range.Text =...

I'm looking for a way to have a inputbox pop out when you open a new dokument template in word. And put the text written in the box on a specified cell in a word table. thanks