WUGNET help - Access - General Discussions

Display different colors on the same text box?

By: Al Campagna - Megaton, Use the OnFormat event for the report section where your control is located. Let's say it's in the Detail section, and the control is named Balance. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Balance < 0 Then Me.Balance.Forecolor = QBColor(12) 'lt red ElseIf Balance = 0 Then Me.Balance.Forecol...

Age at Case closure

By: KenSheridan via AccessMon - OK, lets go back to basics: 1. The GetAgeWithMonths function is the code I sent you in my first post, from the line: Public Function GetAgeWithMonths(varDoB, varClosedate) As String down to the line: End Function You need to add this function to your database by putting the code in any standard module. As it already appears from your earlier po...

Date Format

By: ms saintclair - RPage, Thanks, that was extrememly helpful, thank you! "RPage" wrote: > Fel, > I'm new to Access, but I had the same need as you. After a lot of tinkering, > I think I got all of the dates to work with the following. You'll have to add > the space and the month after this, but this gets the days displaying > correctly. > > =IIf(Format() & fncOrdinal([Shipped...

Debugging does not work - Access 2007

By: Tom van Stiphout - On Thu, 19 Nov 2009 08:25:31 -0800, "John Ruff" wrote: Is your database in a Trusted Location? Check the help file on this topic. -Tom. Microsoft Access MVP >The inventory db was initially created in Access 2003 and when debugging, >everything worked as expected. Code stopped at stop commands, code stopped >at a line of code that...

By: Rafiq Aziz - (1) copy your database & pest 2nd computer (2) Open 2nd db & Delet all TABLE (3) Link all Table From 1st computer db Thankyou rafiqmpl.it@gmail.com Yousof wrote: share 13-Apr-08 Hi, all I want to share one data base file with two computers, may file contains query, forms & reports. So please I want help step by step to create this sharing and how it wil...

soumission

By: marco c - salut

becky comming

By: Frankie Harbison - Becky is comming on sat at 1:00pm-- We will have supper here at 4pm . I would like as many as can to come and at least stop in. Slao baout Xmas I think we need to keep it at 7PM on Xmas after Jimmy gets off. Than no one will have to ask off work and those that can come early and we will have finger food so you can eat when you want. The presents will start ar...

Making a query that creates a value base on a table value

By: erika gomez - en realidad no me hagais mucho caso porque he perdido un poco la intuicion y yo siempre me he guiado por mis instintos o mi intuicion tendre que volver a desarrollarla ahora me guio por la inteligencia que es lo que me queda pero espero que trateis bien a mi familia porque no se merecen que les hagan dao ok besos erika "james" escri...

Form Hiding Behind Switchboard

By: Brian - Wow, I'm gonna stop putting up questions... I found the answer to this under a diff topic also.... opened a couple other windows and selected cascade under the windows tab, whew.... there's a couple days worth of work saved, minus my switchboard, but I'm smart enough to have a final project and a "drawing board"... play around with the dummy and copy any final decisions t...

Form Combo incorrectly rounding

By: KARL DEWEY - >> The values appear correctly in the underlying query (e.g. 0.0160) A couple of things do not match in your post. If it is a number field then it would not display a trailing zero in the query unless you format it and that changes it to a string. >>If I do a setvalue macro to populate a corresponding unbound field on the form, it populates correctly. How do you mov...

Query Def

By: jedireg - Vista SP2, Office 2007 Pro SP1 ok here it is. I have a query ( def below ) which works perfect if I set the sql statement in the query sql view. SELECT tblpart_info.rev_date, tblpart_info.usl, tblpart_info.lsl, tblpart_info.max_ra, tblpart_info.Out_Of_Square, tblpart_info.crown, tblpart_info.comments FROM tblPart_Info WHERE tblpart_info.part_no="XYZ" AND tblpart_in...

Dates

By: Emma - Hello I'm trying to create a database which has many dates (all 3 months from each other). Do I need to create a new table as this list is unbound and can go on forever? What would that table look like? In the client table I have intial date then I would like the closing date to be the last entry in the date table. Any design insight would be great thanks.

$B3'$5$s$X(B(^$B!#(B^)

By: yamakami$B$$$k$+ - $B$*$O$h$&$4$6$$$^$9!#;d$O!"%+%i%*%1$K!"9T$-$?$$!A$G$9!y(B $B0l?M$N;~$K!"2N$r2N$C$F$^$9"v(B

pb with attached tables (sql server)

By: Jeff Boyce - Why unbound? Access handles that quite well if you use bound forms. -- Regards Jeff Boyce Microsoft Access MVP Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or psuedocode included in this post is offered "as is...

increase size of database

By: Tom van Stiphout - On Tue, 10 Nov 2009 19:29:51 -0800, SageOne wrote: Microsoft Project? You probably meant Microsoft SQL Server, the enterprise-level database system. That is certainly a good option if you have that much data, but 35 users (if they are CONCURRENT) means that the app will only work well if developed by a strong Access developer. R...

Stephan Lebans - Report to PDF installation

By: Dirk Goldgar - "FSHOTT" wrote in message news:78E3D63A-1478-4A91-B18F-A18958815016@microsoft.com... >I would like to use Stephan's Report to PDF in an Access application I have > for e-mailing ReportCard reports to my suppliers. I have studied the > questions and responses above but I am still confused on how to modify and > use Stephan"s VBA event proce...