Search results

ok, i've discovered filtering does not work on subforms so i have searched the forum and modified some code to this: Dim strSQL As String strSQL = "Select * from tasks where" strSQL = strSQL & Me!frmSubProjects.Form!Project = 2 Me!frmSubProjects.Form.RecordSource = strSQL...

Hi, I've search all over for an answer to this and haven't found anything, so my expectations may be way off... I have a form linked to an Outlook mailbox folder that i can browse through, select an email and append a table with certain fields from the email. What I would then like to do is...

can anyone please explain why this code works.... xxx = "Format([Start],'dd/mm/yyyy hh:nn') between #22/01/2004 00:00# and #22/01/2004 23:59#" DCount("[id]", "[query]", xxx) 'result is 2 and this code doesn't: xxx = "Format([Start],'dd/mm/yyyy hh:nn') between #22/01/2004 00:01# and...

Help, I have a chart within a report (MSGraph.Chart.8) and need to manipulate some of the properties each time it prints for a differrent customer. Can anyone explain why the first three lines of code work, then fails on the next two: Chart.charttitle.Font.Size = 8 Chart.Legend.Font.Size = 8...

I'm having two problems getting animated gifs to work: 1. The code runs too fast.... On opening a form I have the gifs property set to not visible, then I want it to become visible while the database copies several large files from the server (takes anything up to 1 minute). Problem is the...

Help!! with Acsess 2000 I am trying to send an email using: DoCmd.SendObject acSendNoObject, , acFormatTXT, assignto, , , task, comment, False where 'comment' is a memo field on a form. After much tedious test I have discovered it only sends if the length of the memo field is less than 2184...