Search results for query: *

Hi All, Trying to clean things up in the last few weeks of this job. So I'm a bit... well stressed. I discovered all of these potentially useful date functions that would really help speed up final delivery & blissful departure B-) Just a taste EOMONTH function NETWORKDAYS function Sure I...

Hi, My windows explorer on a Win98 system slows to a crawl. It can take over a min to move to a new directory. It's just explorer. The symptoms snowball after entering a directory w/ about 30-40 (it's at home now) subfolders and 2 to 3 other files. Each subdir has about 10 to 50 files in it...

OK I'm having a bit of brain fade b/c I must be missing the obvious here I'm trying to update a form description based upon totals in the subform header. SumOfQty, SumOfAmt, MinOfFromDate, MaxOfToDate, AvgOfRate in the subform are used to build up a string used in document headers. This built...

Hi all, I've just got word that I'm going to be up to my neck in Linux in about two months time. I need to get up to speed ASAP. 1) I'll have expert help in this... in two months... but I need to know how to do things on my own anyway. 2) I'm not a computer/sysmanager newbie but linux is not...

Hope this is a setting issue... I've just yesterday split my DB into front & back ends with the back end on a shared network folder. Since doing this, the DB has become unbelievably slow! For example: it can take over 15min. (I killed the process) to display a two-page report. I expected...

Sorry about the last post. I forgot the "descriptive title" Hi all, This isn't life or death but it’s annoying me & this kind of thing usually indicates a bad design so... I have a continuous form linked to a multi-table query. All query data are bound to controls in the detail...

Hi all, This isn't life or death but it’s annoying me & this kind of thing usually indicates a bad design so... I have a continuous form linked to a multi-table query. All query data are bound to controls in the detail section. All detail fields are disabled - this form just shows history...

I want to avoid some processing if a report is opened in preview mode. Is there an equivalent to: IF Me.Report.Mode = acViewPreview THEN...? Documentation has been no help. thanks rafe

Is it possible to NOT have all of the columns in a multi-column listbox left justified? everything appears as... John Doe |$20.00 Jane Smith |$4000.00 I would like... John Doe | $20.00 Jane Smith |$4000.00 can it be done? thanks

Is it possible to NOT have all of the columns in a multi-column listbox left justified? everything appears as... John Doe |$20.00 Jane Smith |$4000.00 I would like... John Doe | $20.00 Jane Smith |$4000.00 can it be done? thanks

I'm trying to create a updatable field in a query "on the fly." Something that I can change in a form & the data will be unique to each instance of the form (like a yes/no flag) but not actually stored in the underlying table. am i missing the obvious? is this doable? are there...

I've got this limping along but you may know a better way. Senario: I have a continuous form with only one active control in the detail section, a CheckBox to select documents for further processing. Access 2K. Problem: The last record selected via a CheckBox control click is not updated until...

Scenario: I have a “Documents” table linked one-to-many to a “Payments” table. We process documents at the College but the level of accounting is line items on a document (i.e. Payments). I’ve got a “ProcessDocuments” form that does things like print the appropriate document, e-mail’s people...

Hi all, I've got a race(?) condition for recently added records to a table. Basically, when I add or modify a record in a table and then immediately access the updated record the DB doesn't seem send to the form the recent changes. For example, I'm using an auto number field as a primary key...

Hi all, It seems that with Access 2000 all of those activeX controls (other than the ones in Microsoft Forms 2.0) that are distributed with the package don't have any (well, almost none) documentation to go with. Not in Access help, nor at the MS web site, nor in the MSDN library circa July...

Hi all, I have a form with a continuous subform (A2K). I'm trying to goto a particular record in the subform from the main form. The statements I'm using are Me.consEnter.SetFocus DoCmd.GoToRecord acDataForm, Me.consEnter.Form.Name, acGoTo, i the subform control name is "consEnter&quot...

Hi all, I have a form with a continuous subform for line item entry. I check data input in the Form_BeforeUpdate event. Now, I wanted to have a bailout button on the main form that would cancel processing & clear the form & subform. So I .... 1) Created a module with a global boolean...

Hi again, I know how to do most of the following, but I want to ask how do the experts (you) handle this? I’ve run into headaches trying to back-out some of my newbie baby steps (fortunately I’m the user for now) and I’m trying to avoid this in the future. When you are designing a...

I’m trying to print a multi-copy report from a form. These reports replicate certain multi-copy bureaucratic forms on n-part colored cabonless copy paper. You select the forms to print with a multi-select list box. After some checking & processing I try to do the following: Select Case...

Hi All, I’m trying to use the multi-select property on a list box, but… I want to limit the number of selections to seven. I’ve been trying to use the following…. Private Sub IndexAccount_BeforeUpdate(Cancel As Integer) [tab]Static indexAccountSelected(0 To 7) As Long...