Search results

Hi, I have a table (tbl_invoices) with a field delivery_description of type memo. I have another field on this table invoice_type_id which is a number acting as a foreign key to another table (tbl_invoice_type). When I run a query against tbl_invoices everything is fine, I can see the...

In the end I just added "Me.SUBFORM.requery" to the on-exit event. I have a follow up question, the whole form is basically trying to simplify and speed up invoice production. The purpose of this form is to try an streamline order production from suppliers. -> I have a DDL allowing the user...

I have tried that one too :( It returns the message "The System can't find the field'|1' referred to in your expression." The code is now being executed on a button click from within 1 sub form, the exact code is: Me.Parent.[TESTFORM_SUBFRM_NEW_DETAIL].Requery

Thanks but I have already been looking at this page, it led me to try two things - both of which report Access cannot find the reference to SUBFORM2 So this is all happening on the SUBFORM1 exit both SUBFORM1 and SUBFORM2 exist on FORM1 Me.Parent!FORM1.SUBFORM2.requery...

Hi, I've tried searching for this and am struggling a bit... I have a form with four unlinked sub forms on - I am hoping to 1) add a value from one subform to another and more importantly 2) update 1 subform when the other is amended...how exactly do I reference subform 2 from subform1. I...

Hi, It does - however if I add parameters to the query (in this case I will be using a District Code and start/end dates) it prompts for the parameters as it produces every chart? I am starting to think simply running that query and exporting it to excel to produce the charts would be easier!

See attached, I've deleted everything but the very basics. I kept a few various queries I tried plus the horrible attempts. My head is elsewhere I think.

It basically has the same problem as the CrossTab Query. I have resorted to the following base query: SELECT theme., Type, Count(Type) AS CountOfType FROM Type INNER JOIN [Action] ON ActionType.ActionTypeID = Type GROUP BY Theme, Type; Now that actually produces the charts but it...

four types, but 30+ themes. I have tried it a whole range of different ways, I did get it looking correctly but the queries were requesting the parameters for every theme. I am hoping to start from scratch and build a query slowly building the chart so I know it works.

Thanks, I've done that and I've produced a query which looks as I expected. Unfortunately the column names are Theme, SumType, 1,2,3,4 and when I go to create the chart I would like the chart to be displayed for each Theme with each section of pie determined by the Type (1,2,3 or 4) obviously...

I have some data that I want to display in a chart: Theme Type Count(Type) Blah1 1 5 Blah1 2 5 Blah1 3 8 Blah2 1 1 Blah3 2 5 Blah3 3 10 Blah4 1 111 Blah4...

immediate follow up - I got my VB working to open access to a specific form/record in access almost. There is one problems: -> I "think" the following code is pretty close, it is opening access without any errors but MS Access closes before it seems to open - what am I doing wrong, I am using...

Hi, Can anyone advise how to open MS Excel from a MS Access database (plenty online really) but then select a worksheet and a row in the excel sheet (can't find anything)? I also need to open MS Access from the Excel worksheet and I was hoping to use Set oApp =...

well after trying to re-open in 5-10 times I did a google and came across this - run cmd prompt and type the path to your database followed by /decompile c:\test.accdb...

Hi, I have been developing an increasing complex access database. It doesn't have a whole heap of data in it yet but ranges in size from 6mb-30mb depending on when I run the Repair/Compact database utility. It really isn't huge at around 25 tables, 60 queries, 15 forms, 15 reports. I need to...

EDIT - I have solved this. I wanted to query a Many-To-Many relationship in an invoice system, I wanted to select all the invoices which included only certain products. However as there were multiple products on the invoices it duplicated the rows. To solve it all I did was create a query to...

hi, Can anyone help - I'd like a button click event to go to a specific tab and that tab contains an sub-form which should open at a specific record. I imagine it's a combination of: [forms]![form1].tab_ctl = 2 Followed by: docmd.openform Struggling to find the answer in google so came...

If you copy and paste it into either and then try and update the control you will be able to see the behaviour and choose the best for you. I think I would probably try the after update event - Pbaldy will know best.

http://lmgtfy.com/?q=access+if+statement+enable+control Top result is pretty good: http://bytes.com/topic/access/answers/777130-ms-access-how-enable-control-form-based-another-control

The basic code for enabling a control on a form: me.txtcontrol1.enable = True/False You would prefix that with an if statement to determine which controls are enabled/disabled. If value1 equal this enable controls, else value2 equal this enable other control else value 3 equal this etc Maybe...