Search results

I have recently taken over a database from someone that has left the company as administrator however I have had no handover notes or password information. I need to get into the database background however holding the shift key when I open it is not working. Is there any other ways to get...

Can someone please advise of some code I can write to chuck all the users out of my database should I want to take it offline to make changes?

I have a field in a table that is imported from another database, its type is Test but I need to set it as a number field during a VB calculation Macro. Can you please advise how I do this? Thanks

I have a supplier search query set-up where you can enter part of the supplier name and it will return all matches. This criteria is set-up as Like "*"&[Enter Supplier Name]&"*" I have on a supplier search form a text box (me.text2) where you enter in the part of the supplier name and click...

My Command Button Wizzard seems to have switched itself off. Is anybody able to tell me how to switch it back on so I can continue with my form designs? Thanks

I am writing a query that will allow a user to search for a supplier number using part of a supplier name. I cannot work out how to bring up a promt box where it is set to "like" or "contains" I would have thought that in the criteria I would enter: is like [enter supplier name] or...

I am setting up a database that is merging and grouping a "Global Spend" by my company from 7 different systems. In order to present this data I want to be able to append all the data together but also add in 2 new fields that represent the quarter that the data was loaded and grouped, also the...

I have database that is multi user. Is there anyway that I set up a message that is sent to all users that are logged into the database at the click of a button Thanks

We have a multi-user database that has a facility to kick all users out of the system when we are having system issues or need time to implement small urgent changes. This functionality currently provides no warning to the users and therefore people can be in the middle of completing updates...

I have a control button that I need to be unavailable if a check box is ticked (to stop users being able to reject and authorise items) Can you please advise how I can create a rule for the button that means it will be blocked out if the check box is ticked?

I am trying to add a certain number of days onto a date field to create a due date within a Table but can't work out how to do it. I know that to add days on I can use the function DateAdd but the only way I can see how to do this is to create and update query to run and add the date on. Is...

Is there anyway to extend a field set as text to more than 255 characters? Thanks in advance