Search results

GOOD, BASIC Explanation!! You read the part that said I was new to this and wrote accordingly. This will help because I did not know what needed to go in a form/control and what needs to be played with in VBA. Big Help, Thank You..

THANKS AGAIN to all those who have helped me on this #@R database!! I know this can be done, but I want to do it the right way My Form has a combo box with these fields: ID 1-4, unique location: north, south, etc. (text) seqnum: Numeric/Integer loccode: (location code) N, S, E, W...

ok, i understand that having to refer to a table is not required unless the field exists in another table of the dbf? I understand the last sentence, but the BTW lines and other stuff make no sense all. As mentioned, this is the first endeavor with access. I had other people try to help but...

I have two tables that i am trying to put in a form. The first one works cbolocations/qrylocations, but the Equipment table does not. I added the table to the form as a query and changed the control sources for each textbox to bind the textboxes to the appropriate fields, but I cannot edit or...

found the info that I need, I think. subforms.

Thanks to all that have helped before, I understand a little better now. On a form I have a query that updates a table eventually. That works so far, but I need to add another table to the form. Can I do that? HOW do I do that if I can? I tried putting in a record source on the form with the...

Bob, thanks for the reply. The reason I am doing it this way is right now it doesn't have to be pretty, it just has to work. For future reference, are you telling me that I can go into the properties of a text box like "text92", choose Properties, Control Source and put the "bind" there...

Thanks John, but I did not explain this very well cuz I still don't know much about Access. I am using ADO and won't use DAO regardless. This is what I want to do and the way I want to do it. If there is a better way, it can wait till I understand more. 1. Create a form with text boxes...

1. is a recordset nothing more than a table? 2. if i have a field called fldA in table tblA, can I/How do I store the value of that field in a VARiable??? 3. within a vb event procedure, can i close one table and immediately open another? how? 4. can i have more than one table open and...

To the person from my last deleted thread that wrote DEMO.ZIP: Thank You Very Much. That code and data structures are so streamlined vs. what I wrote that I am embarrassed. Good, that means I have tons more to learn. Thanks to ALL, I learned more than I realized I needed.

Capiche. Thank You John.

John: this is all the stuff so far. If you go down to the 3 rows of asterisks (*'s) you will find the dmax function you suggested and the R/T Error it is giving me. I understand that Fn, been using it for decades. Thank You, big help, very simple...

ok, Thanks. Please read what i wrote to Gizmo as an explanation of what i really need this to do. This is not written traditionally as 1 record per item IN THIS TABLE; that comes in another table and is the easy part. True or Not?: If you have a One Record table with integer datatype...

no. sorry for the ranting and bitching earlier. i hate access cuz I was brought up on R:BASE System V, c.1986, and learned the right way to write dbf code. yes, i know this is object-oriented programming and the other is dos stuff but I got spoiled on good software early (ANSI 68 COBOL for...

Need help to get past this pothole in my app. I have a 1-Record Table called SEQ (sequence number table). There are 8 fields corresponding to 8 different locations and are named as SEQBI, SEQLH, SEQPL, etc. ------------------------------- The thing about this is since there are 8 locations...

Thank you, but that is not even remotely close. I am stuck with Microshaft Access cuz I don't want to spend the money for R:BASE 7.5. I could have this problem solved in the 1985 Version of R:BASE System V in 2 statements.

I am new to this stuff so pls do your explanation accordingly. I have an access table called SEQ with fields such as SeqA, SeqB...Seq?, etc. These are Integer fields that store one sequence number for a particular location (A,B,C...). I have an optiongroup that asks for the particular...