Search results

If you want to have multiple subforms loaded at the same time i would suggest using a tab control. The behaviour is similar to a navigation control, but you can have multiple subforms loaded at the same time. You can then just use the click event, and influence the other subform by...

Hey everyone, for our software i want to create a form showing all customers in a table-view. In addition to that a subdatasheet is supposed to show all orders related to the customer. For this i created a subform, that shows all customers in table-view, and another subform inside the subform...

A client of mine requested to make him a general search field, that can be used to search for more than one field at the time. For example when searching for a customer in the system, you have one input box, where you can search for customer name, street, place, Tax-ID, email, telefone You can...

Thank you. So access is trying to interpret the string as a date, even though a big chunk of it is missing? This is interesting... Then if i want my comparison to work correctly i just have to convert my Date to a String and then compare those two... CStr(VDate)=VString is working as...

Sorry, i should have been more clear here. This was just an example. My actual code looks different from what i have written on top, but uses some custom functions, so i can not just copy paste my original code here. I have Option Explicit in my code. I do have a date value that is coming from...

Hello everyone, in my VBA code i have 2 variables. VDate as Date and VString as String. VString = "22.2" VDate = 22.02.2021 I am now comparing those 2 in an if and the code inside the if is executed. If VString = VDate Then Debug.Print("Hello World") End If Output: Hello World Is this...

Good point. In my case the timestamps will reach a maximum of 2 hours so this should not be a problem. Still good to know.

Nice! That makes more sense! Thank you very much for your help everyone. I will mark the thread as solved :D

Oh wait, i did not refresh the page :D Thank you very much for this! Why do you do the #12/30/1899# though? The rest is very understandable. One more thing, isn't using a reference to the outer query table very performance intense?

Thank you very much! Now i kind of understand how to tackle this issue. I will try to create my own solution and then message back!

Hello everyone, i have a table with multiple timestamps and corresponding Actions. 00:00:01 - Action 1 00:00:04 - Action 2 00:00:10 - Action 3 00:01:00 - Action 4 00:01:23 - Action 5 I need a query that outputs the time that passed between those actions. The end result should look similar to...

Interesting... But i never use any data from the outer query, so this should be fine. Thank you for the information!

Thank you very much CJ, this was very insightfull :D I will mark the post as solved. Now i know why my search tables are so slow, because it is combining too many subqueries. Let me see if this can be optimized...

Hello everyone, Coming from a programming background i like having independent systems, and reusing old "functions". Same applies for SQL queries. i created multiple subqueries to show data in the format i need. For example i have a query which shows all customers in the format [Name] &...

The DateAdd Function is inside the query. Wait, let me quickly reformat it, to make it visible better... SELECT tbl_Transactions.TransactionID, tbl_Transactions.CustomerID_F, tbl_Transactions.CreationDate, tbl_Transactions.Tax, Nz([tbl_Transactions.Price],0)*IIf([Typ]="Credit",-1,1) AS Price...

Oh my bad, i thought you meant calculating the due date in the parent report source. Yeah i am calculating all the values in the source.

Okay after further testing i can confirm it is not the filter. I removed all filters and the Open Report Event, the error still persists. It is definitely coming from the subreport, because once removed the error does not occur anymore, when printing. The query is running fine, and when looking...

In this case the following should work right? Fällig: DateAdd("d";Nz([PayTarget];0);Nz([CreationDate];Date())) I am still getting the error though. Does it maybe have something to do with the filter? Another thing that may cause the issue: I am setting a filter in the "Open Report" event...

Hello everyone, i am creating a report which displays customers and their orders. For this i am using a report containing a subreport, which lists all the orders. Whenever i open the page preview everything works fine, the orders is listed the correct way. But whenever i try to print or open...

I am not fully aware of the problem yet, to be honest. I think it is user fault. The funny thing is, code that is running on my computer on others is not working on individual computers, even though they are doing the exact same thing. We are currently trying to repair the access installations...