Search results

Hi I'm having trouble using the DTPicker control on forms in Access 2000. For some reason I can't work out, some DTPicker controls are moving themselves to the top left hand corner of the form when it loads. Not all the DTPickers do this, and they don't do it all the time. Is this a bug in...

Hi All I have a report in Access 2000 which has its printer set to Adobe Writer 5.0 which has now been removed from my machine. I get the message "You must install a printer before you design, print or preview" when I try to open the report. How can I change the printer setup on the report...

Hi Apologies if this has appeared before, but if it has, I can't find it! I have a database split into front and back end, used by 30-50 users. One particular user is experiencing the following problem: when one particular form is loading, if she switches to another application, twenty or so...

Problem with Date & Time Picker on Tabbed form - not the usual problem! Hi all This isn't the standard problem with DTPickers & Tab to which I've found lots of references! I have a form with a Tab control, each page of which has a subform on it. There are several MS Date & Time Picker (6.0)...

Hi I have a combo box on a form for which I want the available values to be a subset of the values from a table (which I can do), but for older records, I want the combo box to be able to display any value from this table. (The combo is to select a member of staff who has been assigned to a...

Hi Apologies if there is a previous post that answers this - I've looked, but can't find anything that works. I have two tables with identical structures. tblA contains a subset of the records on tblB, with identical values on all fields except ID. I need to remove from tblB all records...

Hi All I'd like to implement something in an app to allow users to create their own ad-hoc queries from a specific number of fields from specific tables, without allowing them full access to the query designer. I can see how to do it (a form with code that creates the SQL), but I wondered if...

Hi Has anybody any experience of setting up tasks in Windows Scheduler from code? (I've searched and can't find any useful posts.) I've had a look at all the libraries in Tools/References and can't find anything useful. What should I be looking for? (Or am I barking up the wrong horse?) Dave

I'm sure I've missed something obvious but... I'm getting the above error when I try to import from a text file and can't work out why; I get the same error using TransferText in code. However, if I open the file, parse the data and put the data onto the table one record at a time (in code)...

Hi all I have a process in an inherited db that rebuilds a table of about 200,000 records every week. The build bit runs fairly quickly (considering), but clearing the table out first is taking 20+ minutes. It currently uses a deleted query ("DELETE * from tblTable") which I thought would have...

I've had a search and can't find anything along these lines... I've got some code which plays about with reports and it looks awful when it's running - is there an equivalent of Excel's "Application.ScreenUpdating = False" functionality in Access (2000)? Dave

I've seen numerous posts where posters are recommended to use one or other - I've always just used whatever felt right and never had any problems. What exactly are the pitfalls of using the wrong one? Dave

I've noticed that the great and the good all seem to recommend not using composite PKs. Does that even go for join tables in the middle of a many-to-many relationship? Not sure I see what's to be gained by adding an ID and making that the PK. Any comments? Dave

If a front-end database has links to many tables in a back-end database and the back-end is moved, is there an easy way to update all the table links in the front-end in one go, or do you have to set up all the links again one at a time? Hoping there's a quick way... Dave edit: just realised...

Hi I'm sure I came across a thread (here or elsewhere) explaining how to create PDFs from reports (without using Ghostscript) by setting the default printer to Acrobat Writer and setting a registry key to the required filename to stop the prompt appearing. I've searched high and low and am...

I have a report containing several multi-page subreports. When viewed outside the main report, the subreport's page header works fine. However, when viewed in the main report, the subreport page headers disappear. Is this a "feature"? Am I missing the point somewhere? Is there a way round it...

How can I set the parameters for a query underlying a report before running the report from code? I've successfully used the Parameters collection of the QueryDef to set the parameters before running a query from code, but the same approach doesn't appear to work for reports, and the report...