Search results

If this is in-solve-able, then please let me know. I'm struggling to find an alternative. I don't know what words to use when searching in google groups.

no one has ever come across this issue? i thought it would be quite a common dilemma.

if it's a total, stick it in a report footer. else =Dcount("[CONSTANT FIELD]","Query")

Hello. I have a report which shows Company's percentages and their regional percentages. Everything below 70% must show, but everything 70 or above musn't show. The visibility is based on region name. So for example, if "Company A" was 85%, but one of the regions was only 65%, then Company A...

Hello... I created a button that opens a link to a URL and copies information from a record to the clipboard to paste on this webpage. The users are not using it correctly (they need to close the page each time they need to do the next record). what i want to do is to close ALL IExplore...

well... my records have a date field which have a long date format. none of them are the same because each record is done at a different time. I basically need to generalise the dates so that all july dates group together, all may dates etc etc, so i can filter that field and all the sums and...

I have a query which has many sums and counts on things like "Company name", "region name" and "Development Name". I'm using this query for a report to do lots of percentages with, but now i need to filter this also by a date period. So the user choses "Alex Homes" as the company name and then...

=Format(DateValue(DateSerial(Year([cmbDate]),Month([cmbDate]),1)),"dd/mm/yyyy") =Format((DateSerial(Year([cmbDate]),Month([cmbDate])+1,0)),"dd/mm/yyyy") Still seems to be giving me all dates before the month aswell. Did the format in the SQL string too, and still giving the problem. Changed...

I've tried so many different ways to try and get this working but it just wont work. SELECT * FROM qry_NatxReg WHERE [Time of Attempt 1] >= #01/07/2006# AND [Time of Attempt 1] <= #31/07/2006# AND [Company Name]='Alex Homes' SELECT * FROM qry_NatxReg WHERE ([Time of Attempt 1] BETWEEN...

We all know that there are numerous different methods of printing to PDF. I want to know the easiest, and cheapest method to do so. All i want to do is print to PDF with a specific file name and bring up an email with it attached... the email part is easy, but with printing to PDF, some...

myEmail = hello@hmmm.how doCmd.SendObject , , myEmail That's the most basic format, assuming that outlook 2003 is the default email client. You can set references to outlook in your projects references: Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem Set objOutlook =...

my bad. the other option is to use open args on every form

one option is to do an if statement and making the button visible if the level is correct. If Level > 1 then cmdBetterThanYou.Visible = true End If Otherwise, some message box saying "you're not important enough, go away" would suffice.

Ok, i found out more about the problem. It's selecting all dates below the date chosen aswell. So selecting July would show June, and selecting June would show May. Me.frmData.Form.RecordSource = "SELECT * FROM qry_NatxReg WHERE [Company Name]='" & cmbCompanyName & "' AND ([Time of Attempt 1]...

in the form properties, put "data entry" to yes. OR Make the recodsource a blank source. For example, creating a query which displays no results. I chose the latter option in one of my forms: I have a query which displays all the data in the table i want to write to, and put my "Complete"...

It's werd though... Why does it work when i select june (getting rid of July Dates) but not when i select July? Does it matter that the field i'm trying to filter was automatically filled in with July dates, and that i manually changed it to June?

Sorry, Deadline on monday. Bump.

I've already got that. FirstOfTheMonth = DateSerial(Year([cmbDate]),Month([cmbDate]),1) LastOfTheMonth = DateSerial(Year([cmbDate]),Month([cmbDate])+1,0) The dates are all working fine, these fields display 01/07/2006 and 31/07/2006 when i select "Jul 2006", but it's showing June. See attached...

Hello, I have a dropdown menu which has a lisrt of dates (mmm yyyy), and when one is selected it updates 2 boxes with 01/mm/yyyy and 30 or 31/mmm/yyyy Private Sub cmbDate_AfterUpdate() Me.frmData.Form.RecordSource = "SELECT * FROM qry_NatxReg WHERE [Company Name]='" & cmbCompanyName & "'...

IIf([field1]="Yes","X",(IIf([field2]="Yes","Y",(IIf([field3]="Yes","Z",Null))))) Is this what you mean?