Search results for query: *

I have not made an update to my database since 7/24. However, I do see that there was a Windows Update between Friday and today. Forms that have been working fine for years are suddenly breaking at random places. Often it happens when a field has a drop down with a selection that resides in...

I am trying to implement the functions listed here: https://extramiledata.com/get-list-form-controls-sorted-tab-order/ I created a button on my form that calls the first function: Private Sub btnControlsInTabOrder_Click() Dim QuoteFrm01 As String TestControlsInTabOrder (QuoteFrm01) End Sub...

I'm hoping to find a solution to speeding up this frequently used report. Over the years, it has always been on the slower side, but as more and more gets added to it; the load times are now not acceptable. Is there an easy way for me to upload the report and example data where it takes ~10...

I have a query that when I run it in Access, the value I get is .6875. I then use TransferText acExportDelim, , "QueryName", "Location.csv", True. After the export, when I view the document in Notepad, Notepad+, or Excel, the value I get is .68. I even exported as .txt and got the same...

I would like to implement a form of activity tracking. To do this, I need to have a user system. Is there a way for Access to use the domain account? I would prefer this over creating a user system in Access. Thanks

A bunch of forms have the option to email a report via Outlook. I made no changes in Access but basically they all stopped working at the same time. I also made no changes to our Outlook settings. We do not use Exchange. When I have Outlook open, I get a 2293 code. When I have Outlook...

The first image is the report. The second image is the report's design view. In the design view, I have ensured that the text box is wide enough to fully display what is entered. Any idea why the text is cutting off? Thanks.

I have a query that pulls all records from a year provided by a user, qryIvcByYear. Then a report, IvcRpt, should be created for each record found. The report has a query in the record source to pull the relevant info related to the original record. Instead, all records are being dumped...

I've got a procedure that is first splitting up a field and creating new records; then immediately dumping those records into an assigned table. Currently, if I enter the same record number over and over, duplicate records are just added into the table instead of overwriting changes to the...

I am trying to remove all the zero values, and have the non-zero values form one complete record. In my example, that leaves TIMB and OAKW, but OAKW could be replaced by other choices. So, I never want TIMB to be the chosen value, always the other. I plan to use NOT "TIMB" as Criteria. I...

One of our users, using Outlook 2016, is unable to send a report via email in Access. The user clicks the button which loads up the box saying, "Now Outputting reportName to mail message". Then, Access freezes up with the white screen and says it needs to close. No error message of any kind...

Every record in this table has a link that opens up a document about the record. The location for many of them has been changed; so I need to update the link in the table. All the links that need to updated have the same starting directory. Here's what I'd like to do: Example of a record...

Hello, I have a form with multiple drop-downs. The process is to start with the first, choose an option, and then move on to the second drop-down. This works just fine if the user clicks on the drop-down for the first, then clicks on an option, and then moves on. However, because the...

I have a user that uses two databases. To save time, the user would like to have data sent from Table A in Database A to Table B in Database B automatically via button on a form. I've never done something like this before because it's usually more efficient to keep the work in the same...

The concept that I'm developing is a late orders form. After the user enters a date range, a list of orders will populate the form. There are some external factors that could cause an order to be late but not at the fault of the company. So internally, the order was completed on time. I...

Hello I have a promise date vs actual date form that I am creating. The user can enter a date range from x to y to see all orders that shipped between those dates. The data that comes up also displays the promise date and actual(ship) date for the orders within the user's range. I'm trying...

Hello, I have a purchase order form that uses two tables: a PO table and a detailed PO table. I tried the duplicating macro that Access already has built in, but all it really did was just create a new blank record. The macro did not copy any of the additional data in the record. So, I am...

Hello One of our reports currently has additional data on it that is intended for the customer only. To fix this, I am hoping to basically copy the report to a second page. Then on that second page, I can make that data invisible. Where should I put the page break to get a second page...

I'm currently moving some programs off of VDOS; so that we can phase out using VDOS. In VDOS, the autoexec file would set the correct printer. However, when running the program without VDOS, the user does not get prompted to pick which printer should print the document. Instead, it prints to...

Hello I am creating a program that pulls out records if a certain criteria is matched. In this case, the criteria is the column, Class, matching a particular code. Unfortunately, the original creator of the table must not have known that Class is a reserved keyword, and it's causing issues...