Search results

Check out the TransferText Method in Access's Visual Basic online help.

I've done a few Access databases, including a couple that my non-profit sells (no commission, sadly), and one that's used as the membership maintenance tool for the organization. I've done a bunch of others, but these were more specialized, single-purpose applications. After hacking around for...

There's a for-purchase product that sounds like it fits the bill at http://members.aol.com/ukandrewc/index.htm. There's a freebie that looks a little lighter at http://www.allianceconsultingllc.com/download.htm. I had looked into something like these a while ago, but the inability to use...

Jeff, Long question, lots of things to think about. Hope I can give you some ideas. First, dealing with the Oct 1 Fiscal Year: You could adopt a convention that internal dates are offset by 90 days so it's easy to extract the fiscal year given an internal date. Calculate an internal date...

Jatfill- I know about hyperlinks. The problem with them is when you click on them a browser window opens. Then the user must figure out how to Save As... (in IE - it's different in NS) the document on the C-drive. I want to avoid the browser and fooling around with a FIle menu and do someting...

Does anyone have a code snippet or a reference I could peruse to learn how to automatically download a file from a web site? We'd like to provide a list of documents (MS Word) on our web site for people to download if they need a sample form, document or whatever. We don't want to package these...

Alex, Thank you for this reference. It does not apply here, as the data I'm displaying are pre-defined within memo-type fields in a table, and not subject to modification by users. The data/memos are actually summaries of different requirements of the US regulations on privacy of medical...

Charity- Makes good sense in a fixed-pitch font world. But a given size box will accommodate a lot more "i"s than "w"s when you use a proportional font like Arial. Still hoping for a property of some sort that's obviously NOT well documented! Thanks anyway! Jim [This message has been edited...

I have a form with a text box whose recordsource is a memo-type field. I have a buch of stuff on the form that precludes a significant part of the form being "taken over" by this field. I have sized the field to accommodate probably 90% of the records, but a few of them overflow the field. A...

Doc_Man, I'm continuing to research this. I found the source of the Access 2K - to- Access 2K incompatibilities - I had been fooling around with the "Rich Text Format Control" from Micro$oft but quickly found that while it works on forms, it just doesn't print. (Another gotcha from Redmond!) So...

js- Thanks for the advice. I have not looked at the MS wizard in the ODE. FYI I also posted this in the "General" forum and had a couple of responses. Thanks again. Jim [This message has been edited by jimbrooking (edited 09-19-2001).]

I'm hoping someone can point me to a solution to the maddening problem of "fluid" References. I have developed a database my Non-Profit organization intends to market. I have developed it in the Access 2000 component of Office 2000 Developer's Edition. I installed Office 2K "custom", adding...

If I understand your query to mean changing the Microsoft error messages (for shame - if they were not perfect they would not be in Access!) then you could do something like ... On Error Resume Next Execute statement generating potential errors If Err.Number <> 0 Then Msgbox "Your own custom...

I'm using the label-as-button technique successfully, but be aware that if your form view is "continuous forms" and you have one of these label-buttons on each line, clicking the button does NOT make the row containing the label you click the current row. For example, if you wanted to have a...

An additional helpful(?) hint to reduce typing: Private Sub Form_Current() Me.cmdCables.Visible = (Me.StockCategory = "Cables") End Sub

MG: You might try this: -set the form's allowedits property to false - in the combo box's "On GotFocus" event set allowedits to True - when the combo box's "On LostFocus" event set allowedits to False To allow yourself to edit the form's data you'll have to do something to change the form's...

Martix, I don't think Access has an autocorrect like Word. The only thing I could suggest is to run the spell checker before saving the data. For example, you could put the following in the form's BeforeUpdate event: DoCmd.RunCommand acCmdSpelling to run the spell checker before the data is...

CAS, For what it's worth, I've played around with using other controls instead of command buttons, in part because the command buttons are so boringly GREY. If all you want to do is execute some code when it's clicked, a text box or label works. (More about images later.) Either will let you...

Helen, Good for you for trying something this ambitious. I started this way around 6 years ago, and am definitely still learning after writing a dozen or more fairly complex DBs. If you would zip your database up and email it to me I'll massage it a bit and send it back. (Outlook 2000 Sr-2...

Hi ModeX This is indeed annoying. I found your inquiry when searching for a solution to the same problem on one of my forms. I found the answer on the MS Support site. On the form exhibiting the problem, look in the Properties window's "Other" tab, and at the bottom of the list you'll see...