Hi Everybody
I need to develop an application which only has to produce basic reports from a large access data file. I am deperately looking for a decent GUI tool which can produce self executable file accessing MS Access data to produce reports. Access runtime is not an option here for some...
Hi
I used to change SQL of a particular query during runtime by using the following
CurrentDb.QueryDefs("Qry_temp").sql = "SELECT * FROM QryTemp_All Where ID=" & MyInput
I have used above method in many complex situation in an Access database. Since I have migrated to MS Access Database...
Hi
In my program I am producing summy reports for individual staff members. My boss wants to select more than one staff member at a time to print report. If I can loop through the selected staff members and open reports for them but iin preview mode it only opens first one. Is there a way to...
I have a simple problem in which I want to get value of variables that run internally to a function. for example look at a simple function which takes MyValue as an input and multiplies it with a random number to return a value
Public Function RandomValue(MyValue As Integer) As Long
Dim...
Hi
This form functions same as windows file find utility and takes parameters like *.doc or *a*.doc etc.
This utility is a useful example of using API to browse for a folder and then using recurssive loop to find files in folder and its subfolders
Hi
Is there any way by which I can loop through all text boxes and get 2 pieces of information
1. Control Source (Name of field) - I have already managed to do so
2. Caption of the attached label of the text box
The objective is to give a list of label captions and their corresponding fields...
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 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...
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...
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
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 :)
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
Hi :)
I tried to link tables to an FTP site many times but always get the same error
C:\My Documents\ftp:\\Test.ftp.com\users\dummy\testDB.mdb is not a valid path. maker sure that the path name is spelled correctly...and blah blah :)
Has anyone got clue that how can get around this error...
Hi :)
lets look at my raw data
ID Score
1 2
1 3
1 2
1 1
*There could only be score from 1 to 3
From this data I want following result
ID CountOfScore1 CountOfScore2 CountOfScore3
1 1 2 1...