Recent content by yeatmanj

I'm not exactly certain what bluegno is doing here, but my solution to this problem was a lot different. I converted the forms to unbound objects and did all of my manipulations using VBA code. In this way I was able to lock the records in different instances and save them to prevent the error.

Guess I should elaborate a little more. What if there are fields on the form that I want to exclude? One of my biggest issues with understanding this is how to declare the variables. Or even when to declare variables.

Good day all. I need help understanding For Each...Next statements. I have read a lot of help files and reference material, but still do not have a grasp of how to handle various objects. Most examples that I review show the syntax and explain what goes where, but I can't seem to find any...

Excellent. That is exactly what I needed. I was thinking in terms that were too complex and completely forgot the obvious. Thank you very much.

I'm familiar with the DCount function and how to use it in most cases. I have a bit of a special situation though. The parent table contains a relationship to a child table and is a one to many relationship. I need to determine which parent record has the most children before I can perform a...

Here it is. This is the code that I used to manipulate the 1-many into a 1-1 for exporting to excel or other reporting purposes. Feel free to help yourself to this code. I'm not particular. If you have better methods to suggest I'm always open for improvements. Keep in mind that this...

Yes, you are misunderstanding. Take two tables, one has a master record, the second has many child records. Make those appear in excel in a single row with a single export function without having to manipulate the data manually.

Alright, I have managed to work out a method for doing this. I will gladly post up the code as soon as it is fully functional. To help with that, could someone please tell me what is wrong with the syntax of this statement. It will be executed through something like DoCmd.RunSQL DoCmd.RunSQL...

ejstefl, thanks for the idea. pbaldy, ditto for concurring. Gemma, Because the users are not always computer literate. And, what the client asks for the client gets.

I've searched and read and searched and read. The one thing that is consistant is that no one knows or wants to answer this question. My database is normalized, however, if I want to export all records from the database where so many 1-Many relationships exist I end up with repetition of the...

I appreciate your input, but do you have an example that shows the proper syntax or way to reference a recordset object and have it perform the interations on a set of records. That is where my main confusion is. I have been unable to locate any information on how to use a for each statement...

I'm sorry to post this because I'm certain that there are a million threads about it. I just can't find them because the search function drops all the words except for Statement. That is an awful lot of results to go through, and when I'm working I just don't have that kind of time on my...

I've searched and searched, but this is the best example of how to create a table using code that I have found. The problem that I have is that the number of fields for the table will be variable. There might be 10 or 100 fields and the number will be determined by the number of records in a...

I have found a solution to this problem using a reference library called Redemption. It works very well at bypassing the security messages. Please make sure to read the site thoroughly because my knowledge of this library is as limited as yours and I will not be able to help answer questions...

Well, I can see either no one had an answer for this or it was a thread that was damaged after the board crash/hack/whatever. I have a similar issue, but the names on my text boxes aren't consistent. I don't understand how to use arrays to cycle through multiple textbox properties (if that is...