Search results

Hey all, Normally i build forms from blank. A colleague asked me about the 'new' view options in form wizard. Not being aware of this, I just went to create a new form using the wizard. The recordsource is a query pulling data from multiple tables. After selecting the recordsource, i am asked...

If your reports are too wide for 'normal' paper sizes, may i suggest the report(s) are not laid out/designed appropriately? The purpose of a report is to communicate pertinent information from a table(s). If the viewer needs to look across more than a couple of A4 page widths, then the...

To the best of my knowledge, view will not show you what you want. Preview mode would be the answer. An alternative maybe is to try outputting the report to PDF?

Subreports have a "can grow" property - set this to yes. Arrange your subreports in the order you want to read them, but make the height minimal (say 1cm). When you run the holding report, each sub report should expand to display all their data

Like CJ said, also do any controls on the form have the same name as one of your new fields?

hi crossy5575 You can not multi select on a combobox. You would need to replace it with a listbox. You are pretty much on it from there. The normal practice is to use the afterupdate event of the listbox to 'build' the where criteria. You can then either use that to set the forms filter OR use...

Data label options are also available from the chart designer interface. I do not have an example available, but i do not think it should not need rowsource changes.

Hi Derek, Open the form in edit mode and double-click the chart so the chart designer interface opens up. From there you can select the type of bar graph you want, stacked in your case.

You would need to build a custom function. have a look at this article for advice https://msdn.microsoft.com/en-us/library/dd327646%28v=office.12%29.aspx?f=255&MSPPError=-2147217396

ARGHHHHHHH!!!!!!!!!!:banghead::banghead::banghead: The form was set as Data Entry. The combobox has a default value (which shows) but the combobox is the first control on the form so the record has no actual values yet. i'm......just......gonna.........slip away.......quietly.....

It s a valid suggestion arnelgp, but like i said in my OP, the combobox does have a value prior to triggering the event.

hi Ihussein You need to set the Allow Edits property to Yes. You will need to do this on all forms upto and including the form that your cbo & txt that filter the subform are on.

Hi everyone This one has me stumped. I have a bound combobox on a form (rowsource form a separate table). When trying to check the combobox.oldvalue in the BeforeUpdate() event, I get an "Invalid use of Null" error. The combobox does have a value prior to triggering the event. Oldvalue should...

Hi Minty I only need to be able to amend data on the GoodsIn_Diary table and the Shipping_List table. But i need the details from a couple of the Purchase_Orders_List table. I have just tried creating a query only using Diary and Shipping and Dlookup() the other fields but even that is not...

Hi Minty I currently have a PurchaseOrder form that contains subforms for each of the other tables and you can update everything fine - just one PO at a time so slow and no overview. But the purpose of this query is to present all the relevant data (everything from GoodsIn_Diary and specific...

I think that is controlled now from External Data>>Import & Link>>Linked table manager. Why would the BE change name or move though?:eek:

Thanks Rabbie. I think i have already exhausted that list. The only one that could have applied is down to indexing, but the joins use the PK.

Thank you for the suggestion. Out of desperation (though not truly a correct approach) i have tried every combination of join in the query:banghead:. Either i can not run the query (which is understandable due to ambiguous joins) OR the resulting record set is not updateable.

Hi everyone, I am trying to 'fix' a Supply database, author unknown. I have created a query to provide a goods in diary, but the resulting recordset can not be updated. I have provided a screen shot of the relevant relationships. There are 5 tables; Purchase_Orders_List - Stores the PO ref and...

Hi bhelmy Just add error trapping to your procedure and check the err number. Something like.. On Error Goto SubError DoCmd.RunSavedImportExport "Trade file" DoCmd.OpenQuery " Run Trade File " SubExit: Exit sub SubError: If Err.Number = 3709 then Msgbox "File does not exist" Goto SubExit...