• 
  Using TempVars in field definitions in SQL queries

  by Petrol

  Is there anything intrinsically wrong in using a TempVar in a field definition of an Access SQL query?
  As a simplified test I have witten a simple query qry_LOI3 thus:

  Code:

   SELECT EventTypes.EventCode, [TempVars]![Drv] AS Expr1
  FROM EventTypes;

  The datasheet it generates is shown in the attached screenshot.
  I then try to open it as a recordset, thus:

  Code:

   Public Sub TestProc()
  Dim db As Database, rs As Recordset
  Set db

  ...

  • Channel: Access

  1 day ago
• 
  g a TempVar in an Access SQL query

  by Petrol

  I was under the impression that TempVars could be used in SQL queries, including in the Criteria field, but this seems not to be the case.
  I wrote the following test query:
  

  Code:

   SELECT People.PersonID , Board_service_h istory.Communit yCode
  FROM People INNER JOIN Board_service_h istory ON People.PersonID = Board_service_h istory.PersonID
  WHERE (((Board_servic e_history.Commu nityCode)=[TempVars]![communitycode]));

  and tested...

  • Channel: Access

  4 weeks ago
• 
  Outlook automation options

  by Petrol

  When I create an email directly in Outlook, it gives me options to select the email account to use (the 'From' dropdown) and the address to direct replies to ('Delivery options'). I can't find any way to implement these options uning Mailitem.Send. Is it possible?

  • Channel: Access

  4 weeks ago
• 
  slow code in Python

  by Edgar458g

  Hi everyone.
  I’m new to Python and ran into a small problem.
  I wrote a script that works fine with small files, but when the file gets bigger, everything becomes very slow. No errors, just takes a long time to finish.
  Is this usually about loops or reading the file line by line?
  What is the first thing I should check to make it faster?
  
  Thanks in advance....

  • Channel: General

  Dec 22 '25, 04:05 PM
• 
  r6v4/h1d1 is a fast and free web server.

  by linshunzhi

  https://r6v4.app/
  hello, i share a not open source linux web server. which faster than nginx.
  https://drive.google.co m/file/d/1LQ7lpSRYI7c3JM Pk-1cIxcnykzUF0yq0/view?usp=drive_ link...

  • Channel: Linux

  Dec 22 '25, 03:55 AM
• 
  CBDC Resources – A Global Data Hub for Central Bank Digital Currencies

  by Dimension

  CBDC Resources is a comprehensive and data-driven hub focused on global Central Bank Digital Currency (CBDC) developments. The platform allows users to explore:

  • Interactive global maps showing CBDC project status (Exploration, Pilot, Launched)
  • Country profiles with objectives, motivations, timelines, and underlying technologies
  • Technology provider profiles and comparative insights into the solutions used in different CBDC pilots
  • A curated

  ...

  • Channel: Product Launch

  Dec 12 '25, 11:33 AM
• 
  Why doesn't my SetFocus work?

  by Petrol

  I have several forms containing bound controls in which a phone number is to be entered. Because I want the saved text string to include spaces here and there (e.g. 07 1234 5678 for land lines, or 0412 345 678 for mobiles), I have a function which reformats the given text string. Since the control is bound to the requisite control source, the reformatted phone number is automatically stored in the record. The function is called from the AfterUpdate...

  • Channel: Access

  Nov 16 '25, 08:12 AM
• 
  5 Free AI Tools Programmers Should Try Now!

  by jeffreestar

  AI is changing the way programming and content creation work. If you are a developer or working in technology, don't miss these 5 super cool free tools:
  
  CodeGPT – Write and optimize code with just a short description.
  
  Runway ML – Create images, videos, and AI effects extremely fast.
  
  Chatsonic – Multi-purpose chatbot, from blogging to data analysis.
  
  Tabnine – Automatic code suggestions, saving...

  • Channel: Artificial Intelligence

  Nov 10 '25, 04:06 AM
• 
  Compact and Repair causing errors?

  by Petrol

  My Access database appears to run correctly, and it recompiles without error. However, if I run a Compact and Repair, when the database reopens I get the error message "Invalid databse object reference" - without, unfortunately, mentioning which object it is referring to. See attached screenshot. Then it says either "The expression contains an ambiguous name" or "The expression you entered has a function name that EmmausDBMS...

  • Channel: Access

  Nov 7 '25, 04:49 AM
• 
  Azure Functions scaling issues that were not expected during busy times

  by Ruth12

  Hey Everyone!
  
  Just moved some of our serverless work to Azure Functions.
  
  Scaling works most of the time, but I've seen that some functions take longer to run or even get held up for a few seconds during busy times, which is bad for users.
  ...

  • Channel: Microsoft Azure

  Nov 4 '25, 09:44 AM
• 
  Kamal Hinduja : How POST requests handle byte data in programming?

  by kamal12362

  Hi,
  
  I am Kamal Hinduja based Geneva, Switzerland(Swi ss). Can anyone explain How POST requests handle byte data in programming?
  
  Thanks, Regards
  
  Kamal Hinduja Geneva, Switzerland...

  • Channel: Product Launch

  Oct 28 '25, 05:30 AM
• 
  Adjusting the height of a report entry in VBA

  by Petrol

  I have an Access report whose records in the Detail section usually require two lines, but occassionally a message needs to be displayed for a particular record. This message is in the form of a label in the third line, which is made either visible or invisible, depending on a flag within the record. To avoid wasting space, I want to adjust the height of the entry to accommodate the third line only when required. The flag is checked, the label.Visible...

  • Channel: Access

  Oct 23 '25, 11:23 AM
• 
  How to trigger the Format event for a report section

  by Petrol

  Does anyone know the magic trick to make the Format event fire for a report section? I have a simple event procedure linked to the On Format property of the Detail section, but it doesn't work.
  learn.microsoft .com assures me "For report detail sections, the Format event occurs for each record in the section just before Microsoft Access formats the data in the record"; but setting a breakpoint confirms that in my case the event procedure...

  • Channel: Access

  Oct 20 '25, 06:16 AM
• 
  Are FlutterFlow Specialists Becoming the Go-To Choice for MVPs in 2025?

  by MarkWhitman

  With FlutterFlow gaining traction for rapid MVP builds, how are you deciding whether to hire dedicated FlutterFlow developers versus relying on traditional Flutter programmers? Have you noticed shifts in demand or pricing trends in the freelance and agency market lately ....

  • Channel: Product Launch

  Oct 9 '25, 06:34 AM
• 
  SQL UNION query with 3 SELECTs

  by Petrol

  Can anyone tell me what's wrong with the following UNION query? When I try to open it I get "Syntax error in FROM clause."
  I note that

  1. Each of the three SELECT queries runs (opens) quite happily when run by itself;
  2. If I remove one of them - any one - from the UNION query it runs happily;
  3. Grouping two of them in parentheses doesn't help;
  4. learn.microsoft .com says one can have mulltiple SELECT queries in a UNION query; and
  5. The

  ...

  • Channel: Access

  Sep 26 '25, 06:27 AM
• 
  Bizarre Access behavior

  by jimatqsi

  I have a sudden, bizarre set of behaviors that make me suspect Microsoft has stepped on something bad. I see unusual and very bad behavior in MS Access and Chrome.
  When I open an Access database on my programming machine, an Access Help window opens on the right side of the window. That does not normally happen. But it happens now and it resists all efforts to close it.
  
  When I try to get into Options the browser opens "by...

  • Channel: Access

  Sep 19 '25, 01:15 PM
• 
  How can I scale user generated content in web apps without spending a lot of budget?

  by natashasturrock

  I am working on a web app where users can upload and share media files. As the app grows, I am worried about scaling file storage and managing bandwidth efficiently.
  
  Do you have any tools, architectures, or hosting approaches that you can recommend?

  • Channel: .NET

  Sep 17 '25, 12:45 PM
• 
  How Do You Automate Your Programs?

  by jmcraven

  I have a program that I run on a scheduled job. It requires that somebody is logged in (Access requires an interactive desktop session). That's kind of a hassle, but I'm dealing with it.
  
  Anyway, that got me to thinking how do others automate their programs? Does anybody do that, or is it just me? I know about the registry hack to automatically log in, but my company has a policy against that. I don't think I can convert my program...

  • Channel: Access

  Sep 8 '25, 06:30 PM
• 
  How to Visualize Trend Data (JSON → Interactive Charts in D3.js)

  by Jessicajessy

  Hi everyone,
  
  I’ve recently been experimenting with some lifestyle and fashion trend datasets—specifically hairstyle trends like textured fringe, bob cut, wolf cut, mid-fade, and layered looks. I wanted to make the data more interactive by building simple visualizations in the browser.
  
  The dataset I’m using looks something like this (simplified sample):
  [
  { "style": "Bob Cut", "popularity...

  • Channel: Updates

  Aug 28 '25, 11:50 AM
• 
  Exploring AI-Powered Reporting for ERP Systems

  by Senthil96

  We run a multi-client ERP system (PostgreSQL backend) with 280+ SQL-based reports. Users select reports via Java UI, but we face challenges: high maintenance, limited flexibility, performance bottlenecks, and lack of deeper insights.
  
  Context:

  • 10+ years of growing store data (daily additions)
  • Multi-client setup → strict data privacy/security required
  • Heavy daily reporting usage

  
  Looking for input on:

  1. Benefits AI can bring

  ...

  • Channel: Updates

  Aug 25 '25, 12:34 PM
• 
  Red Hat Introduces Red Hat Enterprise Linux for Business Developers, Aligning Application Development with Production Consistency

  by LouisPTC

  Red Hat Enterprise Linux for Business Developers simplifies access to the world’s leading enterprise Linux platform for business-focused development and testing scenarios. A new self-service offering through the Red Hat Developer Program, Red Hat Enterprise Linux for Business Developers helps business development teams build, test and iterate on applications more quickly and on the same platform that underpins production systems across the hybrid...

  • Channel: Product Launch

  Aug 20 '25, 09:00 PM
• 
  Automate SEO Article Creation – From Keywords to Ready-to-Publish in Minutes

  by Dimension

  Creating SEO-optimized blog content can be slow, repetitive, and expensive. AlgoSEO changes that by turning keywords into fully structured, SEO-ready articles in minutes.

  • Batch mode: Generate up to 75 articles/month from a simple CSV
  • Built-in SEO features: Optimized titles, meta descriptions, H1–H3 structure, FAQs, keyword mapping
  • Export-ready: JSON & CSV formats for easy integration
  • Developer-friendly: Works with modern stacks like

  ...

  • Channel: General

  Aug 12 '25, 06:53 AM
• 
  Webinar: what happens when scaling meets AI, Zero Trust, compliance and real risk?

  by karspyt

  For several years, we have been helping Medtech and Mediatech companies build scalable and secure systems in the cloud, which is especially important when sensitive data, artificial intelligence and regulatory pressures collide.
  
  Today and in the coming weeks, we'll share what we've learned in live sessions on the real challenges facing CTOs and IT leaders:
  
  🔐 June 30, 3:00 PM CEST - Cloud Security in Medtech & Mediatech...

  • Channel: Cloud

  Jun 30 '25, 09:51 AM
• 
  'Id' is not an index in this table

  by Aftab Ahmad

  Hello developers!
  I was working on project since 1 month and it is going to finish in 2 to 3 days. My MS Access Database is saved in my flash drive on which I was working. Suddenly, the flash drive is disconnected without any reason and my opened Database is getting error as "'Id' is not an index in this table." I have more than 69 tables in this Database. How can I fix this issue as it is not indicate the table name which is not...

  • Channel: Access

  Jun 25 '25, 05:46 PM
• 
  The data has been changed

  by Petrol

  My Form01 allows the user to log on and change their password, by entering a new password twice; if the entries match, the SHA256 hash is created and stored in the AccessAuthority table. The code invoked after the new password is entered, is as follows:
  

  Code:

  Private Sub txtReenterPassword_AfterUpdate ()
  '
  ' This is called if the user is updating his password and enters this new one a second time
  '
  Dim strHash As String, strNewExpiry

  ...

  • Channel: Access

  Jun 21 '25, 10:36 AM

There are no results that meet this criteria.

• 
  Using TempVars in field definitions in SQL queries

  by Petrol

  Is there anything intrinsically wrong in using a TempVar in a field definition of an Access SQL query?
  As a simplified test I have witten a simple query qry_LOI3 thus:

  Code:

   SELECT EventTypes.EventCode, [TempVars]![Drv] AS Expr1
  FROM EventTypes;

  The datasheet it generates is shown in the attached screenshot.
  I then try to open it as a recordset, thus:

  Code:

   Public Sub TestProc()
  Dim db As Database, rs As Recordset
  Set db

  ...

  • Channel: Access

  1 day ago