Recent content by bellemmar

I have a database with one public tab and a second "admin" tab which is password protected. On the public tab, there is an attachment field where we place PDFs for staff viewing. The attachments in this field can only be modified (added/removed) when the protected tab has been unlocked...

Hello, Is there a way to use conditional formatting with a date? For instance, in my form I'd like the date field to turn red once a particular date has passed (to show that memberships are expired). Can this be done or am I better to just format a report of upcoming expiration dates? Thanks.

I'm wondering if (how?) it is possible for a website to pull data from an Access database? We have all our department's policies in a MS Access database on our server. Some of these policies need to be made available to the public on our website. I'm wondering if there's a way for the website...

HELP! I'm using the same premise in a new database. I have the following code: DoCmd.OpenForm "CurrentForms", , , "FormName = '" & Me.ID & "'" [CurrentForms is the second form to be opened, FormName is the on-click (text) field in the report and ID is the control source (autonumber)]. But...

And if I don't have a query behind the subform?

I have a form with a subform with parent/child linked fields called ID. I want to format a report that shows all of the parent form fields but only the MOST RECENT of each of the numerous child entries. For instance, in the parent form, the record entry is called Goal 1 and the subform...

Yes, I can see everything in the subform, I can enter the data and scroll through the entries i'm making. but as soon as i move to another main (parent) record and then scroll back to the previous one, all the subform entries are gone. they are still in the tables though. I've attached here.

The weirdest part is the if I go in to just the subform, the data is there. But when I go into the main form and the subform is visible, the data doesn't show.

It's set to No. Should it be Yes?

My subform is not retaining data. I have linked the ID field on the main form to the ID field on the subform (parent/child) but when I exit the database all the subform data disappears...

I am very hung up on this. I think because I only have one Contacts table. Basically I have one table of "bad guys" and I want to be able to link people who are associated. So if I'm in Al Capone's parent record, how can I link him to Bugsy Segal and have that same relationship reflect in Bugsy...

I have a Contacts database. I want to cross reference associates. But I don't want to have to enter associates in both records. For instance: If parent record is John Doe and in the associates subform I add Mary Smith, how do I make the reverse show so that Mary Smith's parent record would...

Can the navigation pane be set so it is automatically hidden?

Is there a way to make a shared (split) database automatically log/time users out if they leave it open/idle for too long (ie: more than 30 minutes)?

I want a query to return records only for the current year (field called CheckDate) and then a total of boxes that are checked in a second field (field called Breach). Basically we want to see how many checks we did in total, as well as how many resulted in a breach. I can make both run...