Search results

I did a search on my WINNT directory and couldn't find 'Show Desktop.scf'. The shortcut says it's a 'Windows Explorer Command' (testing on 2K, to be implemented on XP). Does XP have Show Desktop.scf as a separate file? I tried creating a shortcut to the icon and placing that in the form, but it...

Thanks, that did the job, and will do for what I need, because Access will be the only window open at the time. But for interest's sake, if my requirements were different, e.g. if the user had other windows open too, that code will only minimise the Access environment. How about minimising all...

Thanks for that, I've downloaded secfaq.doc now and will read it through. It looks more complicated than I initially thought! It's possible I did modify the system.mdw file in the process, but the database is still working properly, and if there are issues I can easily export the tables and...

I have created a database and want to restrict the priveliges of certain users so records cannot be deleted, designs changed, etc. Under the user and group permissions, I discovered that even though I'm logged onto the machine under my username, the 'Current user' is 'Admin'. I have no idea...

I have a database being used by several inexperienced users, so have created an instruction sheet as a desktop image. I have a 'Help' button in my database which I want to minimise all windows in order to show the instruction sheet on the desktop, in exactly the same manner as the 'Show Desktop'...

Thanks for that, got it to work. Not sure if it's exactly what you were saying, but I did the following (may help anyone else with the same question): * Click on 'Lookup' tab * Change 'Display Control' from 'Text Box' to 'Combo Box' * Change Row Source Type from 'Table/Query' to 'Value List' *...

Sorry about the field names, I said Cost and Freight to simplify it, but PricePaid and DeliveryPaid are actually the field names I'm using. Well that worked. I made the new query as you suggested, and it went fine. I then replicated it in my original query, and it worked again. Not quite sure...

Surely there must be some way of doing it though... the SQL tells it to get such and such info from another source, can't you redefine the source of the info? E.g. something like just SELECT 'Male' OR 'Female'

Well it half worked. It allowed me to enter the line you suggested, and accepted it with no errors (which is quite an achievement for most of the code I've entered thus far!), but it didn't produce a result - the field was blank when I went into datasheet view. I ensured the fields 'Cost' and...

This is probably a very simple one, but I haven't had much success thus far. I know you can make a table field a drop-down combo box by selecting 'combo box' in the setup, and then telling it to get the data for the combo box from another table, but is there some way to do it without another...

OK, let's go with the query idea, I'm not too fussed either way. How would I do it in a query? I go into design view, can then select which fields I want and in what order, but I still don't see how that helps me calculate a result for one of the fields. I've got no problem at all doing it in a...

Well in this case I do want to store calculated results. I have two fields, [Cost] and [Freight], from which I want to calculate [Profit] (i.e. [Profit] = [Cost] - [Freight]). I then want to be able to use this stored value elsewhere in the database, e.g. in reports and forms. So a table is...

I know this is possible in forms (Row source = [Field1] * [Field2]), but I've found no way of actually linking this calculated result to a table cell. Even better would be to do this calculation at table level so any forms or queries based on the table would have access to the calculated...

Thankyou, you're a saviour!!! I did what you said, and when viewing the code, discovered the magic is done by the <Next Record> tag, which I was then able to copy into my already designed document and merge. Worked perfectly, and without lots of ugly messy code! Thanks again! :)

I want to generate a mail merge document to create wedding invitations. To minimise printing costs, I want to have two consecutive records on the one page. How do I do this? From what I've seen so far, the only way to get the next lot of data from the database is to click the |> button in Word...

Thought of that. Yes I do have an autonumber field as the primary key, but I'm always changing the order of the records in the form, but still want these sequentially numbered regardless of the sort order.

Dave, The problem still exists. Sorry, which was the 'above correction' you referred to? Could you please go over the last long thread I wrote and show me where the problem is? I'm still not too clear about the MyCount Cancel Integer business.

Thanks for that, I got it to work in the manner you described. Unfortunately it still hasn't exactly solved my problem. Since I have a datasheet form, I am able to view many records simultaneously. I therefore need each row to have a different number in it, i.e. the record number it is within...

That looks like the sort of thing I'm trying to do, but can you please step me through it slowly, haven't had lots of experience with all this code stuff! The first part looks like what I'm after (don't need the x of y bit), what's the deal with the Me! part? I know that would seem to indicate...

Dave, Yes, the first line was highlighted yellow Private Sub form_open(Cancel As Integer) so I presumed the problem was something to do with that line (naturally!). But not knowing enough about VBCode, I'm not sure what the problem is. As I said, I tried changing 'Cancel' to 'MyCount', but...