Search results

recently ... this may be of interest to many of you: Using SQL Server with Access, by Maria Barnes (1:02:31) read video description for links

This week, UK is on standard time and America is still on daylight-savings time (we don't switch till next weekend) ... so for Colin's meeting Wednesday TODAY! if you're used to going and think it is the same time ... the time is 1 hour later in America. George is presenting...

actually, you don't even have to do all that ... if the Data Type is Integer instead of YesNo, you can set Format to something like this (the Format property supports Unicode): ☑[Magenta];☑[Red];☐[Blue];-- btw, it seems that Yes/No is actually stored as an integer -- but capabilities have been...

indeed! decimal Unicode character for ChrW 9744 ☐ BALLOT BOX Checkbox open 9745 ☑ BALLOT BOX WITH CHECK Checkbox checked 9746 ☒ BALLOT BOX WITH X Checkbox X

its not necessary to change the font if you use Unicode characters

@JMongi, I also made a video to use a unicode character in a textbox for YesNo here that might give you some ideas: Big Checkbox in Access with Conditional Formatting

for those of you starving for an online user group meeting to attend for Access ... Mike Wolfe (nolongerset.com aka @NoLongerSet ) posts an article each week about Access that includes online user group meetings that are coming up, as well as what's come to his attention for the past week that...

here is a most excellent presentation by Colin @isladogs. The content is interesting and useful ... and the delivery is one of the best I've ever seen. Colin is such an amazing teacher. AEU: Optimising Queries & the JET ShowPlan (Colin Riddington) (1:08:39)

@Panayiotis, nothing to aplogize for! You're busy doing the actual tasks and Access will be a wonderful help once it is set up. The sooner that happens, the sooner time to track things can be alleviated ... but meanwhile, business must go on ... and you also have quite a learning curve ~ Take...

@SachAccess > Need help to understand Linked Table Manager. the Linked Table Manager tool helps you change the path(s) to your back-end(s) > the purpose of Linked Table. use linked tables when more than one person will be using the application. If that is the case, put tables in a different...

@SachAccess, here's another SQL statement to get info from MSysObjects for object names and types that uses SWITCH to specify the object type and ordering ... it also filters out temporary stuff SELECT...

the next online user group meeting is tomorrow, Wednesday 7 Sept at 18:00 (6PM) UK time Optimising Queries and the JET ShowPlan by Colin Riddington (@isladogs) https://accessusergroups.org/europe/event/access-europe-2022-09-07/ It looks like it will be very interesting!

32 to 64 bit conversion here's Peter Cole @petertheme presentation on 32 to 64 bit conversion for Access Europe

Word Document Properties and Fields Not a presentation, but I just posted an interesting video on YouTube about using document properties in Word to substitute data in documents that you might like if you do a lot with Word: Word Document Properties and Fields (14:06)

you're welcome, @accessonly11 -- glad everything is working for you now

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