Search results

I've finally had some time to make the changes, and it worked flawlessly. Thanks again!

I did see your response, and must have been confused on what you were advising. When you say that my table strcuture still isn't correct, what do you mean? Simply moving columns to match your previous post? ** Edit - Perhaps I wasn't thinking outside the box, I now know what you're talking...

Good Morning, I've created a database to keep track of many things, one of which is the amount of money a Supervisor can earn (incentives) for completing certain things on their work shifts. They can earn a dollar amount on a specific date, and they can use a dollar amount that they have earned...

Thanks for getting back. Okay, I've combined those tables into, and ran a query with the data. I have entered data for myself, which shows up 3 times as I've earned money on 3 separate dates. I want to take the total earned money and subtract the total Used amount from it and get a total of...

Good Morning, I'm not sure if this is a true TABLE questions or not, but here goes. I have two separate tables that are subforms of an Employee Form. I keep track of certain dates where employees can 'earn' money for doing certain things. I have one table that keeps track of the date and money...

Thanks Grumm. This worked like a charm and was exactly what I was looking for! I've been able to learn quite a bit from users such as yourself, and am very appreciative. Thank you -J

The computer ID is simply the computer logon name which is not what I want to show in the user form. Here is the code for the log on form, which I suspect is not saving the user name upon closing the log on form. Private Sub Command1_Click() Dim userLevel As Integer If...

Truth be told, me.user was a code I found from another source. I don't really want the 'computer name/id' to be populated as that is simply a random set of initials. I really just want the lookup statement to reference my user table and grab the user name that had logged into the form. Am I...

Good Morning, I've attempted to create a User box that would show which user is logged into the database on the main form. When the log on box pops up, you put your username and password in and click 'ok'. Which works fine. Once logged in, you're on a navigation screen and can click to open the...

This was a great help. Thanks! Worked perfect.

This is EXACTLY what I was looking for. One thing though, that isn't in this line of code, is that every time you make a comment or entry, that there is a new line. I think that was part of that second string which was to see if there was text and if so enter a new line?

You are correct, and that is what I'm attempting to do. Being that I don't know code, I simply took the two lines of code and swapped them assuming that the order in which the code is written, it would swap the text and time stamp. Attached is the error I get when I try to swap the lines of code.

Would you be able to guide me in the right direction to do that? I've attempted to switch the two lines of code, but it doesn't like the expression.

For whatever reason, I can't seem to get my time stamp to appear before my text. Right now, my comment box places my newly written text followed by a time stamp and I'd like to reverse it. Any ideas?

Thanks Grumm, I'm not sure what I was doing wrong. As soon as I copied your code and replaced mine, it worked like a charm. This is a great forum. Thank you! - J

I've attempted to try removing them, and continue to get some kind of error. Thanks for the thought!

Good Morning, I'm creating a database, and learning Access as I go along. While I'm a quick study, I can't seem to get my comment box to behave the way that I would like. Attached is my comment box form. I have a read only comment box to read previous comments, and then I have a New Comment...

I guess asked differently, Under the pay period ending column, my criteria is set to 'Between [Enter...' and my Owes Pass column is set to "used". When the query is run, what controls the order in which it checks the date / and then checks the 'used' field?

I have two separate criteria for a simple query, but they run independant of eachother. I'm not sure how to combine the criteria so that if one criteria is met, it will display the second criteria. I need to first enter the pay period ending date, then, if the tblAIB column comes back with...

I know longer know the error, because as soon as I click on the button I had created, VBA opens up highlighting the line in yellow. Jiri suggested I get rid of the lines. Do I simply delete the four rows and save?