|
Form can not display search results
I have been working on this for a while, so please excuse my lack of cohesive
thoughts... I will be more than happy to work with anyone who would like to
tackle this issue with me.
Using Access 2000, I am attempting to create a sophisticated search form
that displays its' results in another form. The main issue I have at the
moment is trying to get the data that was selected from a Micr...
|
1 |
31.08.2006 19:43:02 |
|
|
Changing Backcolor of report field at run time
have a large report (+/-300 pp) where the field for each item in the
Group Header is shaded grey.
When the report is generated, I would like to be able to
programmatically change the data item field shading to other colors
based on the text value of another field associated with the data in
the header. There are only 8 different values that are associated with
the Group Header data item, ...
|
2 |
31.08.2006 19:35:01 |
|
|
Hyperlinking within a Table
Hello--
We built a FrontPage 2K3 Web site that includes a form. We used the FP2K3
database feature to create an Access 2K3 single table database connected to
the form. Additionally, we created two .ASP data results pages where we
display data results within the site. One results page displays a brief
summary of the data records, and the other page displays each record in
greater detai...
|
2 |
31.08.2006 19:29:01 |
|
|
Filtering dates problem
I have a table that looks like so -
Contract # | Stage 1 | Stage 2 | Stage 3 | Stage 4| ...............
----------------|-------------|--------------|-------------|------------|
45234255 | 8/8/06 | 8/24/06 | 8/31/06 | 9/7/06 | ................
24256211 | 9/2/06 | 9/14/06 | 9/21/06 | 9/30/06 | ................
Except there about 20 stages. These stages are goal dates basically...
|
6 |
31.08.2006 19:01:04 |
|
|
phone number imput mask
I want to remove the ( ) around the area codes and the dash between the
prefix & number...
|
2 |
31.08.2006 18:56:37 |
|
|
Code works with loaded table but not with empty table
I have some VB code that works fine when my table has records but gives an
error when my table is empty.
The form has a tabbed control which has some subforms.
When I hit the 'create new record' button', the code sets the subform
AllowEdits property to True. When there are no records, the code fails with
"You entered an expression with an invalid reference to the property
Form/Report".
...
|
2 |
31.08.2006 18:54:28 |
|
|
Scroll Bar
I have several List Boxes on some forms I have in an Access 2003 application.
The vertical scroll bar displays fine, however there is no scroll bar along
the bottom. Does anyone have code that I could install to display a scroll
bar along the bottom of my List Boxes?...
|
4 |
31.08.2006 18:49:35 |
|
|
Hiding a 0 value in a SubForm
When I bring up the main form the SubForm displays all the records associated
with the main form. The SubForm displays all the records and "0". Is there a
way to get rid of the 0 from displaying in the subform?...
|
4 |
31.08.2006 16:42:02 |
|
|
Scroll Bar
I have a form with a lot of information on it. Can I make the form scroll my
passing my curser over the borders (east/west) edge of the form instead of
using the scroll bar? If the answer is yes, can you control the speed?...
|
2 |
31.08.2006 16:14:01 |
|
|
my forms are not pulling the data from the table
I have a database that populates certain fields with a yes and Now() for
today's date. I can see where each record is populated correctly in the
table, but when I look at the related form, some records have the data and
some don't. What is really going on?
Rob...
|
2 |
31.08.2006 15:49:12 |
|
|
Re-post: Yet another problem with "no current record"
I posted this in "getting started" almost a week ago, and my experience is
that if it isn't answered in the first day or two, it isn't going to happen.
So I'm hoping I'll get a different audience here - hope that's alright.
I've Googled "groups," and didn't find an answer. Could someone suggest
some things to try, even if you don't have a sure answer? I've made lots of
similar forms, b...
|
6 |
31.08.2006 15:31:36 |
|
|
If statements
Hi,
I have a form with a subform attached to it from the form I run code as below
Public Function CodeVATCal(vatJobCode, vatJobGross)
If vatJobCode Like "CR" Then
CodeVATCal = vatJobGross
Else
CodeVATCal = (vatJobGross / 117.5) * 100
End If
End Function
The works fine however if the recordset of the subform is empty this causes
a runtme error. My question is how can I make the cod...
|
6 |
31.08.2006 15:26:02 |
|
|
Open two reports by clicking one button
Hi
Is it possible to open two reports by only clicking one button?
Thanks
Colin
...
|
3 |
31.08.2006 15:25:35 |
|
|
Phantom code--anyone else experienced this?
Form: single record, single form (no subforms)
Data resides in sql on sbs2003
Form source is a query running against one table
Based on data value in one field, certain fields set to visible = true or
false.
This works perfectly fine.
In testing for some other issues, I commented out that code everywhere it
appears behind that form. Results: some objects are visible when the form
o...
|
6 |
31.08.2006 14:40:03 |
|
|
Password form pop-up based on field info comparison
I am hoping this might be the right place to ask!
I have a form and a subform. The form holds employee information and
contains a field for department (which classifies an employee based on the
department for which they are assigned). The subform contains working hours
and also contains department information. The reason for this is that an
employee may do hours for another department.
...
|
2 |
31.08.2006 14:31:01 |
|
|
Access 2003, SQL, Docmd.findrecord "findrecord not available now"
I am using this in other forms in the same frontend mdb and it works fine.
In one form, however, it does not. I have tried the form's record source as
both the a table and a query.
Anyone found a reason or solution for this? Thanks....
|
6 |
31.08.2006 13:22:02 |
|
|
Show a table on a form
Hi
There's every chance I'm just being silly, but is there anyway I can
show a table on a form?
Thanks
Colin
...
|
3 |
31.08.2006 13:06:41 |
|
|
Renaming a windows folder
I am looking for a method or code to rename folders in windows directly
using VBA or some other method while in Access.
Any help greatly appreciated.
John B
...
|
3 |
31.08.2006 12:24:10 |
|
|
Allow Users to enter hyperlink addresses
I have a database set with user level security and I want to give "Full Data
Users" the ability to enter hyperlink addresses. Currently only I can do
this as I am set to "Full Permissions / Admin"
The associated table is set to accept hyperlinks, and the relevant text
boxes are in place on the forms, however when logged in as a Full Data User,
you currently can not set or add a hyper...
|
2 |
31.08.2006 11:33:01 |
|
|
How Do I Allow Users to Input Paths?
My latest question:
I have a series of buttons that export data to Excel using the
DoCmd.TransferSpreadsheet command. This works fine. However, we want to
allow users to choose which Excel file the export to. I have added a textbox
that allows users to click on, and it opens the acCmdInsertHyperlink dialouge
box that allows the user to input a path.
Then, my program replaces the d...
|
4 |
31.08.2006 11:32:01 |
|
|
Wizard Disabled
Hi
Somehow I've managed to disable the wizards that popup when I create a
Combo box, Form/Subform etc on a form. Does anyone know how to enable
them again?
Thanks
Colin
...
|
3 |
31.08.2006 10:53:35 |
|
|
Error occuring on form
I have a database that is used to store Contractor, Contracts and also the
contracts that have been applied for by the contractors.
i have them all linked together so that when details are put in about
contracts then this information appears on the contractor details also.
what im having problems with is when im trying to type some details in on a
form it says "cannot add record(s); join ...
|
1 |
31.08.2006 09:45:01 |
|
|
Setting recordsource of form with dynamic sql string
Hi,
I have a search function which, one one or two forms needs to be
searchable across subform and/or main form.
I understand i cant just assign a filter to a form (as i have done for
the other forms) as i need to search two tables (courses and
coursemain).
So ive made a sql statement but im not sure how to reference the
subform control in SQL.
If Not IsNull(Me.CPD) Then
s...
|
1 |
31.08.2006 09:28:52 |
|
|
Changing background color by record more than 3 colors
I am trying to change the background color of each field in a record
based on the value of 1 field. There are 12 different status/12
different colors that could be set, conditional formatting only allows
for up to 3 criteria and that would be set per field. The datasheet
view does not really allow for it so I have it set up as a continuous
form for multiple records with each record having abo...
|
5 |
31.08.2006 05:23:21 |
|
|
select
hi,
I have the following, which selects a range of cells across an Excel row:
obj.Sheets("Input").Visible = True
obj.Sheets("Input").Activate
obj.range("a265:m265").select
I need to know how I can simulate pressing the SHIFT, END, DOWN ARROW keys
to select down to the last row of entered data.
Thanks in advance,
geebee
...
|
2 |
31.08.2006 03:10:46 |