Search results for query: *

Hi. I have a shared access DB. It has user-level security set up, which is working on one PC but not on another. On one PC you can see user accounts and the permissions are working fine. On the other PC you can't even see the user accounts. I have created a unique workgroup file but that does...

I couldn't agree with you more but unfortunately I don't have the skills to do so.. This is the easier option. Brgds, PSLM

Well, the "*" was put there to show that this is where I need a wildcard. However, I have realised that this is probably not possible. maybe this example will make more sense: DCount("[JobStatus]","tblJobDetails" Or "qryJobDetails_Filter_Comment" Or...

Hi. I have a live status field with a record source: =IIf([frmJobDetails_Subform_2].[Form].[RecordSource]="*",DCount("[JobStatus]","*","[JobStatus]='Completed' AND [jobID]=[frmBackupJob_Subform].Form![RecID]")) How do I get those wildcards to work? Any...

Mike, Thanks for your help. If I change it to an object in the database, the filter combo's will have to connect to a table or query right? I don't really want that as it is only for filtering... or am I completely misunderstanding you? Brgds, PLSM Brgds, PSLM

I have tried the following with some success: IIf(Trim(nz([Forms]![frmNewMain]![cboFilter1].[Value],""))="",[tblBackupJob]![Archive],[Forms]![frmNewMain]![cboFilter1].[Value]) However, it does produce 2 errors: 1. When run, it brings up an input box which says...

Hi All. I realise it's been a long time since there was any activity in here, which I assume means that solutions work fine. I have read through all of it, and tried many solutions. Nothing works as yet. I actually contacted Teddo who referred me to you guys. I have a very similar problem to...