Search results

The macro was built to runSQL if the result returned was False. But if it doesn't see the module, it can't get a result and determine what it is to do... *sigh* I have so much to learn.

Hrmm... good question. I guess because I'm reading through a book that's supposed to be teaching me the benefit of using macros... maybe I'll just skip these chapters and get back to the coding... It's rather sad - I've already found about 5 total errors in this "tutorial" book... I've had the...

The exact error I'm getting is "The expression you entered has a function name the Microsoft Access can't find" when I click on the macro.

Hrmm... I changed (and saved) the function (module)... still getting the same error... See below: Public Function TableExists(ByVal TableName As String) As Boolean On Error GoTo DO_FALSE TableExists = True DoCmd.OpenTable TableName DoCmd.Close Exit Function DO_FALSE...

I'm not sure - how do I check that? It's not "Hidden" if that's what you mean?

Has anyone found an answer to this? I am looking for the same answer and have eben unable to find it anywhere. I've built my macro and my module (with respectively named function within), but when I try to run the macro, it says Microsoft Access is unable to find the named function. What am...

Well, I went through and double checked and re-copied some of the smae files (overwriting the ones I'd previously moved). I made sure Access was shut down. It seems every time I log back in, I'm able to see more and more of those help topics that didn't exist before. I believe my problem is...

sorry I totally missed the "workaround" section on that page! When I copied all those chm files over, half of the missing help files showed up. Only problem is that ALL of the help files ending like (ADO) are still missing their help topics. *sigh* I'm halfway there... Thanks again, Jessa

nope Well, I ran all the updates recommended on the site. Already had SP1, got SP2 & 3. Still getting same error when trying to access the help files, as if they haven't been installed or linked properly... :(

thanks! That pointed me in the right direction. When I read over that info, I followed another link on the page to the "Office Updates" page that has a device to scan the page for updates much like the Windows updates page. Thanks! Jessa

None of the Access VBA help files are showing up within Access help. Instead I get an error message that says to check to be sure they were installed properly. I checked and double checked that all the needed links to help files were installed correctly. I even uninstalled and performed...

Sadly, it's from the "Sam's Teach Yourself" series - it's the Microsoft Access 2000 Programming in 24 hours book. Although, I suppose I am "teaching myself" by figuring out their mistakes to get their examples to work! Ha! ;) Thanks for your help :)

Ha! It seems all I need to do is post in here and I find my answer. The manual I'm learning from is WRONG! The "Field.ActualSize" should have been set to "Field.DefinedSize". You know? I'm so sick of correcting user's manuals. Maybe I should go into business as an editor. :P

New problem. I'm trying to display the fields & field info (not records) within my table, but when I run it, I get the error message "Run-time error '3021': Either BOF or EOF is true, or the current record has been deleted. Requested operation requires a current record." See following: Sub...

Thanks! I actually found that answer shortly after posting - I'm on 2000, just needed to set up the necessary references. I managed to get my CreateTable working :) Now I'm on to a new problem. I made a new post for it... "DisplayFields" trouble.

This is the code I took directly from a book I'm learning VBA from, and when I run it, I get a "Compile Error: User-defined type not defined" on the second line - "Dim Table As New Table", as well as any of the lines with "ADOX" or "ADODB" on them. Sub CreateTable() Dim Table As New Table...

Create a macro with two lines. Line 1: Open Form Specify the form name in the settings box. Line 2: Maximize No adt'l settings needed. That should do it :) Jessa

I don't know if I'm following you correctly on this, but couldn't you just create a form with a sub-form and link the child/master fields so that when you enter or pull up the Mfg info, you will be able to enter the Toy info into the subform? You can use the Form Wizard in Access to complete...

Yes, I noticed the same problem when I tried to connect my subforms through queries. It seems it works when you pull info to the forms directly from the table, but then I cannot seem to "bind" or "link" the subforms to each other despite their set relationships.

I'm hoping someone will reply as well. I've been watching your post because I'm looking for a relatively similar answer. I need to enter information for a software inventory DB. I have all the tables/relationships set up, but can't seem to set up a functional form that will let me enter the...