Search results

Kiwiman - Thanks for responding :) I tried your example and that didn't quite work but it made me think of something else to try... This worked for me... =IIf(IsNull(DLookUp("LaborCategory1","LABOR","[ProposalID ]=" &...

Hi All, I was wondering if someone could point out what I'm doing wrong... I have a (parent) form with 2 subforms. I would like the field in one subform to look at the value in the other subform... if that value is null I would like the field to display "N/A" otherwise I want it to perform a...

Oh so that's where you can put the code - the On Format area of the Detail Section! Learning something everyday :) Your code snippet worked like a charm! Thanks!! Lissa

I have created a Planned vs Actual Revenue Report which displays planned and actual revenue horizontally as follows ................ JAN FEB MAR QTR1 ...... OCT NOV DEC QTR4 ANNUAL Planned $ Actual $ Variance Variance % The Planned Revenue has already been entered for the entire year. Actual...

Read 'How I use MS Access User Level Security" found at http://www.geocities.com/jacksonmacd/ It's been recommended by lots of people on this forum and it's a great start. It helped me!

Nevermind....

They always recommend making a backup of your *.mdb file before you start doing security stuff to avoid locking yourself out... but try doing seaches on this board under 'security', 'lost password' and you may be able to find something else...

As far as I know.. no. You don't have a backup of your database?

I guess I'll try disabling the database window option with code. I was just hoping there would be a simpler way to do it. Thanks Bob :) Lissa

Hi Bob - What I meant is that the report contains a subreport which calls a query that queries one of the tables I was wanting to hide from the users. From what I have tried so far, unless I grant that particular group 'Read Data' access, the data on the subreport won't show up on the main...

Hello All, I have implemented Access security and it seems to be working or so I thought :( I need to hide a few tables from users but some reports require access to the tables - which forced me to grant read access to the tables... which then lets users read the sensitive data. This is not...

Oooohhh okay I think I understand how to go about it - I'll try it. Thanks Bob & Ray!

Is there a way to make some controls on a form read-only and other controls on the same form allow editing? I guess in some way override the Allow Edit property? If anyone can point me to some examples or has a suggestion on how to go about doing this - I'd appreciate it! Thanks! Lissa

I'll try the dlookup route again. Thanks for your suggestion. Lissa

Hi - I orginially created a report that runs off a single query. (User selects project value that drives the initial query. The report displays # hours billed to a project per month). Now managers wanted me to add $$ values to the existing report. To save time, I created 2 additional...

Wow -it's working now! Thank you Craig :)

short Example Hello MStef & Bob... I've attached a short example of my database. I tried changing Forms! to Forms. but that didn't work either.... Thanks, Lissa

I have a subform with the following 2 fields in the footer: sumJan = Sum([January]) JanUtilPcnt =[sumJanuary]/DLookUp("January","BILLABLE_HRS","Year = " & Forms!sbfPlannedForecastData!Year) These work fine in the subform but when I added the subform to a main form, I keep getting the #name...

Hi Curtis, Does the report pull it's info from the same query as the form does? Yes the same query is used IS the form reopening in add mode? I open the form using this argument: DoCmd.OpenForm "frmSummarizedRsrcData" I'm assuming that's edit mode? If not... do other records show in your...

Hi.. Does anyone have any clue why this would happen? I am still stumped on this one. A user enters a new record through a form based on a 4 table query. The recently added record appears on the query but when the user runs a report linked to the form after adding the new record, 1) the...