Search results

Crosstab report/query OK there is a very easy way to get this done. You already have a query that has got your postcode. you need two other fields in the query one that is a unique field (say customer ID) and one that wont return many values - something like gender where you only have 2...

Looks like a good time to use a crosstab report

Hi. I have two databases, both originally created in Access 2000 on a Windows 2000 platform. database A has links to two tables in database B. Both databases are on a shared drive and are accessed daily by 10 concurrent users. Originally these links worked perfectly and it did not matter how...

Brilliant Bat17 that has sorted it. I wonder why it works as =[fulladdress] in Access 2000.

Hi = yes I have many other custom functions that work OK. I did have a problem with several when my machine was upgraded to Access 2003 sitting on a Windows 2000 platform but using decompile, clearing some references and then picking them up again solved that problem. However, my PC has now been...

Hi Boblarson. Thanks for your reply - But maybe I didn't express myself clearly enough. Originaly I had field controls on the report, which are in effect text boxes, and I did try setting the "Can Shrink" property to yes but this doesn't seem to work. I have tried setting the "Can Shrink"...

Hi, I have a report works fine in Access 2000 - Does't work so well in 2003 The problem is I have a six line address made up from six seperate fields, ADD1, ADD2 etc. If I just place the fields in line under one another any blank field produces a blank line - not so good when there is the...

Hi, Thanks for the feedback- particularly the link to the Access Performance FAQ document. There is a great deal in there that might well be worth looking into. Regarding users having individual front ends the answer is NO they don't. That was the first thing I tried, splitting the database...

Hi. I have an Access 2000 database running on Windows 2000 Operating System. The database is on a shared drive on a network with approx 20 concurrent users. It runs a bit sluggishly so I am looking for ways to speed things up. The network guys say that the bit rate is OK so I need to tweak the...

Oh... thats good!! And so simple. Fits the bill perfectly. Ta. :D

Thanks for the suggestion - setting the 'Enter Key Behaviour' on the 'Other' tab of the properties of the field to Default rather than Next Line prevents immediate deletion but highlights the entire content of the field. Not so bad - except if you then happen to press the Escape key everything...

I have a form that has a memo field. If text in the memo field is highlighted and I press the enter key the text is deleted. Does anyone know how to prevent this from happening? I know it is easy enough to click off the text (deselect it) so that pressing the enter key will move me to the...

Ah!! Magic. Thanks SCOTTN that is a really simple (elegant) solution. There always is an easy way, it is just finding it that's difficult. Many thanks....Sprocket

OK, The report's on-open event tests to see if the parameter gathering form (dialogue) is open or or not. If it is already open by another report then it passes back a message saying process in use and quits. The dialogue form then collects the user input and hides itself until the report has...

Thanks for the quick response Mile-O-Phile but where do I put your little snippet of code? Forms(myvariable).Visible = True I should perhaps point out that it is a report that calls the dialogue box (which is a form) and it is the report that I am trying to refer back to, so perhaps it...

Returning public variable as a Report name? I have 3 reports that all require start-date and end-date parameters entered when the report is run. So far I have a seperate (identical) dialogue box for each report that provides these details. All works well. To slim things down a bit I am trying...

Hi All, Is it possible to link tables that are in different databases that are in the same folder on a shared drive using the old fashioned "dot" syntax that used to be used in DOS. You remember .\..\ etc. and if so how. UNC referencing won't work here because.... What I have are several small...

Just a thought but isn't this a case for a form/sub-form. The main form is the user called from the user table. the sub-form is the job/order detail - called from the job/order table. Then any user can have as many orders running as s/he likes. Or have I misunderstood your requirement?

It WORKS!!! It was my first time using a global variable and thus I thought it must be the variable bit that I was getting wrong. Once you guys convinced me that it was not placing the variable that was wrong it became much simpler to find that I had cut and pasted a line of code into the...

Thanks for the quick response Travis, but....... I think that I must be doing something else wrong as I have put the declaration in a utility module under the modules tab. Could you enlighten me on the static bit. Can a public variable also be static and if so how do you declare it as both...