Recent content by Breanna

Ill be honest those did not make sense. Sorry! the first option you gave had commands for the search form. Do those then make it so that the button creates a new query instead of opening one already set? Where do you put code on a query then. You mentioned record source. Is this all going...

All the information on the table can be categorized into the 4 options. So when I search for something I just want one of those options. Does that answer your question? I did not know you could use VBA like that in a query. I have done a little bit before but would not know where to start for...

I am using Access 2013 and am pretty new to it. I have a table that includes employee information. (employee number, first name, last name, address, phone, emergancy contact, medical, start date, hourly pay, etc. ) I have a search form that has a drop down menu to include 4 different options...

I have a query that uses DateDiff to give me Minutes of an in and out time Online I found the following to use in a textbox control source on a report to convert the minutes to Hours:Minutes. =[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00") But when I enter this it...

If you dont want to help I totally understand. For someone as new as me you have not been that specific in your request data. I did not realize you wanted me to calculate that myself. I put in numbers as sample data because the hours in the table do not have overtime. If I wanted to use excel I...

3rd times the charm :/

You made me laugh with your "nope" :p Sorry if I am being frustrating. I attached a spreadsheet with the added tab. I hope it is what you are asking for.

Ok. So attached is an excel spread sheet with a table tab showing example data for from my table in access and a report tab showing what and how I need the information. in the long run I will need to be able to generate a report that has that layout but right now I am trying to focus on...

I apologize for the messy data in my table example. I am not sure how to fix it so it all flows together in a more readable format... :/

-You are right about "Date" as a reserved word. I an very new and always forget that, thank you for reminder -I do not know how I would put date and time in in one column because I get the data for that table by importing it from an excel spreadsheet. (the guys use the sheet to fill out their...

haha I did find that myself. It is... DoCmd.SelectObject acTable, , True but that was perfect thank you it gave me something to look for.

Ooh that started what I need to do. (DoCmd.NavigateTo "acNavigationCategoryObjectType" DoCmd.RunCommand acCmdWindowHide) I have two types of users. Regular and Admin. For the admin users it brings up a form that has DoCmd.ShowToolbar "Ribbon" actoolbaryes this way when a admin logs in that...

I have a data base that when first opened a login form I created pops up. I am trying to set it up so that when it opens you do not see the navigation pane. once logged in though I do want to have access to that again. I have found other VBA code online but nothing that lets me remove the...

First off sorry it is soo long! There are alot of important details I am using access 2013 and have an issue creating a query with employee hours for a two week period. For starters I have a table with the following: Employee Number, Date, Time in, Time out, Description, Rate Code, Week end...

I am clicking the excel button from external data then it brings up like an import wizard or something and I follow the steps there to import the data to the table. So I have been deleting the rows I do not need. I was just wishing there was some way to avoid that but Im not thinking there is...