Search results

Dennis, The application you mentioned sound just what I am trying to do. I have sent you a private message with my e-mail details. If you can help me by forwarding some details, I would be grateful. Thank you, paul

Thanks for your reply. My users have clarified there objectives into two, however I would still appreciates some assistance. I am using code from 210261 to try to resolve the requirements. #1 To have the word application open, data entered, save in C:\My Documents with a file name which...

Hi, I would like to have data contained in one of my forms (ie one customer only the current record - not the whole customer base) send to either a Word or Outlook template. Currently reading 201271 Knowledge base. Word may be easier, but would then require manual intervention to email on. I...

Thanks lloydmav, I have been away and have now picked up your reply. Could you confirm where you are placing your code? Thank you. Paul

Apologise if I am missing anything basic. We have a database split; front end & back end. One the moment there is only one front end. Distribution will commence once some changes have been made. I need to add a field to a table. I presumed I would need to add this to the back end rather than...

I have an option on a main menu to open a form which holds all customer records. This takes about 15 seconds to load. The users are ok with this, however I would like something appear asking them to wait for the form to open. Whilst searching, I have seen some options for a progress meter...

Thanks for getting back. I placed appropriate validation code & text and changed the required value to 'No' in the tables concerned. I did receive the messages in line with my validation text. If I change the required value back to 'Yes', I recieve a system message that the field has to be...

Some of my forms have fields I would like to be completed in all circumstances. In the tables concerned I had the required value set to 'yes' and I was receiving error messages as appropriate. I then placed some save/cancel code in the Before Update element of the form. This works fine but you...

Thanks for your replies. Could you advise where you would place this code? I have set up a custom toolbar which I want all Groups to have apart from the Admins group. All users have a name/password combination to log in & are presented with a form serving as the switchboard. Re the transparent...

I will have a database running off a small server for a few staff. Staffwill access via office PC's & remote dial in using laptops. Question1 Should the system.mdw file with the workgroup information be placed on every PC & laptop, as well as in the same server drive as the database? Staff...

Most of my forms are based upon queries. Some of the less used forms on tables. Even for forms based upon queries, I have found with some look-up's from tables, permissions for tables as well as queries are required for all of data in forms to function/show. One issue which confuses me is for...

Sorted, i hope. Placed an additional Save command in the OnClick event. Seems to work ok apart from if the user goes straight to the command button (ie does not enter any information which provides a supplierid) & then selects to cancel. Syntax error with supplier id occurs, but I guess I can...

Got some code working to provide a save/cancel prompt. AS soon as a form is closed or moves onto another record the prompt appears. Still have a problem whereby a primary form (supplier) can be completed but not saved, a command opening a linked form is selected & imformation on this form is...

Thanks for the reply. I had already done a search and obtained a few examples which I have been testing. My concern is the potential issue in my third paragraph. A user can only move to a linked form once the primary form has been saved. They get an option to save or cancel. If save is...

My users have asked for a control which prompts them on whether they want to save or cancel entries made in forms. I am still getting to grips with code and presume I would need something in the 'BeforeUpdate' event? Does anyone have some code they can post which has worked for them? I think...

In my db users, in addition to controls (close, minimize etc.) on forms - which are standard - users will only need have print, preview, mailto & sort buttons. Ideally, to help with security, I would like all user groups to see these only and the Adminitrator to see all toolbars & menus as...

I am nearing completion of a database which will require securing - a task I have never done before. I have read through various threads and looked at the MS Help & FAQ. It does not seem to easy, although I accept I have not tried yet. What would be helpful is a few basic pointers/steps on how...

I need to calculate some bonus payments which are based on a rolling 'year to date' sales figure. I am recording for each customer advisor individual commissions they recieve and the for each commission there is a commission date. I can therefore identify which commissions fall within a given...

Thanks for your reply. Unfortunately, I am still having some problems. I am a new Access user so apologise, as I may not have interpreted your suggestion correctly or explained my issue fully. For the field where there is currently the combo selection, I have put the expression in the 'row...

I have a list of business areas (table: "Business Area") and within each business area there are a set of products (table: "Products")The product table lists all products and the Business Area they fall within. A third table lists the product details (table: "Product Details"). I have separate...