Search results

Dear Terrnece You wrote: ---------------------------------------------- This works OK and give me the following result: C 24 D 156 G 32 ----------------------------------------------- The way I understand is that you just want to display above results on the form. If that's so then first save...

Hi Can ypu paste your formula/expression that you are using at the moment.

Hi I am trying to export all the tables from my backend data file to a new database I have created. At the present moment it is only exporting the tables from frontend as linked table. I want it to actually export entire tables from backend data file. here's my code Dim RealDB As DAO.Database...

Hi I want to simply export all the tables from my backend data file to the new database file I have created. When I try to run following code from my frontend, it sends the tables as linked table to the new database. I want this to actually export all the tables from backend file instead of...

Hi, I have not understood ur problem properly but do you know how to use DCount. You can try to use dcount or please try to explain a bit more what u want.

Hi I am trying to get a list of forms from an external database. I have already written a code to get list of tables which looks like this Dim extDB As DAO.Database Dim Tdf As DAO.TableDef Dim frm As Form Dim strMsg As String Dim strTN As String Set extDB =...

Hi I am trying to develope a utility which will scan all the subfolders within a folder and will return the total file count and file sizes in a tabular form. The code so far is only working up to first level of subfolders. What can I do in the code to make it work for all the indefinite levels...

use decompile method One of the advanced methods of reducing sizoe of Access DB is to open the file in decompile mode and than compact and repair. To do that in Start-->Run type "C:\Program Files\Microsoft Office\Office\MsAccess.exe" /decompile then browse for any file you want to compact...

Code not working Hi, I just tried ur solution and its giving me error of "Object variable or with block variable not set" I know I am doing a small mistake, would you be kind enough to see my actual code and point out mistakes. I have already created the table according to code. Dim DB As...

Hi :) I am trying to create a code by which I can append the field properties in a seperate table to get database report. I have been able to get Tables and field names along with thier descriptions and other properties. I can't seem to find any way to find out that whether the field is primary...

Change at Table Level Hi :) Thanks for the reply but I am interested in changing at Table level because the value needs to updated back to table level so conversion will not help. Any ideas Cheers! Aqif

Hi, Is there anyway to Convert a field with Number data type to Text. In my DB the user imports a table and everytime they have to change data type of one field to Text to continue with further process. Any way to put code which runs after import and changes the data type Cheers! Aqif

Use DSum Hi:) StrSql is just a variable which will just hold the sql query as text. Try using DSUm to store value in a variable so instead of writting strSQL = "SELECT sum(shutdowns) FROM System1" write strSQL=DSum("Shutdowns","System1") msgbox (StrSQL) You can also use Dlookup like...

HI :) I got a table TblStudents with RollNumber and Name in my local database. I want to write a code which allows me to compare with another database table having same fields. So far I am able to able to choose another database. What I want to do is that when the user choose the database than...

Hi:) I am trying to get a long path of Current database. I am using like Msgbox(CurentDB.Name) I have also tried FileSystemObject with Path property but every time it returns me the short path like C:\Temp\PATHCE~1\SPLITD~1\a.mdb instead of C:\Temp\Path Centre\Split Database\a.mdb Any way...

Hi:) I am using Access 97 and I am trying to make a copy of my database which is opened by the user. I am uaing follwing syntax Dim SrcFile, DestFile as String SrcFile = CurrDB.Name DestFile = "C:\BackDatabase.mdb" MsgBox SrcFile & vbCrLf & DestFile FileCopy SrcFile, DestFile For some...

Hi :) To my understanding TransferDatabase only works for the current database. I have a split application in which the data file is seperated from front end file. My data file contains 3 tables 1. tblPatients 2. tblSamples 3. tblSampleTransactions What I want to do is to craete a new...

Hi :) Lets look at my data O_ID PersonID StYear EnYear 1 1 1986 2 1 1989 3 1 1992 4 3 1987 5 4 1990 6 4 1996 What I want...

Hi :) I have one master Forms called FrmDrugApprovals and one subform called ApprovalPrescriptions. Whenever I enter subform entry and try to refresh the main form the main form goes to first record. Is there anyway I can keep the main form stay on the record it is ? Cheers! Aqif

Try This = DCount("*", "Job Summary Query", "SIndex =" & SIndex & " And Index =" & [Index]) Here the assumption is that both fields are numeric. If they are text then it will go like this = DCount("*", "Job Summary Query", "SIndex ='" & SIndex & "' And Index ='" & [Index] & "'") Cheers! Aqif