Search results

I have a collegue who is keen to use crystal reports to analyse an Access database. I'm more comfortable using the reporting features in Access. Can someone please let me know what advantages there would be in using Crystal rather than Access. Trying to build an argument for Access. Thanks...

Al Yep, the control is set to "id" but still no luck, any other thoughts? Thanks Richard

Oh wise ones I have a form that displays (or is supposed to) the record id in a textbox from the related table. This field "id" is an autonumber. When viewed in Form view the id does not show up, however (AutoNumber) appears in its place complete with parenthesis. I've tried all sorts of...

Hi all Couldn't find this when I searched on date stamping in the archives. Could someone please enlighten me please. I wish to date stamp records when they are created and not have that field altered when the record is edited (so as to ensure that users cannot the field is not altered to...

Esteemed collegues, I am trying to build a form that has tab control pages on a tabbed page. But when I drop the new tabs on the tab that I want it on, the new tabs stay on top of all the tabs underneath, confused..... Is there a way to group the "sub" tabs to a specific tab page? Any ideas...

Morning all I have a report that I want to analyze in excel. I exported it using office links, nearly all is ok except two fields, both of which are free text with a data type "memo" as the length is longer than 255. My problem is that access only exports the first 255 characters, is there a way...

Hi all I'm having difficulty adding a set number of days to a date in a textbox in a form. I want to add 15 days to a date that was entered earlier in the same form. I have tried an unbound text box with a before_update command of DueDate = (SpillDate+14) Any assistance appreciated. Richard