Search results

Google can sometimes be your friend: http://groups.google.com/group/comp.database.ms-access/msg/97378c41b2f482a8?q=sastray@comcast_SpamBegone_.net&hl=en&lr=&c2coff=1&rnum=1 Also: http://www.granite.ab.ca/access/pdffiles.htm

True, true...you could always split it up into a few seperate subforms, though. If you really wanted, you could (in theory) have 18 subforms filtered on the specific hole. I know there's a limit on nested forms, but not sure on the quantity of subforms. You may run into the same problem. This...

You need to use PivotTables to do this. If 'Counts' is actually performing a record count, then make sure 'Totals' is turned on ('View-->Totals'). Set CULevel, AREA, ASSET to 'Group By'. Then set Counts to 'Count'. If it's a typed-in value, leave totals off. Change to 'PivotTable' View...

Make your subform appear as 'Continuous Forms' instead of 'Datasheet' (the default format). You can then format it however you'd like.

One thought: Set the value of your field in VBA code on the 'After Update' event of the three fields.

The two properties you want to look at are, as CEH said, "Column Widths", as well as "Bound Column". Column Widths defines how wide the columns are and can be found on the 'layout' tab. They are ordered sequentially and seperated by a semi-colon. If you set a column width of 0, it will not...

I love the 'selected' check box--much better than my Temp Table idea. But I have to admit, I'm not a fan of your calculation method, as it would require accessing every single record and performing a calculation--meaning there would be 17000 calculations performed every time the script was run...

Multiply the Random function by the record count. Convert it to a whole number. Put it in a loop that runs based on the number of random records you want. Use a 'gotorecord' function to go to the specified record number. Grab the ID number and append it to a temp table. Then run a query...

Is Null No quotes, no "=". Just, plain, Is Null.

Sure! The code is quite simple: DoCmd.GoToRecord , , acNewRec OR DoCmd.RunCommand acCmdRecordsGoToNew

If the wizards aren't installed, you will have to add them using the Add/Remove Programs, and changing the settings for Microsoft Access. They should appear as the circled icon in the picture attached.

You may consider moving to 'batch processing'. I had to do this with a database myself. Kind of a PITA, but it worked; everyone was able to keep their info seperate. Basically, when the user opens FormA, have a popup form appear that allows the user to select (or create) a batch. Data is...

Why not? Set the recordsource to a query that filters on dispositionchk. I'm assuming you've linked the tables, so the table shows up in the table section of the DB. (I've gotta go, but I should be able to continue this later tonight).

Is the checkbox stored in the table, or only displayed on the form? I'm assuming it's stored in the table. If so, set the source query of FormB to filter on it. Make sure you save the record on FormA before you update FormB, though. "DoCmd.RunCommand acCmdSaveRecord"

OK. So this popup form displays those records selected in the first form? I assume "dispositionchk" is stored in the source table of formA? Could you not simply make the source query of FormB to show only those records that are checked? Wait...is the popup form always displayed? Is it just...

Two ways. You could use the various RecordSet functions to find and change the value in the second table. Assuming you've got some way of finding the correct record in the second table: dim db,rs set db = CurrentDB() set rs = db.OpenRecordset("table2") with rs .FindFirst "[<recordIDfield>] =...

Well, you seem to be doing fine. Similar to what you've got there, you would simply use the .addnew function of another recordset to add the record. Assuming the information you want to add to TableB is displayed on FormA, after you update the record you're editing, but before the if statement...

Wait...are both forms continuous? How are you selecting multiple records?

So I'm understanding correctly... You have a main form (FormA) in 'Single Form' format that gets its information from TableA. You have a second form (FormB) in 'Continuous Forms' format that gets its info from TableB. When you click on a button on FormA, you want to take some of the info from...

The code you posted is adding a new record. Is that what you wanted to do? Did you want to update all of the records in the source table or query, or only a subset? Is Quantity the record count we talked about in an earlier thread? Did you want to update all of fields in the table, or only...