Be sure to read Windows Support on the Win Update site, especially if you are "running multiple versions of Access" on the same network, or machine. You'll find there are numerous "Whitepapers" on the subject.
Crystal Reports, version 8.5 (dated now, but what I'm currently using) has a cross-tab wizard. However, I've only done tutorial / virtual learning stuff with it; & never really used it in an actual business / job situation. Crystal emphasizes how important their usage is, but we don't use them...
Do a Google search on 'FastHelp' which formerly was known as 'DotHelp.' It utilizes 'Microsoft's Help Workshop' to build 'help text' that can be tied-in to the 'F1' key function with some basic Visual Basic programming techniques. You may use 'Paint' to create your 16 bit .bmp graphic...
Please excuse the duplicate posting; this having been posted under "Relationships" before...
At first, we thought our problem was a "relationship" problem, but that now all seems okay, after doing some more checking.
We were having a problem with '#deleted' showing up in bound controls...
At first, we thought our problem was a "relationship" problem, but that now seems okay, after doing some more checking.
We were having a problem with #deleted showing up in bound controls, though we didn't have this problem with Access 97, using the exact same code. (The code does, in fact...
I should add that everything was working okay when we were using 'Access 97,' but this has only happened since we converted it over, into an 'Access 2000' database. There are many linked tables in our (insurance-related) database!
I'm still reading / searching the posts to see if anyone else has experienced this problem. Have found a couple of "deleted relationship" posts, so far, but I'm still looking for an answer.
Posted this earlier under 'Other Topics,' then found this subject heading; felt it was more appropriate posted here, instead!:
When I create a relationship between any two tables in the relationship window, enforcing referential integrity and cascading deletes, it is created without any error...
When I create a relationship between any two tables in the relationship window, enforcing referential integrity and cascade deletes, it is created without any error messages.
When I go back in, the two tables are there but the line showing the relationship is deleted. The tables then behave as...
I just thought of something else. Go to: File > Options > the Layout Tab > the section called "Grid Options." Uncheck the "Snap to grid" checkbox. This will also make your formatting work easier.
Here's what's in the Help file:
Action:
CDate (number) converts and returns a Date given a number which is the number of days starting from December 30, 1899.
CDate (string) converts and returns a Date given a string.
CDate (dateTime) converts and returns a Date given a DateTime value.
CDate...
The person viewing the report may have to adjust their "Windows" settings? Settings > Control Panel needs to be adjusted on the viewer's machine , perhaps? Not really certain about this, but we had a similar problem here just weeks ago...this technique fixed it!
Try removing those pesky little arrows from the ruler area of the screen by clicking & dragging them off of (& away from) the screen area. They are only helpful whenever you build a report from scratch; afterward they are best removed from the report! You should now be able to move groups of...
Ido, Yes, thanks, but I already did look at that one. We skipped the parameter idea, altogether, and went with Madawc's suggestion. It took our programmer here about 45 minutes to figure it out on his own, along Madawc's same line of thought. Madawc also responded to Thread 149-577624, on...
There is only one group on the report. The group is: multiple / various types of insurance plans. For each plan type that the insurance company offers, of course, there are multiple detail records, based on policies sold (certificates). The boss only wants to view about 3 or 4 records (a very...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.