Search results

When you say "Add Mode" do you mean open a new record?

If you click on the query tab and then "New" there you will see an option to look for duplicates. Have a play and will will be clear

Hello One and all, I hope you are all well and can spend a little bit of your Precious time to help me out. I am tring to import a perdifined excel document, the Excel document is used as a template so all the heading stay static though out the document. This is a double question: 1...

Your "Cancel = True" is running to early and the information is been canceled before it is saved. Alastair

Simon, Have you sorted out your problem or not?

Fay, Are you using Todays date 02/02/2006, if so what is the textbox or combobox called that stores the information?

Ken, My misstake 1095 is the number of day plus say todays date would give a date of 27/12/2008. Alastair

Ken, Why would you add 1095 onto the date()?

Fay, Am i right in saying you have two problems. 1. Calulating the date in three years (Should it take into account Sat/Sun) 2. 6 months before the calulated review date you need a report to show the up coming review of this item. Some times it is easier to break the problem down and address...

After a simple forum search is have found an example of how to disable the mouse. please follow the link http://www.lebans.com/mousewheelonoff.htm Alastair

1. On the last text box you need to have a setfocus procedure, this is normally some thing like: me.[Subform Name].Setfocus or you could try: Me.[Subform Name].RowSource = [Your Fist Text box on subform] = SetFocus This will move the entry into the given form. Let me know if any of these do...

************************* Duplicated ****************** I would suggest Access there is a template call "Event Management" have a look and see what you like then you can make changes and ask us all on this forum for help as and when you need it. Let me know how you go on and were i can i will...

I would suggest Access there is a template call "Event Management" have a look and see what you like then you can make changes and ask us all on this forum for help as and when you need it. Let me know how you go on and were i can i will help and show you the way to Amarillo. Alastair

No problems Alastair

Ok, you would need to replace the following line: DoCmd.OutputTo acQuery, "qryFilterPostCodes", "MicrosoftExcel(*.xls)", "c:\Temp\PostCodes.xls", True, "" With the following: DoCmd.OutputTo acQuery, "qryFilterPostCodes", "MicrosoftExcel(*.xls)", "C:\Documents and Settings\All...

ok right lets look at this in sections 1. how is your database shown (ie simple double click and your into the main form) 2. other users need access to a certain part of your database. I will do you a simple logon screen if you can post your database.

Can you post your database so i can have a look and give you the best way of doing it. Alastair

Our you using you own logon system or using database secruities in built?

Johonn, First can i check that i understand what you mean. 1, on openning the form a new records is shown 2, the focus of a predefined text box is shown. Is this all you need to do or am i missing something. Alastair

Try if me.checkbox1=true then me.txtbox1="Yes" else me.txtbox1="No" end if end sub Would ask you to try this and let me know if it is still not working. Alastair