Search results

A2003 on Win XP. Tables called "Master" and "Detail" in a one to many relationship. I have a report that uses a Master table linked to one or more records on a Detail table. The report is based on a Query. The report currently prints multiple Master records if there are multiple Detail...

I don't think I was clear. I don't want to update a record in MyDetail table, I want to append a record to MyDetail and set GID equal to the Master table's GID, and set MyDetail!JobNum to txtJobNum.

I loop through my master table using a DAO ecordset. I'm doing this but Access is not saving my JobNum to the Detail table. Right after my Master recordset does an Update, I do an INSERT INTO on the detail recordset to add the new record. The point is to add a JobNum to the Detail table...

A2003 on WinXP. I mentioned I'm not to good at SQL, but I perused an SQL summary of commands and was unable to figure this out myself. I have a Master table and a Detail table. While looping through the Master table where the key field is "GID", I want to update the Detail table, where the...

Shouldn't the OP only index query fields that have criteria? I thought those were the only fields that needed indexing.

Instead of this: xlWSh.Range("A2").CopyFromRecordset rst Can I set the value of a specific cell as I loop through each record, like this? xlWSh.Range("A2") = myvalue where A2 is the cell I would manually keep track of in my code. As you can see, this Excel stuff is new to me.

Doesn't Access have a limit on the number of characters in a query field? Can I enter 5000 characters in this query field? I also need to do looping to check other things against the field value, as well as substrings on the field, plus concatenations. In my application I import a spreadsheet...

I would suggest at least a 100mbps network interface for Access2007. Who knows how much bloated overhead it uses. Talk to your IT person.

I can't do that. I have to loop through the spreadsheet, do complex calculations not allowed in a query, and manually write each record to a new row in the spreadsheet.

Thanks, Gemma. I always use Insert, Sub so it always comes out with the Public keyword for me.

This does not break normalization rules as he isn't duplicating keys, only specific information. I used to do this a lot in a school, as there were multiple students with the same address and phone number and other information. When entering many students from the same house, it is useful to...

Yes, click on the scale to the far right of the username in the post. I have 79 posts. I gave Dcrake one reputation, then tried to give him another in a different post. The error I got said I had to spread reputation around first, which I assume to mean it was too soon to give him another...

Thank you! I tried to give you reputation but I just gave you some on another post, so it seems too soon for me to give you some again. I got an error from the website.

Thank you Dcrake. Now I know it's possible, I do have that information, and I'm only updating one field on one table for each record I'm looping through. Oh, since I'm not an expert in SQL, doesn't every SQL statment need a semi-colon at the end?

If you omit the "Public" keyword then they are global only to that module or form. If you use the Insert menu, Sub and choose Function, Access puts in the "Public" keyword for you. I believe a public function declaration looks like this: Public Function blah(s as string) as integer end...

Shouldn't it go like this: Set rs = db.OpenRecordset(strSQL, dbOpenDynaset) rs.edit ' NEW LINE Name = rs!Person rs.update ' NEW LINE Set rs = Nothing Set db = Nothing

I guess my question really was, is it possible to do an UPDATE sql statement while the recordset is open and pointing to my current record? My thought was that record would be locked and there would be no way to update it through any method.

I understand the terms you are using, but not sure how they apply to database programming. Not sure what you are saying. All the time I loop through a recordset, do some calculations, like concatenating strings. Especially when I am created tab-delimited text files, which is what I am doing in...

A2003 on WinXP I have 2 variables which, when concatenated, construct a field name in my DAO recordset. How do I read/write to this field in my recordset? Ex: s1="A" s2="3x4" fn=s1 & s2 ' the real field name in my DAO recordset debug.print Myset!(fn) ' Is this right? Thank you!

Access 2003 I am looping through records in a recordset. While looping and reading, for each record I want to write to one field of one of the tables and store a calculated value. I want to update a recordset, but this recordset is composed of multiple tables, and cannot be updated. I just...