Search results

Acc97 and Acc2k icons: How can i prevent acc2k and acc97 'association icons' from becoming mixed up. I have both 97 and 2k installed happily on my (work) PC, except that if I double click on a file in explorer say or a desktop shortcut, the .mdb attempts to open up in whichever version was...

Re Editing an e-mail. Set the editmessage part to true and you'll be able to edit it before it goes. This is the format of SendObject DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]. Does anyone know...

Groupwise I've been following (some) of this thread, and between this and some other threads i've managed to set up a means of sending an e-mail. This method seems to default to Outlook, which is loaded on my PC... but we use Groupwise as our e-mail. As it happens, all looks well, but my...

I guess there must be more to it than this ...but... Why not just remove the hide duplicates from the hours field (only)?.. I've just read the end of your post again, could you ahieve your aims by grouping the names? and hiding duplicates on the hours perhaps?

Yes. Open report in design view and right click in the detail area. Select 'Sorting ang grouping'. Group header = YES, Group On = Each Value, Keep together = Each Group.

You could try a construct something like this:- SELECT [Customers].CustID FROM [Customers] WHERE ((([Customers].CustID) In ([ENTER CUST ID1],[ENTER CUST ID2],[ENTER CUST ID3]))); if you need more entries then just keep adding parameters. NB Parameters in the [brackets] must be different. I've...

Thanks for your posts. I have 'wrapped up' my Access2000 application in an .mde file and it runs fine on my Access2000 installed PC. I can't get hold of a non-Access PC at present, but I tried it on an Access97 only PC and it can't run because the format is not compatible. I supect that it...

I have written a small database in Access for a friend, and want to install it on their PC. They don't have Access installed, so is there a way I can 'wrap it up' so that they can use the database without having to buy and install the software, etc. Cheers.

I hear what you're saying Fizzio re: not storing calculated fields. :) These two numbers are in fact entered as text. The actual number I wanted to enter is like 76000083123. This is too big to be entered as a number, (and too much work) so i set up a separate entry point on the form. I...

Thanks for your interest, I am trying to trap the error at the point where i enter the two 'numbers' into the form. I use an AfterUpdate which actually runs after I input data into the next entry box (PatientName). I run a query to join the two parts together and then write it into the same...

I am adding data via a form. When I try to add a non-unique number I get an error message saying 'non-unique' etc. OK, so if a non-unique number is detected I want to put up a message box to the user and then delete the erroneous record. I have written some code to do this on detection of an...

Excel stores dates as a number, even though you can see a date format, hence when exporting it appears as a number in access. If the date was written in as a text string originally in Excel, then access will pull it in as a text string and you can change the field type to date at your leisure...

Is it possible to force the field type in the table resulting from a query? Reason: Access2000 keeps giving me tables with field type = Binary!...according to MicroSoft this field type does not exist!! These binary fields appear to be generated when the resulting data is 'mixed' eg. "Q3...

Cheers, i knew it was something simple. I'll try it when i get back to the office. Thankx again.

Its a long one!.... (because i've had to do a workaround to get this far), but anyway, how do i indicate line continuation? Any ideas [This message has been edited by st3ve (edited 01-22-2002).]