I have an application that controls inventory of land for sale. At times we
enter into an agreement to sell a lot but the deal is then cancelled for
whatever good reason. To record this event users now enter in a combo box the
string “Cancelled” to replace the name of the buyer. ...

I have a form with several text boxes and contain text only. Each row of text
boxes is enabled or disabled depending on the related Yes/No check box.
What I want to do is this....
If the user un-checks the y/n box, then (after confirming they want to do

We have 3 treeviews on a tab of a TabControl.  When we update the Treeview
under certain circumstances (which I have not yet figured out), the 3
treeviews move to position (0,0).
This appears to be a time-dependent problem, because when in the debugger

I have a directory with .jpg files in it. I need to get the name of
each file and then remove some characters from the file name and copy
it as a new filename. I could also rename the original file. Either one
would work.

I have an application in Access 2000 that basically pulls in a user's Excel
spreadsheet, manipulates, filters and sorts the data, and then exports four
new Excel spreadsheets.  Works fine on my stand-alone PC.  
However, the user is running this on a Citrix Winterm.  She starts ...

I have a database that tracks students and the programs that they
participate in.  I have a form(participation) that needs to allow the
users to select the program(from a combo preferrably(yes i have a table
for programs)), time, and date(these must be txt boxes).  I would like

I've created a form that captures a selected email from an Outlook View
Control, copies its sender, subject and body into a memo field; then extracts
attachments to a specified folder.  I have a subform that is meant to hold a
hyperlink to the downloaded attachment, but if there ...

I am trying to SetFocus on a field call 'Reference' when the user clicks Add
New Record.
I have tried
Private Sub Form_Current()

Using Access 2000, is there way of programmatically creating a new tabledef;
based on the field types of an existing table?  I want to create four new
tables in code, all identical in structure to an existing table, but think
there must be an easier way than setting each of the ...

I am using the following code in the forms On Error Event, but I still get a
system generated error and not my message box. Any help is appreciated....
--------------------
Private Sub Form_Error(DataErr As Integer, Response As Integer)

I have a query with Name, ClassNumber, CourseName, RegistrationDate,
WaitlistDate, MovedUpFromWL, MovedDownToWL, and CancelDate.  I'd like to take
the information from the query and arrange it chronologically to see a
student's registration activity in a form.  

I'm needing to create a monthly invoice for several tenants in one building
that will change the date and the amount owed (which will be a formula of the
% of the whole amount) monthly.  

I've a form which uses as its data source a query. I've added a combo box to
the form using the wizrd. On the Combo Box Wizard screen that first comes
up, I chose option 3 - "Find a record on my form based on the value I
selected in my combo box". It works fine except if I type a ...

I hope some one can help i want delete some files when clicking on my exit
button on my form i have the path and file names saved in a table. I know how
to use the kill command when deleting one files but now i have a list of
files which i can get from my table but i have no idea ...

I have a client form where I call via a button a second form showing
personnel at the client's location.  Presently, I link via the client's
location and this works fine.  
However, I have personnel "affiliated" with other personnel and only desire