Search results

My database works 99.99% of the time. Once in a blue moon I get an error and this is usually rectified when the user restarts the database. Most of the time I'm not there to see what caused the error. Is there a way to suppress the error, log it in a table with the form name, error code and/or...

Good day all, I am trying to add an Item from a list of Products to a set of buttons on a form for quick selection (like in a POS System). It works somewhat but every time the db is closed the Buttons loses the bindings. See the attached db Form SaleF.

Need some help getting the Current Price for an Item based on Quantity purchased. This is my Item Latest Data Query: SELECT Product.UPC, Product.PNAME, ITEMCOST.CPU, ITEMPRICE.PPU, ITEMPRICE.LQTY FROM (Product LEFT JOIN ITEMCOST ON Product.UPC = ITEMCOST.UPC) LEFT JOIN ITEMPRICE ON Product.UPC...

I have a continuous form, if the record has incomplete fields and I set the focus to a record before, how to cancel the current record entry and clear all the fields that were filled?

Not sure I phrased the question properly. I have a form that opens and goes to new record. Data Entry property is set to No. Everything works great for the past couple of months but now I get a Runtime Error (see attachment). Clicking on End opens up the form but I am unable to add records...

Hello all, Is there a module or something available that allows the user to do simple calculation in a text box? For example, if I enter 1+1 in a textbox the textbox value becomes 2. Nothing too elaborate just +, -, x, ÷

I know there must be a system table or something that stores the Backend address. How do I find it? The Problem: The database being used, the Backend is stored on a server and the Frontend is on the user's PC. The user wants to add some stuff to a report, I am half way across the country but I...

How do you prevent the user from seeing the system tables when using the link table wizard in Access. Is it a Server side setting or MS Access?

Hello all, Let me see if I explain this properly. I am opening a report from a Pop up Form (the pop up is set to open as acDialog). The Report, set to open as acWindowNormal, does not become the main window or the current view screen when the pop up closes, I have to click on tab to view it. I...

Hello Everyone, I am halfway there following this suggestion https://www.tek-tips.com/viewthread.cfm?qid=1602602 I have an unbounded textbox that calculated the totals between the Parent Form and it's Subform. My form has no buttons to cycle or save, I am using Access's navigation controls...

I have 3 forms that basically does the same data entry one for Inventory (deInventory), Expenses (deExpenses) and Foreign Purchases (deForeign). I have an event set up on each of them to detect available vendor credits. Private Sub SUBTOTAL_AfterUpdate() Dim rs As DAO.Recordset Dim CreditCheck...

With a form's recordset, How to export the current viewed recordset. I am using this code but it includes all the form's unbounded fields in the export. Private Sub bntEXPORT2EXCEL_Click() Dim Path As String Dim FileName As String FileName = InputBox("Enter File Name to Save As. (Will be...

Came across this little tip I never knew about https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/use-having-and-where-clauses-in-the-same-query-visual-database-tools?view=sql-server-ver16 very useful knowledge for people, like me, who uses aggregate queries a lot.

I am trying to create an OnDouble Click event for the field APPLIED CHQS. If I add a hyperlink to the field the entire string is hyperlinked. I want to be able to click on each on the values that is separated by a comma. For example, the first record, if I click on either 506 or 1199 it opens...

I am using this Source query I know how to get this unique list query How do I join the last SUPID to my unique query? Like this Edit: Preferably as a single query as I want it to feed a combobox.

Sometimes I find myself making one or two additional queries before I can get the join I need. I have this sql called PROSOURCE that generates the WEIGHTID for me SELECT COSTCENTRE.CCID, PROBRC.PDATE, PROBRC.QTYP, PROBRC.DIMENEXT...

I'm reading this thread and having the same problem on Windows 11. https://www.access-programmers.co.uk/forums/threads/accdb-webbrowser-and-acropdf-pdf-viewer.313660/ Can anyone help with an update to the .reg file because I tried it and it did not work.

Getting the alternate row color is easy enough but how do you get alternate row text color?

I'm trying to follow Allen Brown's method as seen here http://allenbrowne.com/ser-58.html to convert a single range to Min and Max Values This is the Table +----------+-------+------------+ | SDate | Class | Range | +----------+-------+------------+ | 3-Mar-14 | 1 | 780.00 | |...

Is it possible to edit records from outside a database via Excel. Here's the situation. My co-worker has a Database saved in her OneDrive the problem is that, if I want to edit records I will need to download the database, make changes and reupload. If I do that while she is adding records all...