Search results

Hello I have a very odd (and frustrating) problem with text wrapping in report fields. Unfortunately it's one of those things that seems to have appeared out of thin air and doesn't seem to have a simple solution. The problem: If a field in a report has a font size of 9 or 15 (the two I've...

Hello After some searching here and elsewhere, I'm not sure that this is possible but....... I have a set of string variables. I want to perform the same operation on each variable and return the result to the same variable name. var1 = "xxxx" var2 = "yyyy" var3 = "zzzz" For each variable I...

I had a sudden problem with a corrupt front-end database. On opening, or any other action for that matter, I got the following message: "x.mdb has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu, point to the...

Hi Here's a knotty problem. I have a small database which runs on my machine with full Access installed. The database also runs on another machine as a runtime database. Until recently, all worked fine. I then installed copies of another program (ESRI ArcGIS) which seems to install some VBA...

Hi As usual, something which I thought would be pretty straightforward is proving more difficult than anticipated. Done the usual searches and surprisingly couldn't find an answer. I have a main-report (rptMain) which has, say, 4 subreports (rptSub1, rptSub2 etc) How can I return the number of...

Hi Can anyone confirm (or otherwise) that you can't set the record selector property to 'no' in a datasheet view form? (well, you can set it to 'no' but it seems to have no effect) cheers Neil

Hi Not really sure whether this qualifies for the Reports or Code forum? I have a report with an Image object which has a 'Picture Type' property of 'linked'. The 'Picture' property of the Image object is set to the appropriate path via code on the Report_Open event. What I'd like to do is...

Hello Sorry to add to the number of 'relationship' posts but a thorough search has failed to turn up anything similar to my problem. I have a table tblSite Each geographical site (defined by a PK 'SiteNo') in tblSite can contain multiple occurrences of a large number of types of geographical...

Hello everyone, I've had a good look round the forum and I'm sure the answer's already out there (most of them are) but can't quite find it. I'm guessing that this is fairly basic stuff but recordsets are new to me...... I have a query called qryA. The query has two fields, StringA and...

slightly oddball sort criteria Hello again all I have a table with a field 'SiteNumber' (a primary key). Values for SiteNumber take the form (for simplicity) PLS00001A PLS00001B PLS00001X PLS00002A PLS00002B PLS00002X I'd like to sort this table so that the records appear as follows...

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...

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...

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...

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...

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...