I am creating a DB in Access 2003.
Tables: Client - Careworker - Placement
Query: Placement query
The Placement query is link to the 3 tables and keeps records of where
the careworkers are and the no of hours they are with clients!
The careworker visit the clients the same day in each week for the
same no of hours.
Requirement: to automatically have the placement query records updated
for 14 days in advance( ie of today's date)... so data does not have
to keep being retyped !
(I have a yes/no box in Tables/palcement. called[Cover]... which I
would like to use as a clause not ...HR Attendance Transactions
I would like to purge data from the attendance transactions table (TATX1030).
How do you do this within Great Plains?
Have a great day!
You need to do this behind the scenes.
Charles Allen, MVP
"W Sue" wrote:
> I would like to purge data from the attendance transactions table (TATX1030).
> How do you do this within Great Plains?
> Have a great day!
> W Sue
Hmm, "behind the scenes". That tells me so much. Does that mean there are
no relationships to this table I need to worry about and I can freely move or
delete records from...Recording Macro in GP 10 RMA Receiving
I am having a problem when I try to suspend macro that I am creating to Post
a return in RMA Receiving. I start recording the macro by clicking on Post
and then clicking on cancel for the 1st and 2nd reports that GP wants to
print. On the 3rd report I want to specify how many copies to print. I have
tried to suspend and/ or pause the macro but after I chose how many copies
and click OK the window for the next report that wants to print pops us and I
cannot get to the tools menu to resume the macro. Any Ideas what I need to
I have nothing in my mind about this issue bu...Grade [School] template to track grades over terms
Operating System: Mac OS X 10.6 (Snow Leopard)
Is there such a template or can someone tell me how to link grades with numeric values (i.e. A=4.0, A-=3.75, B+= 3.5, B = 3.0, etc. <br>
per term and cum is what I am tracking. Thank you.
On Dec 5, 7:36=A0pm, cswea...@officeformac.com wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: I=
ntel Is there such a template or can someone tell me how to link grades wit=
h numeric values (i.e. A=3D4.0, A-=3D3.75, B+=3D 3.5, B =3D 3.0, etc.
> per term and cum is what I am ...Duplicate Record command
I am using the duplicate record command and it works except for the 2 linked
fields in the form. It fills in all other values and then won't even let you
edit the linked fields so that the record will save. Please help.
...Update Attendance in HR
I need to print the Employee Attendance Summary Report out of HR and the
Hours Used field looks incorrect (prints the same info on the Employee
Attendance Summary window). The amount printing there looks like it has
accumulated over the past couple of years. It is not up to date for this
calendar year. Is there a process that is supposed to be done to clear or
update the attendance in HR?
..."edit multiple records" problems
I have a strange error now. all the fields (in contacts and accounts) that
multiple records" form. I installed the hotfix 913645 to enable "parent
account", It works ok. I am not sure whether this is the reason. Does anyone
know this problem?
Thanks a lot!
...Opening a form to a specific Record based on a field in the form
Hi all, I need some help with some coding.
I have a database that containes about 25,000 records. Right now I have a
form that opens to shows the records, some fields already have information
contained in it. Other fields the users will have to update the form/table
with additional information. The users have to take "ownership" of the Record
by providing their ID, Name(this populates based on their ID number using
Dlookup), and ownership date. When they open the form I want it to open to
the first record that currently does not have an owner. Currently the form
opens to the first r...Access Records into Excel
I wonder if any one can help me? When I export from Access to Excel I'm OK
when I import into Excel I am not.
when I import (via external data) a table from Access the records are
largely in the correct order but not completely so, occasional records or
small groups of records are out of sync.
If I open the data from Access (tools-microsoft office-analyse in excel) the
records are displayed in sequence. I need to be able to refresh the excel
file as records are added to access; so as far as I know importing into
excel is the way to do it but I'm a bit stuck.
T...Current Record in Detail Subform
In a sub-form for detail lines, I'm trying to respond to the entry of
a bar-code, using the After Update event of the product combobox,
where I set the Product name textbox in the same detail line to the
ProductName value in the combobox. I'm sure I've done this before, and
it only affects the current record, but now when I update the bar-
code, the text the product name textbox in ALL lines gets updated.
Private Sub ddlProduct_AfterUpdate()
txtProductName = ddlProduct.Column(2)
Sounds like your txtProductName is "unbound" to any field in your ...Derived control
Hello. I'm designing a form to be used for both editing existing records
and adding new ones. A textbox will contain a string derived from three
other (bound & in same table) controls. (It will be a catalog id; I don't
want to construct it on the fly. I want it in the table.)
After a new record is entered, I don't want the string to be altered by
subsequent edits of the fields from which it is derived. Is there a
preferred way to do this? My current plan is to trigger the string
construction in a routine called from each of the (progenitor) control
afteru...record from table based on record from other table
I'm sure this isn't too hard but it's killing me! If a customer has a
pricing level of 1, how do I call pricelevel1 from the products table? This
should also be the case if the customer has a price level of 2, then
pricelevel2 should be called and a price level of 3 should call pricelevel3.
The resulting pricelevel is referred to as UnitPrice.
eg UnitPrice:IIf((Customers.PriceLevel)=1, Products.PriceLevel1,
This is not working in a query.
Thanks in advance
I think it a metter of brackets, try:
On the 9.0 version of Great Plains, when you are entering in attendance, can
you enter in your transactions on the HR side and then not push them to the
Payroll side? Is there a way to keep them on the HR side only? I would
appreciate any suggestions or ideas on these questions. Thanks Kim.
...record stock split in Money 2004
I have entered the stock split using the proper "task"
area, but it is not reflected in my account. I repeated
the operation, and got the message that a split had
already been recorded that day, do I wish to repeat it.
At first I said no, but after still not being able to
find the transaction, I chose to overwrite, with the same
results---it's still not showing up.
In microsoft.public.money, bstone wrote:
>I have entered the stock split using the proper "task"
>area, but it is not reflected in my account. I repeated
>the operation, and got the message...Create Table Record on Current of Form
I have a table called LastVisitedRecord. There is but one field in
that table called "lvCompanyID". I'd like to use the OnCurrent event
of my record form to insert the record id (CompanyID) into a new
record in the LastVisitedRecord table.
After that, I'd like to use a query I've created qLastVisitedRecord
which only shows the top 1 record of the LastVisitedRecord table to
query my contact form by default, showing all records, but skipping to
the record whose CompanyID field matches the sole record in the query
Anybody got an idea on how to do this? ...Weather records into a database: Help
I have collected local weather records for the last 12 years and put the
figures into an Excel spreadsheet. Each year is 1 workbook, so I have 12
workbooks/spreadsheets worth of data which has a heading for each month
horizontally in that workbook. Then each month has a date or day listing
vertically, with data for the different readings I have collected for
I have looked at trying to import each workbook, but it doesn't look
right in Access 2007. The data is there, but the field names are F1, F2
etc, just like it is in the spreadsheet, with the Year and month fi...check table for record
I have an unbound Form, with an unbound textBox: txtReceipt. When I put a
value there, in the BeforeUpdate event, I'm trying to check in tblTransactions
to make sure that that Receipt number has not been used yet, this fiscal year
(check records after 11/1/2007). Basically, if that receipt number has been
used, msgbox "that number already used, you still want to use this number?"
Don't know how to begin, do I use a recordset, or some sort of query? Thanks
for any pointers.
DLookup or DCount is the tool to do this.
VBA help on DLookup / DCount will expla...Macro Recorder
When I record a macro, the dialogbox allows me to specify the macro's name
and a shortcut key.
How do I specify in which of the existing modules the newly recorded macro
should be placed?
Gary''s Student - gsnu200908
AFAIK, you don't. You can always cut/paste it to the one you want.
"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
> When I record a macro, the dialogbox allows me to specify the macro's name
> and a shortcut key.
>...Highlighting Updated Records
Hi I wonder whether someone may be able to help me please with a problem I
have with a db I'm working on.
I have a subform with approx 15 fields on it where on any given day can have
their data amended, added or deleted.
What I would like to do is to capture which records have been amended in a
report within a given month. I know how to show which records have been
updated by adding another field to the table which has a date stamp but my
problem is as follows:
I would like to actually show the individual fields which have been updated,
rather than the whole record. Now I ha...monthly meeting attendance log in excell
I wish to be able to create an excell sheet to show attendance of staff at a
monthly meeting and then show this in a chart format to demonstrate level of
attendance at various monthly meetings
...Deleting Duplicates, All records unique
My column headers are: id, filename, location, and description.
All descriptions are unique.
My filename column has duplicates. For example, flower010104.jpg is
listed twice, with two different descriptions. I want to delete BOTH
rows containing flower010104.jpg.
So, I want to delete ROWS with duplicate filenames, regardless of the
description being unique (which makes the 'record' unique).
I have found that I can only filter by 'unique record', but ALL records
are unique, due to the description.
I need help. How can I do accomplish my task?
----------...Check Records After Update
I need to check the records in a subform after someone enters the information
(AfterUpdate on the last field I am assuming where the code will be checked).
I need to check on the status field (Field could be OUT, IN, RES, CX, adn
NS) for RES and the CHECKOUT and CHECKIN Dates. The purpose is to prevent a
reservation (RES) from being made with an existing reservation is in place.
There can be multiple reservations but there cannot be overlapping
reservations. I am thinking my conditions would be to first check status for
any existing RES and then check the CHECKIN Date of the ...Having a blank, new record for entry when you open a form
I have a Command Button on my Members Form that opens a Payment Form. What I
need is a blank, new record for data entry when the Payment Form opens. I've
tried a macro to go to new record on On Open, On Load, and On Got Focus.
None of those work. Any help will be appreciated.
Posted via a free Usenet account from http://www.teranews.com
Use the Click event of your button, to open the Payment form... and... go to a New
Private Sub YourButtonName_Click()
DoCmd.GoToRecord , , acNewRec
Al Campagna . ...Record data on two lines
Sorry about repeating the post but I think I messed up the first one
I am receiving a spreadsheet from an agency with record information on
Record 1: A1, B1, C1, D1, A2, B2, C2
Line 3 blank
Record 2: A4, B4, C4, D4, A5, B5, C5
There are over 100 records like this. They claim they can't fix it...
It originates from a Crystal Report.
How can I change the data so each record is on one line:
Record 1: A1, B1, C1, D1, E1, F1, G1
Record 2: A2, B2, .......................G2
Thanks for any help!
A simple way is to 1) select all of the data fields. 2) Cli...attendance
I have a database which has 3 tables, Clients, Groups and Group Assingments,
I want to enter records for a Group with the date of meeting into an
Attendance table. I want to have a form with three inputs. One will be the
Group Name which will produce a Group ID, two will be a date and the third
will be a subform listing all those assigned to a group with a check box for
attendance. After checking the attendance all of the records would be
appended to the Attendance table.
Lost in Access