Search results for query: *

This seems like a basic problem to me - I don't understand why I haven't come across it before. Using ADO.find = "StaffName = '" & string & "'" works fine for a string that doesn't have an "'" in it. But the StaffName column include names like "John...

Can anyone help - I want to open a Standard VB.EXE from a Standard VB.exe and get a handle to its public properties and methods. Do I have to use the Windows API? or is there a simpler way. Regards Kirks

I have a StartTime and EndTime and I need to know the difference in hours (preferable 6 1/2 hours as 6.5

I have several Ado controls on a couple of forms each attached to different tables in an Access2000(jet40) database. All work except one. I get a object not set error. When I run the app everthing works fine except this one which appears as though disabled on the forms. (I have tried this on two...

I am using an MSHFlexGrid control to display (as you would expect) A simple Parent-Child Relationship. There are several staff payslips (parent) with multiple payslip items attached. So far I have it working fine, it displays the right data and fields and formats well, however I would like it...

I want to set the system colours for different VB applications (linked to an Access.mdb). I have been told that I could set them and reset them using API calls has anyone got code to do this they wish to share?(or advice). (This is the only way I can be sure that a custom colour scheme won't...

I want to change the default system colours for one of my applications. However I don't want to change any of the button images (i.e. add a new 'skin' using something like WindowsBlinds or ActiveSkin). I'm trying to ensure a unique colour scheme that works regardless of the user system setting...

I have a large Server database (157,000+ records (about 200mb at present) on a Network - I want to replace the Access 97 FrontEnd with a VB6 one and the BackEnd with an Access 2000 one. My biggest concern is data retrieval speed from the BackEnd(The FrontEnd contains very few sets of data -...

I waiting on delivery of VB6 Enteprise Edition and want to clarify its contents so that I can plan the conversion of my Access based app. I could you an access 97 or 2000 database as a BackEnd but have also considered MS SQL Server. The specs seem to suggest that SQL Server is included as...

Im new to Clarion so be gentle with me. I have a window with a Relation Tree Control on it. I want to base the RelTree Control on a a view which joins as follows:- 1:Many 1:Many File1 to File2 to ALIAS1 I need to know the source for the view and especially where to put it. (Actually...

I want to set the size of the application window and turn off the close/max/min buttons (of the app window) Can it be done?

Does anyone know how to relate a record in a file to another record in the same file?

Does anyone know how to find the exact size of the application window (the max size of any form that fits into the App Window). Also does anyone know how to do an OnResize event on the Application Window. I get the impression that MS have left these details out of Access competely (which is...

I want to open a form 'Maximised' but don't want the user to be able to click the 'Normal' button. I can't find anyway of not showing the button. Can anyone help.

I want to make a combobox auto show the list when the user moves the cursor in to it. I managed to do this a couple of years ago (and was told by my client that they didnt like it) and have since forgotten how.

I have found examples of how to play sounds in Access97 but they never seem to work (although I don't get errors). Can anyone help with the code required to play a .wav file?

I have managed to find an API call (and the rest of code needed to use it) to find out the current user login name (Windows Login). what I really needed to know was the Network Identity of the computer running the Access database. Can any one help.

A much shorter question but essentially the same.... I want to create a parent-child relationship where the child is another record in the same file and be able to continue doing this ad-infinitum (29 levels would do). A single Alias works for one level, but how do I display a treeview which...

Firsty I'm a Clarion virgin, so please be gentle with me (only 20+ hours of C5 use and gagging to get going)!! BACKGROUND I want to create a Parent_Child database (for task management). There is only one primary table (not including secondary tables attached to it. Each record has a unique ID...