Recent content by Bullman2000_uk

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 think my best bet is if there is anyway in VB to change the field type before I begin my calculation queries that merge 2 tables together and add a vast amount of information

Its an already created table but the database that was designed required it to be a number. I have been changing it manually every week but I need to automate it incase I am out of the office as no-one else can change it

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

Thanks for that, My next question is the code I need to writed for a command button. The field you enter the part of a supplier name is is Text2 and the query criteria is set as like "*"&[Supplier]&"*" how do I get the code to feed the contents of Text 2 into the [Supplier] Criteria? 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...

There is no date within the download that I need to mark, is there any way to get round this?

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

I am unsure how I would do this or if it would be possibly currently. Is there any scope to just send out a message to all users informing them that the database will close in 5 mins?

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?