Search results

The only event that seems to occur after the form is loaded is the timer event. so i used that one and it works fine. The program is only run once because the access code waits and the timer event never gets called a second time, because it closes the form before it leaves the first time.

As far as I know the first time you open the db you will be asked to convert it

That would work, but it wouldn't be nice to look at because the program that needs to be executed is only a very small window. I was thinking about using a form with no borders and no way to close it and showing it as a dialog form. I'd put a label"please wait" on the form. Then on the...

I currently use this code (with thanks to Ray) to start a porgram and let access wait for it to finish before continuing code. The problem is, the code waits but access itself doesnt. Which mean that the user can start the program again, or close the form where the results are going to be, etc...

Thx, I now know how to do it :) Yet... It states DemoDSum and doesn't even use Dsum :p

I would like the user to only be able to resize the form in the length and not in the width. So only up and down? Is that possible?

Can someone plz make me an example of the following: I have a form with a subform. the subform is based on a table with results(continuous forms). The main form has a textbox with the sum of all those results. That's it. I can't get it right. I know it has something to do with dsum in the...

After some messing around Yeah, had a good night sleep (that really helps) and found my answer :p Dim rs As Object Set rs = Combo34.Recordset.Clone rs.FindFirst "[bestelbonnr] = " & str(Me![Combo34]) rs.MoveNext If rs.EOF Then Set rs = Nothing Exit Sub End If Combo34.Value =...

This is the piece of code I have right now It works fine 1 time and than I get ListIndex=-1 which gives me the first item in the list :( If Not Combo34.ListCount <= 0 Then Combo34.SetFocus If Combo34.ListIndex < Combo34.ListCount - 1 Then Combo34.Value = Combo34.Column(0...

I have a combobox which contains numeric values ordered descending. After the combo gets updated some stuff gets loaded on the form. I want to have two buttons "previous" and "next" that give me the listitem 1 lower and 1 higher than the current one. I used dlookup to get the higher value, but...

Nope, can't be done. The main program won't accept anything that isn't in the likes of c:\maypath\myfile.exe Even batch files won't work. But it's ok. I went to someone who still has vb6 and made the proggy. The full 7 lines of code :D But still thx for the reply Nirious

Oh wait Ifound it. When I added a second criteria to the field, Access misinterpreted the command and misplaced some brackets. I changed them the I way I needed them and all is fine now. :rolleyes:

I have a query that has the following code in SQL view: SELECT Bestelbonnen.bestelbonnr, Bestelbonnen.klantnr, Bestelbonnen.datum, Bestelbonnen.gefactureerd, Bestelbonnen.geselecteerd, Bestelbonnen.TotaalBedrag, Bestelbonnen.Verzendingskosten, Bestelbonnen.Anderekosten...

Before anyone starts with get runtime and its not possible etc. let me explain ;) I expect the user to have ms acces installed. I have a program that can be loaded from the main program(written in c++, don't have access to the code), by clicking a button. Now the main program only supports...

thx, never notissed that property before :)

Is there a way to replace the value in a textbox with "*" 's for typing in some password? (as you type in the text)

In my program you are allowed to make backups of the current databases to an external file. It also allowes you to get the tables back from one of those files. At least it should. I thought this wouldn't be a biggy. I thought I'd just delete my current tables and replace them with...

Can someone explain this to me. I currently have the following code. It draws two lines at the border of my report. The lines on the first page are shorter than the ones on all the other pages. The problem is that the linewith of the first page is ok, but the linewith of all other pages gets...

Thx, that's exactly what I needed :)

Hi, Can anyone help me find out wether a form is open or not from vba-code. I have some code in one form, that shouldn't be executed when another form is open. (Just one form, not all)