Search results for query: *

I'm using Access 2000. My users enter one of four values via a textbox, the entered value is found in the "many" table and the linking field is stored to a variable I call FoundPNR, The main form displays the data from the "many" side of the one-to-many relationship in a listbox. I want the...

I'm using Access 2000. I have 3 files, the strucures are: FileA: Category = primary key Mftr, Location, Address FileB: Category, SubCat, SerNr, PartNr, Model. (primary key is category & SubCat & SerNr) FileC: Category, SubCat, PartNr, Trouble, DateIn, DateOut...

I'm using another person's mdb as a learning tool and when I run the analyzer-documenter the following code is shown at the very beginning of the code section of the documentation, but I cannot find it *anywhere* in the application. Can anyone tell me what this is, is it necessary? how would I...

I have a form where the user inputs the data they want to search for and clicks a "search" button which runs an SQL statement. The results of the SQL is the rowsource for a listbox. All is ruuning fine except I want to display a msgbox stating "No Records Found" if none were found. I cannot...

My Problem: When running the code below I get the "Run-Time Error 3001 - Invalid Arguement" error message when it reaches the dbs.properties.append.prp line. This code is a modified version of code that is posted in this forum. I'm using Access 2000 and just testing this so I have it attached...

I have been working from the searchdb.mdb that I "found" on this forum and can't find again to give multiple stars - it's a Gem. :-) I have modified it to suit my needs and it's perfect, but I would like one more enhancement that I don't know how to do. The current SQL retrieves if the user...

I would like to use the "Find Record" button on one of my forms, but the users that will be using it only have read-only rights. Can I disable the "Replace" portion of this button in anyway? Or, if I set the network permissions on the drive containing the data to read-only will the replace...

The background: A user selects 1 of 4 fields to search on by selecting from an Option Box, this selection opens a 2nd form, the user then enters the desired criteria into a text-box on the 2nd form and clicks a "search" button. I'm ok to this point and have the values of both forms (option and...

I want to GoTo a Label and then return to the line below to GoTo - Can I do that in vba? If so, what's the command/syntax. An example: FIRSTSUB: Msgbox "Message One" GoTo SubTwo MsgBox "Message Two" SUBTWO: MsgBox "From Subtwo" As always, thanks for any input. Pam

When using the documenter I noticed that it doesn't list my DELETE queries - is there a way I can get them included? Thanks in advance, Pam

When running the code below as the on-click event of a button on a form, I receive the error message "Object doesn't support this property or method" when it gets to the line: If vartype = "SPECIAL" Then Can anyone tell me what I've done wrong? I really, really appreciate all the help...

I'm new to ACCESS and becoming familiar with forms, but how do I simply read in a file, manipulate the contents of one or more fields, replace the fields with their new value and/or write to a second file and then to the next record in the first file?? This has got to be right under my nose...

I need to be able to manipulate dates in the following way: Add x number of months to a given date and have the results precise enough that if I add 3months to 30-Nov-2003, the result is 29-Feb-2004, If I add 3 months to 30-Nov-2002, the result is 28-Feb-2003. Also if I add 30 days to...

My company is switching from FoxPro/VFP to MS ACCESS 2000. I have ordered Access 2000 Desktop Developer's Handbook and the Access 2000 version of Visual Basic for Applications step by step. I have to convert all my programs and forms. These are not terribly sofisticated, but are important to...

I'm interested in taking or buying a good "self-teach" course that will cover forms and macros to the advanced level and also ACCESS SQL, a little vba coding wouldn't hurt either. Can anyone give me the name of some good courses/web sites to check out etc. Thanks in advance, Pam

How can I get an SQL query to produce a count of the total number of records in a table? I am using Access/97. Thanks for the help, Pam