Recent content by MushroomKing

If you end up with 2 queries, make a UNION query. What happens if you just copy past you form and subform onto your report? I did this a few times and it works with subforms also i recon.

Plog is right. You could make 2 (lets say A and B) queries for your 2 tables. Then make a new query (C). Now copy the SQL code from query A and B and put them into the SQL editor of C. In between those 2 blocks of code, put the word UNION. If you run your query, it will "merge" A+B. Hope...

The table is SQL, but as an ODBC link in my front end. Technically there is no autonumber datatype indeed, but the function does exist! When i go to my SQL server, to my table and add a new record manually, it WILL autonumber by increment of 1! (yes automatically) Personid int IDENTITY(1,1)...

Yes! Correct Minty. While i import the backend into the SQL server, i was able to edit the SQL code. So before final import, you can edit the code and all i had to do was add IDENTITY(1,1) PRIMARY KEY, Now it is indeed autonumbering in SQL server. Thanks guys!

Hi Arnelgp, thanks for your swift answer! Right! I do. When i have my Access front-end, and i link the (odbc) SQL tables to it, it will prompt for a unique identifier. So i select the primary keys and the import goes well. Also, they are editable and new records can be added! BUT...since it's...

Hi everyone, Yet another question i seem to be stuck on for 2 days now. I successfully setup my SQL server 2017. My backend is imported and my Access front end reads all data and my databases work....kinda.... Problem: I have a form that has an on open event GoTo new record in my vba. This...

Hi everyone! I hoped someone could advice me with something on the old trusty forum :) I successfully linked my Access front-end with an Sql server and everything checks out. After some playing around i was wondering if it's possible to use VBA on my FE form that creates a new table on my SQL...

Awesome! thanks for your help :). That indeed did what I needed it to do. FINAL SOLUTION Set rs = Me.Recordset Thanks everyone! Always a pleasure here :)

strSql = Forms!calculation.RecordSource Me.FilterOn = True But that's A shot in the dark. Im still trying to find it

Thanks mailman!!! I corrected the 3 points. But fail to add a filter to the sql that filters my form results. Could you advise me on how to do that? Thanks!!!! :) Already helps alot

Hi! Thanks for your answer! Our management, wants to make daily reports based on the data they filter out in the form :) That's it really. So they filter some data, copy it to the table with the button, and an Excel file will fetch the data from that table on a daily basis to create some charts.

Hi guys! Im sure the answer is somewhere, but after a day of googling, I still need to ask. Please help :) What I want to do: I have a form, with filters on the headers, and I want to send the filtered results (records) to a table. Not overwrite, but add them. So what I did is copying the...

Hi Gasman! Always good to see you in the thread :) Still doesn't work for some reason. I get an #error in my field. :confused: (sorry, will quote with code tag next time, its corrected)

Hi everyone! I have a small question that im unable to find the exact solution for. It's driving me craaaaazy :D I have a query where I want to apply this: actualtime: IIf([daytext]="vrijdag" Or "Friday",([timediff]-48)) Now obviously its not working...but why? If my daytext is equal to...

Hi everyone! I know youre thinking there is alot of solutions out there to this, and a common question, however its driving me up the wall for hours on end and will not work. I have simply no idea what to try anymore :confused::confused: I have a linked excel file as my data source. I have...