Search results

The compiler is telling you it doesn't like either query1 or tempQuery1, depending on which line raises the error...so the place to start would be to look at those queries. Regards, Tim

This sample Access file has code that sports for next and for each loops, arrays and collections, and even arrays in collections. Fit for viewing by either VBA or movie enthusiasts. Regards, Tim

Are you asking if you can get "title" data from a table or query -- rather than from a form? If so, the answer is likely a yes.... You might be able to tweak a function here and call it from inside an Access query and then use the query as the record source for your report. You may also be able...

Array madness... Regards, Tim

I understand what you're attempting to do but am confused by the record sources. I have attached a sample which hopefully will get you closer to a solution... Also, I recommend, if at all possible, eliminate the first step in your process. It makes your job more difficult and lengthens the...

You may want to use the Where Condition argument of the DoCmd.OpenReport method. The report must exist and it must be based on a table or query that includes the field by which you want to filter it. Private Sub StockCode_DblClick(Cancel As Integer) ' Assumes stockcode is a string...

I think you want to use a main form and subform...not tabs...if, that is, you are trying to work with clients and their treatments where one client may have 0 or more treatments... In Access Help, search on create SubForm in the index where you can read up a little more on this. Regards, Tim

You may want to consider adding another layer or two to the process; it may make things slightly more manageable... Very rough...just to get you thinking along these lines... Private Sub QuickSearch_AfterUpdate() If Len(Me.CompanyName) Then SearchByCompanyName(Me.CompanyName)...

The subform closes? Is the subform embedded in the main form? Answers aside...a proposal for working through this: Create a copy of your Access DB file and then strip out all code from your subform except the BeforeUpdate code... Run a test to trigger the Before Update event... If the form...

A connection string treasure trove. Regards, Tim

For starters try working with this code in the subform's before update event handler... Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Me.Project_Number) Or Me.Project_Number = 0 Then MsgBox "Please enter a Project Number." Cancel = True End If End Sub Regards, Tim

Make sure ProjectNo is indexed on the Oracle table. The SQL itself is trivial -- how many records does it typically fetch, one? Regards, Tim

Looks nice but it's clear you didn't move to Nice.

Yes, but it comes at a cost: you may have to interact with the in-laws.

A guess... Based on what you wrote, you may also want to disable the combo... Me.StatusID.Enabled = False Regards, Tim

The Grammar Goons are restricting us...so let's fix that... I should say, "Let's fix fat." Other examples... Before The opposing team scored a touchdown. After The opposing team scored a suchdown <-- Flexible semantics. Before My best friend is now serving in ping pong. After My best friend is...

Names starting with the letters A through L occur at the start of a sentence while names starting with the letters M through Z occur at the end of a sentence. Also, if you're buying a particularly expensive car, flattering adjectives may occur at either end of the name.

Love those Gotos... I'm sure Wayne's on the course you plotted B.

Again, I suggest you do the search... If the "solution" I proposed doesn't make sense to you, you may want to search on normalization. If it does make sense, I suggest you step back a bit and, in simple terms, write what you want to do in the code window, step by step... ' Get advice number...

Use the advice number as criteria to fetch the related items from the database... SELECT Advice.X FROM Advice WHERE Advice.Y = Advice Number from Listbox ...putting those items into, say, a recordset. (Search on ADO and DAO and loop and recordset for example code.) Then loop through the...