Dear Group, I have a big problem. When two persons work on the same record, it is always corrupted. Is there any way to avoid this? Thanks! Kevin ... Do You...
Hi, I have recently inherited a system that is composed of about six different front-end .mdb files that share one back-end database. The guy who created the...
Kevin- Which version of Access, and does the table contain a memo field? Does it happen in any table or just one? John Viescas, author "Building Microsoft...
Abraham- If you have the code from the VB front end, that same could should work with a few tweaks in Access (using an Access form - you can't import a VB form...
Hi John, Would you please tell me how? Thanks! Kevin John Viescas <JohnV@...> wrote: Yes. ... Yahoo! Groups Links To visit your group on the web, go...
Kevin- I can't tell you "how" unless you tell me "what" you want to calculate. What is the business problem you are trying to solve? John Viescas, author ...
Kevin- Here's another related article: http://support.microsoft.com/default.aspx?scid=kb;en-us;296389 John Viescas, author "Building Microsoft Access...
I've used the following to zip files from a particualar location. It works fine. Now I want to use it on a folder where all the files are in subfolders. I...
John- I am making an invoice for our clients who book Hotels through our company. This invoice contains two parts. One is the final invoice to be print to our...
Kevin- Although it is possible to reference a control on a subform (such as a Sum calculation in the footer), you need to use the DSum function to recalculate ...
John- Thank you! I am going to try it right now. By the way, do I have to put that "Link"? Would you please give me an example? Can I just put it this way? ...
AD, I have seen a lot of developers using For Cnt = 1 To 5 I am wondering why you do not use For Cnt = 1 To 2 SendKeys " ", True This way it avoids 3 extra...
John- If I just use some fileds in one subform and some filds in another to do the calculation instead of "sum", what should I do? Sorry to bother you again...
Kevin- What is in the outer form? Are the invoice and payment amounts for a specific record or account on the outer form? If so, you must apply the filter so...
Kevin- What is the Record Source of the two subforms? What field(s) are you using for the calculation? If it's a single value, perhaps a DLookup would be ...
I see only the following Text align settings Center Distribute Left Right General I do not see the Justify option. Does anyone have a work around? Thanks Abe...
Abe I'm not trying to answer for AD, but a tab is usually 4 or 5 spaces in a document. Two might not be enough of an indentation for some people. Bill Mosca ...
From Stephan Lebans' site: Version 4.0 updated April 15, 2003 JustiDirect.zip is a database containing Functions to produce fully justified text within...
Abe- "Distribute" is Access' version of Justify - but it does it on a character by character basis, not word by word. Also, it won't leave a short last ...
I need help in filtering a query. I have uploaded a sample DB with only 4 tables @ http://groups.yahoo.com/group/MS_Access_Professionals/files/3Filtr.zip It...
Bill, You are right; a Tab is 4-5 spaces. My original reply included 5 spaced between the SendKeys " AND ", True Yahoo removed it. (I forward that post to my...
Abe- You can potentially put all the criteria in one query. If your query includes Orders and Order Details, you'll need to double-click the join line to open...
Oh, I get it! Yes, you just send the 5 spaces as a string. I don't know why AD used a For loop. Bill ... AND ", ... there) ... the ... spaces ... some ... to...
Abe, I agree with you. In fact, the For/Next loop is not required at all. Single statement below (containing five spaces), should suffice. SendKeys " ",...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
