Search results

Thanks for trying, chaps. It must have been a bug in the control - I've found a later version of mscomct2.ocx and it works fine now. Thanks again. Dave

I'm not closing or hiding the form, just disabling the DTPicker (based on the value of other fields) When it is re-enabled (again depending on the value of other fields), it seems to lose track of some of its properties and methods. The events that re-enable it certainly dont have any code in...

More... I've now narrowed down exactly when this happens - it's when the DTPicker is enabled again after it has been disabled. I'm currently getting round this simply by storing the position and setting .Top and . Left again after enabling the DTPicker. However, I now have a more serious...

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

Thanks. I just had a closer look at my printers setup, and although I have several printers set up on my machine, none of them was set to be the default! I set one as default and all works fine now. Thanks again. Dave

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

Thanks That was going to be my next step! Cheers Dave

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

Add each new row at the beginning rather than at the end. Dave

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

Aha! Can't do exactly that as the form isn't bound (should have mentioned that!), but you've given me an idea how to do it. Thanks! Dave

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

Thanks very much. Obvious once you see it! Dave

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

Sorted! It just didn't like the extension ".tsv". Changed it to ".txt" and voilà! Pretty unhelpful error message though... :rolleyes: Thanks anyway. Dave

... I've checked everything I can think of - I have full access rights to the directory it's in etc. I also get the same problem if I try to link to the table rather than importing it. I've looked for previous posts on this and can't find anything. Anybody? Dave :confused:

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

I think the best way is going to be dropping the table completely and rebuilding from either some make-table stuff in SQL or copying from a blank template. The data actually comes from an unnormalised table in the same db, so not only is there an unnormalised table, but the data is then...