Search results

So there is no practical way of doing it? It's really not that important either. The user's just gonna have to get used to it and try not getting all confuced.

I dont know what its called excactly, but you know the sliding/scrolling thing on the right side. I have a continous form with a header. The scroller appears so if the header would be scrolled away when you scroll down the records. I would like the top of the scroller start at the top of the...

Allright.. this coloring business is a good start, but what would have been great is if there was any possability of making the line that seperate the forms in continous-forms clearer. What is the alternatives to coloring, are there any at all? Is coloring all there is if i'm in the business of...

i havent tried your code yet, and i'm not sure if i understand it. But just so we are clear about what i want. I primarily want the user to be notified if he is adding a number that allready excist. But since this is a Do Until where i add all numbers from a userdefined number a to a userdefined...

when i said its a formality i ment its a formality in the sense that it's no rational reason to set the focus to controll b other than to get it away from controll a. But i made it work. Thanks

I have a Do Until which i use for adding elements with primary key from number a to number b in a table. A problem is that if some of the numbers allready excist in the table, it wont add them. There is no error with it, but it just dont do anything with the numbers that are allready there...

i dont feel the same way there. I have SO much fields and buttons that this sunk and bord-line pretty much disappear.

I have a form-subform case where i have the form to type in search-criterias and a subform that show results. I want to make a visual clear distintion between the form and the subform. I guess i could find out ways to color the grey background, but i believe some of you know the best way to do...

but the SetFocus is just a formality, right? I dont want to commit to a next button.

As the question in the title. I click a button, and if i answer yes in the following msgbox, i want something to happen, pluss the visibility of the very button i clicked to be false. I get the message that i cant set a button thats in focus to not visible.

I have a database with several forms, and you can go from one form, to all the other forms by clicking buttons. I wonder if there is any possibility as to lock a form when it is opened. Lets say i have a form A, and a form B, C and D. You can get to form B, C and D from form A by clicking...

I have a recordset shown in continous forms. The Recordset is based on a table. I want a delete-button to be able to delete that record. I do an sql query, but it doesnt work. It makes sense since the form allready displayd would have to change. But it doesnt do anything.

I have a form which i would like to requery from anywhere. I do an update on the forms recordsource, but when i open the form, the last update is not on there. I have to close the whole database and open it, then it's there. Cant i just go "Forms!FormName.Requery from anywhere? i try in...

i found the answer. i use Chr(13) & Chr(10).

ah.. ok. But now i want to do more than just know what form it's opened from. I want to use the openarg to something important.

its not in a query, its in a controll. i need to change lines in controll.

It is a sql query. It's an update sql.

i did that, as i said, Me.Openargs also gives me "strSql". It doesnt work either.

allright.. now i think i understand i have MsgBox strSql DoCmd.OpenForm "Adresse", , , , , , strSql and in the form Adresse, i do CurrentDb.Execute strSql which should work. It doesnt work because currentDb.Execute strSql is just the text "strSql" ive used the msgbox as you can see...

Well.. i understand what you're doing there, but i need it to be dependent on what i do in another form, i cant use MsgBox for it.