Search results for query: *

I want to use the text in textbox to rename database. name c:\test.mdb as c:\"text1.text".mdb. This gives syntax error so instead of "text1.text " it must be different. Help is appreciated. Gunter

I am trying to copy a file by clicking a button : Private Sub Command4_Click() FileSystemObject.CopyFile "d:\neurotest.mdb", "d:\my documents\" End Sub The above does not work. Would appreciate some help. Gunter

My form shows question 1 and after button click I get question nr 2 etc. However by pressing the page-up key , you can go back to the prior question.Is there a way to disable this ? I only want to show the question once. thanks for your help. Gunter

Goodmorning , I have a textfield "question" in my database which read like: Do you like wine ?A: Yes B: No I like to see in a textblock : Do you like wine ? A: Yes B: No So three lines instead of one. Is there a way to do this. Thanks in advance for your help. Gunter

I have a form where a question is shown.By clicking one of 5 option buttons an answer is given.After clicking a "next" button a new question is shown.The last clicked option button is has still the black dot.I like when clicking on the "next" button no option button has a...

Good evening, I want to send the text in a textbox to MS word. I am using DAO .Can anybody help ? thanks in advance GG

Good morning , I have the following problem: I have a table like : text code score Redbook with score 1 r 1 Redbook with score 2 r 2 Bluebook with score 1 b 1 Bluebook...

Good morning , I have the following problem: I have a table like : text code score Redbook with score 1 r 1 Redbook with score 2 r 2 Bluebook with score 1 b 1 Bluebook...

Goodmorning, I have the following lookup : n1normscore = DLookup("[nscore]", "normscoresn", "[nleeftijdcode] = 'a' And [ncode] = 'n1' and [nruwescore] = 29 ") Which works fine. Now I want to change 'a'in a stringvar agecode and 29 in a valuevar ruwn1. I tried...

Good afternoon , I have the following fields in my table: main category category description detail For instance filled with : expenses car-cost fuel-cost shell 17 june The first three fields I fill with the help of a combo-box.What I want to achieve is that when I fill only the field...

I have added 6 more records(total now more than 350 records) to my database and to my surprise the first new record does not appear in the table(the other 5 do) , but does appear in reports ,query's etc.So the record is there , but does not show in the table and the add-form. How can I solve...

Good morning, I like to change my Dutch style dates into USA style dates. example: 22-mrt-02 into 22-mar-02 23-mei-02 into 23-may-02 Thanks in advance for your help. Gunter

Good Morning, I like to add an extra column in a query which is the total cost by category of the last 12 months.My skills are not sufficient to solve this problem.Advice is very much appreciated.My query is like this : Category Year Month Cost Cost last 12 month by Category --------...

Good Morning , I have a filter problem : me.filter = "[bank] = 'Chase' " me.filteron = true This filter on my report works fine. When I choose a bank via combo-box : Dim BK as string BK = "=" & combo17 'this works ,I checked with messagebox' Now when I try to filter ...

I like to update a new created field [date] with the fields [day],[month],[year]. I tried : update name-of-table set datepart("yyyy", date) = [year], set datepart("mm",date) = [month], set datepart("dd", date) = [day]; This is not right as I get an error message...

I have something like this in query: Id Descr Amount 1 AAAA 100 2 BBBB 200 3 CCCC 300 I like to get : Id Descr Amount Running T. 1 AAAA 100 100 2 BBBB 200 300 3 CCCC 300 600 Help is very much appreciated,thanks in advance. Gunter

Good morning, I used oleapp=createobject("Excel.Application") oleapp.visible=.T. oleapp.workbooks.open("c:\my.xls") oleapp.visible=.T. This works o.k. , it opens the workbook with sheet1. What is the code,so that it opens for instance with sheet2 Thank in advance for your...

Good evening, I used oleapp=createobject("Excel.Application") oleapp.visible=.T. oleapp.workbooks.open("c:\my.xls") oleapp.visible=.T. This works o.k. , it opens with sheet1. What is the "ole" ,so that it opens for instance with sheet2 Thank in advance for your...

Good Evening , When I click the button on a form I want to go to a certain page of a certain Excell spreadsheet. I probablely have to do this with VBA, but do not know how. When I click the button now ,I open Excell. Thanks in advance for your help, Gunter

Good evening, I want to open a table with a button.I made a button which opens a form.(works fine) and I tried to change "docmd.openform etc " in "docmd.opentable etc" (in the code builder) without succes. your help is appreciated , Gunter