Recent content by ian87

Hi All, I'm in the first design phase of my db and have attached an image illustrating my data. I need to be able to get a form for each [ServiceType] that allows users to enter all [ServiceSub]'s and [Geography]'s for the parent [ServiceType]. The problem is I want the boxes on the form to...

Thanks guys, we have now just created a shortcut and emailed it to people. It makes the form work quicker as everything is located on th evpn server. YOU GUYS ARE THE BOSSES!

Hey Rabbie, I am agreeing with you that it must be network related. We've been having some problems with our netgear router recently and it could be related to this. The round trip takes 3ms-10ms between UK computers and 140-200ms for U.S. based PC's. Many thanks Rabbie and CBrighton, we're...

Hey Rabbie, The form is based on a query, sql server is now not an option unfortunately due to deadlines. The form has 48 input fields plus 13 sub total fields (SUM etc.) Got any ideas on how to make it faster? :)

Hi there, Having finally finished my database and successfully getting it to work, thanks largely to the posters on this forum, i have run into yet another roadblock and i was hoping you could help. The database i have created needed to be accessed my multiple people across multiple...

Hi all, I've successfully managed to do this in another database but it doesn't seem to be working in this one. Basically I've been referencing certain cells in the top half of a split form so that i can show sub totals for higher categories. To do this i have inserted loads of text boxes in...

ENJOY! I have to type something to make the message long enough to post...

Hey guys, I have a solution. You guys are going to hate it :), it's so messy. I'll just take a screenshot and send it over, one sec.

I agree with you about data normalisation and realise that is what makes this difficult Jon, the problem is that I now have over 12947 records and have already designed 12 forms that feed from it. I would rather just try and get this fixed in the same format because people are trying to add new...

Hey guys, I tried using Dlookup but it just says #Name? =DLookUp([qryCMS]![Est2009],[qryCMS],[qryCMS]![ServiceLine]='CMS') The above was posted in a form so i could get the result and edit it. I have a qry with the following fields as in the previous picture Vendor ServiceLine...

Hey Jon, I knew the anecdotal story about sandwiches wouldn't be the best one to use but I was trying to illustrate my problem. I'll give you more of an insight and maybe you can help. Please look at the picture attached.

Hello again fellow access users and overlords. My problem today is that I want to create a form that allows me to view all fields from a query but then group certain records into parent boxes on a form. Basically my idea is to create text boxes that reference a certain field which will allow...

Thanks for the reply John, but I don't think you understood what I was asking I have attached two pictures below to show you how I have organised things. I want the tick boxes in the forms in picture 1 to show/hide the fields that they correspond to qryResultsReporting. What do i type in each...

Hi all, I need to be able to show certain query fields based on whcih tick boxes i select in a form. For example my form contains a drop down box for companyname and then i want to view the revenues of only some countries so i have made them into tickboxes for the user to select. E.g...

Hi everyone, I need to have a query expression where it shows data based on what i choose in a combobox. This is simple when you simply want to filter a combobox based on values you already have but I am adding new labels in my combobox which do not relate directly to field titles or values...