Search results

How does it not allow you? I assume you mean not. In a code window main menu, click Tools->References to open the references dialog. Click the Browse button to open a Windows file selector. By default, this selector filters for Type Libraries *.olb, *.tlb, and *.dll, but you can change this...

Yes, you can absolutely set a reference to another access database without the referenced file being open. Any public sub in any standard module is then visible in the application that holds the reference. Forms in the referenced file are not directly visible, and cannot be opened using...

Yes, you can. All the best.

Link the Subform.SpecialtyID field to the value of the MainForm.SpecialtyCombo. 1) open the main form in design view 2) open the properties window of the subform control 3) set Data Tab->LinkMasterFields to the name of the control, which is "SpecialtyCombo", not "SpecialtyID" 4) delete the...

What do you mean listed? Does that mean added to a list? Displayed from a list?

I think you want to add one object to the bill. If you look at this code... Public Sub AddToBill(ByVal Vegetable1 As Vegetable, ByVal Qty As Double, ByVal Price As Double) BilledVeggies.Add(Vegetable1) Billed_Qty.Add(Qty) Bill_Amount.Add(Price) End Sub See how you are adding three...

If it is possible that everything side A says is based on lies, then it is equally possible that everything side B says is based on lies. This is the problem with broken trust, fractured integrity, and mutual disrespect. And if this is where we find ourselves, how should we act? As I see it...

Here's a function that returns a reference to the main form... Function GetMainForm(obj As Object) As Access.Form On Error GoTo handler Set GetMainForm = GetMainForm(obj.Parent) ' MainForm has no parent Exit Function handler: Set GetMainForm = obj End Function You can pass...

I think the hard part about a "complete knowledge" of C# is understanding how to structure your classes in a data-centric application. Access does not train us well in this regard, because we want to display our data immediately, directly queried from the database, in our UI. This is great for...

Here's another way, where the ControlSource is fixed at design time... It makes sense in this regard: changing the control source causes the system to query the attributes of the underlying field, and if it does not support rich text, the system assumes the control should not either. In this...

Try reboot your machine.

It's like it's raining outside, and you go outside without a hat, and then get pissed off at the rain because your hair got wet. Like, put a hat on--problem solved.

@The_Doc_Man, why participate on this thread? No one is forcing you. Col yanks chain. It is what he does. So why keep exposing chain for him to yank? How is your pain here not totally self-inflicted?

If it is important to tell others what they "should and should not," then I think you should be more gentle. It is a public forum. It was the OPs pleasure to ask, and it was the pleasure of others to respond. No harm, no foul.

To the question, it is possible? Yes.

This is a many-to-many relationship. As others have noted, it should be modelled using three tables, like...

Your code tries to take you to a new record when you have a pending edit in the original record. Don't try to move to a new record. But I don't see the sense in opening a popup to control the value of quantity when it would simpler to just let the user edit the field directly. You force your...

To me the simplest solution is to put identification data in the filename. Then you don't need to open the file or parse its contents for your MS Access code to triage the file's origin, destination, purpose, etc... Imagine filenames like ... 1234 Johnny_Jones Report_Card.pdf 5678 Suzie_Smith...

If AWF = True AND IsModerator = True Then Call InsertPolitics End If