Search results

New question, same topic. I needed to go with multiple search options in the database: Name, ID, SID. I made a search for each line but since its 3 different buttons I cannot hit enter to search. Is there a way to keep all 3 and just have the enter work if the field has data?

yeah i have it pulling from the query that I have sorting through date, so the top record is always going to be the most recent and thats what i wanted to show

Yeah I figured out I was completely wrong. CanGrow is the way to make it 1 record I just had to resize my subreport on the report.

I have a report created that pulls an individuals admin information and a sub report on there that should pull the most recent test results. For some reason it is pulling ALL the test results for the individual. I tried to turn can grow to no but that's not right. Is there a way to show just...

oh ok, so everything has to be inside some form of bracketing. I thought when I saw the variable print out as exactly what I wanted I thought it was working. I see what you are saying about the date looks like division so the # on either side make it a date. Thank you for the description of...

ok so here is the code: Private Sub cmdControl_Click() Dim dbCurr As DAO.Database Dim strControl As String Set dbCurr = CurrentDb() strControl = "UPDATE Leave " _ & "SET [Control Number] = " & Me.txtControl.Value & " " _ & "WHERE...

Wow thank you this is amazing!!! I was able to go step by step and see the output of each variable, the debug method I was taught was to put watches on the variables and place a stop in the line and see what your variables are filled with. So I got the variables to do pull in the proper info...

I don't understand how to use debug.print. I have just been OTJ trained and never told that. I tried to do what i googled and nothing happened. Dim dbCurr As DAO.Database strControl As String Set dbCurr = CurrentDb() strControl = "UPDATE Leave " _ & "SET...

after what y'all have said I did change my statement to an update which is more in line with what i want to do yet I am getting datatype mismatch error now. Dim dbCurr As DAO.Database Set dbCurr = CurrentDb() dbCurr.Execute "UPDATE Leave " _ & "SET [Control...

This is my first attempt at an INSERT SQL statement: DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO [Leave] ([Control Number])" _ & "values ('" & Me.txtControl.Value & "')" _ & "WHERE (((Leave.[Start Date] = me.txtStart.value) AND ((Leave.[End Date])=...

I ended up putting in a button with an event that's just 1 line : DoCmd.GoToRecord , , acNewRec I couldn't trust my users to know to hit tab after filling out the text boxes so now they hit a save button I created that clears the text boxes for them.

I have a subform with a few text boxes I have set the form to data entry, but i wan the form to clear the data to input new data after saving. Do I have to make a VBA code with a button to save or is there a properties box I can change to clear the text contents to input new data?

Yeah i figured as much so when I do link I am going to make queries for the users to see and sort by instead of opening the table

I haven't attempted to do this yet but I was wondering. I have DB1 which has a table dedicated to days off for soldiers. I want to link DB2 to that table in DB1 so that I can make a calendar in DB2 for users to see when people are off and for how long. If I go to the external data tab and...

ok I started with just copying the code deleting the code saving the DB then closing and reopening DB and pasting the code back in. So far that is working I will keep you posted if i have to do anything else.

For some reason all of a sudden my search buttons are pulling up this error: If I go into the VBA code of the buttons and close it, the buttons mysteriously work but i dont want to do that EVERY time I open the database. Is there something I need to do so I dont get this error?

I am sorry y'all. After sleeping on it i realized my issue, the table "Evaluation" only had 4 entries in it because i was testing so of course there was only that many things to output in the query.....So if anyone wanted to know the string i used for my dates. >Date() And...

1. no its a number field 2. yes 3. I only get entries that have entries in both tables, some entries will not have ALL the information filled out 4. DoD ID is the same on all my tables thats how i link my queries

ok so deleting the join i get 2 entries of every person

yeah still got nothing, I changed to y after d didnt work and just didnt go back before copy pasting to here that was my bad.