Copilot, Access, and VBA
I don't know how many of you use Copilot to assist you with Access. I developed my own application using Copilot and it was extremely helpful. I recommend you give it a try to see if it can help you. Here is an article I wrote on it in case you're interested: https://medium.com/@jmsp4home/did-my-own-spending-income-tracking-software-using-microsoft-copilot-heres-why-and-how-it-went-1aa8b4814cca?source=friends_link&sk=64ebb3ecf7e5b19c05d1731a571b1001
Link a table from MS Fabric
Is it possible to link a table stored in MS Fabric Dataflow Gen2 to an Access database? The data set is roughly 500k rows of data. FYI I'm not trying to link Fabric FROM an Access database. Rather I would like to work with the data in MS Access. Any help would be appreciated.
VBA code copies an Excel template into a specific workbook which is in the cloud - hangs randomly
My client has a small application which effectively, using Access VBA, copies an Excel template to a systematically named excel file, populates it, and then saves the destination excel workbook file. It hangs "randomly" , claiming it cannot find the renamed destination file, at copying time - one filesys copyfile statement - before it has been populated. The Access is running on 1 PC in a lan but the excel files are stored in the cloud - OneDrive. I think that the short process is too fast - sometimes - for the cloud to find / create the destination excel file. I also discovered that a newly arrived Excel advice banner was a problem. I "upgraded" the original Excel template as advised and this issue disappeared. But the "can't find" issue is not new. Any similar experiences?Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes
The next online meeting of the Access Europe User Group will be onWednesday 6 Dec 2023starting at18:00 UK time (6PM UTC)and finishing at about 19:15 (7.15PM). In this month's session,Mike Wolfe (MVP)will be leading a presentation calledStreamline Your Import/Export Spec Workflow with VBA Classes. For more details about the topic and speaker together with connection details for the meeting, please visithttps://isladogs.co.uk/aeu-22/orhttps://accessusergroups.org/europe/event/access-europe-2023-12-06/ The meeting will again be held onZoom. When the time comes, you can connect using Join Zoom Meeting. If you are asked, use:Meeting ID: 924 3129 5683 ; Passcode: 661210 For other local times, please checkhttps://www.worldtimebuddy.com/ NOTE: For our friends in the USA & Canada, I recommend you do re-check time differences now that its Winter Time for you as well as in Europe.Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools
The next Access Europe meeting will be onWednesday 6 Sept 2023starting at18:00 UK time (6PM UTC+1)and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please checkhttps://www.worldtimebuddy.com/ In this month's session, I will be demonstrating my newDatabase Analyzer Proapplication. The free evaluation version is now available for download from the above link on my website If time permits, I will also be discussing a number of related Access examples and code samples such as: • the use of progress bars • creating a table of contents in Access reports • the undocumented SaveAsText/LoadFromText features • changing query views using command bars code For more details about this session, see:https://accessusergroups.org/europe/event/access-europe-2023-09-06/orhttps://isladogs.co.uk/aeu-19/ The meeting will again be held onZoom. When the time comes, you can connect using:Join Zoom Meeting. If you are asked, use:Meeting ID: 924 3129 5683 ; Passcode: 661210 For more connection options, please see theAccessUserGroups.orgweb page for this event All sessions are recorded and later uploaded to theAccess User Groupschannel onYouTube I hope you will join us for this month's session. As always, the session will be recorded and the video uploaded toYouTubeafter the event NOTE: I regret that the planned presentation on Better Access Charts by Thomas Moller originally scheduled for Wed 6 Sept has been postponed until further notice.Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor
The nextAccess Europemeeting will be onWednesday 2 August 2023starting at18:00 UK time (6PM UTC+1)and finishing at about19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1).For local times, please checkhttps://www.worldtimebuddy.com/ In this session,Juanjo Luna(MVP) will demonstrate how to create applications for any type of platform usingBlazor. The approach used will be forVBA and MS Access developers. You will learn what the learning curve is for this technology and be able to create your first application in an hour. This means an end to limitations of being unable to offer services in the cloud and on mobile devices. For more details, see:https://accessusergroups.org/europe/event/access-europe-2023-08-02/orhttps://isladogs.co.uk/aeu-18/ The meeting will again be held onZoom. When the time comes, you can connect using:Join Zoom Meeting. I hope you will join us for what should be a very interesting session. As always, the session will be recorded and the video uploaded toYouTubeafter the event I regret that the planned follow-up presentation on Better Access Charts by Thomas Moller on Wed 6 Sept has been postponed. Details of the replacement session to follow
Dynamic reference to array
Hi, it's been a long time since I've done any VBA code within Access. I have a situation where I globally defined 2 arrays. Dim a1() as string Dim a2() as string Within a Sub routine, I need to call another sub routine passing the an argument for either one of the two array names defined in the global area. I'm struggling to figure out how I can add values to the correct array dynamically. sub addRecs(Byval arrayName as string) arrayName(1) = "new value" end sub When I run it this way, I get an error stating it's expecting an array.
Rating system problem
To start out with, this form is used to rate things using a five-star method. I have a combo box that a user can select a category on which they wish to rate the transaction on. Once they select one and decide to add it, I have VBA that adds that selected category to the database and requeries a subform. The subform is linked to the overall record. The entry is listed in the subform and has 5 empty stars and the user can click on the star and it, as well as the previous stars, get replaced with a filled star. The images are merely placeholders and the actual rating, 1 to 5, is stored as an integer. Everything works to this point. My issue is, when the user tries to select a star, all the ratings for all the other categories are also mirrored. I am sure it is something very simple I am overlooking but I just can't put my finger on the issue. As the 5 placeholders are individually named but duplicated for each record, my code does not know specifically which entry it should stick to. Can anyone help me on this; point me to a tutorial online or help anything to help rattle my brain My continuous form looks like : This is subform in the actual form with the Rating category combobox. The Overall Rating works like it should. Any help and guidance is greatly appriciated
help acces office 365
hello if we say that I am a beginner I want to make the database I already have the table that is with the relevant data of a person name surname etc but I want that search bar that I look for a name and then the data of the person appears I don't know if it is possible for you to send me a video or the step by step to make that search bar work, please, and also do the same as the template you have, but there is some data that doesn't work for me, so no I know how to do it
