Search results for query: *

How to I merge multiple rows of data from the same table with the same ID. I have tried group by by I get the following error Column 'cos_attribute.bunit' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. The running this query...

Hello All, I am trying to loop this until it hits the top level parent groups. Currently I get the users group then the group of those groups. I want to be able to go up until I hit the top group. I could probably nest a few more foreach statements but there has to be a cleaner way to do this...

Hello all, Im trying to sort by servers named SACCTX001 - SACCTX999 but everything I have tried seems to not work. What I have currently brings up some extra servers that I do not need I have tried SACCTX[0-9], SACCTX### and SACCTX/n. Does anyone know what I should be using? $filter =...

I am working on a script that adds a local administrator to remote systems. This is what i have so far but on some of the systems the account might already exists so the first part changes the password for it the second two add an account and add it to the administrators group. Everything works...

I have a database that keeps track of employee training completion and due dates and im trying to figure out how to append a new training record to everyone’s record in the database. what I have now is if a new user is created a template is put into their record with all of the required...

I have a text box that uses this code to append numbers together for a criteria for a query. Dim AddText As String Dim NewText As String Dim strOr As String If Forms!Test!Type2.Value = "" Then strOr = "" Oldtext = Forms!Test!Type2.Value AddText = Me.QuestionID NewText = Oldtext &...

What i have on my Form is three buttons one for report view another for outputto and the final one is sendobject. All of them work when clicked on although i am trying to figure out how i can get the information on my form to filter the sendobject and outputto buttons. This is my code for the...

Im trying to load a form set by strType that displays CACID that is equal to strCACID and if there is no match then open a new entry. I have no problem loading the new entry part by its self but when i try to add the equal to part in nothing works. Thank you for your help strType is selected...

Ok im trying to DCount using two different variables. I can use =DCount("Type", "All Query") and that works for all types fine but am trying to use something like =DCount("Type" = "Escorted" And "DateOut" = Date(), "All Query") So that i can specify the type of escorted and records that also...

Im using some code that i found online that the part they supplied works with filtering the dates but im also trying to patch in filtering the Type field in my database but it dosent work. Can you show me what im doing wrong? Private Sub cmdPreview_Click() 'On Error GoTo Err_Handler...

Hello, Im trying to setup a button that saves information to a different table than the control source. Have no clue where to start or what to use for this any ideas? Any help would be much appreciated. Thanks, Glenn

I have a database that allows individuals access to our complex until a specific date. How can i have Access delete the record of that person after they have expired? Ex Name: Date Entered: Date Expires: Joe 08/05/09 10/17/09 John 08/05/09 10/16/09 Dan 08/05/09...

I am trying to merge a few databases into one form by separating them by tabs but i cannot figure out how to make each tab have a different control source. Is it possible? What i have now is one form with 5 tabs one for each database with the controls for each database. Thanks ~Glenn

I am trying to be able to capture an image with a webcam then attach it temporarily or permanently to a record then print out a badge from a form. I have already created a template in a form and linked to a table to save the data. But have no clue how to be able to add a picture. Thanks, ~Glenn

Hello, I currently have an access database that compares information in a table to data that is stored in an Excel document and displays the information that is the same. The two things that it compares is first and last name. When using the program i currently have an Excel document located on...

I have a large amount of files linked together to create one mass table. A lot of these excel documents have a lot of empty lines at the end of their lists that are showing up on the mass list. I would rather not try and go into each individual list and attempt to remove the empty lines there is...

OK i have a major issue. I have a database that keeps track of issued badges on a server. a few people decided to copy the entire database instead of creating a shortcut to their desktops. So i have 4 copys of the extremely large database about 4200 entries each. i need to be able to create a...

I am trying to make a drop down box so that a user could select what report they wanted insted of searching through large amounts of buttons. I have about 500 reports and do not want to have each of them attached to a button like i have started to do. I want to be able to just select what report...

Ok here is what i have going on I have been first linking excel documents to the access database i have about 500 that need to be linked and combined. Then i am using a union query to combine about 50 at a time because i get a query is too complex if i do any more. Then i am trying to combine...

I am trying to compare two databases against each other and have the data that is the same be displayed. I can get the SQL code to run if it is only last name or first name but cannot figure out how to make it check that both the first and last name match then displaying the information. The...