Search results

Or if you want to capture after they have updated a field then use the AfterUpdate event

Are you both running the same OS and version of Access?

The syntax above is correct if your Yes/No field is a traditional Yes/No field as the values it uses are -1 for True and 0 for false. If you have created your own Yes/No field maybe in a drop-down then the values could be anything and the syntax will be wrong.

Sorry, the correct line should be this: =IIf(Not Isnull([CallingContactRel]),[CallingContactRel],"") & IIf(Not Isnull([CallingContactRel]) and not nz([BookingNoteContactExcl],0), ": " ,"") & IIf(not nz([BookingNoteContactExcl],0),[CallingContact],"")

Here is everything you need broken down. You can simplify if you like but you get the idea: IIf(Not Isnull([CallingContactRel]),[CallingContactRel],"") & IIf(Not Isnull([CallingContactRel]) and nz([BookingNoteContactExcl],0), ": " ,"") & IIf(nz([BookingNoteContactExcl],0),[CallingContact],"")

Re: How can query display info based on cascading combo boxes when box "isnull" You could do it something like this: First remove all filter criteria in the query. Then create a new column and put this in the field: IIf([Forms]![FormName]![ControlName]="" Or...

Hi Ian, we do offer one-to-one tuition though this has always been done in person. I guess it could be done via logging in though I think the sessions would need to be shorter as over an hour on the phone would be quite tedious. One other thing to note is that if you require more general...

Where are you based?

Here are a few options: 1. If you have a server put the database on that and then the remote users can use remote desktop to login. 2. Buy a server though this will be expensive and then follow option 1. 3. Remotely host the database on a rented server. This means all users would have to...

From the original database you uploaded you need to add a Member_ID field to the Test table and link them up with a relationship. Then in the new field add the missing values (i.e. the ID values from the Quest Second table. Then in the query link on the new Member_ID relationship. This should work.

Maybe try these first: Tony Toews has an excellent web page on database corruption. Http://www.granite.ab.ca/access/corruptmdbs.htm Allen Brown also has excellent info on corruption. Http://allenbrowne.com/ser-47.html

Did you only import the actual tables i.e. not the MSysCompactError table?

Definitely sounds like corruption so take a backup and then import your tables into a new backend and then compact it and hope that message doesn't re-appear.

When I say special characters I mean hidden characters that could be formatting or something say in Word which Access can't translate and thus the error. I would probably look further at this to find out exactly what users are copying/pasting and from where. One way to avoid these characters is...

To be honest I really can't see why you need the 'Item list query' in your main form recordsource so I would strip it out. The issue with your subform is down to a property of the subform on the data tab called 'Filter on Empty Master' which is set to No - set this to Yes.

Robinson, If I were you I would do a Google search for If statements in VBA to gain a greater understanding but essentially you are passing a condition and if met the corresponding code will be run and if the condition is not met the 'Else' part of the If statement will execute. This is what...

Are you linking another query in to this query that has grouping switched on?

Is there grouping in your query?

What is or isn't happening?

Yes, I did but I think this is because it has reached the end. Try the amended code below. I have added a line count to help check what's going on and extra break points in your loop for when the filehas reached the end. Option Compare Database Option Explicit Public Mode As String...