Search results

Hi, I have some images on my form that I'm using as buttons, based on On Click Under certain circumstances, I'd like to disable these "buttons". Is there a way to do this, as I can't find an Enabled property. Thanks

That worked - thank you

Hi all, I have the following query which returns the last 5 digits of a statement number :- SELECT DISTINCT b.Brokerage_Name, Max(Right([Statement_Number],5)) AS Expr1 FROM tblBrokeragesNew b LEFT JOIN tblStatementsNew s ON b.ID = s.Brokerage_ID GROUP BY b.Brokerage_Name; How can I amend this...

It is now! Sorted - thanks again Minty.

Hi, I'm opening a form in VBA using the following :- DoCmd.OpenForm "frmBrokerAcc", acNormal The form opens, but focus remains on the original form. I've tried setting focus to a control on the opened form :- DoCmd.OpenForm "frmBrokerAcc", acNormal DoCmd.SelectObject acForm, "frmBrokerAcc"...

Thank you.

Thank you.

Perfect. Thanks again for your help.

Hi all, I am exporting various types of data from Access to Excel using Dim excelApp As Object <snip> Set excelApp = CreateObject("Excel.Application") I then do some formatting, etc in Excel via Access VBA This all works perfectly. What I would like to do though, purely for aesthetics, is...

Perfect - thank you!

Hi, I have 2 queries :- SELECT tblBrokeragesNew.ID, tblBrokeragesNew.Brokerage_Name FROM tblQuotesNew RIGHT JOIN tblBrokeragesNew ON tblQuotesNew.Brokerage_ID = tblBrokeragesNew.ID GROUP BY tblBrokeragesNew.ID, tblBrokeragesNew.Brokerage_Name HAVING...

That makes sence. But, for example, one of my tables in Access has 30 fields. Surely I don't have to create each column manually in Oracle?

Hi all, I need to move some data from my Access database to Oracle. To setup the oracle tables, I need a Make Table query that "makes" my Access table (data types, etc) Is there a way to do this, in or out of Access? Thanks in advance

Yes, all good points - I had a few issues with my provided query - apologies. Basically, I need to return every record from qryCML, and the corresponding data from tblCommissionNew. qryCML & tblCommissionNew are related by QuoteID/Quote_ID. The relevant fields in tblCommissionNew are Stage...

Hi have the following query :- SELECT t1.QuoteID, t1.Supply_Num, t2.Cost AS Stage1Cost FROM qryCML as t1 LEFT JOIN tblCommissionNew as t2 ON t1.QuoteID = t2.Quote_ID WHERE (((t2.[stage])=1)) GROUP BY t1.QuoteID, t1.Supply_Num, t2.Cost; This results in 3 columns, one of which is a total where...

Excellent, thank you.

Hi all, I have a listbox on a form, populated by VBA. The values on the listbox are dynamic, depending on query results, in this way :- Me.lstReports.AddItem "Puppy (" & RS.Fields(0) & ")" I want to create events based when the user double clicks the listbox. I was doing this using a select...

Thanks all for your suggestions. Minty & JHB, your suggestion for great, thank you. Ranman256, I get a #Name error using your code. Not sure what I'm doing wrong. Either way, problem solved. Thanks again.

Hi all, I have a text box on my form, who's control source is [CODE]=DCount("Quote_ID","tblNotesNew",("Quote_ID =" &