|
Reproduce F9 behaviour exactly
Hi,
We have a snapshop of data coming from SQL Server 2000 (linked tables) which
is shown as continuous records in a subform in Access 2003.
When a user views a record we update a tick box on that subform (via a
stored procedure becuase as it is a snapshot view) to show that it has been
viewed.
There are three ways that we know of making the tick visible after it has
been update...
|
8 |
25.08.2006 18:27:52 |
|
|
Date format and Trim function errors
I have an application which uses Format functions in text boxes on forms. It
is used by approximately 90 users at this location, but users at another
location see the "#Name?" error rather than the data in the textbox. We are
on the same version of MSOffice, MSAccess and Windows XP.
In some instances, the format function is entered in the properties box
under Default Value - "Format(Now...
|
3 |
27.08.2006 12:14:01 |
|
|
ODBC timeout error
Hi,
when I use the below query in the query window it works fine. But when
i try to run the same in a module it gives me a ODBC timeout error, can
somebody help me how to get rid of the ODBC timeout error for the below
code.
DoCmd.RunSQL "SELECT dbo_property_value_bpo.loan_num,
dbo_property_value_bpo.prop_id, dbo_bpo.order_type,
dbo_property_value_bpo.prop_value_id, 'Assigned' AS Type,...
|
1 |
27.08.2006 07:04:59 |
|
|
where do i get to learn more access programing
where do i get to learn more access programing...
|
2 |
27.08.2006 04:04:54 |
|
|
digital signature access 2002
How do I get a digital signature in an Access 2002 mdb. I do not have
anything under tools, like in Access 2003. ...
|
2 |
26.08.2006 20:33:49 |
|
|
Input specification for docmd.transfertotext in an ADP?
I am trying to set up an Input Specification so I can do a
docmd.TransferToText and list the spec to pull a text file into a table at
run time. When I do the initial import and do the spec layout, it all works
the first time, but the Save command is always disabled. I am using an ADP,
not an MDB. Is this a problem?
Thanks,
Steve...
|
1 |
26.08.2006 17:39:01 |
|
|
how do i replace a MSysDb object?
I get this message when i try to open my database, their was a problem and it
shut down wrong, now i get this error message...
|
2 |
26.08.2006 16:51:24 |
|
|
Get information to a form from another table
Hello,
I have two tables.
Order Entry and Invoice
I have a checkbox on both forms called Invoiced.
This checkbox is checked by default in the Invoice Entry form.
What I need is for the Order Entry form to read the Invoiced field in the
Invoice Table where [Order Entry].[Order Number] = Invoice.JobNumber
If the check is checked (yes) in the Invoice table, then it should be
che...
|
22 |
26.08.2006 15:48:59 |
|
|
Using SendObject
I'm using this
DoCmd.SendObject , , , "myemail@dot.com", , , "subject line of email", "text
in email"
to send an email via outlook express. I'd like to loop it to send several
emails. If I do the first mail will open up BUT wait for me to send/close it
before opening the next. If there're 5 items in the loop can I open up 5
emails at one time?
Jesper
...
|
5 |
26.08.2006 12:48:55 |
|
|
AllowByPassKeys
I know how to set AllowByPassKeys in the current mdb file.
Because of political battles, I am not allowed to use Access Security, so my
question is, is it possible to set this property in another mdb (my back
end), and if so, How?...
|
7 |
26.08.2006 12:39:01 |
|
|
How do I refer to a general module?
I have code that I need to run when the database starts up. I created a
general module called relink_at_startup with the code in it in a function
called relink_text_files, and I am trying to run it from an autoexec macro.
The macro is the runcode action with relink_at_startup.relink_text_files as
the parameter.
When I try to run the macro, I get the following error: "Purchase
Requ...
|
6 |
26.08.2006 11:54:01 |
|
|
Open form using vba
I have a table full of names and address. I have a search form with a text
box for data I enter and a combo box that lists the fields of the table. I
want to search the selected field of the combo box for the data I enter in
the text box. For example I type a last name and then select last name in
the combo box. I want the on click event to open up a form "search results"
showing the...
|
7 |
26.08.2006 11:52:36 |
|
|
Automatically close Front End if User has not done anything for 10
Hi Guys
I have a split FE and BE applicaiton and want to automatically close the FE
is the user has not done anything for 10 minutes. This will ensure that if
they go away and leave there desk for an extended perikod of time or leave
their office without closing the applicatikon then the application will do ut
for them.
Is there an easy way to do this?
Thanks
Regards
Greg...
|
3 |
26.08.2006 04:21:02 |
|
|
Can we remove the Close button of Access?
I have a button on my switchboard that allows the user to quit the
application, and I want to remove the application close button on Access so
that the quit button on the main swichboard can check several conditions
before closing the entire database. Is there a way to either remove the
button or run a before quit sub similar to a Form_BeforeClose sub?...
|
2 |
25.08.2006 23:41:13 |
|
|
How to make checkboxes checked by default in MS Access 97
Hi i have several checkboxes on my MS Access 97 forms in order to
monitor if an item is required. By Default all items should be checked
(required) and later if some of them are not required then i can
uncheck them.Could someone help me please how to make checkboxes
checked by default in MS Access 97 (in the table for preference).
...
|
12 |
25.08.2006 22:51:09 |
|
|
Complex Query
I am trying to model a form and add some calculations from a spreadsheet,
when a record is updated the record needs to carry out a series of
calculations
here is an example of the spreadsheet formula
=ACOS(COS(Z15-Z14)-SIN(Z14)*SIN(Z15)*(1-COS(AA15-AA14)))
To try and make things easy I have named the fields on the form the same as
the columns ie A to AD, but as you can see the formu...
|
4 |
25.08.2006 22:50:22 |
|
|
Looping An SQL Statement
For a timesheet application, I am using un-normalized Timesheet and Timesheet
Detail tables on a form that shows 2 weeks of data in a grid format. This is
done to simplify the data entry. Rather than forcing the user to enter a
projectnumber, date, and hours, each row represents a given project, and the
user can cursor to one of 14 columns (DayHours1, DayHours2, etc.)and enter
the hour...
|
7 |
25.08.2006 21:06:02 |
|
|
/Runtime Switch seems easy to disable.
Hi;
Have been reading about "How to distribute a secured database", (Article ID
205151 for A2K)
It states: "Specify the /runtime switch on all command lines that you use to
start the application"
Found this example at http://www.kbalertz.com
C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Program
Files\Microsoft Office\Office\Samples\Northwind.mdb" /runtime
It seems...
|
4 |
25.08.2006 19:04:29 |
|
|
selecting date
After clicking a button on an Access form, I want the vb code to prompt the
user for a date using one of the available calendar functions. Any ideas?...
|
4 |
25.08.2006 18:29:50 |
|
|
Make formula based on other formula blank
Is there a way to make a value in a text box, that is based on another text
box, blank and not always say "#error" ? I tried using an IIF statement but
it didn't work. I'm sure people run into these all the time. Thanks
txtbox1:
txtbox2:=DateSerial(year[txtbox1]....
When opening form... txtbox2 displays..."#error"
...
|
4 |
25.08.2006 17:43:03 |
|
|
self destruct??????
The AgencyRemits.MDB works just fine untill it reaches about 400,000 bytes
then it starts acting goofy. We see it in the Salesmeothed table. When you
make a change the change wont take or different fields are changed.??? The
field "Changeby" is suppost to hold your name when you change anything on the
form. I puts a null in the field and the "ChangeByDate" field gives a random
date....
|
2 |
25.08.2006 16:33:01 |
|
|
Interesting query trick...expandable to a crosstab?
I have a table with 3 fields - Name, Value, Month
After reading something about a Union query, I created the following select
query:
SELECT tblData.Name, Sum(tblData.Value) as Total
FROM tblData
GROUP BY tblData.Name
ORDER BY tblData.Name ASC
UNION ALL SELECT "Grand Total:", Sum(tblData.Value) as Total
FROM tblData;
What is interesting is that the last record becomes one with 'Gran...
|
6 |
25.08.2006 13:12:02 |
|
|
Finding a table
Does any one know of a tool that will let me find witch MDB use a table
"REMITS"?
I have a list have about 60 .MDB programs. I need to find witch one's use
the "REMITS" table. Beside opeing each one and look in "Tables", I am
looking for a faster way.
Scott Burke...
|
3 |
25.08.2006 13:08:02 |
|
|
Additional information
There were only 224 records selected to change out of 13,116.
--
M. Shipp...
|
1 |
25.08.2006 13:02:02 |
|
|
If - Then
I have a FORM that has a YES/NO checkbox for prompt LEIN. If the box is
checked I need the section for lein information to be visible. Likewise, the
opposite to occur if the box is not checked. I have four fields in the lein
section that need to be (in)visible according to the checkbox.
I looked up in the help section under "PROGRAM > Example of setting the
value of a property in ...
|
2 |
25.08.2006 11:40:28 |