Recent content by pitt_ph

As an update, I attempted to run this code on the Form_Open event of the switchboard (as well as a data entry form). In both scenarios, I obtained the following error (highlighting line 34 of the code, specifically the bolded part below): Would anyone have an idea of why the FillTo method may...

Alright, so commenting on (and asking questions about) a thread that was last answered about four years ago may not be the smartest idea, but here goes -- I use Access 2007 primarily, so most of the split database relinking codes I've seen don't seem to apply to me (because they *appear* to be...

Hey all, In Access 2007 I have a couple of continuous item forms that can be opened from either an "Add Data" or an "Edit Data" switchboard using either a "Add Entry" or a "Edit Entry" button. (I created these switchboards myself, by using a blank form and buttons leading to different forms.)...

Ooh, good point, forgot about that. Any other tips?

Hey boblarson and AccessProgrammers.Co.UK Folks, Sorry about the delay in my response -- it's nearly been a month since you last heard from me! It turned out that I didn't have the time to strip my database of the non-pertinent information. Luckily, I picked out the majority of the kinks from...

Hah, the reason why there are quotation marks is that the code I gave for the DoCmd.OpenForm event was converted in Access 2007 directly from an embedded macro. :) As for the Form_Load() event, should I simply make some type of intermediate variable that isn't named the same way as the variable...

Alright, I looked at the code of my database later last night. Apparently, I was right about the OpenArgs (that they weren't being passed properly). They were being mentioned in the DoCmd.OpenForm event of each of the buttons, but they were NOT being loaded in the Form_Load() event of the...

OpenArgs, you fiend! =P (Seriously though, half my posts have been about openargs. I'm so sorry about that, retroactively.)

Interesting thought -- I knew this would be easy if I kept all the forms upon upon their use. Unfortunately, the switchboard form is being closed and reopened whenever a button is pressed, because otherwise the user would end up with at least 15 tabs open, and that'd get terribly confusing for...

Hm. If I decide to upload the database, it will mean I can't get to uploading it until tomorrow. Oops, sorry about that! :( On a different note, do you think this has anything to do with openargs? The code that I've been copying has also been trying to pass the parameter...

Haha, I thought about that. :) I actually copied the form names directly from the form name (aka, I right-clicked on the form name in the navigation panel, clicked "rename" and copied the string from that, without renaming the actual form) when writing the form, so I don't think that's the case...

Hm, that's odd. I usually write my form names in CamelCase, so that shouldn't have been the problem. I switched all the dashes to underscores, and I still was getting errors along the lines of, "Compile error: Expected: Then or GoTo" -- even when I had Then in the code! The code I have now is...

Hey all, Recently, I renamed my forms and my tables to have numbers in front of them (mostly to establish a temporal order in my forms). I had a code which worked when the form names didn't have numbers in front of them... However, upon adding numbers to the form names (and trying to update the...

Look, I understand that much. What I'm worried about is, if I try to exit the switchboard, go to another form and return to the switchboard, I'd like to have the button remain disabled. I'd also like the button to regain function as soon as a new record has been entered and someone goes through...

Re: Changing How Combobox Functions Based on Form's Editing Mode? ("Add" vs. "Edit") I tried to work on something that was along these lines. Essentially, I have enabled a form to be open in either Add or Edit mode. Depending on the mode that the form is open in, I'd like for a single button...