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

I think this works? Function exists() strDBPath = "full path of database" strDb = Dir(strDBPath) If Len(strDb) <> 0 then MsgBox "Db exists" End if End Function

Yep, why not just leave my strings in the array. Was so fixed on getting the variables back out again that I didn't think about that. many thanks Mr DJ

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

I've spotted the deliberate mistake! I added the first picture manually in the report properties and then set up code to change the picture depending on the record shown in the report. Just leaving the 'Picture' property as '(none)' to begin with and then adding a picture via code means that the...

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

Thanks for your response Ken:) I'm not certain of what you mean by a 'feature definition' table and how the 1-1 relationship would fit. I see that I could link the Site table to a table FeatureTable with two fields, SiteNo and FeatureType (tree, pond etc), via a 1-many relationship on SiteNo...

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

Dave Many thanks for a quick response and taking the trouble to provide an example db. Sometimes you spend so long looking at a problem that you start to make it much more complicated than it needs to be and it takes someone else to point out the blindingly obvious! Got it sorted now cheers Neil

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

Thanks all for the further responses. I've thought about emalrola's suggestion but for some complicated reasons the data really does need to be stored in the specified format. So, Plan B swings into action and then comes to a halt as I try to work out how to carry it out. I've added a text...

Hi Neil Thanks for a (very) quick response. What you suggest is actually my 'Plan B' - I thought of adding an incremental number field and sorting on that although your suggestion seems to allow less scope for error. However, I'm reluctant to have an extra field if I can help it and would hope...

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

I do intend to set up proper admin/user permissions so this looks like the easiest way to do it. I've had a quick look at api calls and don't really like the look of that route (too complicated for me). I'll post back to let any interested parties know how it goes. cheers bretto Neil

bretto Thanks for responding. I quite like this idea - I presume we're talking about Access user ID's as defined in a workgroup file/security permissions etc and not more general network login ID's? I haven't got as far as assigning the users yet but when I do I'll certainly have a crack at...

Hi FoFa Thanks for your swift reply, much appreciated. I'm afraid parameter stuff is not one of my strong points so setting this up may be a little tricky for me (I wouldn't know where to start in truth!). I was hoping to go down the code route to keep it all neat and tidy and avoid users...