Search results

thanks John @NauticalGent > DataPig ... short, to the point and very easy to watch. Here are links to the 2 batches of them -- one for queries and one for forms playlist ~ Datapig Queries https://www.youtube.com/playlist?list=PLis0tV85b5t4eWAaKDBR9l2XQY23FqvG4 playlist - DataPig Forms...

good it's working for you, @accessonly11 ~ happy to help. Guess next you'll figure out how to change the controls at the bottom ;)

@accessonly11, adding on to @Gasman's comment ... if you want a control to only be calculated, you can put an expression in the ControlSource. However, if you want to be able to change the value, as you would if you're storing a point-in-time values for an order, the ControlSource must be a...

@Leo_Polla_Psemata, adding on ... here is a presentation about the online SQL converter I mentioned from AccessUserGroups Access SQL ➔TSQL converter tool by Ben Sacherich and Aaron Kogan, host Juan Soto (47:08) I actually don't do it this way myself as I've written my own tools, but a good...

@Leo_Polla_Psemata, for converting SQL to VBA (or TSQL), here's another useful link: https://accessusergroups.org/sql-converter/ As for breaking long lines, in the SQL I like to replace comma with line-break, Space(3), comma (since I like to put commas at the beginning of the next line so it's...

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