Search results

So leave the table itself simple and use a query or report later to calculate what is needed. That makes sense. In a query I thought you can only have columns that are already in a table. If I have a table with date, time in, and time out can I have a query that also has total time after that...

Well maybe if I get super fancy then in 20 years I will be able to help some poor newbe like you are doing for me. And Ill say this is what my first project started out as!

CJ_London, So are you saying create an additional worksheet in the excel file that is formatted like a table and then import that one? So they would fill out the main timesheet, then it would autopopulate the info into the hidden sheet which is set up like a table. Then in access I would just...

First off getting a detailed point by point is a no go. Trust me when I say Ive tried lol. He is too scatter brained for that and has already demanded the database be started. So I have part set up that has employee info and inventory info and things to go with that which are working so far. He...

I tried to import a spreadsheet like you suggested. (although I do not know how to do that to an existing table) The issue I had with that is that the excel spreadsheet is not in a table format. I attached a prntscr copy of part of the timesheet to show what I mean. Having it layed out that way...

This is going to be a long question but any information on the situation will be greatly appreciated. I am creating a database for the company I work for. My boss wants it to have every information possible stored and accessible through the one database. Right now the time sheet that we use is...

I have a form with a button that I would like to open a report apon clicking. Right now when it is set up to open the query it does that just fine apon click. But when I change the VBA to open report it then prints the report when clicked and does not open it at all. The form is set with a...

I am not sure if this was the best way to go about this issue. Would still appreciate an opinion on if I made this more complicated than it needed. So in order to solve my issue what I did was create a form like this Employee Number: (text box to type in) First name: (textbox to type in) Last...

Here is what I need. I have a form with First name, Last name, Employee number, Information. The information box is a drop down menu with four options (contact, emergency, company, personal) I would like to be able to enter in search criteria for an employee using one of last name first name or...

Haha I knew it would be simple like that. Ive used that before but didnt realize you can add to it. Thanks! :D

All these post have been helpful thanks. :)

Hello, I am brand new to Access and have started to create a database. Apon all the reading I have a few questions that I havent been able to find answers too in a way that I understand. With the questions I know there are websites with answers but as I said I am having trouble understanding the...

I did everything you all suggested and it totally works! Also great tip about the debug button I didn't even know it was there and that will really help me in the future as well and not just with this one part. I know this is probably a silly question but when you posted a reply with the code...

The last thing I have to do with this part has got me stuck. So I have it working from my navigation page i click on the search tab, enter what im searching for and click run query. It now opens up the query with just the details I asked for. What I would like it to do it actually open up a...

Wow! I did not know about that build feature. It worked. Thank you super much.

This is my very first time doing this so I hope its not too messed up. :) Private Sub Command1_Click() If IsNull(Me.txtUserName) Then msgBox "Please Enter User Name", vbinformation "UserName Required" Me.txtUserName.SetFocus ElseIf IsNull(Me.txtPassword) Then msgBox "Please...

Being new I asked two questions in different threads and they have ended up being the same answer. But I have gotten myself stuck. So this is where I am right now. I created a Search form that opens a query based on what was typed into the text boxes on the search form. This is working is I...

I am using Access 2013 and starting to create a login form (based off a video I found online) so that it wont open without the correct login. So far I have created a form with Username and Password text boxes. Then OK and Cancel Buttons. I also have a table that has UserName and Password set...

I changed the criteria from Like "*" & [Forms]![SearchF]![Item] & "*" to Like "*" & [Forms]![Main Page]![Item] & "*" SearchF was the original search form that I moved onto the navigation form (named Main Page) Doing this I can go to the search tab...

I did not create the form itself. In access under create there is an option that says Navigation. When you click on that it brings down layout options. I chose one of those and have different reports (based on set up query's) for each of the tabs. To me it looks like a website page. So after I...