Search results

hi @accessonly11 > "it will change the values of entire column, not only the row cell" you must have a field in the source table to store the value, and that field should be the ControlSource of a control on your form -- which is what the code wil refer to

@accessonly11, you can use the AfterUpdate event of the combobox to store point-in-time values in order details. For instance: With Me.ProductId If Not IsNull(.Value) Then Me.RetailPrice = .Column(3) 'or whatever column it is End If End With

@Leo_Polla_Psemata, I did a presentation about creating Word documents from Access without a template. Links to the download files are in the video description. There is lots of code you can reference and a sample database with more code. Word Automation from Access VBA Deep Dive by Crystal...

hi @accessonly11 why not? (EDIT: didn't see @GPGeorge's comment whilst writing mine ... same reaction) As @Gasman suggested, best would be to add that query to the RowSource for your combobox. And then add controls that reference other columns to display values if you want to also see them...

I agree, John @NauticalGent -- Karl covers things going with Access in an entertaining, creative way. Now there are more 'Access News' videos by him -- latest is here: I like your idea, @Jon -- especially if there is a good way to FIND videos relevent to what you want to learn about like...

excellent news, @Jon ... thank you too -- nice to have this great forum for Access. Congratulations, Colin @isladogs, very happy that your brilliant, insightful, creative work and propensity for sharing is officially recognized by Microsoft with the MVP Award!

@Rmaster2022 if you trace the origin of the error message, you'll see it isn't coming from the report itself (Report_NoData looks ok). When you open the report, instead of testing for a specific error number if there's a problem, an easy way is to skip any error message. If the report doesn't...

if anyone can figure it out, it is you ;) ~ good luck @isladogs Colin . Hey an idea for your interface ~ textbox to enter pattern with wildcards like q*vid*stat*

very interesting approach, Colin @isladogs. Cool design and functionality! I didn't know about "Shorts" ~

hi @SachAccess > "return name of all the Queries, Reports, Form and Modules from the DB" adding onto Pat's SQL on the MSysObjects table ... this uses Switch to sort and elaborate. Make a new query, switch to SQL view, and paste this in! SELECT...

@Ihk, perhaps Echo is False? and then a pause (sleep) then Echo True again? http://msaccessgurus.com/VBA/Code/API_Sleep.htm

interesting -- gobbledygook too ;) @GPGeorge knows so many impressive words ~

Access has a new Microsoft MVP, hooray! Welcome to Colin Riddington @isladogs Colin has deep knowledge of Microsoft Access and builds impressive, creative applications. He shares his knowledge on forums, in videos and presentations, and has lots of information for developers on his website...

If the data is in Access, True is -1. However if data is in SQL Server, then True is 1. False is always 0. Therefore, to test for true, I like to test for <>False or <>0 EDIT: Yes/No's bit is stored in a byte unlike the byte data type whose range is 0 to 255 I often store Yes/No as an integer...

thanks for testing @Gasman and @HealthyB1 I uploaded MyContacts again -- please let me know if this one works: https://msaccessgurus.com/tool/MyContacts.htm#Download

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...