Search results

Thanks everyone!

Hey guys, so I'm following Pat Hartman's great advise as best I can and made a junction table called tblAgencyProgramCodes and drawn out the relationships between both tables (screenshot below called tables). Have made a subform (screenshot below) and set to continuous forms. And below I...

Hi thank you for your detailed reply. Now my question is, the form's record source is a query. In the split form (screenshot below) there is a button the user can press that will open up this form. I had a previous problem where new records entered did not show up in the datasheet. To solve...

Hi all So in the screenshot below is a form users use to add new company information. The organization I'm with is a local community college and they monitor which companies work with the college. Certain companies or agencies if you will, will accept students from certain programs. E.g...

Never mind guys, I got it working. THank you!

I'm trying to post on here but it's not letting me. Something about proxy connection, I tried following the instructions but still no luck The SQL for the query the datasheet and form is built on is this: SELECT tblAgencyInformation.Agency, tblAgencyInformation.Subsidary...

I added this refresh button on the split form (frmAgencyLookup) and the on click property is [Event Procedure] and the code here is: Me.Requery The close button on the add new agency form (frmAddAgency) has an On Click property set to [Event Procedure] and the code here is: Private Sub...

Sorry you mean this bit of code should be in the frmAddAgency form? (See picture)

As a datasheet. It's record source is a query. The form frmAddAgency's record source is the main table itself

I got an error that said: Run-time error '2478': Microsoft Access doesn't allow you to use this method in the current view Private Sub cmdClose_Click() [Forms]![frmAgencyLookup].Requery// this part is highlighted DoCmd.Close End Sub

So after I hit save putting something like: Me.Requery In the On_Click property of the close button?

You mean like on the add new record form?

Hi all I have a split form where the top half displays some agency information and the bottom half is a datasheet that contains records with more details. I have a form button for users to add new records and when I went to fill one out, I hit save, then close on the form but whenever I try to...

It didn't but I will just delete it and replace it with another copy. I also work on splitting this database. Thank you.

Basically just function as a search bar that filters a datasheet (split form) based on whatever the user types in.

Well that's the thing right. I mean, I don't fully understand this as well but I just basically found this online, made some changes until it did what I wanted it to do. It works perfectly fine on my version of Access, I type really fast, really long things and I don't get any errors, but for...

Hi everyone So I'm working on an access database and I've saved two copies. One is read-only, the other is the copy I've been working on. They're both on the same drive, just in separate folders. I know this should be split, but for the time being I just copied this database for my supervisor...

The only time I used the asterisk was when adding that field value *NOCODE not anywhere else in the query, but if its a problem in general i will get rid of it and simply say NOCODE

Well I know now the code works because I for a fact there are 12 records with the program code 1212 but there's also MANY more records with the value *NOCODE I attached two new screenshots that show what I mean.

Yes, there are text boxes in the detail section of the report. I have attached a couple of screenshots of the report when the selections are made