|
Clear Form
I am using this code at the end of my routine that once all data has been
updated in the table it then clears all values from the TextBox's or Combo's
on the form.
My problem is that I keep getting this error message on the following code
and dont know why or how to get around it
Me.PersonalID.Value = ""
Me.txtForename.Value = ""
Me.txtSurname.Value = ""
Me.txtAddress1.Value = ""
Er...
|
4 |
11/14/2008 1:01:39 PM |
|
|
transparent background on tab control doesn't work on Access 2003
I have Access 2003 running under 2003 sbs on one of my workstations, and XP
running on the other. On the 2003 system, the version is:(11.5614.5606), on
the XP system, the version is:(11.8166.8221) SP3. I have designed a system
with Access that uses tab controls. I set the background property on the tab
control to "transparent" so that the color of the underlying form will show
through...
|
2 |
11/14/2008 6:48:54 AM |
|
|
Auto populate Dates in Access Forms based on a yes or no statement
Is there a way to autopopulate a date based on a yes or no selection?
I am practicing building a databse and building a video rental store..
I want to place a "due date" based on if it is a new-relase or a non
new-release.
so if the customer rents a "new release" I want the due date to be =Date()+2
but if is a old movie =Date()+3 or more..
Is there a way to do this??
...
|
5 |
11/14/2008 4:42:57 AM |
|
|
open db without access
Hi All,
Is there a way for any user to open a db without MS Access installed? I want
to distribute my db (.MDE) to other users but they don't have MS Access
installed on their PC.
Any suggestions?
Thanks,
Tracktraining
--
Learning ...
|
3 |
11/14/2008 1:57:24 AM |
|
|
Default value on form coming from another table
i would like to have the default value for my Inspector field on my
InspectionForm form come from my CompanyInfo table from a field called
Definsp. Since this table only has 1 record, can i get this value and pass it
on to the form control as a default value?...
|
4 |
11/13/2008 10:54:10 PM |
|
|
order - backend or 2002-2003 convert
Hi All,
I was wondering which one is better: creating the backend (Database
splitter) then convert to 2002-2003 (for MDE) or should I convert first then
Database splitter?
This is what I am thinking:
1. original DB
2. make a copy of the original DB
3. database splitter of the copy
4. in the copy - set up startup then convert to 2002-2003 format
5. make MDE
is that the order...
|
3 |
11/13/2008 10:26:12 PM |
|
|
Form & subform Validation issue on Send Email button click
Hi All,
I am trying to figure a way to validate data before it is sent in a report
form. I currently can validate the main form easily using the following Code
that I got from Dirk Goldgar:
<Code Snippet Begin>
Function fncRequiredFieldsMissing(frm As Form) As Boolean
Dim ctl As Access.Control
Dim strErrCtlName As String
Dim strErrorMessage As String
Dim lngErrCtlTabI...
|
1 |
11/13/2008 9:22:27 PM |
|
|
treeview help needed
Hello. I have a main form that has a treeview (parent and child) on it and a
tab control with subforms and textboxes. The treeview control works and
displays just what is needed. But, I am lost as to how to make a record
appear on the tab control when a child in the treeview is selected. I have
used a combobox or listbox after update event in the past to have the
selected record info...
|
2 |
11/13/2008 7:44:14 PM |
|
|
DoCmd.TransferDatabase
Hi,
Hi holey.. excuse me.
My question is :
I want to import file type .DBF by using VBA code. Can any body show me
some examples?
Thanks,
...
|
13 |
11/13/2008 6:23:10 PM |
|
|
Cascading Combo Box - find record in query based on
HELP! I have been getting lost in the forum - trying all the different ways
to create two cascading combo boxes in the header of my form that also find a
record in the details of my form depending on the results of the two
choices-I think I have the various ways all-mixed-up.
I want the first Combo box [ComboStatus] to filter out the choices of
various types of contracts/contract prosp...
|
1 |
11/13/2008 5:17:04 PM |
|
|
open form help
I have a command button on a form that I am trying to use to open a blank
form based upon clientid. When I test the form and use the command button it
brings up all the notes for all clients.
Private Sub cmdAddContactNote_Click()
' This code adds a new contact note based on client id.
On Error GoTo Err_cmdAddContactNote_Click
Dim strDocName As String
strDocName = "frmcontac...
|
2 |
11/13/2008 5:00:55 PM |
|
|
queries
Hi All,
can queries be hidden from the end users?
Thanks,
Tracktraining
--
Learning ...
|
9 |
11/13/2008 4:49:02 PM |
|
|
Losing last Record of record set
I've created a form that transfers a report into a Word Document Table.
Program working well, except that for whatever reason, the last line of data
in the record set is not showing up in the table. Below is the code, what am
I missing? Why am I losing the last line of data?
Thanx!
RHM
Private Sub cmdCreateCDRLReport_Click()
Dim aWordApp As Word.Application
Dim aRange As Word.Range...
|
3 |
11/13/2008 4:21:36 PM |
|
|
Mailmerge to Word via Access Query
Hello All,
Im after some help in regarding my mail merge, ever since ive split my
database into front end and back end, my mail merge has started to
play out,
the mail merge is based on a query which filters certain results.
So When i open my word document, and because my database has had to be
renamed i have to reselect the data source,
The Query is in the front end, When i select ...
|
1 |
11/13/2008 12:30:20 PM |
|
|
Open New Form with Previous Form Data
I have an input form which the user will input all1st records. I then have a
second from which I want to input any other records on that patient number.
When the 1st form is written to the DB I also write to another table (visits)
so that it can be seen on form 2. How can I put a command button on form1 and
when clicked it will show all records for that patient, I will then click
another co...
|
2 |
11/13/2008 11:55:06 AM |
|
|
Automation by not storing calulated variables
Hi
After some investigation it seems best practice not to store calulated
variables, and I
can't seem to do it either, but rather to recalculate them. This however is
posing a little
frusting dilemma for me.
I have a single form(Vesselcapturing) which reads and displays data from a
table(tblTFCMASTER)to the end user fot editing. If the user edits/updates a
record I need to
be aware...
|
6 |
11/13/2008 8:35:56 AM |
|
|
Sort listbox contents based on individual column ?
I'd like to be able to sort the contents of a listbox by clicking on a column
heading. Is this possible? Thanks....
|
2 |
11/13/2008 4:14:08 AM |
|
|
Showing screenshots in a DB
Dear group,
How do I make a set of screenshots available in my DB?
I would like to take a set of screenshots that show how to use some
merge documents that use info in my DB.
In order to use the merge the computer must be configured to use DDE.
I would like to have a form that shows how to change the options in word.
Sincerely,
Shimon...
|
5 |
11/13/2008 1:47:01 AM |
|
|
HOW to Programmatically> Query of 2 tables Output to Form ?
Hi,
1. Like to find out how do I compare login name with value from table 1,
results search lists in table to
in query criteria ?
2. Eg: Leave Application> Supervisor Login> Display Lists of Names FROM
Personnel_Table (ONLY) Where Dept= '" & LoginID!Dept & "'" & " AND
AccessRights > '" & LoginIDAccessRights'" FROM PendingLeave_Table [PS:
Higher Authority = Lower...
|
1 |
11/13/2008 1:30:20 AM |
|
|
Total on subfrom to mainform
I've done this before, but it's not working on the main form. I keep getting
#Name?
The MainForm and Subform are not linked, would that make a difference?
I have a Datasheet subform inbedded in a Mainform so I can have room for
command buttons to open reports.
I place an unbound box in the footer of the subform to total project costs
and placed another on the mainform to show it.
Subf...
|
3 |
11/13/2008 1:19:08 AM |
|
|
Continue sequence from highest number in field
I have the code shown below on a button on a form that appends records to the
Observations table. It gets the CatalogID from a selection in one listbox,
and a Doc_Number from looping through a multiselect listbox.
It works fine only if there are no existing records with the same CatalogID.
The table has a CatalogID field and an ObservationID2 field. This is used to
create an "index" nu...
|
2 |
11/13/2008 1:02:06 AM |
|
|
Problem with Junction Table in AddNew?
(originally posted to wrong group - am reposting - sorry). I have a main
form with a subform within a subform that when the user clicks on a button,
it will add a
new record to another subform (with a subform inside that)
I thought the best bet would be just to ignore those second subforms for now
and get the one subform (well, table) to update to make sure that I actually
get it rig...
|
1 |
11/12/2008 11:15:02 PM |
|
|
Prevent DownKey
I have an ActiveX SplitBar control on my form that works great. It has a
quirk that happens if the user presses the DownArrow key after resizing the
splitbar (i.e., it has the focus). So I want to prevent it, or redirect the
focus.
I tried setting the focus after the OnChange and DownKey events but the
focus did not move.
Ideally I would like to move the focus a subform (the splitbar...
|
3 |
11/12/2008 11:09:01 PM |
|
|
Keeping SubSubform on New entry
I have rather complicated form-structure and want to accomplish rather
cumbersome action, but maybe it would look as fisible task to the forum
experts .
I have ParentForm with unbound cboSelectClient. On it there are:
Subform1 (AccountsList) - datasheet list of client's accounts (each record
has a few controls with account-related data, one of wich is AccountNumber)
Subform2 (AccountPor...
|
11 |
11/12/2008 9:22:07 PM |
|
|
VB Coding for using a second query in my Form
I work for a manufacturing company which produces hollow metal doors and
frames. At their request, I created a database to access door and frame
cuts, we call these documents Preps.
I have created the database and search program with the invaluable help of
the Discussion Groups. Up to this point, I have receive an answer on all my
questions by reading the questions and comments posted...
|
2 |
11/12/2008 8:45:24 PM |