Search results

As far as I can tell, Randomize doesn't do anything for the recordset. It's used if you want to generate a random number in VBA. https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/randomize-statement Dim MyValue Randomize ' Initialize random-number generator...

Have you done any search? Student database really is a common topic. Start with a review of MS Student database template https://support.microsoft.com/en-us/office/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb

Right, NavigationSubform container on NavigationForm object does not have master/child links. Considering primary purpose of NavigationForm to dynamically display different datasets - one at a time - that don't have shared parent, the main form commonly doesn't even have a RecordSource. An...

Click the </> icon on post editor toolbar. I am not really understanding what you are doing. Why would subforms need to "sync"? Why would different subforms have same data? That's why I asked if you could provide db.

Documenter doesn't allow that level of selection. Get all fields. But can limit to Name, DataType, Size so maybe not so bad to pull all fields. I just tested Documenter. I get a report so not direct to printer. Even with limited output, a 6-field table produced 3-page report with a lot of...

Should post code in a CODE block to retain indentation and readability. Have you step-debugged? Could you provide db for analysis? Comparison to "SELECT * FROM Coredata" might never be equal to RecordSource SQL because it lacks semicolon at end of SQL string. Access tends to add them. Why...

TMK, the documenter only goes to printer. So if you don't want to chew up paper, roll your own. Or maybe first set default printer to MS PrintToPDF and maybe it will output to PDF.

Review: http://allenbrowne.com/func-06.html https://www.utteraccess.com/topics/2066511/posts/2827647

CJ, good catch. I tested this with a subform in Datasheet. Code behind main form: Docmd.Close , , acSaveNo Datasheet changes are not saved. Nice. Disable the X close: CloseButton set to No Don't even show: ControlBox set to No You tried what? Just copying a file into folder?

Would security prohibit splitting db if both files are in same folder? You haven't had issues so far but it is still safer to split, even if only one user at a time. Good luck with your project.

And if there are multiple child tables, can still customize field names so they are unique.

Alternative is to keep Datasheet, let users adjust as they wish then when form closes (or maybe when opening), use code to set column widths and maybe order because changing order is also a feature of Datasheet...

If this db has multiple simultaneous users, you should plan on corruption of data and design. Or so I keep hearing that is expected. I have designed one multi-user db that wasn't split and in 4 years it never corrupted. But it was very small with no code, not even macros.

Make it a Continuous form arranged to look like Datasheet. But why is this an issue? Database should be split and each user have their own copy of frontend.

The table named tblJunctionTransaction is not a "junction" table. Purpose of a junction table is to associate data of two other tables in a many-to-many relationship. What you have is simply a dependent table. What is purpose of this table? However, tblCheckCat is a junction and I don't...

My vote is to delete the BegNumb field and move on.

Ideally, data would be validated during data entry, however, sequential nature of this data still complicates any effort in this regard for multi-user db. User A input would have to be saved before User B input could be validated. We still don't know what constitutes a "gap". Doesn't sound like...

Another consideration is that workbooks with lots of rows get very sluggish.

Okay, in new record QtyStart is set with a default value derived from QtyPlanned. It's not clear to me why or when QtyStart would be changed.

Agree with CJ - keep numbers and discard everything else. More than one way to accomplish but all most likely need a loop structure. Here's another: Function GetNums(s As String) As String Dim x As Integer For x = 1 To Len(s) If IsNumeric(Mid(s, x, 1)) Then GetNums = GetNums & Mid(s, x, 1)...