Search results

Heh, don't worry. This database has been giving me headaches for three months now. Basically repairing a pretty sizeable .mdb fraught with errors and adding forms and a switchboard. Anyway, that code almost has it, when the Faculty form opens, the newly-entered name pops up all right, but it...

Hmmn..it seems to be having a compile error at the "&" for a possible missing expression. I wish I knew the quick-fix for this, but I fear my VB skills were taught to me back when VB III was still new.

Ah, well that sort of worked. The records loaded in the form correctly, but it automatically went to the last record. To give you an example, I'm adding a test record with a name of "New, Name A." so it gets inserted in the middle of number of records (alphabetically). The edited command...

Hmmn..no, that just did the same thing as before. At first I thought it might be a compile problem, but no. Below I've copied the content of the code, could it be a previous error? Public Function Faculty() Dim strInput As String Dim db As DAO.Database Dim rst1stTable As DAO.Recordset Dim...

Hmmn..by doing that, it brings up the form with all the fields blank and doesn't acknowledge the list of existing names. Do the number of commas reflect the total number of fields on the form? The navigation buttons only list one record (blank) even though there are records in the two tables...

Hmmn..just out of curiousity, would you know the answer to the following: At the end of the below code, I toss in a generic "OpenForm" to open the Faculty form automatically. You wouldn't happen to know the code that opens the form automatically to the new record I just added, would you...

Ah, it worked! Thanks! This problem has had me scratching my head for some time.

I have the below code which allows a new Faculty member to be added to the table "MasterTable" it also copies the new Faculty member (by keyboard input) to the "Faculty" table. The problem is that I'd like it to also copy the new MasterID number generated in the MasterTable (Autonum) to the...

Ah, never mind, I think I've got it. I'm just using the default module name, (Module1) and putting multiple functions in it. Thanks for all your help!!

I've tried with with the paranthesis, as well as without. I'm baffled. Is there a syntax where I can do onClick =NameOfModule(NameOfFunction) to reference it explicitly?

Hmmmn..it can't seem to find it even with a different module name. (I called it Module2) The onClick property (on the button of the test form) is set to =GradStudent with the code for the function as follows: Public Function GradStudent() Dim strInput As String Dim db As DAO.Database Dim...

Well yes, other people will be using the database, but only a select few. Hmmn..I must be saving these modules wrong. It can't find them when I click the test button. (I set up a test form with buttons to activate the modules to see if they work before re-building my switchboard). Should I...

Hmmn..well, at first your solution worked. But I'd forgotten that I'd also have to add a record to two tables on just the first pop-up, (Master, Faculty) but three tables on the other two pop-ups, (Master, Grad, Employer and Master, BA, Employer). I know how to set up the code to add another...

Hmmn..so it would create a pop-up input box? That's a good idea. As for my experience with recordsets, no, I'm afraid I don't. I have a background in Visual Basic, (though unfortunately it was back when VBIII was still new) and I thought there might be a good VB solution for this. To give...

I'm not sure I understand, in what column should that be placed? I've never coded an append query.

Hello, I was hoping someone could tell me a way to perform what may or may not be a simple problem: I'd like to build a small form with one text box and one button (Add New Record) which will take the information in the text box and append it to a field in two different tables within the same...