Increment a number based on four adjoing cells
I am using an xlsx spreadsheet for indexing metadata for file folders. Based
on the metadata selected from dropdowns in columns H, I & J, the spreadsheet
builds a file number in the format AA-AA-NN-nnnnn (A=alpha; N=predetermined
number; nnnnn= sequential number).
I'm using the following formulas:
Col B =VLOOKUP(H577,FUNCTIONLU,2)
Col C =VLOOKUP(I577,CATEGORYLU,2)
Col D =VLOOKUP(J577,TYPELU,2)
=IF(D576="","",IF(COUNTIF($D$2:$D576,$D576)=1,TEXT(0,"00001")+0,IF(COUNTIF($D$2:$D576,D576)>1,INDEX($E$2:$E576,MATCH($D576,$D$2:$...To Record in Form View from Query
I have a query run from FORM view using a button. To view records associated
with parameters built in the query. I would like to select the record and
view it back in the FORM view and continue on editing from there. Is it
possible to add a column in my query with this type of feature or something
along those lines?!
people usually do this sort of thing with 2 forms. The first form allows a
user to choose which record they want to edit. After they choose the record
there will be a button to click or sometimes a double click which opens the
second form with only the re...Reply's from MS Publisher Forms
I have added a response form to my website, However when i click submit ,it
returns error 404.
In the from form prperties i have entered my email address. I have check that
my server is running MS Frontpage extensions, how do i get the form to send
reply 's to my email address, & how do i create a confirmation page.
Please can anyone help with submitting forms so i can recieve a reply from it.
Many thanks Brelade.
A reference article
Publisher web publication forms 101
Mary Sauer MSFT MVP
http://office.microsoft.co...Bulk Import only Imports 15 records?
I use bulk import to insert records from CSV (save as from Excel) file
to CRM Contact Entities. But, everytime the bulk import runs, it can
only succesfully import 15 records, although there are more than 15
records in the CSV file. I have tried to create a new CSV file and
ensure that is nothing wrong with the 15th records, but same problem
occurs. Any idea how to solve this?
On Aug 22, 9:50 am, Gunady <Gun...@gmail.com> wrote:
> Hi All,
> I usebulkimportto insertrecordsfrom CSV (save as from Excel) file
> to CRM Contact Entities. But, everytime thebulkimportruns, it ...Need help with a project sheet, need date to show/not show based o
I have the following formula in cell S2
This takes a date in cell B2 and adds 31 days to it and displays it.
What I need to do is to NOT have cell S2 show any date if anything is in
I'm not very adept at Vis Basic if that what it will take to do it.
No need for code
> I have the following formula in cell ...Budget input form/worksheet
Anyone got a form or worksheet that staff members can use to provide input
on their organization's annual budget?
We are a non-profit trying to work smarter. Our Director tasked me
yesterday with developing something that can be given to the staff members,
in a standard format, that can be easily consolidated into a central
proposed budget. Rather than (possibly) reinvent the wheel, I thought I'd
ask the readers of this NG if this has been done and is available as a
Platte River Whooping Crane Maintenance Trust, Inc.
a 501 (c)(3) organization
...Set value in a query when opening a form
I have in a database an append query which has a Yes/No field Append. The
query appends only those records where the Append field value is set to No
(0). In the OnOpen event of a form, I want to first run the append query to
add any new records, then set the value of the Append field to Yes (-1),
then finish opening or loading the form. How can I do this programmaticaly?
You can do this using DAO.
In the VBA editor, open the Tools menu, select References, and, in the
References dialog, select Microsoft DAO 3.6. Close the References dialog.
In the database window, create ...cascade combobox with one combobox in a subform
I have a form with a subform.
The formfPerfEmissionGua) has a field called FuelClass.
The subform(fPerfEmissionGuaDetails)is based off of a table called tFuel
with the fields...
FuelID -- GasLiquid -- FuelName
1 -- Gas -- Propane
2 -- Gas -- Buthane
3 -- Liquid -- JetA
4 -- Liquid -- Crude
The subform is used as a dropdown choice of the above fields. It is a
I would like to be able to choose the FuelClass - Gas in the main form, and
the sub form drop down only show the fuels for Gas only (Pro...Locking a record from futher changes
How can I lock a record after someone changes it in a form so that no more
changes can be made to that record. I have a database that tracks items as
either being in stock or out of stock. When we do inventory I would like to
lock a record so that it can not be change back in my form. So when I'm
doing inventory and an item is out of stock and a clerk clicks on the out of
stock button that record is locked and someone can not accidently go in
change it back. The only way I would like it to changed it was that I would
have to go into the table myself and change it or I create ano...How do I import my mailboxes from a web-based email to Outlook?
I just started using Outlook 2003. I previously used a web-based email
service through my university (similar to hotmail, for example) in which all
of my emails were saved in cyberspace instead of my computer and therefore
accessible from around the world. Now that I am using Outlook, I would like
to somehow transfer all the mailboxes I had created in my web-based email
service to Outlook so that it is all in one place. Is this possible? Right
now, the only mailbox contents which were transferred from the web-based
email service is the Inbox. But I can't figure out how to get my oth...does GP print 1099-B forms?
Does GP print other 1099's besides DIV, MISC and INT?
Up through GP 10 it's still DIV, Misc and INT by default.
On Jan 15, 11:15=A0pm, "6538" <beach_house1...@yahoo.com> wrote:
> Does GP print other 1099's besides DIV, MISC and INT?
...importing with a custom contact form results in a notes record
I am importing a comma deliniated dos file to a contacts
sub-folder using a custom contacts form and the imported
records arrive in a notes format rather than my custom
contact format. When I add a record manually the custom
form produces the desired result. My form starts with
What am I doing wrong? and can I change a notes record to
a contact record after the fact. I am using Outlook 2000.
...Form not functioning properly
I've got a form that I use the following code to open.
Private sub lbl_Admin_Click
me.visible = false
'Don't go back to the main form while "frm_Admin" is loaded
While CurrentProject.AllForms("frm_Admin").IsLoaded: DoEvents: Wend
me.visible = true
I use this code, rather than opening the form in Dialog mode, because
"frm_Admin" has a couple of buttons on it that hide it, and open other forms.
If I didn't have the While:Wend loop in here, when I hide frm_Admin, my
splash screen ...about form refresh
I show a messagebox on the form that it has a parent, the form and its
parent are both inherit CWnd, and they are the same size.
when I close the messagebox, the form's OnPaint() isn't actived, but the
whole form refresh, its OnPaint() is actived.I don't why.
Now, I want to write some codes in the OnPaint().The form's OnPaint() is
actived when the form' s small rect refresh not whole. how to do that?
Try calling Invalidate() when you want to refresh the entire window.
"PPDragon" <firstname.lastname@example.org...Counting Records after filtering by feilds
I am working on a project that will create a report to count the
number of open work orders (records that have their opendate field
with in a date range given), close work orders (records that have
their closeddate field with in the same date range given earlier) and
pending work orders (records that do not have an entry in the closed
date field). I don't know how to (a) prompt the user for a given date
range, im thinking of maybe using a form interface? Is it possible
for me to have a calander button to click to select a date from there?
and (b) To count the what was previously describe...Choosing a field's record based on date
Hi. I am newish to Access and have a question. My friends familiar
with Access don't know the answer to this one either. I feel like it
is just on the tip of my brain but I can't get it.
How can I select an item in a table based on the date? For example,
an employee may have many hourly wages listed by date of hire and
How do I pick the right wage based on a given date? (Looking back at
labor reports, I want to solve this question: On this day the
employee worked 10.5 hours. What did he earn?)
I have an employee list table and a linked wages table that show...Record shift or change on form
When the application is left alone with a record displayed on a form, it
sometimes jumps to another record without any keyboard or mouse input.
Is this a bug? Any plausible explanations?
On Tue, 18 Mar 2008 16:27:02 -0700, Karl H
Some VBA code is making this happen, perhaps from a Timer event.
>When the application is left alone with a record displayed on a form, it
>sometimes jumps to another record without any keyboard or mouse input.
>Is this a bug? Any plausible explanations?
Hi Tom, I have 200 users, and ...Customizing a Popup Form as a Message Box
How does a person create a message box which is a popup form instead of the
standard boring gray rectangle?
Im reasonably new to this but here is the approach i would start on
create a form to look however you want with a unbound textbox..
set its Modal property yes (has to be closed to continue)
then in your code where you had a message box
Forms.messageform.messagetextbox = "here is your text"
hope this helps
> How does a person create a message box which is a popup form instead of the ...Query and Form to edit record
So, I have a few tables:
Agency_ID = PK
LOC_ID = PK
Prm_Code = PK
Agency_ID = FK
LOC_ID = FK
CensusEvent_ID = PK
Prm_Code = FK
I have a great form with subform where I use a dropdown to choose the agency
and it's program and then input the census, discharge and admission data for
a specific date. Now I want a form where I can choose the Agency and it's
Program in a similar dropdown and find that record with the census date,
census, discharge and admission data and edit it if I n...Enter values in table from form using dlookup
Just wondering if it's possible to put values in a table, using data entered
on a form?
Like if the person enters for item a, 1, then it adds 1 to item A in a table.
I've tried dlookup(blah) = me.text1 but it doesn't work.
What you want is the way it is supposed to work. You don't need to do a
lookup to move data from a form to a table, you simply need to "bind" your
form to the table (or a query based on the table). Every form has a "Record
Source" property; which should be the name of the table or query you want to
be the source ...get/change operation on SY_Current_Activity record already locked
We just upgraded to GP 9.0 with SP2 on SQL Server 2005 Express and we cannot
login to GP. Both of the 2 licensed concurrent users are showing as already
logged in the system. Since they are on GP 9.0, it gives them the delete
activity screen, but then gives an error message and they can go no further.
These are the two following erorr messages:
“A get/change operation on table ‘SY_Current_Activity’ failed the record
was already locked”
“A get/change operation on table ‘SY_End_Routines_Check_MSTR’ (45)”
(When I click on more information, I get more detail that says the disk
might ...MX records & SMTP connector
I have a SBS 2003 Std server with Exchange 2003 and I want to get my
mail system up and running.....
I have configured an mx for mail.mydomain.com, and a pointer from my
private ip to mail.mydomain.com.
What else do I need to do?...other than have my public ip handy when
setting up the register for my domain.
I have tried to send mail for testing and it lets me send mail to everyone
except for verizon.net domain members?
Also, is MX for send and receive? My outgoing must current be using smtp.
I need to change that to MX outgoing correct?
Sorry for so many questions.....
Test your ...Opening XFDL form using VBA
I have a electronic form that is in the format of XFD or XFDL. The IBM
Lotus Form Viewer is used to open the form, enter information and can be
printed, saved, or emailed. I have a need to open the form from an Access
database and pass data to it, populating the form.
I have tried many methods, including FollowHyperlink, and the form does not
open. The viewer starts but it is blank. I even tried to open the viewer
and pass SendKeys command to do a CTRL+O to open the form, but that doesn't
even work. It's as if the viewer is blocking the access to the form.
I can...selecting data from a list #2
Thank you gentleman (I presume based on the names) for your help. Th
sumproduct command worked perfectly. I'm still not sure how, since I'
expect that since non-numerical data is assumed to be zero (shouldn'
that return a zero? Zero times anything is zero, and the sum o
that...nevermind). But you guys saved me some time. This is th
solution I was looking for.
dave05's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1623
View this thread: http://www.excelforum.com...Get name of selected item for a product
Column A is with names of items.
Columns B to D are for entering value of items for products B to D.
Value of item is set to be max. 1 and only one item can be selected fo
Row1 A B C D
Row2 Lamp 1 0 0
Row3 Diode 0 1 1
Row4 2Pin 0 0 0
Row5 (result) Lamp Diode Diode
I need to get the result, in the last row of each product as, name o
product that has been selected.
What should be the formula