Search results

One more question please I use this code: Private Sub mCl_AfterUpdate() If mCl <> "00" Then DoCmd.MoveSize , , , 7450 With Me.cmdOk .Left = 13680 ' (9.5 cm) .Top = 12240 ' (8.5 cm) End With Else DoCmd.MoveSize , ...

Exactly..onOpen form I open form with regular size, after inserting some data in a certain control with AfterUpade event I need to resize the window and additional controls to be visible..This means that the final Add buton to be reposition automatically...(a little bit down) I know that it is...

I mean with docmd.movesize ,,,5000 the form is getting larger and a few new controls are open to place data and I need to move add button a little bit down... The question is how to move Add button a little bit down... I need a little example of the syntax Thnaks

I mean with docmd.movesize ,,,5000 the form is getting larger and a few new controls are open to place data and I need to move add button a little bit down... The question is how to move Add button a little bit down... Thnaks

Hi I want to move control on a form from one place to another...I tried to use this move method: me.control.move(,,,6000) but obviously this is not right syntax..please help Thanks

I have a query in a subform related with main form with master and child filed for certain criteria i.e date...Also I have a button in main form to delete what ever record...Fist I choose a record from subform and then click on button to delete it..I use this code: If (Not Form.NewRecord) Then...

I have a query in a subform related with main form with master and child filed for certain criteria i.e date...Also I have a button in main form to delete what ever record...Fist I choose a record from subform and then click on button to delete it..I use this code: If (Not Form.NewRecord) Then...

Hi I want to retrieve value from a certain field in a variable before i delete that record ..I need that value to find another record in another table..Please help.. Thanks

Please dont bother with my problem...the solution is Order By On Load = No in the property

How to remove sorting in form with subform in datasheet view. I want to remove small up arrow or down arrow. With right click there is only sort A to Z and oposite but there is no remove sorting...This annoying me...Please help

Hi Is there any way how to choose a back-end database with a combo box..i.e I have two databases, one in folder '2011' and other in '2012' I want to work eather with database in folder '2011' or 2012 chosen by combo box. Please help

Happy New Year to all How to put dynamically a FIELD in a subform using CROSSTAB QUERY..I.E I use Crosstab query and each month a new field (column) is added in my query. If I use this query in my subform I miss this new field. For example..I use cross tab query for customers for each...

In this simple line of code: If Left(mOsig, 4) Not In("4834", "4835", "4836", "4837") Then i got this message: Expected: expression and cursor locate at In..and cannot go anyfurther..What is the problem I have seen similar example in the books and seems everything is ok.. Please any idea

how to fill current record with data from previous record automatically Actually If I chose a value from a combo box I want that value to be default value for the next record Thanks

Hello please for help used in Access 2010 program this line returns "run time error'13'" dim RETVAL RETVAL = Shell("C:\apteka\BravoPrint.EXE c:\apteka\smetka.txt", 2) but if I run BraboPrinnt from MS DOS no problem..file smetka.txt is well printed Also have in mind that BravoPrint uses .ini...

How to set focus on a specific control in a form after closing a report or another form...What to write in Event ..on Close

Hi I use InputBox to enter password. How to type asterics instead of letters in Inputbox....Thanks

In a report with one Group I want to know how many pages are in the group Thanks

Hi I am using this code: Private Sub Command12_Click() Dim mDate As Date mDate = #1/8/2011# Dim mSQL As String Dim i As Integer For i = 0 To 31 mSQL = "INSERT INTO tblFAKTURI ( BROJ_ID, MB_ID, DIJAG_ID, KOL, TEN_CENA, NAB_CENA, MARZA, IGUN, PARTIC, RANG_ID...

What a shame for Microsoft staff...not to be able to align right the numbers and left for text in Combo box