Recent content by Mikeyboi92

Hi Guys, I have had a look and i cannot find another Post that explains my problem here :( I have 2 tables... one named Hive_Rental and one named Pricing. In the Pricing table i have 3 records ID Product Fee 1 Hive Rental £11.00 2 Nucs...

Hi Pr2-eugin, Thanks for the reply! I have looked at these and thats is something i can do but i wondered if there is away in which i can Copy an existing Query (as the queries are the same but the Table names are different) then replace the table names with the Text box Value? as the...

Right this is the 3rd time ive typed this and then the stupid design of the keyboard makes me go back a page and all is lost!!! :eek::mad: I want to be able to change certain parts of a Query and Code based on the contets of a text box. Example with Command Button Code: Textbox contains...

Good Afternoon, OK i have had a quick browse on this forum but cannot really find anyone with the same problem. Is there a way in which someone can select a table from a drop down list and then search that table for a record then move that record to another table. For example. User...

We dont just use this for escalation my database I created is also used to managing our cases work better. We have other systems we use but it they were never easy to 'see' everything if you will and so I created database to collate all the info in one place so was easy to work with the other...

Hi Mihail. They do not have access as they work in a different department. We used to just send an email with the escalation details but this is becoming more and more inefficient. The BE is on a shared drive my department can access and so myself, my team, team leaders can all use the FE...

Hi JHB Thanks for the reply. I will be applying the way you described I.e import to new table then append :) thank you. Mihail, that in an ideal world would b the way forward however they dont have access ttothe shared drive that the back end is stored on and so would not be able to update the...

Hi JHB, Thanks for the reply. Basically i work on a case management team and have created a database so that myself and my colleagues can manage our cases more effectively. If a case needs a manager escalation (bit more of a kick) we have to add some extra details etc. Our manager then...

Hello Bugleboy.. I had a similar issue as you. The way i got around it was to create a batch file. Its a bit old school but we have a few restrictions on what we can and cant do where i work. The batch file basically pointed to a shared drive and copied the Front end file to a set location...

Hi All, I hope i have put this into the correct place. I gathered queries as i use a query to export my data. Right, I have a slight issue that i cant seem to resolve. I have created a database, it has a table that a query runs on. when the query is ran it looks for any records that have...