Search results

Just to clarify, my MDE does not contain any tables - they are linked via UNC path per recent advice on this forum. On that basis, is CDrake's experience universal and should I just remove the Compact option before compiling the MDE?

As a rule, when starting a new database, I set certain things up in advance, such as Tools > Options > General > Compact On Close in MS Access and Tools > Options > Editor > Require Variable Declaration in VBA IDE. I've now started exploring MDEs to keep users from playing about with my...

If you've got the button to fire off a query which requests variables, you're more than half way there! Ideally, though I stand ready to be corrected by those more knowledgeable, you should make the EOCR report that you've written use the query as a record source. Rather than the query asking...

You need to understand relative and absolute references for this to work. I'll try to give you an example based on your information. With A1 as the Active Cell, and Cells A1 to A10 Selected, choose Conditional Formating from the Format menu: Change Cell Value Is to Formula Is Enter your...

This thread has gotten me 90% to the solution to my problem, but I've fallen at the last hurdle. My form has an On Load event which: Updates an Action Caption Calls a Function for that Action Updates the Progress Bar by 10% Updates a Status Caption There are 10 steps in total, and each...

A quick look at your code and the MS Access help file suggests to me that you can't call a module; you need to call a function or subroutine within it, just as you would in MS Access. The example given is coded like this:Dim appAccess As New Access.Application appAccess.OpenCurrentDatabase...

Logs into the computer or into the database? If the latter, a batch file isn't necessary; just create a macro in the database called autoexec() and it will run when the database is opened. This is the easier option. If the former then yes. You create the batch file and save it somewhere...

It only says Microsoft Word because Microsoft Word is installed and Microsoft Word is the application associated with opening RTF files. If you went into My Computer and clicked on Tools > Folder Options, you'd get a dialog box. Choose the File Types tab at the top to display a list of...

If your database is opened daily, just have the code run on firing a particular event, rather than on start-up, such as the form accessed before the one that will need to display the updated information. If it's only opened weekly, there's even less urgency. Either way, firing the code...

You're able to read the properties of any file system object and you can time-stamp the records that you add to your table so you can get it to poll the folder structure only for those items created since last update.

RTF is indeed platform-independant. It also doesn't support macros, which is a security bonus when emailing files! Any word processing software should be able to read RTF documents, including OpenOffice, WordPad, Lotus, etc. The icon associated with RTF documents will differ from machine to...

Can you expand on this please? I don't really know what you're refering to.

... and I'll consult mine to correct my own spelling - eduction!

Well done for coming clean. Also, having worked in insurance in a previous career, the question was obviously put together by somebody who doesn't fully understand what they're talking about! Personally, I'd say that your Packages table is superfluous, as is your Business/Products. As any...

I've just checked with my accountant, because that whole notion of giving back more money than you'd originally asked for, struck me as totally wrong. The correct procedure, when issuing a credit note, is to use the same tax point as the original invoice. Therefore the VAT rate and the amounts...

Judging by the wording of the question and the number of previous posts, this sounds like either homework or an exam question. Fair cop, Guv'ner? This forum is aimed at MS Access users to help each other but, if you're honest up front, I'm sure you'll get some assistance with the question...

This is a housekeeping challenge. I've inherited a few databases lately, for different customers, that I'm developing in accordance with the customers' requirements as opposed to the original developer's desires. As a consequence, and I'm not saying I'm better or even right, I find I'm doing...

For that, we have Pitman Shorthand, which is a skill in itself. Misspelling and txt-spk is not and never will be. Woe betide any of my staff who use any such method of communication with my customers! Whilst I sympathise with the truly dyslexic, I also think that it is excessively diagnosed as...

@missinglinq The above code helped me out, for which thank you. I also have the reverse problem and the solution currently escapes me. On my bound form, used for solely for entering a new record, I have Commit and Cancel buttons. Using VBA, clicking either gives the user an Are You Sure...

The method you could use depends on the format of the field called [Date Time], if I've understood your question correctly. If [Date Time] is a Date/Time field, then you can use Format([Date Time],"DD/MM/YY") for the Date portion and Format([Date Time],"HH:NN:SS") for the Time portion If [Date...