Recent content by tanc

Thanks, I knew it would be something simple

Hi I have a database for mapping out site location with an Eastings and Northings fields but i need a 3rd field for the grid reference which is built up of two letters and parts of the Eastings and northings (British grid system) for example Northing:123456 Easting:78900 would be gridreference...

Thank Gina, can you recommend any word press themes?

I'm on access 2010, I would only need a photo and a few fields of the database to show and respond to queries rather than the full thing, I was thinking of exporting it out as a CSV but I'm unsure of the next step

Hi I'm not sure if this is the right section but i have an access database of finds from an archaeological site which i would like to put a limited (not editable) copy online similar to the British Museums site: Britishmuseum.org/research/collection_online/search.aspx all i would want...

Hi does anyone know if there is a way to cross reference between records? For example I have a memo box where the user would write that the item is simular to record [34] (34 being the PK of that record) what I'd like to do is click the 34 to send me to that record rather than search the...

I have a form with 2 different methods of entering XY data to import into GIS the first is simply 2 fields where you type in the XY value and the second you type in a reference with a relationship to another table containing the coordinates. what i would like to do is have them both appear in...

Ive got a simple report which uses serveral linked image with the control source directing the database to the folder containing the images =[CurrentProject].[Path] & "\Images\" & "P" & [ID] & ".jpg" adding an a,b or c this works fine and all the images show on the report mode but when...

Thanks, I've manage to bodge the first issue by forcing a refresh when in form view. I've manged to fix the other issue as well, I had the field type set to text had to change it to number Thanks again

I have inherited 1000 records which need to fit into new criteria selected from combo boxes and to do this individually by the forms will take forever so i want to copy and paste the data in the table, but when I do it doesn't fill in the form. This may be a problem with the cascading script in...

This may be impossible to do but I have a database of objects, of which some have been broken down into their component parts and given new records. I have a field for parent number but I was wondering if there was a way to next the children under the parent so if you queried the object you...

thanks the issue with assigning a 01 instead of a 00 would be confusion if there was an event on 01/01/1940 for example, the only other way I could think off would be to separate the date into 3 separate columns with null data but sorting and querying then becomes an issue

I've got a spreadsheet that someones asked me to turn into a database but the formatting is a bit messed up. the date system used is YYYY/MM/DD, although this is not always followed its easy enough to fix, the problem comes when some of the dates are 1940/05/00, as the days are not always...

apologies if this has been asked before but I'm just getting back into access after a few years on a mac. What I am trying to do is create a form with 2 drop down boxes (A,B,C,D) &1,2,3,4...) what I want to do is make it so if you select option A in the first box only 1,2&3 are available in...