Search results

I am trying to find the quick way for texting the Month off this formula: =MONTH(NOW()) but the value that gets returned is a Number and it seems like there is an easier way than nested if statements to get what im wanting. Now, I would like to keep this out of VBA perty please. Ty! Daxton

! WOWsers!!!

Thank You SportGuy You have been very helpful to me. Very!

Thank You SportsGuy That fixed part of my problem but what I need is to take the date difference from now back until the hire date automatically where it isn't having to be entered in everytime it just tells automatically how long it has been since the hire date. Is there a formula that tells...

What is asked of me to do is for Access to tell when an employee has reached 30 days, 60 days, & 90 days. Now I know how to do something like it in excel but I don't know what the formulas or anything that I would use in Access would be. Daxton

I know i've asked this question b4 but I can't find it in the search forum. I'm trying to make the rectangle where it's just the lines or the inside of it is clear. I tried the Order part of it but that just changes the order so that other stuff that is created can be see thru it.

How's it goin Muzicmn, I got a question for ya. Once i put the make in, the model worked where it would show me what to choose from but when i selected it, all it would show was a blank? And I am guessing that once i select the model, that other combobox will let me choose which Price right?

... It dont say how to get to where I put VBA in for a table value.

Yea But it dont explain how to get to vba. I better re-check it just to make sure tho.

How do you put VBA in for a table, well for a value in a table? I'm used to using VBA in excel but I just started using access and I don't know anything about it. Meaning how do u get to where vba is put in? B/c what I am trying to do is have a table that has a number for every record that is...

I'll do a search... Thank you both for the help.

What the problem is, is this db that I'm making. Its a Bill Of Lading, which is a form that prints out and gets shipped with all of our parts that we ship off. Which we work in a plastics plant. So is there a way to get access to start on that #? The # we're on is 1680 and I want it so access...

;)~ Just wanted to say Thank You.

I have a table that was hidden. How do I make it to where its not hidden anymore b/c I cant select it and tell it not to hide it. I shoulda asked this b4 it was hidden.

Doh! I always do that. With the part about forgetting to attach something. Thank you for telling me that. I went to: Tools-Options, General tab. Check "Compact on Close" By Dreamboat Is that the same thing?

I'm making a db for my bosses acquaintance. I thought the one i made in excel for her would be good enuff last year but now its not big enuff. I made it in excel cuz I didnt know access and I thought it would be good enuff, but now she wants to make it longer so what im doing is making it all...

Ok... I figured out the part about showing both of em up but how do I get only the manufacturers parts to show up?

Nevermind I figured it out. :D

?????? I dont see a combo box wizard. What are ya talking about?

And how do I Get a combobox to show up all the manufacturers. I've created the query and Im creating the form right now. But what do I have to do to make the combobox show all the manufacturers? Forgive me but this is the first time I used Access. :confused: