Search results

Hi, I'm a beginner using 2007 and I've just got to the bottom of this weird problem. However, it will be a big inconvenience if I can't get the database working like the old one was so would appreciate suggestions. On the old version of this database I was able to make references in the VBA...

Hi, I'm a beginner using 2007 and I'm trying to get a form the way I have it on another database but can't get it the same for the life of me - any help would be appreciated. The way I would like it is fitted to the screen height (within the access ribbon etc), centered horizontally, with...

Hi, I'm a beginner using 2007. I'm making a split fe/be multiuser database, and all users will have Access 2007 so I don't want to make a runtime-packaged exe really, but I am concerned that data in the backend could be damaged accidently by users if I provide an accde. I know I can change...

Hi, I'm a beginner using Access 2007 and have had some strange problems today. I've been trying out splitting my database and making an accde file, but then decided to recombine the database by importing the modules/forms etc into the b/e. Everything seems to be working ok but for some...

Hi, I'm a beginner using Access 2007 and I'm currently trying to get a subform looking the way I want it. It's a datasheet view subform that I'm using purely as a (short) list for the user to see - new records / edits etc will be done elsewhere. Therefore I'd like to remove the bar at the...

...well for me anyway. I'm a beginner using Access 2007 and have a problem with a filter. I've made filters on other forms without issue but the difference is that on this form the information displayed on the fields to filter (and the text the user will input) are from another table - they...

Hi, I am a beginner using Access 2007 and I'm currently working on making my forms user friendly. I have some numbers to enter in a form (corresponding to business names in a different table) and would like for the user to be able to choose from the names rather than the numbers. The way I...

Hi, I'm a beginner trying to get to grips with Access 2007 and can't make the query I need - would really appreciate a some advice. I need to count up the number of child entries for each record in a parent table. Sounds like it should be easy but I'm struggling badly. Parent table is called...

Hi, I am a beginner and struggling to get to grips with some fundamentals of Access 2007 and VBA. Like the subject says, I am currently trying to hide a column in a sub form without it hiding in the source table. I'm trying a workaround by using VBA to hide the column when the form opens then...

*It's ok - I've sorted it now. Thanks* Hi, I've been struggling to make the form I need and was hoping for some advice. I'm a beginner using access 2007 and I'm trying to make a database for a college library (not a real one yet, thank god). I have two tables one containing info on books...