Search results

This is the first time I have tried this so I am totally inexperienced. What I want to do is place a table on the server ready to receive data from a form availabe to all on the intranet to all users. What is the best way of achieving this? Regards Eddie

I would like to have a back-end Database on a host server and link a front-end Database to the tables several hundred miles away. The problem is I have no experience whatsoever in doing this. My questions are: (1) Can tables be linked via the Internet? (2) If they can, is this the best way...

Hi all, I’ve been using the DoCmd.SendObject to Email Access 2002 reports in a “Rich Text Format” from one of my applications. This works perfectly except where the left right margins of the report are less than the default margins in Word, then it truncates each field and places the cut off...

Hi all, I’ve been using the DoCmd.SendObject to Email Access 2002 reports in a “Rich Text Format” from one of my applications. This works perfectly except where the left right margins of the report are less than the default margins in Word, then it truncates each field and places the cut off...

Hi Hayley, Many thanks for the advice. Regards Eddie

Hi All, I'm using the 'SendObject' command to Email reports in one of my databases and with most my clients this is working perfectly, however, I have one Client who is using Lotus Notes and this does not work. Can anyone help with sending Emails where Lotus Notes is used? Regards Eddie Mason

try sorting the text field that you have applied the Val function to: SELECT Val([Test]) AS fldTest FROM tbltest ORDER BY Val([Test]); Regards Eddie

many thanks for your help. Regards Eddie

Hi all, I've got a combo-box reading from a table, on a data-entry form for a report. On which, I'm using the On Not In List Event to allow the end user the opportunity of entering an additional record whilst remaining in the data-entry form. this works perfectly well but new entry does not...

Hi All, Is it possible to Email a report from within Access 2003 that can be viewed or printed by the recipient even it they do not have Access loaded on their computer? Regards Eddie

Hi Colin, Many thanks for the advice, works perfectly. Regards Eddie

I have a client that wants to show the length of service that staff have in years months days. The present formula I use is ([PresentDate]-[StartDate])/365.25, which only gives me service in years to a decimal point. Can anyone help with this problem? Regards Eddie

Hi Rich, Many thanks for the advice Regards Eddie

Hi All, Where can I get a list of error numbers? I'm getting error 3021 and 2105 on a database form. Hope someone can help. Regards Eddie

Hi Jason Many thanks for the advice. Regards Eddie

Hi All, I need to add two tables with a one to many relationship to a clients database. I could Email them a database containing the two tables and then phone them and take them through the import procedure, but I would prefer if it’s possible to have them simply open a database and it...

Many thanks for your help the .columnhidden works perfectly. Regards Eddie

Using the .visible does not work in datasheet. I've even changed the visible to no on the textbox format and it still appears when I change it to form view. Regards Eddie

Thanks for letting me know that it's possible to hide a field based on a condition, on a datasheet form, using the load event? How do I hide a field based on a condition, on a datasheet form, using the load event? Regards Regards

Hi All, Is it possible to hide a field based on a condition, on a datasheet form, using the load event? Regards Eddie