|
Incremental Record Numbering when appending Batches of Records
I am wondering if there is a place I can put code to create an incremental
number system directly into the table or appending query (not into a data
entry form) when appending batches of records.
I am familiar with expressions to create incremental ID numbers used in data
entry forms such as an Event Procedure (On Current) or a default value in the
ID field control on the form itself.
...
|
1 |
27.09.2006 05:49:02 |
|
|
Can't change the path of a linked table
I create a new database and import the linked tables, when I want to
change the links to the new location it said "THe Microsoft Jet
Engine couldn't find the (tblName).Make sure the object exists and
that you spell its name and the path correctly.
The path of the Old Database is like that P:\MyDatabase\ MyDatabase
Back End\My_Database_ be.mdb and I want to change it to
P:\NewDatabase\ NewDat...
|
1 |
27.09.2006 02:04:10 |
|
|
checking data in a field and then setting focus
I have a form where one field is a combo field. Also on the form is a
subform that has a query that shows all the records related to a customer.
What I need to do is look at one item in particular and if it's INT (for
initial) to run a query against all records related to that customer. If it
finds an INT already existing I need it to go back to that combo filed and
say pick another cho...
|
2 |
27.09.2006 02:03:57 |
|
|
Question re yes/no fields and checkboxes
I want to add the option of yes or no on a form but I want to have two
checkboxes. One for Yes and one for No. Should I use a yes/no field in my
table and then create an option group in my form with a checkbox for yes and
a checkbox for no. I am not sure if the field in the table should be a yes/no
field. For example I would have a question: "Has patient had previous
treatment " and ther...
|
2 |
27.09.2006 00:37:21 |
|
|
Option group triggers tab
I have an option group in a form as well as multi-tabs. Is there any
way to force a certain tab to display based on the selection in the
option group?
I don't know if this is too much wishful thinking or not....final
attempt...
Thanks
...
|
4 |
26.09.2006 22:43:59 |
|
|
Subforms and Datasheet views
I have a subform(A) viewed as a datasheet in the parent form.
I'd like to add a 2nd subform(B) within the subform(A) and show (B)'s
information in the datasheet view. Is this possible?
This is in an effort to solve a larger problem.
The subform(A) is based on a 2-table query and must remain editable.
If I add a 3rd table to the query it locks and is uneditable. (the larger
problem)
One ...
|
1 |
26.09.2006 22:15:03 |
|
|
unique first name and last name
I would like to use a control to check that the first name field and the last
name field on my form are not duplicate in the table. It is a situation
where both have to be duplicate on the same record in my table to error. We
want to be sure that the "new users" who are entered are indeed new. The
field names in the table are First Name and Last Name. On the form they are
first_name ...
|
8 |
26.09.2006 22:08:16 |
|
|
Combo box with "or" in code??
Hi,
I have a form with a combo box that filters another form based on type of
liquid selected. There are two fields that have liquids listed. Is there a
way to add an "or" statement to the following code to return all records that
have selected type of liquid in either field. I need to add the field
[FluidListedBySy].
Code currently used for one field filter is as follows:
Priv...
|
4 |
26.09.2006 21:23:18 |
|
|
Open file
Hi.
I have a continuous subform with records.
For each record the user creates a .doc file (MS Word) and save it in a
certain location (not defined yet).
Is possible to allow the user to double click in the record and the
respective .doc file opens?
Thank you in advance.
Best regards.
Acores...
|
2 |
26.09.2006 21:22:30 |
|
|
Superscript
One of my fields in my database are titles of articles from scientific
journals. Many of the titles contain superscript numbers within the title.
How do I do this without having to make a separate field?
--
S...
|
3 |
26.09.2006 21:22:04 |
|
|
Small textbox width forces rounding.
I have a textbox with a small width that fits only two digits. When I try to
enter 10.5 in the textbox, Access rounds it to 11. Is there a way to prevent
it from rounding automatically, I don't mind that 10.5 be clipped....
|
6 |
26.09.2006 20:49:02 |
|
|
Combo selection
I (still) have a combo with a few columns. The bound column is a date.
Is it possible to code the combo so that all the records are displayed but
only dates >Date() are selectable - maybe some form form of OnClick exclusion
Driving me mad
I can't simply run the combo from a query with >Date() as the criteria as
this would remove all the items from the combo that were from befo...
|
3 |
26.09.2006 20:39:02 |
|
|
combo box
I have a form 'Home Dept' that opens from autoexec that has a combo box bound
to a table column called 'HomeDeptID' that has 2 choices Sales or Purchasing.
I want the combo box to open and filter a form that uses the ID from these
choices to limit the records shown to the homedeptID.
The form is called QCPC and has a text box that is called HomeDeptID in it.
I have read many threads a...
|
3 |
26.09.2006 19:38:55 |
|
|
Datasheet Form Design
This one is stumping me.
I have a form that is used to process errors in orders. The first form is
the customer information and it has a subform to take down the specifics of
the error. I have the subform setup to be viewed as a datasheet that can be
used to enter data. The first field in the datasheet is the product code,
followed by description and then other data that is entered i...
|
1 |
26.09.2006 19:38:02 |
|
|
Checkbox to signify what to search for
I am attempting to create a form that will be used to launch a search in a
table in access. Here is where I am stumped...
1) How do you make a form look at anything checked or selected in a
combo/list box and search the table for any records that match all of the
information specified?
2)If, let's say, 4 out of the 5 fields need to be searched, how do I tell it
not to search for inf...
|
1 |
26.09.2006 17:57:02 |
|
|
Insert a control in a tab control
Hi. How can I insert a control inside a tab control. I insert a tab contril
in my form. The tab control has two tabs, in one tab I want to place a
subform, how can I do it?
Regards,
Marco....
|
3 |
26.09.2006 17:23:01 |
|
|
subform does not update after chosing date in main form
I have a form that has a combo box with date in it. Based on the date chosen
in the combo box I want the subform to display the data for that date. The
parent/child fields are linked by the date. When you first open the form the
first date in the combo box displays and the data in the subform is correct.
When you change the date the data does not update. What did I miss?
Thanks...
|
1 |
26.09.2006 15:36:02 |
|
|
Color on Forms
I got a requst for the colors to change on a form if a certain check box is
checked. So I have two check boxes. I have a domestic check box and a
International check box. When someone checks the domestic check box I want
the background of the form to change white and if someone checks the
International check box I want the background of the form to turn blue. Can
this be done?...
|
3 |
26.09.2006 15:31:21 |
|
|
Refresh form data
Hello All
I have a main form called [frm x main], on which there is a subform (in
datasheet view) called [qry x main table subform].
After entering data into [qry x main table subform] the user clicks a button
on [frm x main] to run various queries.
The queries use the data entered via [qry x main table subform].
The problem is that data entered/amended in the last (final) record in [qry
x ...
|
3 |
26.09.2006 15:29:52 |
|
|
OutputTo excel gets Run-Time error 2282 in Access 2000
Hello
I have a command button to export a forms data to an excel
spreadsheet. Works fine in Access 2002. Here's the code.
DoCmd.OutputTo acOutputForm, "frmFormName", acSpreadsheetTypeExcel9,
CurrentProject.path & "\" & "SpreadSheetName.xls", True
But in Access 2000, I get a Run-Time error 2282 (formats are missing
from the Windows Registry). I could use the TransferSpreadsheet
...
|
1 |
26.09.2006 15:25:21 |
|
|
Bookmark not Valid
Hi there
I'm trying to enter a records into a form on an Access 2000 database and
every now and then it comes up with a message that says: "Bookmark not
Valid". Its only just started doing it - up to now its been working just
fine
Does anyone have any idea what this means and why I would get it.
Many thanks for any help you're able to give.
David.
...
|
2 |
26.09.2006 15:09:00 |
|
|
I'm Lost Here
Access 2000
First Table:
LogID (AutoNumber) Primary
Auditor (Lookup to Auditor Names)
Date (Date/Time Field)
Round (Number field indicating which round of audits)
Second Table:
LogItemID (AutoNumber) Primary
Stager (Location being audited)
System...
|
3 |
26.09.2006 15:05:58 |
|
|
Simple question
Hello all
When I click the command button icon in the Toolbox and make the size
of my command button it used to pop up a wizard with several option,
like Quit application, Go to the following form, etc. Several option to
choose from. But now when I create a command button the pop up wizard
will not show up. Where is the option I need to change in order to get
back the pop up wizard automat...
|
3 |
26.09.2006 15:00:03 |
|
|
Combo Box Problems
Hi All,
Afraid I am relatively inexperienced with Access, so please excuse the
question if it seems silly.
I have created a from/subform based on 2 tables. The tables are 'customers'
and 'payments'. The main form has a combo box from which you select the
customer code from table customers. This displays unpaid invoices for that
customer from table payments.
When I input the paid ...
|
1 |
26.09.2006 14:50:01 |
|
|
Forms based on multiple tables / queries
I have a table Prospect Tbl that draws input from 3 other tables (using
the Look Up function in the table's design view). Then, I have a query
Prospect Qry that puts this table together with another table New
People that also draws off a few different tables. I want to create a
form that is based on Prospect Qry, but it won't let me update any of
the records. I know you can't have too many la...
|
2 |
26.09.2006 14:29:40 |