Search results

Here's the scenario: There's a button(Button1) on the main form (Form1) and on the second form (Form2). On Form1, I've got a link(LinkToForm2) to Form2. When people click on LinkToForm2, I want access to open Form2 and hide/show Button1 depending on whether it is shown/hidden in Form1...

I used google, but i couldn't find anything for Google drive - only dropbox. And what I did find for Google drive was not referring a split database.

Does anyone have any experience or knowledge of sharing a backend of a split access database using these services. I want to access my database from different locations. More than 1 user may be using it at the same time. Can I put the back-end of a split database in a Google Drive folder or a...

Thanks guys. I've been trying to figure this one out all day; I should've known. I'm not inputting any data atm so I made the join a type 3 so all data from tbl_Classes is displayed.

Hi sir how u doing

Is it supposed to do this? Am I doing something wrong? Picture attached. Thanks.

Thanks, I'll have a look at what constants are.

Let me quote the section of the tutorial: And then, an example is shown. This is typed in above the first subroutine: Dim dblRate As Double dblRate = 0.03 And then, when one of the code modules was run, a message box displays: "Compile error: Invalid outside procedure."

You can declare it, but can you set a value to it? I ask this because I watched a video once where it said you can declare it but not set its value.

I did, but "actually, that wasn't what I was looking for. It filtered the 2nd form to the 1 ID. That's already what I have, using a different code."

If I set a variable inside of a subroutine, it is set to nothing upon the end of the sub. Can I set a variable outside a sub and set its value, so that you can use it within subs? I'm new to coding.

Thanks uncle, I've found the solution in one of your links. I've used this code in the button's on click event DoCmd.OpenForm "[Form name]", , , "[ID of 2nd Form] = " & Me.[ID] UPDATE: Actually, that wasn't what I was looking for. It filtered the 2nd form to the 1 ID. That's already what I...

Lol thanks but that goes in line with what the uncle gizmo and bob said - to create a subform. if i do it this way, i will be faced with more problems and a need for more troubleshooting, because of other factors

Thanks for both of your suggestions. Uncle gizmo, u didn't need to explain in that much detail lol, i know my way around but thanks for that. I'd rather not have subforms as the tabs, for many reasons; an example is that my "record control" buttons are in the footer; having a subform as the...

I thought I'd find this to be a fairly common demand and that I'd find the answer by googling, but to no avail. I've got buttons (on the header of my form) that I plan to make act as tabs for a single record. Each button should display more information for the same person (basically, more...

I done it like this because I want to separate unrelated fields. The naming isn't the naming on my actual form; there's a whole lot more in my actual form. It seems to work better if I edit the relationship to cascade update and delete but I don't want that. Either way, I can't move to the...

1 address, 1 email, Multiple phones. The phones are in a subform and the other 2 aren't because they are 1-to-1. Even if I remove the subform, the problem persists, so the problem isn't there.

Buuuuuump?

Here it is.

What's wrong with my relationships