Search results

yeah

SELECT Roster.[Last Name], Roster.[First Name], Roster.Rank, Evaluation.[Draft Initiated], Evaluation.Location, Roster.[Eval Type], Roster.Evaluation, Roster.Rater, Roster.[Senior Rater], Roster.[Supp Reviewer] FROM Roster INNER JOIN Evaluation ON Roster.[DoD ID] = Evaluation.[DoD ID] WHERE...

All of my entries have a due date. I am trying to run a query to pull everything that is due in 90 days from today. I thought that adding <=DateAdd("d", 90, Date()) in the date field it would query what i want but I am getting blank queries.

yeah i was stupid and just typed it in on the file path search instead of just clicking the file....sorry for the problem

yes but when i manually link the FE to the BE I get file path Z:\\ instead of just \\ because my other users are getting an error stating that the location of the backend is not correct. I want to get rid of the Z: in front as i think its messing up the file path

I just split my database but the front ends that other people are opening cannot link to the backend because when I split and put the backend in a folder in the same share drive the file path has my letter assigned to that share drive. Is there a way to add the full file path to new front ends?

OMG!!!!! thank you soo much it has caused me headaches that every time i hit enter after putting in my text and just go oh right gotta hit the button

I created a button that searches for what i put in a text box. The search works perfectly if i click the button after entering my text. What I was wondering is, how do i make it work by hitting "enter" after typing my text?

Ok so to make a joined table called AcftToRoster Does it have to include everything? I attached the 2 tables I created. I made a subform for the PT test using PT test table as the record source. When I input the scores and save the form, the PT test table brings in the ID from the roster table...

Is there a one to many style. I have read that 1 to 1 is not proper its best to keep it all in the same table. This will be 1 soldier to many different attempts at the PT test with the soldiers ID being the linking field.

Thank you, yeah i tried to search but i was using link or words like that for my search and didn't get the answer i as looking for.

I don't know if "link" is the appropriate word to use here but, I have a roster table with all personal data of people. I want to create a physical fitness table with the scores of a PT test. Now I want to make the PT test scores to the right person, do i just put their name in the fitness...

yeah thats my mistake, I changed to findfirst afterwards and took out the extra steps of making a different recordset with name as well. Now both searches are exactly the same just in the name one I added the delimiter part. Thank you it all works now.

ok I added in the delimiter but code just ends without searching. rstName.FindNext "[Last Name] = '" & NameSearch & "'" I had to add the extra & since it wanted an end of statement without it.

I have a form that i want my users to be able to search by certain things. I have a search by ID # and a search by last name. The ID # works perfectly but the name is giving me an error " Run-Time error '3070' The Microsoft Access database engine does not recognize 'name' as a valid field name...

So I have "Table" that is linked to SharePoint but the fields in the table have become obsolete and I need to delete those fields from the table completely. I know its a simple open in design view and right click delete but since its linked to SharePoint I get an error "Operation is not...

Nope sorry....USER ERROR....I am an idiot and didn't name my text box the name that i referenced in the formatting

I have put a subreport that refers to another table to add a single line of information to my report. in the subreport i have added in conditional formatting to add color to the text. When I run my report the text line of information shows up but the conditional formatting doesn't change the...

Thank you everyone for the responses. I went with using the 12:00:00 AM as the base line the "Zero" if you will so in my if statement i just put that value in for if blank. The "And" and "&" debate ended up only working with AND in between, Access wouldn't let me use & it gave me an operator...

shoot did I put my less than and greater than wrong? I am trying to do between dates