Recent content by NewShoes

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...