Search results for query: *

Ah, mebbe I should have pointed out we're still using Access v2 here? That rules out OpenCurrentDatabase I think? Ta Al

*One alternative is to copy from 1 to 3 and then from 3 to 2.* Hmmm. If I go into #1 tho, I might as well copy straight to #2?

I want to copy objects from Remote Database1 to Remote Database2, whilst the code is resting in Database3. I realise that the CopyObject function only permits me to copy from a Source database to a remote specified database, not from remote to remote. Any ideas? Or am i Stuffed? Ta Al

OOps. Wolluf, thanks.... :D

Thanks bgross22 but I'd tried that. Also tried renaming win.ini to win.bak (as suggested) and loading w98 - gets a bit further in the set-up and fails witha gpf.... As a last resort I was thinking I might move all my data files to a single directory and delete everything else. I have a full...

Thanks Wolluf. Haven't tried the step-by-step boot, will give it a go before I reinstall the os. Cheers Al

I managed to delete some *important files* (sorry to be so technical :D ) and rebooted after running Spybot software. Now w95 won't load properly. I'm pretty sure config.sys has gone missing. Moving to c:\windows in dos and typing *win* gives the message that "HIMEM.SYS is missing.&quot...

I have an Access 2k application thats been converted from version 2. The v2 version was using the CurrentUser() function no probs, but in 2k it seems to think everyone is "Admin". Any ideas? Cheers Al

Thanks for replying Darryl. Are you suggesting my subform needs to have a RecordSource of two tables? How do I do that? Or are you suggesting my subform should be a query based upon two tables? (so my query is the RecordSource) If the latter I can certainly do that but I'm left with a few...

Really need some help on this.... :D I'm fairly new to Access - what I have is this :- I've got a continuous subform whose record source is a query (basically a table using parameters from some unbound combo boxes in the header). When ALL the combo boxes are populated the query runs...

Depends how your dates are held:- SELECT Item, Location, Week, Sum(TotalWeek) FROM TableName WHERE DayOfSale >=(Now()-90) GROUP BY Item, Location, Week; .. where *90* equates to 3 months (roughly), in days. Any help?

Anyone? This is easy surely? Help me out here.........

Ta, but what I need to know is which part of the property sheet needs to be modded so that a checked checkbox becomes a "Y" in my table and unchecked becomes an "N". Do I need to set up some triggers??

Hi I'm fairly new to this Access lark and having problems getting to grips with some of the simple stuff (stuff I could easily do in ORACLE Forms etc...) Anyone care to tell me how to make checkboxes work in Forms? i.e. if I base it on a table Y/N column, how do I make the on/off functionality...