Irene- Either supply the filter with the WhereCondition parameter of OpenForm: DoCmd.OpenForm "Main Form", _ WhereCondition:="DepartmentID = " & glngThisDeptID...
You won't see a "white" control unless the form that is inside the subform control is already open in Design view. What you did sounds correct, but it might...
Tom- Assuming each record has some "contract" identifier, you could create a query that looks something like: SELECT ContractID, SalesPersonID, PaymentDate,...
Dear All, I need to insert some images into my db. I created a table with the fields: item and pict, linked by the item field with the main table. Now I added...
Davide- What version of Access are you using? It's not a good idea to store pictures (particularly large ones) in an Access database. The OLE Object data type...
At times, I feel somewhat underqualified - learning as I go, but I didn't want to give the appearance of saying that about someone else before I was a little...
Hello John, Thank you. After playing around for a while that's pretty well what I got ( except for the 'dummie' part) :) I actually posted that amongst all the...
John, thanks for your help. I will work on all this soon. Your understanding of of my intention of variety and plant name are correct. Plant name grape =...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
May 1, 2006 11:29 am
36495
Bill, I have uploaded a copy to the Assistance Needed file, labelled "AssistNeededMarathon". The form(ParticipantsBloodsPost) has the attempted BeforeInsert...
I'm using a text box for my form heading. The control source is the ck box The format is ;"Display version A";" Display version B" If the ck box = true, it...
Joe- Instead of using the Format property, use the Control Source. Make sure the name of the control is not "ck box" and put something like this in Control ...
I forgot to mention, I'm preparing 3 different broachers, and a customer can buy multiple pages. FYI The payment entries and the Commission report are...
The 10.5 database. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL...
Tom- I assume you mean "brochure." The query I gave you should calculate the correct commission without any user intervention. If the date of the payment is...
Dear All, I need your help with the code I wrote: I have 6(or more) text box in a form called: StartDate EndDate Day2 Day3 Day4 Day5 ... And I wrote a code...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
May 1, 2006 3:11 pm
36506
Can anyone provide the simple code to open an excel spreadshet from access Excel sheet = C:/TEMP/example.xls TIA...
Can you please help me how to set the two link properties as what i did only is to drag the item form and drop it into customer form in the detail section. ...
Sanjev Chopra
sanjaiv20@...
May 1, 2006 3:25 pm
36508
John hi, I just re-uploaded db10.5. I cleaned some of the older tables and forms out to make it easier on the eyes. This db has the workable search form...
This uses Object (it is late bound, version agnostic); use excel.application when 100% sure you and user/s have same version (also needs reference set for that...
AD, Thanks for this suggestion. What I would like to do is use one form to move a different, already opened form to a specific record while not filtering out...
Tedd Here's the code. Again, add the ADO ext. for security and DDL. Public Function ReadSecGrp(strUser As String) As String 'Purpose : Get CurrentUser's User...
Hi, I have a form where user enters data(frmIncident)saveto to tblIncidentData table. When user finishes another form opens(frmDMHIncident)where some fields ...
Linda If you can get into the database administration end of it all, you will find that the file size of the database as well as the transaction loge file can...
Courtney I downloaded your database. One thing I saw was that you must enter a Participant ID in order to get the BeforeInsert event to fire. That is because ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
