Search results

I am working on some vba to connect to an excel file, so I can insert new records or edit records from access. I have modified similar code that I use to connect to an access table, just updated the connection string with what I found here: Excel connection strings - ConnectionStrings.com...

Find my description in the link: vba - Keep object in memory while is form is open (access) - Stack Overflow

I have an Access Database that I created for users to do special orders. Inside the office it is quite fast but when users go out of the office, on their laptops and using a remote desktop connection, the speed is super slow. I already gave them a copy of the front end on their machines to...

I found this code that finds a list of users that have a database open. I now want to open up a form with a table of all the people that have it open. I figure the best way is log it to a table and then use that table as a recordsource on a form. Then when I close the form, it deletes all...

I have a query attached to a form. In which depending on the user logged in, it will need to query based on a different number of criteria. As an example: If user A then view Group A, Group B, Group C If user B then view Group D, Group E If user C then view Group A, Group E, Group F, Group...

I am using the AfterInsert event to add values to a new record as it is created. Private Sub Form_AfterInsert() Me.tbSpecialOrderID = Me.Parent.tbSpecialOrderID Me.tbStatus = Me.Parent.tbStatus End Sub It works, adding the values correctly. However, it has a small side effect that...

Which is quicker and better to use? Bang (!) or dot (.) when referencing objects? Bang has the problem of no intellisense but is there other reasons to use it? Is there a speed difference between the two?

I was thinking which runs first the recordsource or vba? Reason I am asking is I have a lot of forms that have the recordsource set to a query that uses a date variable. Then on the OnLoad event I change the variable to default to today. If the query in the recordsource runs first that means...

I have this querty: SELECT tblWillCallLog.ReceivedDate, Sum(Nz([Payment])) AS TotalPayment, Sum(Nz([AmountOnInvoice])) AS TotalAmountOnInvoice, Sum(Nz([AmountOnInvoice])-Nz([Payment])) AS TotalOutstanding, Month([ReceivedDate]) AS MonthRange FROM tblWillCallLog LEFT JOIN tblCustomers ON...

I am in subform A and I am trying to change the record source in subform B (they both have the same parent form) but I keep receiving this error: Run-time error '2455' You entered an expression that has an invalid reference to the property form/Report These are the two ways I tried it and...

I am using the Current Event to change the records in another subform as a user clicks on different records in the first subform. However, I want to make it so if the user clicks on the total row then it will show all the data on the other form. Is it possible to know when a user clicks on a...

I have a table in Access with Employee Name, Position (selector, Loader, Reacher, etc) and Location (Cool, Dry, Freezer). I now need to create a report that mimics the picture I sent. I know how to do it with 12 subreports and 12 queries. Does anyone have any idea how I can reduce the number...

I am using a sum(if()) to count all the records in a subform that are null and it is couting all the records? What am I doing wrong? Here is the formula I am using: =Count(IIf([ReturnTime] Is Null,1,0)) and I tried =Count(IIF(IsNull([ReturnTime],1,0)) and...

I am accessing an AS400 database using the IBM iSeries Driver. It has worked for every table I need. However, now I am trying to access a table and it is giving me this error: "The Operation Failed. There are too many indexes on table 'PWRDTA_HHHORDHP'. Delete some of the indexes on the...

I am using many tables from our AS400 in my access database but now I need another table this is something called a member table. Here is a link on how to work with member tables in SQL in general but I cannot figure out how to work with it in access because when I use the link table manager...

I have a sql query where I need to do a DSUM to create a running total. So it will add the value of the previous with its own. The issue is the field I comparing is an alphanumeric character it can be 200, 201, 202 but also 200A, 200B, etc. So I cannot do a simple > symbol. how do I determine...

Hi, I have this procedure that takes a few seconds. It is very simple inserting a single line of data into a table, so I don't think it should take a few seconds. How can I speed this up to be near instantaneous? Sub TrackChanges(ByVal TableName As String, ByVal ProductKey As Long...

I have an access query that i based on 2 tables. One is a table from a 3rd party program, so I cannot modify the table structure. In this table, they do not have a single PK, they use multiple fields as their primary key. (I tried pasting a screenshot here to show the 3rd party table but it...

I asked a question at Stackoverflow and it is not getting much traction. Here is a link to that question: https://stackoverflow.com/questions/54596503/invalid-operation-in-left-outer-join-in-access?noredirect=1#comment95989185_54596503

I created this Vehicle Maintenance and Parts database for my brother and I am having an issue. In the 'Vehicle Parts Maintenance' button in the frmMenu form, you are supposed to choose the vehicle on the left side then with the drop down on the top right pick what maintenance type you want...