Search results

hi @tmyers agree with @Pat Hartman's comments. Picking good names is one of the hardest things to do! It seems that you're missing a Locations table. It would be kind of like your Pallet table except it wouldn't care what is in the space, just that the space can be used. It also seems that...

@Galaxiom, you're right, I should never say always -- with the big data anyway. However, I generally convert most all of them (that are read-only) just to shave off every possible nanosecond ;)

@mike60smart, adding on, If you want the user to get a message when a report has no data, there are 2 places to possibly do it in the calling program in code behind the report before DoCmd.OpenReport, perhaps you want to consider: 1. if report doesn't have any data, an error will be returned...

@templeowls, adding on ... anytime you have data that doesn't need to be edited, like the RowSource for a combobox or data for a report, using Pass-Throughs is a good idea for better performance. > new to SQL do you mean SQL Server or SQL, the language that queries are stored in? If the...

aside from each collection, there are other collections you might want to check, the ones for CurrentProject like AllModules, AllForms, etc -- they also have dates.

@Pat Hartman what dates were suggested? you didn't answer that ...

@Pat Hartman It has never been important enough to me to compare all the dates, but since you seem to care so much, which dates did Ben say to use? To me that is something fairly trivial compared to everything else.

@eprous, ah, what you want to do then is set the focus to your first control in the form Load event: me.controlname.SetFocus

hi @abenitez77 here is some code you can use Sub RenameCopySheets() Dim i As Integer _ ,sName As String 'rename first 4 sheets For i = 1 To 4 Sheets(i).Name = CStr(2021 - i) Next i 'copy first 4 sheets For i = 1 To 4 sName = CStr(2021 - i)...

hi @eprous > "Is there any way to force a form to go to the first page whe the load finish" you can use DoCmd but I prefer not to do it with macro commands, Instead, I like this: me.Recordset.MoveFirst "me" can be another form reference ~

dates are stored in multiple places, it just depends where you're looking. If the Navigation Pane gets it, then it's somewhere. > Making a value correct shouldn't break anything. surely you're joking. It's been wrong for years, probably always. And the code that writes to it was created a...

thanks, @Pat Hartman >really hoping that you had figured out the problem and when I found that you hadn't, I was so bummed I just forgot to thank you for what you did do The dates are different. That IS the problem. All the Analyzer does is document what's there. Obviously it can't fix...

@Pat Hartman -- nothing positive? Really?!? I spent hundreds of hours on the Analyzer and didn't have to share the tool or the source code but I did. So far, everything I've posted has source code because I'm a teacher. Only reading negative comments from someone is disappointing. >...

hi @Pat Hartman I found a discrepancy between the dates too ... and also have SQL similar to yours for quickly getting information from MSysObjects -- always interesting though, to see how you do it, which is a little different. Thanks. In the Analyzer, if I recall right, a_Objs table gets...

the report designer is like the form designer, so if you can modify forms, you can modify reports the same way :)

the problem with your example is the extra spaces and the string inside the string Nz(txtContract, " '' ") should simply be Nz(txtContract, "") > constructing an SQL string in code so maybe Nz(txtContract, """") or Nz(txtContract, '') inside a string delimited with double quotes, if you want...

ps, @mastermithi, adding on Here are a couple videos about Access reports that might be helpful for you: Create a Grouped Report using the Wizard in Access, then Modify it Polish Reports in Microsoft Access

hi @mastermithi the wizard is limited. To get more controls containing fields, you need to modify what the wizard creates -- or just make a custom report to begin with

ps, @GUIDO22 As for records in tables, the dates stored in MSysObjects and the tabledefs collection are for when design changes were made, not when records were added or changed. To track that, it's helpful to add these 2 fields to every table: dtmAdd, date/time, default value = Now(), when...

hi @GUIDO22 While MSysObjects does store DateUpdate, I seem to recall that using DAO (as mentioned by @CJ_London) gets a different value ... here's a free tool with source code that may be helpful for you: Analyzer for Microsoft Access http://msaccessgurus.com/tool/Analyzer.htm