Search results

Hi, I have a split accdb in Access 2010 with tables/data in the back end file (stored on a network drive) and the forms, queries and code in a front end file stored on each desktop. Note the front end file is common to two back end files. Both back ends will be mirrored but I need to use one...

Hi, I've got two tables in my Access 2010 database - both are identical in structure, the difference being one (Dove) contains old data and the other (Dove Data File) contains updated data. The primary key for these tables is "TowerBase". I want to use an update query to update only the...

Thanks very much... it works a treat!

Hi, I'm after some help to concatenate a number of fields from a table into a query please. The fields are: Prefix Firstname MiddleInitial MiddleInitial2 MiddleInitial3 Surname Note that there will be varying combinations: some people will have a Prefix, Firstname then surname (no middle...

I really don't know the mathmatical formula. I simply have a spreadsheet with the calucation and formula in it. Maths and formulae are far from my strong point. All I can do is give you some examples on the spreadsheet, that way you might be able to decipher/understand better?

Hi, I have a weight conversion formula in excel which looks at the values in two different cells and provides a result in a third cell. I could really do with this 'conversion' happening in a query in Access based on values within two fields which are in the same table (I have Access 2010)...

Hi, How can I display the count value from a query on a subform for the related/selected record? I've tried a DLookUp without success (the text box remains empty): =DLookUp("[CountOfMethodID]","Methods count","[MethodsRungVisitID] = Form![Form4b]") Here's my table/query/form info: Query is...

Hi, Not sure if this might come under Forms or Queries, so I'll try here first. When I add a record to table A (using a form) the first field I enter is a date. That date will then determine which records I see in my drop down list from table B (via a query). Some records in table B have...

Dale, thanks for your help, though I still haven't been able to get it to work. But I have since changed the design of my database so I no longer need that functionality - for now at least.

I've done as you have suggested but the value is still not copying to the required field.

I'm not actually typing into the field. It's the auto number/primary key number that is generated when I add a new record in the sub form to table B that I need to automatically copy to the field of the same name in the main form/table A. The value is not updating to the main form field. Oh...

I've tried the following two variations but still not working. Sorry I'm not getting this: Forms!Form4a!QuarterOrPealID = Quarters and Peals subQuarterOrPealID Forms!Form4a.Refesh Forms!Form4a!QuarterOrPealID = Forms!Quarters and Peals sub!QuarterOrPealID Forms!Form4a.Refesh If it helps my...

Thanks Dale, but it didn't work (probably something I've not done correctly. Here's what I put in the After Update event of the field in the sub form: Forms!Form4a!QuarterOrPealID = SubformTextbox Forms!Form4a.Refresh Is there more to it than that? Ta Gareth

Hi all, Firstly, I apologise in advance for being an Access 2010 novice, but there is something I really need help with. How can I get the value from a field in one table (in the sub form) to copy/insert into a field in another table (in the main form) when adding a new record? The main...