|
Data Entry Solution?
I am trying to find a method that will take one field entered in a form for a
table that will "auto" fill (or pass) that data for all data sets. For
example, instead of entering the DATE for each set, the user would enter the
date into the form and it would be "repeated" for all the other subsequent
sets for that particular date. Not sure if forms and subforms work best or
if there is ...
|
3 |
12.09.2006 13:11:02 |
|
|
Refresh Form
I have an Access adp project with one main form with 2 subforms attached to
it. From this form, I call a number of pop up style forms to add data since
I can't add the records to a linked subform. However, when I come back to
the main form, I must select Record-Refresh before the new records are
displayed. I have tried a number of combinations for Refresh and Requery to
do this programmati...
|
2 |
12.09.2006 13:11:47 |
|
|
Heads up - Spurious "You cancelled" message
Execution of a DLookup function on a form produced this error message:
Runtime error 2001:
You cancelled the previous operation
HUH? I racked my brain over this, but finally executing the DLookup in the
immediate window of the debugger provided the answer: I had misspelled the
name of the field being looked up! How's that for informative run-time
messaging? It happens in both A2K and 20...
|
14 |
12.09.2006 12:53:02 |
|
|
listing open forms and reports
Hi Friend's,
I have an access database project with SQL backend. Most of which is
completed. I wanted to add a navigaton bar which would list all open forms
and reports. Clicking item on this list would make the concerned form or
report active.
I dont know whether this is possible, but would certainly appreciate any
response if reference is available for what i need.
Thanks in advan...
|
3 |
12.09.2006 12:45:48 |
|
|
Need HTML/Access Coding Guru for Question
Hello Guys,
We are in development of building our software as a VBA Module in MSAccess.
We would like to have a Web Version of our software using the programming we
have now (800 pages) based off of MSAccess and VBA, (I guess?)
I need to know what it take to create a web interface that interacts with
our software?
Basically I would like to create a web verison of my software.
...
|
5 |
12.09.2006 12:36:02 |
|
|
Simple SQL Statement
Hi,
I am using simple SQL statement :
Set Rs = Db.OpenRecordset("SELECT DetailPicknote.DTime,
DetailPicknote.DDate, DetailPicknote.DetailID FROM DetailPicknote WHERE
DetailPicknote.DetailID = x")
where x = double
Error: Too few parameters : Expected 1...
|
4 |
12.09.2006 11:52:01 |
|
|
Error in code
can anyone know why this doesnt work??
"FROM tbl_Tax_periods INNER JOIN tbl_Options_periods ON (tbl_Tax_periods.
TAX_PERIOD_ID = tbl_Options_periods.OPTION_TAX_PERIOD_ID) AND
(tbl_Tax_periods.TAX_PERIOD_ID = tbl_Options_periods.OPTION_TAX_PERIOD_ID)
AND (tbl_Tax_periods.TAX_PERIOD_ID = tbl_Options_periods.OPTION_TAX_PERIOD_ID)
AND (tbl_Tax_periods.TAX_PERIOD_ID = tbl_Options_periods.OPTION_...
|
2 |
12.09.2006 11:49:02 |
|
|
insert text into a word document
Hi!
I'm have a way to make a merge with Word document to a table's records.
However I need to have the possibility of inserting some text to that word
document.
How can I do it in run-time?
Sometimes I don't have to make a new document for each record of the table.
There's some group of records that have to be in a same document, and I
thought to try insert those records in the same ...
|
3 |
12.09.2006 11:47:01 |
|
|
update rows in dbase4 file from access tables+vba
hello.
i want to update some rows in dbase4 file which is location in 'c:\final
directory'. the name of dbase4 file is 'data_final.dbf'.
well i tried to link this file to ms access but cant, as the length of
filename.
however the data_final.dbf contains sum of the data based in ms access tables.
i am trying to do this in vba. can anyone tel me how to link to / make a
connection to dbase ...
|
2 |
12.09.2006 10:31:57 |
|
|
Retrieving data from Access Table
Good morning internet community,
I am using Access 2000, and I am trying to do something that shouldnt
be as hard as it's appearing. I have data entry boxes to input data and
store into access tables. Then on a separate tab I have a subform that
I wish to display the data (view only). I have a search box for a 6
digit number, and when I click the button, I want it to do an SQL query
to sel...
|
4 |
12.09.2006 10:08:08 |
|
|
how to identify if last record?
Good Day!
i need a little help. i want to identify that the record that i am viewing
on my form is the last record. i maybe not had enough joe this morning, but
i cannot get this. any thoughts? any help is much appreciated.
~K
--
KMJ >!
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1
...
|
6 |
12.09.2006 09:50:09 |
|
|
Tab Control: Moving To The Next Tab
Hello,
I have a db form in MS-Access 97-2000.
The form has three (3) tabs on it. Each tab has 5 - 12 fields.
I can tab to each field. When I get to the last field, I want to tab to the
next tab control.
I downloaded an example (CurrentTab) from Microsoft (MS), but it did not
show me what I needed to know.
The form (example) MS provided, uses a button to get to the next tab. I do
not wan...
|
6 |
12.09.2006 09:37:22 |
|
|
correct way to round up an integer after division
I am not sure if there is a VBA function to simplify this.
What is a good way to correctly round up to the nearest whole number
after dividing?
for example 135 / 10 = 13.5
for this result, 14 is the desired value for a SELECT TOP
another example 133 / 10 = 13.3
for this result, 14 still is the desired value for the SELECT TOP
query.
Regards,
Charles...
|
3 |
12.09.2006 09:07:48 |
|
|
Call function from a form
I have a public function in a form: Public Function DeleteNewRecord()
I'm trying to call that function from another form and I keep getting the
error message: "There is an invalid use of ! or .(dot) or invalid parenthesis.
Private Sub CancelNewRecord_Click()
DoCmd.Close
DoCmd.OpenForm "NewPartInputfrm", , , , acFormEdit
DoCmd.GoToRecord , , acLast
Forms![NewPartInputfrm]![Model#] = "t...
|
7 |
12.09.2006 08:58:10 |
|
|
Tap into Exchange data source
My boss would like me to write some code to analyze usage of our Exchange
Server. I found the Exchange link in the Get External Data popup, but that
only lets me link to my mailbox.
Does anyone know how to tap into the Exchange Server data store so that I
can get more detailed information about our Exchange Server usage?
...
|
6 |
12.09.2006 05:57:24 |
|
|
Open current record in from list view subform
Here's what I've got, a 'call management' type database which has a
main form with the users information in it, then a sub form in list
view of all their service calls. We want to be able to double click on
the call number (ID ) and have it open that record in a separate form
in form view. I setup the 'on doubleclick' action to run a macro which
opens the form with the criteria:
[Workorder...
|
1 |
12.09.2006 05:43:23 |
|
|
total amt in subform
Hello. I have a subform that is the many to the main forms one. One field
on the subform in the footer is a textbox that provides a total of a field in
the subform. This works fine. What I am doing now is adding another field
to the subform footer to provide a total of the same field but only if a
combobox in the subform has a specific value in it. Now, I am confused and
seek assis...
|
3 |
12.09.2006 05:21:08 |
|
|
Current event not working in continuous subform
I have a subform (Access XP) that is a continuous form. When a user selects
a record in this subform, I want to check the value of several of the
controls and enable or disable several of the controls on the parent form.
I thought I would put this code in the forms Current Event, but it does not
appear to be firing when I select a record using the record selector or by
clicking in one o...
|
4 |
12.09.2006 02:09:21 |
|
|
DoCmd.SetWarnings
I use the DoCmd.SetWarnings False before running append and update queries
to suspend the warning messages that the user sees followed by
DoCmd.SetWarnings True to resume the screen messages. This also suspends
the duplicate record error message, which is useful to know. Is there a way
to trap all of these messages while SetWarnings False is active and write
them to a MessageLog table ...
|
1 |
12.09.2006 01:12:12 |
|
|
How to Specify Output Directory for Macro ?
In Access 2003, we have come to a situation where we need to specify an
output directory for macros which generate Excel files.
Right now, we are running the macros in VB code as below:
DoCmd.RunMacro "GenerateExcelSheet"
If we have the output directory string in a variable, strPath, and strPath =
say "d:\ExcelFile\", is there a way to have the macro generate the
spreadsheet in th...
|
3 |
12.09.2006 00:38:36 |
|
|
text box/list box font weight issue
I have a listbox and when it is set to enabled = false, I would like to have
the text in the listbox be greyed out as well. Currerntly this does not
happen for a list box as it does for text box, combo boxes etc... When you
disable a listbox, the text in the listbox remains normal or bold - whatever
it was set to - just the background changes to a "gray" colour.
So, in light of that, I ...
|
3 |
11.09.2006 22:17:30 |
|
|
Not in fieldlist
I have a combo box on a form based on a query. After using the Expression
builder an equal sign is automatically inserted in front of the field
identifier, eg tblSample.PersonnelID suddenly becomes
=[tblSample].[PersonnelID] after closing the Properties box. This means that
the combo box no longer displays the name. By removing the = from the field
itself then save, it works fine. I hav...
|
9 |
11.09.2006 22:09:02 |
|
|
listing open forms and reports
Hi Friend's,
I have an access database project with SQL backend. Most of which is
completed. I wanted to add a navigaton bar which would list all open forms
and reports. Clicking item on this list would make the concerned form or
report active.
I dont know whether this is possible, but would certainly appreciate any
response if reference is available for what i need.
Thanks in advan...
|
1 |
11.09.2006 21:39:31 |
|
|
form allocating a value to a number field
i have a field ona form which is to accept a currency vale, however when a
new record is created instead of a null value access is defaulting a value of
£16,777,215.00 each and every time. the value can be changed but it is still
a nuisance.
any help appreciated.
i have checked the default value on both the table and the form and none has
been set.
thanks
richard...
|
3 |
11.09.2006 17:21:03 |
|
|
Updating txt box
On a form there is a combo box. In that there are table names. Once the
user selects the table they want, a BASIC instruction executes on the
AfterUpdate command. Here a query is generated from the corresponding table
selected. This query holds about 3000 records, corresponding to data taken
from sensors.
From that query, a totals query runs selecting the Min, Max and Avg for one
...
|
5 |
11.09.2006 17:07:03 |