Search results

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...

I'm trying to get the last/most recent cost of an item using this query. SELECT Product.UPC, Product.PNAME, PurDetail.PurDate, PurDetail.CPU FROM Product LEFT JOIN PurDetail ON Product.UPC = PurDetail.UPC WHERE (((PurDetail.PurDate)=(SELECT MAX(PurDate) FROM PurDetail As P2 WHERE P2.UPC =...

Hi all, This is the statement I'm trying to pass through VBA BioClockSql = "SELECT EmpTimes.USERID " & _ ",EmpTimes.EID " & _ ",EmpTimes.CHECKDATE " & _ ",Format([CHECKDATE],'ddd') AS DOW " & _ ",EmpTimes.INTIME " & _...

I'm now trying to learn Recordsets so bear with me. Dim db As DAO.Database Dim PrimaryTRS As DAO.Recordset Dim ItemsRS As DAO.Recordset Dim NewItemsRS As DAO.Recordset Dim ItemsSql As String Set db = CurrentDb Set PrimaryTRS = db.OpenRecordset("tblItem", dbOpenDynaset) ItemsSql = "SELECT...

Hi everyone. Just wanted to get an idea of everyone's development style. Action Queries, do you all (the more seasoned developers) prefer to type out the SQL in VBA or create the query GUI and refer to it and why?

Hello all, I am trying to make a query to get numbers missing in a sequence. So far I've used this SELECT CHQREGISTER.CHQNUM, (SELECT TOP 1 T1.CHQNUM FROM CHQREGISTER AS T1 WHERE T1.CHQNUM = CHQREGISTER.CHQNUM+1 ORDER BY T1.CHQNUM ASC) AS SEQ...

I was reading this thread https://www.access-programmers.co.uk/forums/threads/append-if-rows-do-not-exists-else-update-if-exists.320254/page-2 and was wondering how to do an UPSERT using a query (not a table) as the source. I am trying the method described here and I am getting a "Operation...

I'm trying to make a Opening/Closing stock query. So far I've managed to do it for 2022 but how would I go about using 2022 Closing Stock as 2023 Opening Stock? I've attached the db and the query "RMMOVEMENT" is my current progress. Side note: I've heard that keeping a table (rather than...

When doing data entry you can enter the month and day and Access will fill out the year, which is based on the PC's date. I have a backlog of data entry, how to set the year part of the date to the previous year, 2021 or even 2020 when doing data entry. I know you can change the PC's date and...