Search results

That worked - thank you so much! It slipped my mind to use dcount also - I was using and overly complicated sql query and recordset - so thanks for that too!

It's a linked SharePoint table.

The form is bound, and even after dirty, whenever I try and get the ID, null is returned. I assigned a textbox to the ID, and it stays empty.

Hi all, I have a form where after saving (clicking "save") for a new record, I want that new record's autonumber ID to be added to a table, only if it doesn't exist in that table. I know how to add records to a table. Where I'm struggling is getting the saved form's ID, and then efficiently...

Hmmm, the checkbox is in the form's header. I hadn't thought of that! I'll need to think of a different approach. Thanks for helping me realize my stupidity!

I enabled record selectors, and got a pencil when editing. The check box is definitely enabled. I stepped through the code to check.

Like this :- Private Sub Form_Load() Me!chkEAC.DefaultValue = True Task = "SELECT t1.Sales_Ref, t1.Actual_SSD, t1.Customer_Name, t1.Tariff_Length, t1.Utility, t1.Supply_Num, t1.Region, t1.EAC, t1.D0019_EAC, Round([EAC]-[D0019_EAC],1) AS Difference, [EAC]/[D0019_EAC] AS [Difference %]...

The textbox is bound. Does your second point still apply?

Hi all, I have a continuous form (no subforms) that is populated by a query. On the form I have a checkbox that changes the forms recordsource via SQL ,via VBA. Each record on the form has a textbox where the user can enter a value. I want a message to be displayed if the checkbox is...

They are from the same table, so that's good enough for me. Thank you.

Hi, I have 2 queries as per below that count 3 sets of data from one table by date, and then group by month. The queries are :- SELECT Format([Date_sent_to_Registrations],"mmm-yy") AS Period, Count(tblQuotesNew.Date_sent_to_Registrations) AS xCount...

Sorry, what I mean is, how will I get the values into the textboxes without using separate DSums? Or do you mean still use separate DSums, but on the totals query?

Could you explain a little more? Wouldn't I just be DSumming again on the new query?

Firstly, thank you for your suggestions. I've modified my union query into 2 separate unions :- SELECT Count([t1.DateTPIAgreementSigned]) AS DataCount, "WhiteboardTPIToday" AS Code FROM tblBrokeragesNew as t1 WHERE (((t1.DateTPIAgreementSigned)=Date())) UNION SELECT...

Here is my query SELECT Count([t1.DateTPIAgreementSigned]) AS DataCount, "WhiteboardTPIToday" AS Code FROM tblBrokeragesNew as t1 WHERE (((t1.DateTPIAgreementSigned)=Date())) UNION SELECT Count([t1.DateTPIAgreementSigned]) AS DataCount, "WhiteboardTPIWeek" AS Code FROM tblBrokeragesNew as t1...

You'll have to excuse my trepidation on going into too much detail. In the past ( not on this forum) I have spent a lot of time asking a question only to receive one reply telling me to read a book on VBA, etc, etc Anyway, my environment is Sales essentially, and the dashboard is used to...

Each of the textboxes contains a numerical value. Each of the queries within the union is a count, which counts records in a table of around 6000 records if certain criteria are true - usually based around dates. So, I have 4 rows for criteria A, B, C, D. And columns for today, this week, this...

Hi all, I have a dashboard with 15 textboxes. In short this layout can't change. I was populating the boxes with one query each when the form opened, and they populated fairly quickly. In order to reduce the number of queries, I merged them all into one union. I populated the textboxes by...

Yesterday, this is exactly what I planned to do. I setup the tables exactly as you explained, but when I tried to setup the relationship, I got a warning - I can't remember what though. Now when I try after you post - it works fine! I think previously I may have been trying to create the...

Hi, I have 3 tables, tblQuotes, tblCommission and tblNotes. Each quote can have multiple notes. In tblNotes I have a Quote_ID, which I have related to QuoteID (PK) in tblQuotes. Each quote needs to have 6 commissions. I'm not sure how to relate this as I've already used tblQuotes' PK for...