Search results

Are you compiling your front end into an MDE or ACCDE? A compiled front end will not allow design mode for reports, forms, or code modules, even with the full version of Access. My suspicion is you are using a non-compiled database with the Access Runtime installation. I hope you plan on...

When an Access application connected to a database does something to cause JET/ACE to flag the database for a need to be required, the Suspect State can often be set to True for the possible offender. If the Suspect State is every set to true, I have often have found there is a reason for concern.

Are you looking to hire someone to help you? If not, please ask a specificquestion.

Great job getting is working to meet your needs. (y) Thanks for the update and sharing your solution so others can also benefit.

It is a huge paradigm shift in thinking to go from designing a spreadsheet to designing tables in a relation database. The shift from thinking "wide," with all related data in one row with Excel, to thinking, storing data narrow and tall with multiple records in a table is not easy. I would...

To do what you ask for, you will need to write a lot of VBA code to use Word automation to either perform a mail merge or use bookmarks to fill out the document. Warning: This will require Word to be installed on the workstation running Access. If I were doing what you ask for, I would use an...

What you really need is the ability to use SQL Server Management Studio (SSMS). It is a desktop application that would allow you to create views and stored procedures in the SQL Server databases. If your Access front end can write to the database, it would make sense you should have...

Does this mean the SQL Server database you connect to is not your database? Possibly belongs to another software application? Connecting to a back end over a WAN will be slower. Are you using a DSN or DSN-less connection? I always replace my front end when deploying updates and have never...

One of the best ways I know to improve your programming/developer skills is to recreate the examples. Do not copy and paste anything, Hand type all the VBA code from any other example. Doing it is the only way to get experience. Both creating Access objects and using what you built. I...

Akbar , The way to move further will take a lot of your hard work, time, and learning new skills. Welcome to the world of software and database development! It can easily take a programmer with years of experience months to build what you want. . Without inventory control and scheduling...

Offie 365 is basically a subscription to Microfot products. Depending on which subscription level, which Microsoft product are included. When someone has an Offi e 365 subscription, that usually indicates they have the most current version of the Office Desktop applications installed...

It is simple if you follow the GAAP standard that uses Dedits = Credits. It has been proven to be the best method for over 2000 years. While you might get away with that in Excel, it causes many issues in a Relational Database. I urge you to do some research on database normalization rules.

I thought it looked familiar. See: https://www.access-programmers.co.uk/forums/threads/records-database.282430/ If I remember correctly, what you downloaded was work-in-progress with some issues. Not the working final version.

What you want to do is possible. I have been doing it with Acess since v2.0 (1994). I handle it with VBA code to post/un post transactions from the different journals into the general journal ledger. A basic GL transaction ledger will need the following fields GL Transaction ID (used to...

Have you made any changes to any of the objects? If you made any changes, it would be helpful to see the original. Please provide a link to where you downloaded it? There may be helpful information on the page.

It could be because you are not using the # delimiter around the dates Also, it may not like form field references within the SQL statment

I agree that if you want to do a global shortcut menu, then set at the application level would be the best for you. FWIW: I have not found setting a global shortcut menu useful. By building it dynamically, it can be context related. Making it extremely useful to the user.

I agree with CJ_London that using docmd.transferspreadsheet is a better way. The best method I have found for saving a form or report to Excel is to create a query just for the export. This allows you to change the query to match your desire format without impacting the form or report. You...

I prefer to set the shortcut menu by the object. Check out: Dynamic Shortcut Menus

mnaeem90, Yes, it is possible to do with one major limitation. You can NEVER compile the front end into a mde/accde for deployment if your code will need to open any form in the design view in production/live. Something to keep in mind if you ever want to protect your forms after deployment.