Recent content by DanielGreenwood

Hi I'm trying to create a data entry spreadsheet for a windows 6.5 device (HTC HD2) running Office Mobile 6.1. The problem I'm having is that none of the validation/vba features are available when opened on the device. Does anyone have any ideas how to either to get these to work or what...

Hi, I've not had much experience with this area and so I'm really looking for some advice as to best way forward. We have some handheld devices (HTC HD2's) which are used to collect data on site using a specific application. I've just been asked today to collect additional data on the...

I've a need to link an access 97 database to access 2003 tables. When i try i get the error message: 'Unrecognized database format \\XXXXXXX' Is there any way to do this?

Do you use this method with data access page? I know this works on forms but I cannot set the control source to this value on a text box in data access page. It gives me an error 'invalid 'condition'

Hi, I'm developing an internal system using data access pages to view data stored on Access 2003. In order for the users to only see the data relevent to them i would like to filter based on their login name. I have found it's not possible to do this using a database login therefore need to...

Hi, I have an excel graph to track performance against a target for several areas of our companies operation. The x axis is a timeline of months and performace data is input per month. However, the target is set as a fixed value for the whole year and therefore it only appears once in the...

Hi, I have a slideshow presentation which contains several images. The problem occurs when I try to save the slide as a jpeg image file. The images loose a lot of quality to the point that its blurry. When you print the images using powerpoint they retain all the definition. There seems to be...

I just declare tdf as a table def object: Dim tdf As TableDef Am I missing something here?

Hi PHV Yes I did try that. It then kicks out another error: -- Run time error 91 Object Variable or with block variable not set -- Usually sticking 'Set' in front of the variable would solve this I think. If you have any other ideas I would be grateful.

I have checked the References but not sure what would have changed or what new libraries I should insert. I can't see why setting the 'Name' property of the table def object would all of a sudden not be valid. I think I might be able to find a work round by looping through all the linked...

Hi, I've got a simple form in MS Access 97 that I use to relink linked tables within my database. I have a list box that populates the names of all the linked tables in the DB (cboTableName) and a text box that i can enter the new pathway into. This has been working fine up until today when I...

Thanks for the link but I'm working in A97. I found the solution in the end anyway, here it just for reference: 'Place this in a normal module Declare Function IsZoomed Lib "user32" ( _ ByVal hwnd As Long) As Long 'Then use this in your code, where 'f' is a form object If...

Hi, I have a pop up form that contains a calander control (frmCalendar). When I click on a command button (on another form) to open frmCalendar it opens over the command button clicked. However I have only made it work when the form is not maximized. When I tested it on a maximized form my...

Hi SiJP Could you give me the string you ended up using? Having the same problem and I'm sure its only the string thats wrong. Thanks D

I'm in the process of upgrading some databases from 97 to 2003 and doing some general tidying up of the code. Currently there is central switchboard which is used to navigate between various databases on the network. It is coded using send keys to open the 'Open Database' dialogue box then type...