Search results

Just as the title describes, I want to include either the Datasheet Caption or the column caption for the associated control in VBA. I've got the following that is located in a module as a public function. Dim ctl As Control Dim Num As Integer If Num = 1 Then MsgBox...

Awesome. I'll start putting that practice into action. Thanks.

That does make sense, and I would hate for a user to log in, and for me to then lose the ability to specify what items they can actually perform in the DB. Do you add additional values to use in that hidden form as opposed to using Global variables as well?

You can also refer to field storage size here: http://support.microsoft.com/kb/824263

Note: Access stores only the characters that are entered in the field. Access does not store space characters for unused positions in a Text field. To control the maximum number of characters that can be entered in the field, set the Field Size property to the value that you want. Numeric...

Alright, more importantly here, I am trying to figure out how to make this scalable. Let me re-hit the scenario, and maybe get some suggestions on how to implement this: I have a table that lists all of the tests, evals, test/eval associations and then two tables for test results and eval...

Yeah, you would be correct on that. For as much as Access is nice, I still like to complain about it every now and then :) This is good information to know. I for sure would have been sitting down trying to reference those fields and have them not be available. You would have seen another...

Alrighty - After learning that 2007 has no User Security roles, and not having Sharepoint or a SQL server, I decided to work starting with Bob's Simple Login script located here. I've got it functioning fine and incorporated some of the options also made available here. You'll see the code...

Awesome, I'll give it a whirl tomorrow when I have more brain cells I can devote. Thanks a ton for the sample code! I'll post up if I have any more questions or to let you know how it turned out. Thanks again.

Awesome, I'm going to start playing around with this idea. Could the cboSelect combo use a query that contains all info necessary or does it need to be populated from a table?

Right, I know that I have that option, but I'm looking for a non "hard-coded" solution. One where I could incorporate a query into the If Then statement so that I'm not set to particular values and I won't have to constantly update the VBA if a new option is added via the forms and tables...

I have a form that is used for recording test scores. The first selection that is made is a type of test. After the test is selected, some tests have a second sub-type of test that needs to be recorded. My quetion lies in how to hide or grey out this second combo box until a test is selected...

Awesome. That did the trick. For some reason or another I thought changing records would auto-refresh. What was I thinking? I forgot I was working with Access. :)

Alright. I must be overlooking something. I have a main form that's form record source is a query containing among other pieces of info, containts a CourseID. I have a combo box on the main form that moves to a different record based on that query and repopulated all of the sub forms on a tab...

I have a query on a form that is providing all of the information I need for everything on my form. The problem is I don't know how to refer to a field's value in the query in VBA without having a hidden text field on the form. I know I can reference a combo box's query to include criteria...

Awesome. I've been going through them one at a time. I appreciate the link. I'm sure when questions arise, I'll be back.

You didn't provide a whole lot to work with, but I threw something together for you. Take a look and modify as you see fit.

All - I have just about finished up a Split DB that I plan on deploying in a LAN environment. The goal of course is to turn what looks like an Access Application now into a non-access looking application where the Front End can be distributed and run on any computer within the LAN. I have...

Multiple tables it is. Thanks.

The only thing it sounds like to me is that you may have an incorrect linked table or query to the back-end since that error would be displaying when the available fields from the source aren't existing.