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!
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.