Recent content by alanij

Yes i do. I have an autonumber field PK which is linked to the other table with a one to many relationship.

I have a silly question but it's bugging the hell out of me! I have run a query from 2 tables with a 1 to many relationship. My query shows what i want it to show but where there are duplicate records in my main table it leaves the cells blank where there are other records in my second table...

Thank you!! something so simple! can`t believe i missed that. You have made my day :D

Hi I have a command button in a form which opens a report from a query i created based on parameter dates entered within my form. I recently changed the date field in my query to another date field as the report was using the wrong date. Since i changed this date in my query along with...

Hi Not had a chance to look yet but will do and let you know. Thanks for your post by the way :) Cheers

I have seen threads on this subject but not really seen a solution as such. I have created an Access database that will be shared by 4 admin staff in an office at work. I am trying to set it up so that only one user can access it at a time to save double inputting issues of data entry. (Also...

Thanks for replying. I have checked these and they are set up as you described. However, i still do not get the corresponding ID show when i click on the command button to display the subform. I have to scroll through the records to find the subform where the unique IDs match.

Hi I am wondering if it is possible to open a subform via a command button to display the corresponding record in the Main form. I currently have a 1:1 relationship on Unique ID in both main form and subform. At the moment my command button opens up the subform ok but it doesn`t automatically...

I have 6 tables which are quite specific so have kept them separate rather than put them all in one table. Therefore I have joined them by a unique number to each record by a 1:1 relationship to each table i have. I was hoping to have my 'main table' as the Parent Form, and then a few of the...

I am trying to create a command button that allows a subform to pop up in my Main form (parent form). The relationship between this 'Parent' and 'Child' is a one-to-one relationship and when the subform pops up it won`t relate this subform to the 'parent' form. i.e. i would expect the...

Hi Does anyone know how to create a textbox a second subform that replicates a textbox that is entered in my 1st subform? I have a date in my first subform [Alert Details Subform] that has a one to many relationship with my second subform [Meeting Details Subform] and i would like the date...

This has probably been asked a million times before but i can`t find a reply that suits my problem!! I need to add a text box to my form with a formula that calculates the days between 2 separate date fields within my form (excluding weekends). I know Access doesn`t recognise NetWorkDays as...