Search results

Welcome. You've come to the right place :)

Wow thanks for all the answers guys. I ain't made a start on this yet but your thorough info is definitely going to help when I do. I'll let you know how I get on.

Hi all, I want to make a database of contacts with email addresses and telephone numbers. And I want to assign them to groups but I want them to be possible to be assigned to multiple groups. Basically so I can write an email and send it to the group I want to but then get access to send only...

Brilliant thanks so much!! :D:D

Hi all, I'm after showing a button to cover some other buttons when a combo box has a certain value. I am using this code but am missing something... Private Sub Combo7_AfterUpdate() If "1" Or "2" Then Me.[Command21] = Visible = True End If End Sub When I do it says... Run-time...

Hi all, I have built a simple database (by no means complete) but I am after adding some further code into it. Basically on the form [FrmMain] I have a button that allows me to send a document to a relevant CSU contact. It finds the file name based on the info in the table TblResident. What I...

Hi all, I have a VPN tunnel across 3 locations in work. Due to the tunnel and the setup it is very very slow. I have tried splitting my database and having the backend on the network but it is unusable. I have ended up splitting the database into three and having one at each location. This is...

I agree it is wrong in terms of how I now make databases. I no longer use lookups and all my fields have no spaces and pk or fk and do work on relationships before creating any queries etc. as I say I learned to do what I do now building this and it's a very simple application so there is no...

My sincere appologies I thought you'd been working on the second file I uploaded. Hence the info was a little different. Your fix works beautifully without the need to change all the tbl info. Thank you so much!!!!!!!!

When I remove the added parameter it works again without asking for TblResident.ID

No they are both the same. Just keeps asking for that parameter even though it is there. Only seems to happen when I add the EXIST in

When I run the report

Then I get enter parameter TblResident.ID

Nah I still can't get it to work. Now its asking for the TblResident.ID and when I add that into the other query it takes away from the idea of it anyway and just shows them all

Comes up with a circular reference problem when I do the work you suggested CJ

Here's the file

Hi, I have rectified the data in the tables now and also tried your suggested fix CJ but couldn't get it to play. I have re-uploaded the file here...

I did this database when I was learning so I know the data isn't the way it should be just need a quick fix to this

Here is the file

Hi, Can't really get this to work so I have made a stripped down version of the database and uploaded it here. You will see when you open it that there are two buttons on the main form. One to edit the medication and one to print preview the report. If you run the report it asks you to put a...