Search results

OK thanks. I am planning a complete rebuild later in the year to bring in user accounts , passwords etc so will think of something more perminant then. I was just hoping for some code i could attach to a button that changes the unc path of the linked table.

Yea i assumed that was the case but was hoping for something simpler lol

again simpler lol Just need a button that relinks to a specific location and i will create 6 of them to change as required.

Hi The requirements we have are to store the data indipendantly and control access. Being able to do this solves the issue and still sticks with the guidelines

ok thanks. This query also prompts input from the user so whenever we refresh they have to enter the data again, do you know of a way to save previously entered data? so when they first run the query they enter their name and it filters to their data, when they refresh they have to enter their...

I kind of want it to be a bit simpler than that. Just a button that runs a macro. If you wouldnt mind sharing your code i might be able to make it work with the code builder. Thanks

I would have the button locked with a password that only certain people can access.

Hi All I have a union query that displays data as a dataset in a form. When someone updates the data you have to refresh the query for the updates to show in the dataset. When you use the 2 individual queries indipendantly and display the data as a dataset it updates automatically when a...

Hi All I have a DB running in 6 of my sites. They are all set up identically. I have one front end that is linked to the back end. Each user has the front end and it is set to connect to the correct file location for their site. I also have some multi site user that have to unlink and...

Ah that makes sense now! the penny just dropped on having the form open! Also sorry but "Edit: To get your service advisors add a group by (totals icon) to your combo row source." how??? lol

Yea this is what i did before but i still get the same results. When i open the query i get the above box not a combo box. the form shows correctly when i open in form view and the combo box i have created works (however it does show duplicate values which i could do with removing, but thought...

Yea i tried that but it kept going wrong. I created a new query that just displayed the initials I created a combo box linked to the initials and tried to get this to show as the criteria for the query but it wasnt having it. creating the forms and combo boxes is not an issue its just linking...

Hi Everyone. Need some help again. So the setup. I have a table (Day Sheet) of jobs and each job has an owner in the form of their initials. there is a field in this table called Serviceadvisor. I have a query (Sadaysheetqry) set to display the data and it has a criteria of [Please enter...

Sorted lol. managed to work it out myself. Again, thanks for the help

ok so removed as suggested Happy with normalisation but well dive deeper into it. I have also dealt with the paperwork received and removed the special characters and spaces Next steps? again, thanks for the support

Thanks so the picture below shows the design view of my table the Wip Closed field is the one i want to go and look to see if the wip number appears in the rb5 wip number field (they have a relationship). Where would i write the code and what might it be?

Thanks for that. That code is just my example of how i do it in my spreadsheet. Im not sure how to apply this to access. sorry i have not used access for over 10 years so am extreemly rusty lol.

Hi ALl I have converted a spreadsheet i use to be a database as it is growing large and unmanageable in spreadsheet form. The issue i have is some of the functionality i get from the spreadsheet i cant seem to replicate in the database. This is probably largely down to my lack of knowledge in...