Hi All,
I have a form SearchTestDetai ls ,which when loads first time , shows all the records from a table.Linkchild fields , LinkMasterField s set null and sourceobject has the table name.
Its has text fields where a user can enter search criterian,and on clicking ok the same form should load with filtered data.
after filtering , also Linkchildfields , LinkMasterField s set null and sourceobject has the table name...
titli
Last Activity: Aug 23 '11, 07:46 AM
Joined: May 7 '10
Location:
-
titli started a topic How to set the values of SourceObject,LinkChildFields,LinkMaster fields at Runtime?in AccessHow to set the values of SourceObject,LinkChildFields,LinkMaster fields at Runtime?
Last edited by TheSmileyCoder; Apr 22 '11, 10:00 PM. Reason: Remember to use [Code] tags around your code. They are NOT optional. -
inserting dynamic controls in a form , one overlapping the other
I have code to create an access form , and the controls will be added dynamically , taking information about type of form control, answers , questions, answer type control , number of answer type control.
How to put the Question label ,Answer values and answer controls in the form by calculating the x-axis and y-axis values ?
I am adding certain number for every loop counter , to increment teh x- axis and y-axis variable... -
titli started a topic How to create controls in an excel worksheet which has been opened from access modulein AccessHow to create controls in an excel worksheet which has been opened from access module
I have created the excel worksheet from MS Access using the following code:
Dim xlApp As Excel.Applicati on
Dim xlWB As Excel.Workbook
Set xlApp = New Excel.Applicati on
With xlApp
.Visible = True
Set xlWB = .Workbooks.Open ("QuestionPaper .xlsx", , False)
Dim ws As Worksheet
Set ws = Worksheets("She et1")
End With
Now... -
Running a .mdb database in Access 2007 , throws error 3085
Hi Group,
I get error in this line :--
Error Message Box:Code:Set db=Currentdb Set qdfToRunFiles=db.QueryDefs("qryToRunFiles") With qryToRunFiles .Parameters("dCOB").value=dCOB-----at this line Set rsToRunFiles=.OpenRecordset
Need help !! There's no missing reference.Code:Run-time error '3085' Undefined function 'Environ$' in expression
-
Access 2003 saved as Access 2007 shows error
We had a database (.mdb) which was working fine in Access 2003 , it still works fine in 2003.But when it was saved as .accdb to work in 2007 it shows error.
On double clicking , it opens with an error message as
Error:
Source:clsAppli cationError.Log ErrorToFile
Number:-2147221500
Description:Can not locate RavePivot.code. accdb error log.
after clicking ok another error message box:... -
Why am I able to open ceratin .csv files in Excel 2007 and and use the files for running an 2007 MS access application , whereas not able to open same .csv in Excel 2003 and not able to use the files for the MS Access application (access 2007 ) ? ---- I need help !! Please.I have to run it 2003.And it's kind of very urgent. -
TableExists Code
Private Function TableExists(sAc cessPath As String, sTable As String) As Boolean
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Set db = OpenDatabase(sA ccessPath)
For Each tdf In db.TableDefs
If tdf.Name = sTable Then
TableExists = True
Exit Function
End If
...Leave a comment:
-
Why do I get errors while linking ?
I am repeatedly getting errors , while trying to link tables in a local database at the below code
If TableExists(Cur rentDb.Name, "tblBC") Then DoCmd.DeleteObj ect acTable, "tblBC"
DoCmd.TransferD atabase acLink, "Microsoft Access", sNormalisedData basePath, acTable, "tblBC", "tblBC" ----getting error in this line
The database was built in Access... -
How to convert d:hh:mm:ss to hours ?
Hi All,
I have the following in every column as shown below.Could you please let me know the formala for calculating the hours between two dates with times
ColumnK2 ColumnL2
05/11/2010 12:03:00 05/11/2010 13:03:00
ColumnM2
=TEXT((IF(L2=0, NOW(),L2))-K2,"h:mm:ss") gives value 0:1:00:00
Column K contains a Bug open date... -
titli started a topic How to save the access database tables , queries , forms , reports and VBA code ?in AccessHow to save the access database tables , queries , forms , reports and VBA code ?
Hi All,
Please tell me the best solution to implemenet security in access databases , to save the tables, queries, forms , reports as well as the VBA code from user access.
The users of the application should only be able to work using the application frontend.
I have read about various ways to implement security in access database at http://msdn.microsoft. com/en-us/library/aa139961(office .10).aspx.... -
Access Form Question
Hi All,
I have an application , with the following features.Recent ly facing some problem.
At a certain point of time if a user had already run partfile , application displays file status as locked by the particular user.
columns are filename , sourcedata present(checked /unchecked),want torun(same),onc ehasbeenrun(sam e),nameofperson WhoHasrunit(sam e)
Step1 : On checking the "wanttorun" field... -
Hi Stewart ,
thanks for your response.Yes my staging path was incomplete.I was just getting the file name as sDbname.Whereas in previous place from where i was running teh application showed teh full statging path.Will investigate more.Because in xml file i didn't even chnage the staging path.
Thanks !!!
TitliLeave a comment:
-
When I changed the path in the xml file my .mdb throws error ?
Hi All,
I get a .txt file from a Samba drive EE\e1\e1 and , feed it to my access application.
ALso a separate shared database is used , which is in another drive say DD\d1\d2
O/p to be kept in OO\o1\o2
Now the application is being moved to a new drive MM
I just changed the path of o/p data to to kept in and the shared database path.
Get an error message as could not find APPLI inside...Last edited by Stewart Ross; Jul 31 '10, 06:14 AM. Reason: Please use the [Code]...[/Code] tags provided -
titli started a topic project contains a missing or broken reference to the file 'OWC10.DLL' version 1.2in Accessproject contains a missing or broken reference to the file 'OWC10.DLL' version 1.2
Hi All,
Both of my mdbs were developed in Access 2002.
Till yesterday two of the mdbs were opening and working fine.
But today one of the mdbs is throwing the error below when the user tried opening it.
Error message 1
Your Microsoft Access database or project contains a missing or broken reference to the file <filename>.
* To ensure that your database or project... -
titli started a topic Which is the best version control tool to be used for VBA code(access, Excel)?in AccessWhich is the best version control tool to be used for VBA code(access, Excel)?
Hi friends,
Any idea, how do you version control your VBA code?Which tool or which way is the best?
Thanks
Titli -
Thanks All ...for your responses and explanations... .Yes, the last update query in the link , worked fine.Leave a comment:
-
Access query help needed !!
I want to run a update query
This sRawDatabaseNam e is C:\Documents and Settings\All Users\Documents \Data.mdb...Code:accApp.OpenCurrentDatabase sRawDatabaseName accApp.DoCmd.TransferText acImportDelim, "DataImportSpec", "tblRaw", sLocalDataFile, False accApp.DoCmd.RunSQL "Update tblRaw SET tblData.MaturityDate="" WHERE BookCode="123-America" AND StrategyID IN('420','320','220');" -
Can i call you up for some more help, if you dont mind?
If you are ok with sharing your number here, i can call you right now.Leave a comment:
-
yes i have opned teh mini mdbs , they are like any other mdbs , created in the pastLeave a comment:
-
Jim, this is very serious issue, teh users won't be able to run the file tomorrow again.i need to solve this right now.
Yes, execl is able to open the other mini databses created yetserday or befor ethat..it's only today that teh generted mini dbs from the .mdb , are not opening in excel.
I have not changed any queries / table , in teh mdb which generated mini databases to be viewedin excel.Leave a comment:
No activity results to display
Leave a comment: