Search results

http://www.access-programmers.co.uk/forums/misc.php?s=&action=faq&page=1#avatar

HW Once you've opened the form at the correct person, as defined by your search, clicking the remove filter button will then enable you to navigate through all records. Once you've done what needs to be done, it wouldn't really matter whether you remained on the filtered record or not. I...

A copy of the same in Access 97 HTH

Lyncroft The following thread also contains an alternative aproach to Jeff's. I've tested this and it appears to work ok. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=17808&highlight=for+each+ctrl HTH Graham

HW I have posted an example of something similar to what you are looking for. The zip file contains the database (Access 2000) and a text file explaining the process. The only thing that this does not do is present the form unfiltered, as basically when searching you usually want to find the...

Alexandre Thanks for your 2 cents worth.... The different times are for the prep times (preping the actual ingredients) and the cooking time of the actual meal. My thinking of storing intMealCookTime in the LINKMealsMethods is that there could be different cooking times dependant on the...

Clauses Unchecking the database window should stop the window displaying on start-up. However, this will not by itself stop a user getting to the database window. They can simply use the F11 key to bypass this or hold shift+enter to bypass. To secure this there are many posts relating to...

Rick Take a look at Stephen Lebans site and particulary this link: http://www.lebans.com/tabcolors.htm This has an example of coloured tabs. HTH Graham

Scott Revised code that pulls out the 31 March of any year: Private Sub Form_Open(Cancel As Integer) Dim dte As Date 'Check to see if today's date is 31 March of any year dte = Format(Date, "DD/MM/YYYY") If Left(dte, 5) = "31/03" Then 'Turn off system warnings...

Scott This is a basic example of something that would work although there are other things that would need to be considered. The basic code is as follows: Private Sub Form_Open(Cancel As Integer) 'Check to see if today's date is 31 March If Date = #31/03/2002# Then 'Turn off system...

Cosmos75 You probably have the database set to Compact on Close which seems to ask for a password when closing. I don't think it makes any difference whether you enter this or not as it doesn't appear to effect the compaction. Might be wrong though...... HTH Graham

I am attempting to create an on-screen Cookery Book. From the information provided I have deduced that there will be a need to store information in four main tables relating to: tblMeals (this will store Meal Information) and should include: * lngMealID (Primary Key, autonumber) * strMealName...

AJ The simple approach for someone to unhide the database window is to press the F11 key. This will unhide the database window. If you search these forums there are many posts on disabling this feature. Once this feature is disabled you can do the following: This code is attached to the...

In the design view of the chart, double click the chart area to bring up the chart toolbars. Either from the toolbar buttons or the data menu choose Data: Series in Columns HTH Graham

A definate NO. Search the forums for .exe and you will find many, many threads !! Graham

Chris There is an example of this in the Northwind example that ships with the Office disk. Take a look at this to see how it's done - it's in the startup form. HTH Graham

Can you post the code... Maybe someone can help with this

Try using the Paste Special option of pasting values not the actual formula For example your code should include something like: Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Hope this points you in the right direction. Graham

Webster The following may provide a work around for you, although not using conditional formatting...... On my form I have an OrderIDNumber, InvoiceDueDate and DaysOverdue field. The DaysOverdue uses the DateDiff function to work out how many days have elapsed between InvoiceDueDate and...

ssh As doulostheou mentions in the prior posting the form that you are using is set to be a Data Entry Only form. Firstly change the property for Allow Data Entry to No Go to the properties of the form Data Entry >> No The field that you are specifying (i.e Kataloogi) is bound to your...