access web database
96 TopicsTransitioning From Access To Web Sites
I have a question for the individuals out there that are moving to a web interface from Access What it the best app/program to use to make the move from using Access to using web pages? I've been tasked with converting the Access app that I have been working with for years to make it a web "site", which would be converting the entire application - forms, reports, etc. so that it can be used via web browser instead of MS Access. I am in no means a website developer, but I'm always open to learning new things. Mind you, one of the databases has in excess of 12K lines of VBA. I want to be able to use some of the same techniques as what I've done with VBA and to be able to create a good user experience on the front end plus create some additional enhancements. Al of my searches have not yielded anything helpful. Thanks in advance. Jeff2KViews0likes25CommentsMS Access Handling Nulls In Query Formula
Hi all, I have this formula in Access: IIf([Init_Static_P] < 0 And (Nz([Adj_Static_P], -9999) < 0), "Resolved", "Not resolved" which keeps outputting an #Error when Adj_Static_P is null which will happen. I need the nulls in my dataset. Whenever Init_Static_P is < 0 and or Adj_Static_P is < 0, it works as it should outputting "Resolved" and vicer versa, however it does not work whenever there is any instance of Adj_Static_P as a blank value. Does anyone know how I can handle the nulls so that if the Init_Static_P is >0 and Adj_Static_P is null, then it would output "Unresolved", and if Init_Static_P is <0 and Adj_Static_P is null then it would output "Resolved" instead of #Error? Output should be as follows: Init_Static_P Adj_Static_P Result >0 Null "Not resolved" >0 >0 "Not resolved" <0 Null "Resolved" <0 < 0 "Resolved" Thanks in advance! <381Views0likes3CommentsSharing and updating an ACCESS database on the cloud
I have implemented an ACCESS database. I would like to store it on the cloud so my colleagues can access it simultaneously. Some of them may be updating some data while others will look for certain records and files being stored within the database. I realize that I should do all my design and coding on my local PC then upload the file on the cloud; however, this central cloud copy of the database file should be accessed and updated while it is on the cloud by multiple users. I am not sure if storing on OneDrive would allow me to do this. I would highly appreciate any experienced developer in this issue.7.7KViews0likes12CommentsMerging formatted text boxes in MS Access
Hi All, Is what you see in the first image below possible in MS Access? (See first image below, right side!) My goal is to merge multiple formatted text boxes into a single, coherent paragraph while retaining their distinct formatting. The software TLex exquisitely accomplishes this task as you can see. But let's look closer at what's going on. On the left side, you have a data entry box where users can enter: definitions, translations, example sentences, notes, etc. That info is then displayed on the right side of the screen. Notice how the styling, coloring, and formatting are all preserved. The text is not simply compiled into a list! It flows one sentence after the other, forming a coherent paragraph. THAT is what I'm trying to achieve. I did make an attempt. The image below titled "My Version" clearly shows where I fell short. Yes, I maintained the text box formatting, but I was not able to get the text boxes to form a coherent paragraph.I also tried string concatenation, but that method does not preserve any of the text boxes' formatting. So, has MS Access met its match? Can MS Access get text boxes to merge together while preserving the text boxes' individual formatting and form a coherent paragraph? Hopefully, you can help. Look forward to your suggestions. Thanks in advance!1.4KViews0likes15CommentsAccess Database Deployed to Sharepoint
I just got done bidding on an Access project that requires sending email via Outlook and generating some reports in Excel format. I think to myself "no problem, I know the VBA for doing that". I win the contract and then the customer says: "When you are done, we will just put it on Sharepoint where everyone can use it." From what I can gather from the forums - Access on Sharepoint does not support VBA. Is there some other way I can send email via Outlook and generate Excel reports when the Access file is on Sharepoint?Solved929Views0likes3CommentsLink 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.266Views0likes0CommentsEasy to migrate Access to the cloud.
Hello everyone, I am Hamamatsu from Inforce, a software development company in Japan. We will introduce how to migrate an existing Access system to Azure SQL Database. In the past, up to Access 2010, there was a feature called "Upsizing Wizard" that enabled migration to SQL Server. By improving and expanding this feature, we are finally releasing the new upsizing tool "Access Azure Drive (AZD)." By using this tool, it will be easy to migrate Access to the cloud. By migrating Access to the cloud, Access data will be managed with Azure's security and compliance, allowing integration with various services. Furthermore, by linking with advanced data analysis and PowerApps, it will lead to the development of web applications and mobile applications with low-code/no-code solutions.713Views0likes2Commentsautomatically migrates Access databases to Azure SQL
Hello everyone, I am Hamamatsu from Inforce, a software development company in Japan. I am excited to engage with this vibrant community, known for its insightful discussions, and I look forward to your comments and feedback. We have developed an unprecedented, innovative tool that automatically migrates Access databases to Azure SQL Database, named AZD (Access Azure Drive). As some of you might know, AZD is an evolution of the "Upsizing Wizard" which was a standard feature in Access up until the 2013 version. We continued our research and development efforts even after Microsoft discontinued this feature. Originally, we were engaged as technology partners at Microsoft headquarters in developing the next-generation Upsizing Wizard, so we are well-versed in this functionality. Although it does not achieve 100% conversion at this point, we would be very pleased if you could try it out and share your thoughts. Please feel free to ask questions or contact us. Mail to email address removed for privacy reasons AZD Introduction Website [link removed by admin]350Views0likes0Comments