Search results for query: *

Yes another one - I'm on a roll here. When firing up the Runtime Version 11 exe from a batch/script, I notice that the status bar does not display what is happening on the status bar e.g. compiling data C:\send\*.db. It does in Paradox 7 so what may need to be configured to display the what...

Have upgraded to Paradox 11 Runtime and have a delphi program which uses WinAT to set off some compile scripts re-delivered in Paradox 11. Program and scripts worked in Paradox 7 for years but now getting a "Microsoft Visual C++ Runtime Library" error which results in the scripts not being run...

Dear Folks, Does anyone know what the syntax would be to get an Excel spreadsheet Template to automatically open and run the macro attached to the Template? The first thing the macro does is Inputbox and fill in the values. Angelique

Dear Folks, I have several spreadsheets that have numerous graphs and each month I update the worksheets that feed these graphs. Now while the results display, the labels have to be manually changed, one by one and it takes hours. Is there a way to pass a parameter to a label/title on the...

I have recently been asked to assist a colleague with a problem but I don't have the experience to help. Having said that, I thought you guys & gals might have done something like it. The scenario is that a text file is imported into Access on a weekly basis. The text file appears to be...

Installed Access 97 on laptop this weekend for my son, tried to run the Database Wizard, but got "ActiveX cannot create object" when Access tries to create all the tables, forms etc. Any ideas? I tried reinstalling Access97 again making sure to include everything. The only thing...

My main table contains a date field e.g. 01/07/01 for record for the entire year. How do you create monthly totals in Paradox? Does Paradox have a Month function like Access? Any advice would be nice. Angelique

Has any one ever setup crosstabs in Paradox? If so, can they give me some guidance? Thanks in advance Angelique

When I finally thought that I saw the light at the end of the tunnel, it was someone with a bright idea which I am sure I don't want to do. The user thinks it would be good if they had a diary to display the dates, times, trainers for any particular day. The idea is that everyone could look...

Need to create an "overdue" letter to the client. I have added an unbound textbox with the following syntax: =Format(DateAdd("yyyy", 1, [Date of Training]), "mmmm" & "yyyy" & ".") When I run the report some of the letters have July, August...

I realise I have been a little more active on the forum than most lately but this form is driving me up the wall. What is the correct syntax to avoid error 13? INSERT INTO tblClientSelect (ClientID, DateOfTraining) SELECT DISTINCTROW [Training Details].ClientID, [Training Details].[Date of...

The following syntax is giving me an 3075 error message: If Not IsNull(DLookup("ID", "Training Details"![ClientID]='" & MySet![ClientID] & "' AND TrainingDetails![Date of Training]=" & mySql![Date of Training])) Through the forum I found a posting to handle...

Well I got rid of the 424 Object Required but replaced it with: Run-time error 62436 - error in date in query expression '[ClientID]='453' AND TrainingDetails![Date of Training]=##' I used the Debug Window and Me![lstClient].Column(2) is null. Any suggestions Angelique

My form for "Overdue Clients" is coming along really well, thanks to those who assisted with my "no record" problem in the subform. Now! having said that I have had a problem which I spent all weekend trying to resolve without much success. I need to have the form record...

I have a form with a listbox of overdue clients and a subform that displays those clients the user selects for printing an Overdue letter. All goes well until the user selects the &quot;<&quot; command button when there is a Null/empty value in the table. I need to prevent the user from...

After spending probably two days with a form/subform that displays all the overdue clients in a listbox and as the user selects the > command button the clientname is removed from the listbox and appears to be inserted into the subform row. The user can then print only those clients which are...

As I don't have Sheridan panels to work with as I did when I use to work in VB, I use the Option Group control to group my command buttons. The oddest thing is occuring - if you click onto the edge of the option control the command buttons disappear. This gives the user quite a shock and so I...

I got some cool code to allow the user to compact the database from a command button on the Main Menu. It worked fine until recently. I have included the code which looks at a table to see what the last compact date was, and if over 30 days proceeds to compact the database by closing it...

Found some interesting code through the forum to load a listbox of reports. It's multi-select and works fine but I would like to know how I can code command buttons that will: (a) Select &quot;All&quot; reports. (b) De-select the recently selected ones. Here's a challenge to those guys &...

Does anyone have a query and/or sql that finds duplicate records? I have a table that has 4 key fields to create a unique key. One of the fields can become a duplicate if imported from a standalone when one of the fields isn't exactly the same (therefore not a key violation). Angelique