Search results

It is just 1 sheet that encompasses the whole fiscal year. cell 4,1 is the start point that i want the roster query to input into the spreadsheet. There are over 100 soldiers so I want the query I created that has the soldiers names and DoD ID input into the spreadsheet starting at cell 4,1

I took a stab at it but can't get my for statement to work properly. Dim rsRoster As DAO.Recordset Dim dbCurr As DAO.Database Dim xlApp As Object Dim xlWB As Object Dim xlSh As Object Dim strRoster As String Dim vCel As Variant Set xlApp =...

Darell, that is pretty awesome, thank you. I have kinda defaulted back to the original ask as well and created the shell of my spreadsheet. I also have a query that pulls all leave input into the database with the last and first name. I want to now pull that query and put it into the...

With xlSh.Range("D2", "AH2") .HorizontalAlignment = xlVAlignCenter For Each cell In xlSh.Range("D2:AH2").Cells counter = (counter + 1) .Value = counter Next End With This puts the total of counter in all the cells instead of just 1, 2, 3, 4...

I want to put the numbers 1 - 7 accross a single row in an excel spreadsheet using VBA. I also want to put Monday - Sunday repeating through a single row till the end of my columns. i have column D to ND formatted If I start the coding With xlSh.Range("D2", "ND2") I am at a loss as to...

Ok after reading all of this seems like I am not going to go that route. Switching if I get approved I want to try to create a monthly spreadsheet that shows days off in the same format as the yearly one. How do you format an excel spreadsheet through VBA in access?

It is an ongoing never lose data spreadsheet with a new tab created for each new fiscal year. This is the top showing day by day. The bottom showing the tabs of each fiscal year. In between in the first column is all the names of every soldier, the top 3 rows are frozen.

The allready formated and controlled tracker is in excel I just want to update it from access. If I make a new form in access to track the same data in the excel spreadsheet I have to go through so much BS to get it approved OVER the excel spreadsheet it really isnt worth it.

ok sorry for confusion. I am in the ARMY, the database I am making is accountability and soldier data tracking purpose. We have an Excel spreadsheet that tracks soldiers leave days to inform command who is available throughout the year. The database is newly created by me which has already...

ok i figured it out. I needed to add ByRef txtChoice into the functions () so they would read Private Function NameSearch(ByRef txtChoice) sorry for the silly mistake.

the lines that call upon the functions. Depending on what i search for is what line is highlighted so apparently I have a problem with all 3 functions or just how I am passing my variables into the function.

Ok I changed it to 1 button but I am getting type mismatch errors after the search has happened. I enter the appropriate info and the search finds what I'm looking for and then I get a type mismatch error. If Me.cboChoice.Value = "SID" Then SIDSearch ("' & txtChoice & '")...

https://answers.microsoft.com/en-us/msoffice/forum/all/append-data-from-access-table-or-query-to-an-excel/9be2509a-6ac4-44e9-a538-25f1c0c97fac

yeah I know not "together" but 1 text box instead of 3 is all I meant, I kinda like the simplicity that it is now so I will just tell the few that want the "enter" option they are SOL.

I just read online about linking the Excel spreadsheet to the database and running an append query to add the info to the spreadsheet. Would that work for what I am trying to do because I know how to do that, the pivot table and basically anything with excel is foreign to me. I just think that...

Ok so what i feared is what would have to happen. Have to make 1 button and put all three types of search together. Thank you

Ok let's change gears, what about if I have the excel spreadsheet already created called "Testing". When i input a start and end date for a certain person it adds the word "Off" during that time in the excel spreadsheet.

I am hoping the button I push will fill in the all the fields for them but there are always going to be outliners that someone didn't submit their form in time and we have to input their days off manually in the spreadsheet.

I am completely out of my depth but have been tasked to create a specific excel spreadsheet based on a query in my database. I need to Excel spreadsheet to have the 1st 2 columns filled with the names of everyone in my org. Then i need the top row of the spreadsheet to have the months in order...

Some soldiers do not have SIDs but 95% do so its a valid search, DoD ID everyone has but hard to remember at the time to search, name is fastest way to search of course searches by last name. I could put them all into 1 button but was seeing if there was a way to keep the 3.