Search results

Hi I want some columns in a Combo box to be aligned left, some columns to be aligned center and some to be right aligned. Is there any way to do it. And instead of False/True in a column to be check box And is there any way Titles in a Combo box to be different color Thanks

Thanks Bob..

Thanks for your effort to help me...but please how can I check the version of library I have installed on my com. or others...VBA take me to this line of code " Dim rs As ADODB.Recordset > Set rs = New ADODB.Recordset < rs.Open "tblMATICNI", CurrentProject.Connection, _...

Hi VBA get this message on some computers. "Run-time error '430': Class does not support Automation or does not support expected interface". I use win 7 registered and office 2010 activated.. How to solve this problem... Please help!!!!

In my computer I did not get this message. I get this message on other com. where my application is installed. When I clilk on button to save records from an unbound form using ADODB.RECORDSET I get this message : Class doesn't support Automation (Error 430)...Here is my code Private Sub...

Thanks for your replay....I use split form to enter data...and everything is going well while entering data confirming with dialog box. The code is like this: Private Sub txtDATPRE_AfterUpdate() Dim answer As Integer answer = MsgBox("Are you sure", 36) If answer = vbYes Then...

I need to add data from main form to a table and data to be seen immediately in subform in datasheet view. From time to time I need to delete a record from subform and data should be upadatet immeditale in subform.. I dont want to use split from...Any example please.. Thanks a lot

So...let say that one of the values I choose I want to be default value..because it is used mostly. Thanks

How to put a default value in a combo that reads values from a query. Thanks

I want to put a form in a certain position on the screen on opening..i.e upper right corner or so...How to do that

Thanks, but instead of fiscal32.exe in my code if I put Notepad.exe it works....(Notepad.exe is in the same folder) ..have any comment?

Hi I have created txt file pf500.in which should be printed by fiscal32.exe...Both files are in the same folder I use this code: Dim RetVal RetVal = Shell("fiscal32.EXE", 1) but I get the message 'File not found' In Dos prompt if I invoke FISCAL32.EXE it automatically take pf500.in to...

Thanks a lot and God bless you

I use this code for combo dropdown, but from time to time its jumps up and down and cannot be controlled...Is this code ok or should be changeed... Thanks.. Private Sub cboNAME_KeyDown(KeyCode As Integer, Shift As Integer) Me.cboNAME.Dropdown End Sub

How to escape from datasheet part of a split form to some control in upper part of the form with keyboard

Thanks a lot I have already solved it the same way....

I have created .txt file from a table. I want to transfer it from folder to USB flash with some VBA code...Can anyone help

Many thanks to you.. Your suggestion works...STRING(10-LEN(STRING),"0") & STRING I got exactly what I want...0000059.68 Thanks

The field in the table is Single with 2 decimals...i.e 56.78....In Query design When I use Format([field],"0000000.00") and press Enter it changes to Format([field],"000.000.000") and the result is only 000 in Datasheet view

Yes..I tried this eather and it works in Immediate Window but when I put it in a Query it changes to format([fieldName],"000.000.000") Where to correct not to change the format