Another Access Condtional Formatting ?
Aug 27, 2004
My question is two fold. First, I have an Access Report that lists the training due dates of my people. What I need to do is have the cells highlight when they are due/comming due. My guess was with conditional formatting. I have tried the Excel version of that without success.
My second is for the same report. I need to find out percentage of how many people are still current for this training.
Thank you in advance,
Military guy in need,
Sarge_Rob
View Replies
ADVERTISEMENT
Jan 4, 2006
I want to change the Caption of a textfield depending upon a value selected from a combo box. i.e. If the user selects 'Scientist' from combo box, then the caption to enter name should be 'Scientist Name' if the user selects 'Engineer' then caption should be 'Engineer Name'. Can anyone guide me how this can be done?
Thanks
View 3 Replies
View Related
Mar 7, 2006
hi all, first time poster, with an awkward question.
i'll save you my life story but suffice to say i'm just 3 weeks into a 6mnt work placement from college and i could do with a bit of help.
the company i'm working with has to generate an xml document (preferably with access) corresponding to this schema (http://www.ros.ie/schemas/eusavings/v1/schema.xsd)
the problem so far as i can make out is that when i import this xsd into ms access - i'm presented with a rediculous number of tables and in turn these are not related, i.e. there is nothing to say that the e-mail address table is associated with the header table. (having them in one table makes more sense to me, but i'm not an expert, all i know is i have to comply with this xsd.)
when the data is exported to xml format, it's meant to look like this:
<?xml version="1.0" encoding="UTF-8"?>
<EUSavings formversion="1" periodstart="01/07/2005" periodend="31/12/2005" language="E">
<HeaderDetails>
<PayingAgent>
<TaxNumber taxtype="4">1234567T</TaxNumber>
<PayingAgentName>
<NameDetails>Joe Bloggs</NameDetails>
</PayingAgentName>
<PayingAgentAddress>
<AddressLineDetails Type="Line1">Test Road</AddressLineDetails>
<AddressLineDetails Type="Line2">Test City</AddressLineDetails>
</PayingAgentAddress>
<PayingAgentCountryCode>
<CountryCode>IE</CountryCode>
</PayingAgentCountryCode>
</PayingAgent>
<FileSequenceNumber>1</FileSequenceNumber>
<PaymentYear>2006</PaymentYear>
<ContactDetails>
<ContactName>
<NameDetails>Paul O'Neill</NameDetails>
</ContactName>
<TeleNumber>
<TeleNumberDetails>0875252252</TeleNumberDetails>
</TeleNumber>
<EmailAddress>
<EmailAddressDetails>test@test.com</EmailAddressDetails>
</EmailAddress>
</ContactDetails>
</HeaderDetails>
<AccountDetails>
<DocumentType>1</DocumentType>
<AccountHolderDetails>
<FormType>A</FormType>
<KeyName>
<NameDetails>Jones</NameDetails>
</KeyName>
<OtherNames>
<NameDetails>Tom Paul</NameDetails>
</OtherNames>
<Address>
<AddressLineDetails>New Road</AddressLineDetails>
<AddressLineDetails>New City</AddressLineDetails>
</Address>
<AddressCountryCode>
<CountryCode>GB</CountryCode>
</AddressCountryCode>
<BeneficialOwnerResidenceCountryCode>
<CountryCode>FR</CountryCode>
</BeneficialOwnerResidenceCountryCode>
<BeneficialOwnerBirthDetails>
<DateOfBirth>01/01/1945</DateOfBirth>
<BirthCity>Paris</BirthCity>
<BirthCountryCode>
<CountryCode>FR</CountryCode>
</BirthCountryCode>
</BeneficialOwnerBirthDetails>
<PaymentType>0001</PaymentType>
<CurrencyCode>EUR</CurrencyCode>
<AmountPaid>8889</AmountPaid>
<AccountIdentifier>152525525</AccountIdentifier>
</AccountHolderDetails>
<ReferenceNumber>455200211</ReferenceNumber>
</AccountDetails>
</EUSavings>
everyone in this company is completely new to xml and seeing as i have a little experience with it from college i've got quite a bit of pressure on me to try and make this work.
so, my question is: how would i go about exporting data from access into a xml document which conforms to the xtd, and looks like the xml code above?
is access capable of doing this?
they want this solved programatically, but nobody here knows how to do it.
can anyone offer guidelines on how to tackle this? any help would be really appreciated, i'm in over my head
View 3 Replies
View Related
Aug 1, 2014
Need to confirm whether the Default formatting option in the Conditional formatting Dialog won't work in datasheet view of a form. Please note that all conditional criteria are working fine but not the Default Formatting option - only in the Datasheet view (In Single Form view the default formatting is working fine)
View 11 Replies
View Related
May 4, 2007
.HTMLBody = .HTMLBody & "<LI>Resolution Description: " & Nz(Me!ResolutionDesc, "")
How can I keep the formatting of the ResolutionDesc memo field (ie Line Feeds and carriage returns) when I add it to an HTML email like this?
Thanks
View 4 Replies
View Related
Jan 10, 2006
I have sort of a loaded question. I have some code that is taking a bunch of records returned from a text box value which is running a query. The results are placed in a List Box. I then have a button set that grabs the returned records and exports them to a Specific Excel File.
1. Can I set the text size so that the imported text is automatically set to size 9?
2. Can I set it up so that the imported records start at row 3? Leaving the first two rows blank.
3. And Finally, can I preset a few column widths?
I appreciate any help in advance.....thanks for all your help up to this point....it is very appreciated.
View 14 Replies
View Related
Jun 17, 2005
Hey guys, very new to access.
I've been put in charge of setting up a database for work which stores statement and invoice information.
I'm just wondering how I can auto format a field.
I'm guessing it's in the "Validation" section.
A statement is a collective of invoices for each month.
So each March '05 Statement will contain all March '05 Invoices
Basically, what I would like it to be able to do (:)) is for the date inputed into the database, it creates it's own "statementnumber".
Eg. March '05 will create a number as 305 for example. 3 being the month, 05 being the year.
Because I need a common number to setup a relationship of One-to-Many.
Just wondering if this was possible.
Thanks guys :)
Greg
View 7 Replies
View Related
Jun 14, 2005
I hope someone can help me here because I'm pulling my hair out... Anyway... Basically I'm trying to save and retrieve a UK date (dd/mm/yyy) to an Access database using asp. The database resides on a server located in the US
Things I've tried so far:
-- Specifiying Session.LCID both in Global.asa and individual ASP pages
-- Using Custom formatting to format date before entering into database (using SPLIT function)
-- Using custom formatting to format date AFTER retreiveing from database
The problem is that the date seems to change how it's stored in the database. If I entered "16/02/1982", it would be saved in teh database as '02/16/1982".. but if I entered "03/04/2005" it would save it as this.. So fomatting after retreiveing the date from the DB just messes everything up!
Does anyone have any ideas how to solve this other than moving to a UK server?
View 2 Replies
View Related
Jul 22, 2015
1. Can we have the cells within access table change color when their input changes as in excel? For Ex:
If the input for a cell inside Column "Status" says "Pending" then the cell color is orange.If it says "Completed" then color is green?
Is this possible on Access?
2. Also is it possible to change the color of Column headings?
I tried changing the color but found that the entire table changed colors with alternate rows.
View 7 Replies
View Related
Jul 9, 2013
I am looking to export a table to excel from access. I would like to order the transaction category column in a specific order(round trip air far, parking, lodging etc),. I have a button that runs a make query table and exports it to excel. I would like the rows to be in the order of transactions category. What code would I need in the button to make this order correct?
I have attached some code below.
Private Sub ExportDebitsButton_Click()
Dim oApp As Excel.Application
Dim oWB As Excel.Workbook
Dim i As Integer
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
[code]....
View 1 Replies
View Related
Aug 7, 2014
I am making a planner in the access 2010 report. I am showing which activity finished when but I also want to highlight/ shade the cell to the corresponding month on the planner to the right. See picture above. I tried conditional formatting with date rage 1/1/2014 and 31/1/2014 but it does not gives me accurate result.
View 3 Replies
View Related
Nov 21, 2007
These days more and more of my databases are wanting to be accessed via the web as well as from MS Acess. I guess this is the norm these days but in most of our (office) dbs it's just 'web for web's sake' and there is no real need to access it outside of Ms Access.
Bu hey that's what they want...
Problem with one such db is that a lot of the fields are memo fields and hold a LOT of text and they want to create MS Access reports/PDFs as well as have nicely formatted html for the text on the web pages.
I seem to be able to cater for one or the other but not both.
1. I can leave the memo fields as raw text and the reports/PDFs look fine with the report formatting, but on the web page there is no formatting and the text ends up in one block paragraph with no formatting.
2. Use a html control for the hmemo fields and store all the html tags within it. The web page looks nicely formatted but the html tags will show up in the PDFs!
I've tried various tag stripping tools but they seem to give unpredictable results.
I also don't want to just dump the PDFs on the web, as they will be static and it's just plain lazy!
(too many unnecessary PDFs on the web IMO)
Is there any way i can cater for both formats?
Many Thanks
View 1 Replies
View Related
Oct 5, 2004
When exporting from Acces to Excel numbers formatted to one decimal in Access are displayed with two decimals in Excel. How can I get them to export to one decimal? I know I can reformat them in Excel but I'd rather have it work automatically.
Thanks
View 2 Replies
View Related
Sep 16, 2013
I have a button on a access database form that runs a query and exports the data to an excel sheet that remains open. I am ok with this. What I would like to do now is format the sheet and then save it as a file name that is the same as the query name but adding the date at the end. Here is what I have so far:
Private Sub Command1_Click()
On Error GoTo Err_Command1_Click
Dim stDocName As String
stDocName = "Qry_SentForProcessing"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.RunSavedImportExport "Export-Qry_SentForProcessing"
[code]....
I just want to add the code to this button. Or do I need to write a function as a module, then call the function after the export is run.
View 1 Replies
View Related
Jul 11, 2012
i have a script that creates an email for a booking when i click on the artist name which works great. i want to be able to subject the email with the week number of the month. ie in subject it would be WEEK 1 JULY WEEKEND CHECKOFF. with the date info coming from gigdate field
Code:
Private Sub artist(Cancel As Integer)
Dim msgTxt As Variant
Dim objOutlook As Outlook.Application
Dim objMailItem As Outlook.MailItem
Dim blnCreated As Boolean
Dim act As String
[Code]...
Please confirm your upcoming weekend Booking
NAME OF ACT
Friday 20 July 2012
NAME OF VENUE
ADDRESS OF VENUE
09:30 pm - 01:00 am
Act Fee: $800.00 Less Commission: $80 Net Pay: $720.00
Payment Details: Invoice venue prior - EFT
Please reply OK to confirm this booking
View 9 Replies
View Related
Nov 4, 2013
I have a table in access and I need to format it so that when column "Status" = "Closed" column "Closed" = "yes". so it will automatically mark column "Closed" "yes" if "status" says "closed". Instead of having to change both columns all the time.I know how to do that in MS Excel, but is it possible in MS Access 2013?
View 3 Replies
View Related
Mar 24, 2014
My new and previous laptops are both 64 bit and installed MA 2010 on both of the computers running win 8.
When I run reports on my new laptop the reports are not formatting. They are reflecting on 4 pages and not on 1 page like on my previous laptop running the same programs.
On my new laptop I installed Office 2013 and old one office 2010 but I used the same Access 2010 on both laptops which is a separate disk as office was not the professional one.
View 3 Replies
View Related
May 15, 2014
I have a continuous subform with a fairly complex snapshot query as its record source. I have controls on the main form to allow criteria parameters for the query and a command button to requery the subform based on the selected criteria. I also have conditional formatting on a number of the continuous controls in the subform (the conditions are fairly straightforward, i.e. highlight if null, true/false etc)
When the subform is (re)queried, it seems to repaint several times (3 or 4 although it appears arbitrary to me) before it eventually settles. And it really louses up the aesthetics as controls flicker between colours; sometimes I even lose the background colour on parts of the detail section, or controls disappear altogether. And this continues as I scroll down the subform (or even click anywhere on it)
I don't mind that the query itself takes some time to run - of the order of a few seconds each time - but I'd prefer for the screen to wait until the query is completed, and all of the CF applied, before refreshing itself, instead of 'sweeping' top to bottom repeatedly. It's a snapshot query so once it's run, there should be no changes to the dataset.
I've tried Application.Echo but it has no effect whatsoever.
View 6 Replies
View Related
Sep 18, 2013
Using Access 2010, I have a subform in datasheet view and I want to set the font size to 10pt. Setting font sizes for datasheet fields in the Format tab does not change the font size displayed.
I understand that the font size can be set using VBA (for example: Me.DatasheetFontHeight=10). Where do I put this code for it to work in a) a single datasheet b) all datasheets in the db?
View 6 Replies
View Related
Oct 9, 2012
I can generate an email by clicking on a button on a MS Access Report. In the body of the resulting Outlook email you have formatted text. I have also included an array of values which are displayed in this email but I need to highlight certain items in the array in red based on whether or not another column for that record is checked. Here is an image of the email. Notice that I have circled "ZWO" and that it is red. I need for this to happen programmically.
View 7 Replies
View Related
Apr 13, 2006
Really simple one for all you folks out there, but I've just been struggling for 20minutes and thats it I've decided to to seek proffesional advice. Though its been said I need it in other areas of my life too (so my ex says but..), any way I digress.
I put a tab control on a form all I want to do is format the title of each individual Tab name, i.e. font size etc, type. Had a look at the properties but nothing there seems to register.
Is it possible?
View 6 Replies
View Related
Apr 20, 2006
Hey do any of you guys know if its possible to change the colour of the tabs or set them as transparent in a form plz??? I know you can set the background as transparent, but i dnt know if you can do that to the actual tabs.
Thanks guys
Zaf
View 1 Replies
View Related
Jul 20, 2005
Ok, don't know what I should title this problem as, but maybe you guys can help. The data stored on my table is formatted as Currency, however, when I Queue up the data, I also multiply it by a factor (exchange rate). Which turns the data into just a regular number. When I display this data on my form, I reformat it into Currencies again. However, when I click on the field, it shows the number in its raw format. How can I fix this so that when the user click on the field, they won't see the raw number but just regular Currency format? Much thanks in advance.
View 9 Replies
View Related
Feb 5, 2007
Hi,
I am creating a database of private equity funds. I want to have a currency field for an input entitled fund size. However, I need to be able to display whether the size of the fund is in dollars or euros. How can customize a number/currency field to allow me to input the correct currency symbol?
Thanks
View 2 Replies
View Related
Nov 8, 2006
Hi
I have a database with multiple tables all linked together in various ways. I would like a master reset button that will delete every record in every table as well as resetting the auto number(s) back down to zero again. Can this be done and if so, how?
Thanks in advance.
Dave
View 9 Replies
View Related
Mar 11, 2007
I'm trying to format a header in a report and need some help.
The following results in "Error" if placed as the Control Source :
=IIf(IsNull([Captain]),"","Captain:" & [Captain])
Is there another way to do this?
Essentially, I want to display the word "Captain: " followed by the name if there is an entry. If there is no captain, I want to display nothing.
Thanks for the help!
View 1 Replies
View Related
