Search results

I think i got it: Expr1: DLookUp("[overall KPI Score]","[KPI Rating]","[KPI Rating].[Project ID]= " & [project status survey].[project id] & " And [as-of date]= # " & DateSerial(Year(Date()),Month(Date())-1,0) & "#") it was just a matter of putting the correct characters (#, ", &) in the...

vbaInet: I'm talking about Dlookup (not DCount). SOS: I looked at your database. thank you for that! but is there a way to do what i want without requiring an additional query? also, i spent so much time trying to figure out the dlookup that i am really curious as to what i did wrong. Thanks,

I am using Access 2003. I have a table called [KPI Rating] with the fields: --number field called [Project ID] --date field called [As-Of Date] --number field called [Overall KPI Score]. I have another table called [Project Status Survey] with the fields: --primary key number field called...

thanks! my mind is at ease now. You're the best!

thanks Bob. The code is working so nicely i was scared i would lose it! Do you know if it's possible to keep my mdb file with Access 2007? I know User Level Security doesn't work with the new file type called ACCDB, but can I keep my mdb file with 2007 and not convert to ACCDB? With my...

I am currently using Office 2003. There is talk about moving to Office 2007. I read that the 'Output to Excel' no longer works in 2007. I read that Service Pack 2 fixes this, but I don't know if we will get SP2 right away. Will the code I am using above still work using Office 2007 (no...

You're my hero!!! it works perfectly. Thank you so much!

Almost there! it populates the tab with data, but then i get the message 'Object variable or With block variable not set'

I'm getting 'Select method of Range class failed'. It populates the second tab with the column headers, but then gives that message. No data gets populated.... Edit: What i mean is, no data other than the column headers gets populated.

Yes, it is a new set of records from a variable I define called strSQL. (see below in red). '*************for users that select Report ID=13 (Watch List)************************** 'if user selects Watch List (Report ID=13) then need a new tab. If...

Hi Bob! I'm trying to figure out how to populate the second tab. I am able to create and name the tab, but how do I populate it with the strSQL data? Thanks,

Thanks to both of you for writing. YevS: Yes, the code is in Access. I tried Docmd.TransferSpreadsheet, but one of the required arguments is FileName which is the name of the text file to export to. The full path is required and it is a required argument. I don't have the path since my Excel...

Bob Larson helped me greatly with his code to go from Access to Excel. Everything works great and all the data is populated on one Excel tab. Now, I'm trying to add a second Excel tab to that same spreadsheet if a user picks a certain report from a combo box. Here is the code--the bottom...

I am using Access 2003. I think I finally figured out Access security, but I'm not sure if I did it right. Here are my steps: --Opened a blank copy of Access and created a new blank database. Named it SecurityTest.mdb and saved it on the shared drive. --In that new database, went to File...

Yes, it works with the Start " " Thanks, for your help though!

I found the answer! I have to add this line to the beginning: Start " " Here is my .bat file: @echo off Start " " "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\nct3\Common\ManagementCenters\ProjectHealth\PADA\Test Databases\securityTest.mdb" /WRKGRP...

Thanks for writing. It didn't work. Now the DOS windows opens for a second, then closes and Access doesn't open at all.

thanks for writing. I renamed the file from: shortcut Test.bat to: Copy of shortcut Test.cmd but it doesn't fix the problem. The Command window still stays open. I have Windows XP and Office 2003. Thanks,

I know this is an old post, but... I am trying to do the same thing. Using my batch file works fine, but the DOS window stays open until Access closes. Here is my .bat file: @echo off "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"...

Thanks for writing. I don't think we're ready to split the database. For now, we want the db on the shared drive. What should I do to make the security correctly applied? Thanks!