Recent content by aqif

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...

The code in which you are adding the item just put following line at the end Me.LstItems.Requery

Assumming that the row source of your list box is "Select ID, Name, Date, Notes from TblMyRecords" Put this code behind your command button. If IsNull(Me.LstRecords) Then MsgBox "Please select a record from the list to delete", vbCritical Else DoCmd.SetWarnings False If MsgBox("Are you...

Hi Create the chart in Access by using the data you want. Then double-click the chart to open chart editor. Click on Data and try "Series in Rows" and "Series in Colums". Sometimes that does the trick.

Well I just want to change the WHERE clause based on whatever user selects.

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 already explained that this is an example and I can easily calculate the Random value based on the output. My real question is that is there anyway to output value of an internal variable running in a function. The only way I can think of right now is to create a temp global variable ans...

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...

I have always used Dirty to check for the changes. In my view the code for Form's update event should go like this If Me.Dirty Then Me.ModifiedDate = Date End If

Instead of using Application.FollowHyperlink, try Call Shell("Explorer.exe " & vardoc,vbNormalFocus) Hope it helps

Best way to find which objects is to create a new blank database and then import all objects from the "suspected corrupt" db. After importing objects open any form in code view and goto Debug-->Compile and finally compact and repair the database. Whole thing will take 5 mins. Worth a shot

You can use currentproject.path in your code. That way everyone will always get the correct links.

You can try two things 1. Open a blank instance of MS Access program and then goto Tools-->Database Utilities......... and then try selecting and compacting your database. 2. If above fails then create a blank database and then import all the objects from old database in to the new. If some...

Well, with a bit of VBA it should be quite easy Say if you have main form with its subform (linked together offcourse). I assume that the subform is for a Child table. On the After Update event of the suitable text box on the main form you will put. 'Save Master Record DoCmd.RunCommand...