Recent content by ekayp

Rain, Thanks for your time. The problem seems to be fixed now: I moved the field from the IDs table to the header of the form instead of the detail part. Unsure why this was causing a problem with the code I had though. regards, ek

Hi, In my main table/form I have all the IDs and few common items, which are only input once. I've used this form to link to 10 other tables/forms and most of these are 1-1 links with the IDs. Saves having users to input the clientids in each time they go into the 10 forms. Not really 100% sure...

Hi, I've tried to open a form using a button from a menu form. The button onclick property creates a SQL join (1-1) between 2 of my tables and then sets the recordsource property. The form opens fine but the record selector always shows all records whilst the form is on the 1st record but when I...

Hi, I am assuming you add the above function(s) in a module within your application. How are they called if this is the case. What is a packaged solution? I am having a problem with distributing a 2010 Access application to a user with a 2007 version and he seems to be encountering lot of...

Hi Sherry, I've had the same problem. I created the application in Access 2010 and sent it to users who had 2007 installed on their PCs. It seemed to work fine up until last week as I thought that 2010 was backword compatible to 2007. However, this week somehow my file got changed from an .accdb...

Dear Tinyvill777/Linq, Please find attached a sample. I've removed the project logos at the top of details and bottom of footers but have left the remaining controls as they are. I've tried to change the special effect properties to raised and flat and hopefully you will still see the ghost...

Thanks for the suggestions/help everyone. I've tried the tab border to transparent and it works to a degree where I now have slight white dashes in the top corners still. The special effects property was already set to Flat interestingly and I tried with setting these to sunken and raised too...

Thanks for this. I've looked at all the properties on the Form including the dividing lines one and must confess that this is still a problem. My main form has a 2 page tab control below the details section and a lable with the form title just above it. They don't appear to be touching the...

Hi, Can anyone please suggest how I can remove a faint horizontal line from appearing just below the details bar in my main form? I am certain that I do not have a line control in the application and it can't be my laptop as its new. Have tried moving all the controls away and near to the...