Search results

directing back to the topic of this thread .... contacts side topics are great .... always learn something new ~ I posted a link to 2 examples to help with the question about structuring contacts. @twgonder liked but @HealthyB1 had trouble downloading ... and I want to know if that was caused...

you may need to remove Mark of the Web from the zip file. Here's a link with steps to do that: https://msaccessgurus.com/MOTW_Unblock.htm Does that do it @HealthyB1?

hi @twgonder I have 2 contact management systems with source code in Access that you may want to look at to get ideas. http://msaccessgurus.com/tools.htm#Contacts The Contact Management Template is older and more robust (and also has many extra tables so just import what you need). MyContacts...

first thought is to either: 1. create a batch file and run it or 2. loop through files and compare each to the mask to see if it needs to be deleted ? hopefully this code can give you some ideas Function CreateBatchFile(sMessage As String) As String '160711 strive4peace 'this code creates a...

@tmyers, on the different warehouses ... how many warehouses are there? If lots, do you still use same IDs for Aisle, Bay, and Shelf, or are they specific for a warehouse? In other words, are they numbered so you don't have to know dimensions for each warehouse or will you need to know that too...

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 :)