Recent content by MOTOWN44

worked perfectly :) thanks very much! thanked

Afternoon all Could someone please give me a hand making a DAO connection to another database, with a view to copying the data in a table on that database and pasting/appending it to a table in my current database. Please note that I cannot have linked tables for security reasons (don't ask...

We have a main database at work with hundreds of thousands of records, but it has changed in to a read only state effectively halting all our users from recording/amending etc. Any ideas why this has happened? 90% of the data is written to the database from excel, but this has been working...

your first suggestion worked perfectly :) thank you Matthew

Afternoon This is probably a quick win for some of you guys J but im having really trouble getting my SQL statement to work! Public Sub CheckNewDir() Dim mysrcdir As String Dim myfilename As String Dim fso As Object Dim mydatecreated As Date Dim mydatemodified As Date mysrcdir =...

Hello Everyone I have this code that I got from allenbrowne here > http://allenbrowne.com/ser-59alt.html which does exactly what I want, I was just wondering if anyone would help me make it get more information on the files?? Ideally I need Date Modified and File Type along with the Path and...

Is there a way of making access find the below listed properties of every file in a selected folder, including those in sub folders and list it in a table? Obviously the headers would be as displayed below also Path File Name File Size File Type Date Last Modified Date Last Accessed Date...

Now then all Is it possible to run an update query based on a list box?? The list box displays all the staff that a team leader has assigned to them containing an ID number on the database [ID] the staff name and business ID (M Number) I want the team leader to be able to select a member...

thanks for getting back to me guys, i cant get Dlookup to work with more than 1 criteria but if you think Dcount is the way to go what would the syntax be ? If DCount("[StaffID]", "tblStaff", "StaffID = " & Me.txtStaffID) Then ... returns that its isnt a duplicate no matter what and if i add...

Now then This is probably seriously easy but i cant for the life of me get it to work properly! i want a message to appear if a number has already been entered in to the table, i reckon DLookup is the way to go but i could be wrong My table tblStaff has a field StaffID now when entering a...

Thanks guys ill give it a whirl and let you know :)

Hello I have a form and would like a msgbox to appear when a user submits information using a cmd button that lists which of the fields have been left blank. Eg Field 1, Field 2, Field 3, Field 4 are all blank on the form the msgbox would display as a list Field 1 Field 2 Field 3 Field 4...

Thanks for the reply i agree that would be the best port of call but due to the nature of the data we have a company policy of hiding everything (ie toolbars) and locking down the whole database so there is minimal chance of somthing going wrong for this reason everything must be done via...

Morning This is probably a simple problem but I cant get my form to filter by multiple criteria. And all I can find on the internet is how to define 1 combo box any another. So any help here would be great. There's 3 fields called Name, Site, Age which are accompanied by 3 combo boxes called...

Tharks for getting back to me :) creating a list of computers and user names isnt really a viable option for me as we all work of UTC machines which run a "session" on a server and any 1 server can have 400 people running sessions. we are also a large organisation with around 3000 staff. if...