Search results for query: *

Thanks Duane, I will move the code to the On format event to begin with and see how it prints. Trouble is I am doing the coding in any spare time I have at work which can take a long time to get done.

The code is in the OnLoad event rather than in the OnPrint. I have just started experimenting with putting code in the OnPrint event. However, I need to have a combination of the 2 events as some of the overprinting is a simple 'X' that is either visible or invisible dependent upon a field...

I have a report that overprints individual letters onto a pre printed form - much like an English passport application form. The individual letters HAVE to be within the small boxes otherwise the form gets rejected by our NHS. I have spent hours getting the letters to line up correctly only to...

The code behind the AfterUpdate event is: Me.Description = StrConv(Description, vbProperCase), so it shouldn't cause a problem. Lewy

Hi Darrylles, I will have a look at the table and form on another computer. Two things to note; 1, on the data entry form there is VBA code to capitalize every word after Update. 2, It doesn't happen to all of the records only some of them, that's why I am frustrated. and yes I just love access :-)

I have a table which has a 'Short Text' field in it's structure. What is happening is if I move into the field (In table or form view) using the cursor key, the data is visible, however when I move to the next record the text vanishes and does not reappear even if I click in the field with the...

Go into Tools,Utilities, Restructure and choose the main table, not the lookup. On the form that comes up click on the tab that says Table Lookup and in lookup type check the box all applicable fields and check the box fill and view and then save it. That should do the trick. Lewy

I have a pushbutton with the following code. I am trying to archive a record from a customer database but when I delete the record I need to give a reason for the deletion and the date of the deletion. The code copies across the record into a table with the same structure with the added...

Should run the same as far as I am aware. Not sure of the question however.

None that I know of. It was hard enough moving from 3.5 for DOS to version 10 for Windows, the majority of coding had to be re written. Lewy

I wish to add the records from 1 table to another using objectpal, however the receiving table has an equivalent field shorter than in the main table that the records are coming from. For example the "first name" field in the main table is 10 characters in size but in the receiving table it is 1...

Bubsi, Are you referring to highlighting a line in a tableframe that is on a form, if so look at the following webpage: http://www.techtricks.com/paradox/highlight.php Trust this helps, Lewy

Anyone, even a little hint?

I have a table with the first record having no information within any of the fields( a blank record). For confidentiality reasons I always revert to this record so that other customers cannot see any details on screen when I have finished editing or viewing customer details. To automate the...

vecjjk, Look at setreadonly method in the objectpal reference files. This gives a simple example of how to set the tables as read only. Personally I would try to import the data into the new system. Lewy

Thanks Tony, I will try what you have suggested and will let you know. Once again, many thanks and have a good weekend. Lewy

Sorry Tony, I always find it hard to explain a problem. The problem is that when I run a saved query, in one of the fields in the answer table has a blank field, yet in the table I have queried, there is a value. Table Structure: Primary Key Customer_No N ExamDate D...

Have also just found there are records missing from one of my tables. Corruption somewhere? Should I run Tutility? Thanks, Lewy

Thanks for the reply Tony. the field in question is only checked so that it appears in the answer table. The value is used in a mail merge to indicate to a client how long ago their last visit to our practice was. ie 6/12/18/24 months. The answer table is not dependent upon this value but on the...

Odd thing started happening. I query a table with a check mark in all the fields. In the answer table in random records one field is blank, yet in the table that is being queried there is a value in that field! There doesn't appear to be a pattern to the missing fields. Any thoughts? Thanks, Lewy