Search results

This same question has been asked in the microsoft office answers forum and has rececived many helpful answers already. http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/4af7ab27-7b04-4550-9806-c7d7e0bfe658/

The syntax is not correct. In access, there is a specific way to create a join. Here is a simple example: SELECT tblCase.CaseID, tblCase.CaseEEID, Count(tblDiary.DiaryID) AS OpenDiaries FROM tblCase INNER JOIN tblDiary ON tblCase.CaseID = tblDiary.ClmNum; I suggest you create a query in the...

Usually in access, create the table first then build the form, using the table as its record source. The table is created first, with the 4 fields for description, route #, blk length and waste factor. Be sure to avoid symbols in the field names, and it is a good idea to avoid spaces in field...

I'm not sure what the 'heavy' issue is with the scrollbar - my personal taste says that your pics look normal. You can turn the scrollbars on and off with code in the form's current event. Sample code below: If Me.RecordsetClone.RecordCount >10 Then Me.Scrollbars = 2 'vertical only Else...

Discard the code in your post above. Use the double click event of a textbox on your form (or you could put a button to open the task edit form). The code will be something like: DoCmd.OpenForm "TaskEditForm", , , "[TaskID] = " & Me.TaskID

You can cancel the save if that textbox in the subform is blank and pop up a message to tell the user to enter the number of animals before saving. So your Save button code would check for the number of animals, see a sample code below. If Not IsNull(Me.TxtBoxNameForAnimalNumber) = True Then...

Create a list box with the possible treatments. Set the listbox's Multi Select property to simple and that will allow you to select several treatments at once.

Reports will do this automatically when you set the can grow and can shrink properties of a textbox to yes. There is no easy way to do this with forms. You could try writing some code to count how many characters in each textbox and then change the height accordingly - it is tricky because...

Use one additional field to indicate a process instead of changing the value of a field that is part of the index - perhaps a long integer or a yes/no for the additional field. You can choose to only append those records where the process has a specific value - append only those that are...

Your solution isn't dodgy at all. That is pretty close to the way most of us do it with subforms on the pages of a tab control. Here is a tip that can speed up your form - you can remove the source object from every hidden subform control. Only load the subform into its tab control when the...

Re: "" Our simple one page estimate form has buttons on the top to search for an estimate number, go to the previous/last record, etc. We implemented the code above into a report, and double clicking on a field in that report brings up the form like we wanted. However when we get to the form...

Spell check a listbox issue. How is the user adding a new note to the notes listbox? If you pop up a form where the user can add a new note, the user could do a spell check before the new note is added to the listbox. If the user wants to edit one of the notes, you would do something like...

It is much easier if a form for data entry is based on a single table, but not always possible. I'm not sure how your tables are related. If you have a main form based on the products table, you can put a tab control on it and put a different subform on each tab of the tab control, where each...

Spell check issue in notes field - I just checked in both A2007 and A2010. I opened a form that had a memo field and pressed F7 to do a spell check. The spell check worked. Here's something to try. Make a test form (a new form) with a memo field on it - just a quick form - nothing fancy. Type...

With the ampersand issue - &. If you are doing a caption on a button or label, you can put 2 ampersands together - && - just like that without any space between them. If you are doing data entry or edits into a textbox, the & is treated just the same as any other character.

Make a form where the user can select which report - you could put a checkbox. If user wants 'withcopy' they check the checkbox. Put a button to open the report on the form. Use the where condition of the OpenReport method to open the report. Change the Where condition depending on what the...

Hi David, I'm glad to hear that your boss loved the mail merge. Sorry to hear that you don't even know how to begin creating new folders for the Word Templates. Sorry that I am very busy on a new project and I'm not able to just write the code for you as I did for your previous post. Would you...

Here's a link to a sample db with logon form. http://www.rogersaccesslibrary.com/forum/topic104.html

I couldn't find a sample db to do exactly what you want. Here is a link to a log in form that will start you on the process. Post back as you need to.

There are a couple of different ways to accomplish what you want. When "DW" is logged in, somewhere in the database there will be a table, a property or a hidden form with the ID for the user logged in. Does your database have a table for users and their login? Depending on your database, you...