Search results

I am having difficultly refreshing records in subforms. I have a main form with 3 subforms, all junior to each other. I have tried the advice in this thread http://www.access-programmers.co.uk/forums/showthread.php?t=124648 with no success. I'm not sure if it is because I have 4 forms in...

I have set up a report filter based on the example by Martin Green: http://www.fontstuff.com/access/acctut19.htm This was all working very nicely indeed, without any errors. However, I have transferred the database from one pc to another (using an external drive) and I am now receiving the error...

Access 2003. I am trying to create a chart that has an x axis containing date values and I want that axis to extend past the last date and corresponding plot on the graph. The trendline will then extend into this forecasting area. For example, to predict sales or profit in the future. There...

Access 2003. I have searched for info on designing many to many forms, but not found anything to match what I am trying to achieve. I have attached part of my database for reference. I want to create a form that a user selects a 'Vineyard' from a combobox and then selects 'blocks' particular to...

Access 2003. I am guessing this is a bug, but all of my vba has dissappeared and all of the functions or events now produce a missing reference error message. The function names are still in the left pane in the vba window, but I get 'Automation Error' if I try to view the code. This happened...

Access 2003. I have added an unbound textbox to my (sub)form which displays a value based on the value in another bound textbox. This works ok, but when first loading the form it displays #Error. It also displays #Error when there is no subform data for the record selected on the main form...

:confused: I have created a form and subform based on 2 tables. I have filtered the selection on the subform based on the entry on the main form, using the code: Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer) sBlockSource = "SELECT [tblBlock].[VineyardIDb]...

Access 2003. I have created a line chart which shows sample dates on the x axis and values on the y axis. The value of the sample normally increases each sample date. Therefore I have added a trendline to show this increase. However, I would like to extend the range of sample dates to beyond...

Access 2003 Can anyone tell me if it is possible to put a subform of the current form (in the first tab) into the next tab, and the subform of that subform into the next tab and so on. I am thinking this isn't possible, but trying to find a way to tidy up forms which contain multiple subforms...

Access 2003. I'm sure this is possible.:confused: I have attached 2 examples. Example2 (form: HarvestVineyard) was my database form before I realised that I couldn't have all my subforms on the main form if I wanted to add new records to the most junior subform. However, the filter does work...

Access 2003. I was just wondering if there was any way to refer to a calculated field in the same query. For example if the first calculated field was - Total: ([Quantity])*([Price]), could you add another calculated field - Inc Tax: ([Total])*1.175. At present I am having to type the whole...

I'm getting error 3341 when trying to enter data into subforms. I have set up a database with mulitple tables, these are the relevant ones: tblVineyard VineyardID VineyardName VineyardAddress VineyardRegion etc tblBlock BlockID VineyardID BlockName Variety etc tblBlockHarvest HarvestID BlockID...