Search results for query: *

Thanks lupins46 It is what i had in my mind as the very last solution in case there is no other way. Finally i'll fix it like that Thanks again

Sorry for the message, actually it is a great mistake that it was posted here Sorry again.

Hello to everyone. It's a little strange but is there a way to insert (via code or otherwise) a new record on the top of a tabular form instead of inserting it at the bottom? (after all the existing records) I don't want to make a data entry form...

Hello to everyone. It's a little strange but is there a way to insert (via code or otherwise) a new record on the top of a tabular form instead of inserting it at the bottom? (after all the existing records) I don't want to make a data entry form...

Well Miners74, i suppose that you want your Main form to be maximized all the time, and the other forms to be appeared over the main. First open your "client" forms in design view and with mouse. stretch or shrink them as you want. Set these Properties as follow: AutoResize No ---...

Francescina means this: to provide concurrent access to records by multiple users, Access locks records. In a multiuser environment you can open recordsets in one of 3 different ways. I) No locks II) Edited record III) All records It is up to you to decide which Locking Strategy is best for...

Hi modalman, why don't use the DLookUp Function... It is very helpful if you want to get or just display the value of a field that isn't in the record source for your form or report. See Access Help Topics for this. Good Luck

Well sayetta, try this code in a backup of your database. ***This deletes all of your tables in your project*** Do While DCount("[Name]", "MSysObjects", "[Type]=1 And [Name] NOT Like ""MSYS*""") > 0 DoCmd.DeleteObject acTable...

Well limpan, the following is from the Access '97 help topic on Selected Property The following example uses the Selected property to move selected items in the lstSource list box to the lstDestination list box. The lstDestination list box's RowSourceType property is set to Value List and the...

Lee, try to be more specific please.

Well jlindquist, Use the following SQL statements as Rowsource for the ComboBox. SELECT MSysObjects.Name FROM MsysObjects WHERE (MSysObjects.Type)=-32768 ORDER BY MSysObjects.Name or check faq181-690 for selecting other Access Objects via Combobox. Good Luck.

Hi to everyone. Well, i have a bit strange(?) question. I have a Continuous Form based on a table with 4 fields, say f_A, f_B, f_C, f_D and all of them exist on the Form. f_A is an integer and can take these values:1725,343,7408,9054 and may appears many times on the Form. Is it possible for...

Hi to everyone. Just a thought, but i don't know how it could be work. (Access 97) First, you have to make system objects visible. Click Options on the Tools menu, click the View tab, and then select the System Objects check box. Now, in your Tables Area should be appear a Table named...

Well mattpearcey, some stuff for you. Say that your Main Form is called frmMain. Now add an About Form with some details, your Name,Copyright, etc. Name this form as frmAbout. Set these properties for frmAbout: DefaultView=SingleForm RecordSelectors=No NavigationButtons=No AutoResize=No...

Thanks MichaelRed, it now works perfectly

MichaelRed, thank you for the reply, but let me do the problem clear. First, it is not VB but VBA. Second, this is the real code: Dim FileLength As Long dim Message Open "C:\MyFile.MDB" For Input As #1 FileLength = LOF(1) Message= "FileSize: " & (FileLength) / 1050624...

Hi to everyone!!! I think this is something easy. Suppose we have the following code: Dim MyNum As Long MsgBox "The number is: " & MyNum Now, i want the "MyNum" to be appeared with 2 decimal places. Does anybody know how should i format it ? Thanks

Mel, I keep half of ghubbel and half of Aristarco, which means: 1)The Criteria Form opens before the Report. 2)The Report's On Close Event should include a command that close the Form. And something else...If you see on your report something like this #Name...try not to close the Form while...