Search results

missinglinq - I think the = date() thing is going to be more then adequate. All I am doing is making an add inventory form, and one of the entries was adding the date, and since most of the stuff we are adding into the database is new arrivals, I found it to be a pain to continually add today's...

Awesome. Thank you so much... now, what if I didn't always want it to be today's date? I imagine it gets much more complicated, right? edit - Actually, what I got going now is great. thanks.

Bueller? ;)

Thanks, where do I put that piece of code in my database? Sorry, I'm not too sharp w/ the VBA just yet. I did try to put it in the Code Portion of my form. Under: Option Compare Database Me.ReceivedDate = Date()

Hi, I've got a simple form where we enter in inventory items as we recieve them. Typing the date in is kind of a pain in the arse. I know in Access 2007 it has a little button that you can press and it inserts today's date. Is there any way I can do that or something similar with Access 2003...

Yeah I found it on this board and I cant seem to relocate the original thread. I'll upload it in my post but I take no credit for it. The guy who posted it originally goes by the handle "smercer" I found it to be the most helpful thing on access that I've read yet - I'd love to get my hands on...

sbooth, Thanks for taking the time to look at my database... I don't completely understand why you would need separate tables yet, but I know thats just because I'm ignorant. I still see access as something of a glorified spreadsheet. Luckily, I have all summer to learn. I'll try to fix that...

Hi I want to add that I have this same problem, and it does not work. When both values are null it outputs everything, but when 1 value is null then it outputs nothing. edit - I just want to add that I'm using Access 2003 if it makes any difference.

Sbooth, First off, thank you for the response. I actually got my form to work but I am interested to see how I should really set up my table. Plus I want to set up more complex forms and queries so I realize that I need to get my tables looking right. Here is my database... it is a bit of a...

Ok, thanks to an awesome tutorial I found on these forums I have made some progress. I made a query and linked it to my combo box and then linked the subforum to the query... now the stuff works. Awesome.

Ok so what I'm thinking is, I need to do a query based on the combobox, and have the sub forum pull information from that query, right? Well I created a new query but I don't know how to base that query on the combobox... I'm assuming that is the first step. I'm trying to be proactive here...

Hi all, I am new to these forums and new to access. I can set up the most basic of things but after that I get confused. I work in a research laboratory am using access 2003 to set up a lab inventory database. I only have 1 table with all of the inventory. I am looking to set up a few...