Search results

It's solved now, I was just missing the "me." :)

Sorry, I mean check box. I am using the macro builder and selecting requery option and then entering the name of the subform control.

Hey all, I have a tickbox on a subform that, when ticked, I would like the requery the same subform. When I try this I receive an error. Many thanks for any help! -NS

Hey all, I am currently developing a database in Access 2016. there is talk where I work of moving to Office 365. I know very little about 3656 except that it is a cloud based environment. I am looking for general advice really... Things like will my DB work if it is currently a front/back end...

Thanks for your reply CJ. Those are all good ways but not quite what I'm after. Basically, every week, I want a user to be able to open up the database, launch a form that have a datasheet view on it (empty tho). They will then copy from Excel and paste into this empty datasheet. They will then...

Hey all, I'd like to copy data from an excel spreadsheet and paste it into a temp table in Access and then hit a button which will run an append query and append all the data in the temp table to a permenant table. Can anyone push me in the right direction on how to create a temp table? Many...

I've been doing some reading on this and it seems I need to disable the ribbons, disable the shift-bypass key and disable the quick access keys (as F11 shows the Navigation window). Please could anyone advise on how I go about doing this? Thanks, -NS

Hey all, I'd like to secure my frontend by disabling access to the linked tables, queries etc. I thought converting to .accde would do this but apparently not. Is there a way that this can be achieved? I am aware that I can disbale the ribbons etc but they can all be turned back on using...

Thanks for the suggestions folks. Is this the best solution? How would I go about doing this? Thanks, -NS

Hey all, I am building a search form in my DB. I have got this working by using a text search box on the main form which then links to a subform that shows the results. This works great, however, when the form is first opened, it shows all the records that be searched. Is there any way that I...

Thanks for your help, Pat. Unfortunately, I don't have a user login or anything and I'm unsure how I would grab the username. This is something I'd liek to look into tho, can you nudge me in the right direction? Thanks, -NS

Hey All, I have a knowledge base database which lets the user search for articles containing answers to common problems and issues. Some of the users want to be able to bookmark certain useful articles. The DB is a front end/back end design so I am thinking if I have one table stored in the...

Hey all, I am creating a knowledge base in MS Access. I have the basic design down but now I am starting to think a little bigger and am looking into possibly creating user accounts, which would allow each user to have their own name and password. I am hoping that that will allow me to create a...

Hey all, As the title says really. I have a date field that users can enter dates on (normally using the date picker). However, I'd like the date to always start with '01' (first of the month). Is there a way I can achieve this using input masks? Many thanks, -NS

Thanks all for your replies. Pat, that is a very creative solution, thank you! The only slight issue is that it does not allow the user to click into the combobox and type (thus activating the auto complete feature). It does however work when tabbing into it. I think I can live with this tho...

Hey all, When using combo boxes, I tend to use a query as their row source. In an effort to maintain certain comboboxes and stop them from becoming too long, I use a check box to exclude values that are no longer needed. For example, if I have a combobox on a form that lists 'Years', as the...

After some searching it seems this is not possible. Can anyone confirm? Thanks, -NS

Hey all, Just wondering if it's possible to create a type of Hierarchical Family Tree report in Access? By this I mean an actual visual representation of the people and links between them? Thanks, -NS

Hey all, I will be attempting to enter links to external (stored on a network drive) files. The files will be Word docs, PDFs etc. What I'd like is a button that would allow the user to browse to the correct folder and document and then for that UNC path to be entered into the text box. The...

Thanks for your reply Rain. I am aware of normalisation and table structures. However, this particular one is tripping me up slightly. I believe what I need is a self join in a query (as the linking records are of the same type and must sit in the same table). Using my example from my...