Search results

Hello All I have a shared database which contains a button which opens Arcview GIS and runs a script, zooming to a particular site depending on a value passed from access. The code on this button is given below. My problem is..... One of the users does not have Arcview installed on their PC...

Hi Uncertain as to which forum this should sit in (might be a VBA thing) but here goes anyway. I have a subform 'SbfAdjSites' based on a table 'TblAdjSites' The table (and subform) has 3 fields IDNo (PK Autonumber) Site (Text field) AdjSite (Text Field) If I have a 'Site' (Site1) and it has...

Back again, I've figured out how to do this using a macro instead of code (after much trial and error) so I guess that draws a line under this (for a while....) If anyone wants to see the macro i came up with to do this, just post back and I'll post it up. Thanks for everyone's help in this...

Hello everyone, back again. I have (yet) another question related to this thread and the idea of opening forms at specified records. Thanks to cpod and Dave I now have the following code working nicely on my forms, navigating between forms at the appropriate record. DoCmd.OpenForm "Form2"...

Thanks again cpod. I understand this now. cheers Neil

Dave Thanks very much - that works very nicely. If I could use a little more of your time, could you explain the significance of the 'acForm' bit. I'd like to understand what this is and why it makes the difference, rather than just plugging it in and accepting that it works. (sorry if this...

Hi cpod Thanks very much for your reply - I've just plugged your code into my form and it works a treat. Fantastic. Thanks for supplying a little explanation of what each line does - this helps me understand what I'm doing rather than just copying and pasting chunks of code without knowing...

Seems like a golden oldie this one but I can't find an answer that does what I want so, with apologies for the repetition, here we go again. I have a button on 'Form1' When I click the button I want 'Form2' to open at the same record as was displayed on 'Form1' . The common field on each form...

Thanks all for your suggestions - much appreciated. I tried Pat's first as it seemed the most simple and it worked a treat straight away - thanks Pat. Now that I see how this sort of query is constructed I can take it away and fit it to one or to other similar things I need to do. Thanks...

Here's a quick one for the experts out there. I have a field (PCLNumber) that contains a number in each record. I want to change this field so that it fits the format PCL00000 ie I want to add 'PCL' to each record and the right amount of zeros so that each numerical part is five figures long...

Doc I appreciate the time you've taken to reply and in no way do I see it as an admonishment. I'm a relativley new user of Access (in at the deep end) and this sort of advice about looking at the big picture is invaluable to me (and others like me?) as it doesn't seem to be covered in the few...

Thanks to you both for your replies - after a bit of thought I've decided that I have to go with Pat's suggestion (she is the Guru after all). I've mapped out a possible structure for my tables and their relationships but not confident that I've got it right - any comments are much appreciated...

Hi All First - hope I'm in the right forum here. I know that normalisation is already well covered here (not least by Pat) but I can't find anything that addresses my particular question. I have a large db (50-60 fields, mostly Yes/No). Field 'PCLNo' is PK and represents a geographical...

Sorry for not tying up this thread - been away for a while. I've sorted it now - thanks for your suggestion thouston. Cogent - I can't answer your question - its confidential :)

Hi everyone, I have a table with a yes/no field (Confidential) and I want to populate another field (Confidential Text) with a set text ("this is a confidential file") if the yes/no field is true, or else leave blank. I'm sure it must be obvious but I'm a new user and still finding my way. Hope...