Search results

excellent idea, still not quite sure how I would write an expression to take the date from the first box, and not the second.

Thanks a lot! that gives me a few ideas. If i need anymore help I'll let you know!

Its for a project name, they don't want the project name to change if someone has an earlier time, they just want it dated with the first date inputted(not my idea). I will try the hidden text box idea, not really sure how to implement it, but i'll play around and see what I can do

Thank you guys,(i'll try to keep it in proper format for now on) I'm still getting an error, I basically want it so if the two statements aren't true, then four 0's appear ="P" & [rcCarrierName] & "-" & [rcLocationCode] & "-" & [rcDivision] & "-" & [rcProjectName] & "-" & [rcProjectYear] & "-"...

first date as in first entered, sorry for the confusion.

Populating an access database from another access database, Is this possible in access? If so how can you do it? My one database has dates of equipment received(no internet there) So i bring it back and my other database has a section for when the equipment was received. I would rather have a...

Hey, I am creating a inventory database and I want to keep in normalized, but in this situation I'm not sure if I can. Basically a shipment comes in and from that shipment all the serial numbers, part numbers, part description, and Manufacturer number has to be recorded. The problem is most...

I have a table with multiple serial numbers(serial numbers, part numbers, part desc, a second serial number) which exceeds the amount of fields. I know there is an easy way to fix this, but i can't think of it at the time. My table looks a little something like this. SerialNumberA38...

Pretty new to vba, I need to make a control grab the first date entered from two text boxes. I have tried doing this in expression builder, but it was getting pretty complicated(not sure if you can do variables in expression builder) If anyone can help me out that would be great

So basically I have a bunch of text boxes, two of the text boxes gathers dates, and the others gather other info and puts it into a smart key containing keys from the date boxes and other boxes. The problem is I only want the date from the first date that was inputted. If anyone knows how to do...

Its not based on a query. Its based on two tables, and one of the tables is solely for a lookup column

Changed my textbox name to txtcolourdateA, so now my control source is still ColourDateA and the name of my textbox is txtcolourdateA. With the expression in ColourStatus as txtcolourdateA=date() yet nothing works:( Is there a way to do this with a macro?

The control beside it is a textbox, which is bound to a date. Called ColourDateA(tried to change the format as well). So basically the Drop down control is called ColourStatus. On the ColourStatus Event I have the expression ColourDateA = date() for On Change, namliam I have tried After Update...

Topic says it all. I have a drop down menu that connected to a table. When you change it, it should update the control beside it(from another table) with the current date. I've tried a few different things in the expression builder and nothing seems to work(not even updating it with a certain...

I made a new database, and it works fine in the new one. I linked the Employee to the EmployeeCard by using Employee PK and Employee Card EmpID(using a lookup to select the first and last name in Employee) and it works fine. I have no idea why it isn't working for my other database:(

I'm kind of following, an Employee can have more than one card type, so every time i make a employeeCard they will have multiple types of cards. So I dont think i can use card type as a fk... not sure though

Well I do have a ID primary key for the cardHolder table. I should put cardHolderID field in the employee table? and then create a relationship between cardHolder.ID and employee.cardHolderID(not too sure on this), after that is done I can inner join the tables? edit: My foreign key is my...

Well I do have a ID primary key for the cardHolder table. I should put cardHolderID field in the employee table? and then create a relationship between cardHolder.ID and employee.cardHolderID(not too sure on this), after that is done I can inner join the tables? edit: The employee ID key is a...

It was a typo. fixed now I believe. For the above poster. I do know the tables aren't normalized( didn't really want a table for each card, but if I need to do that then I will), the hldName is a primary key because it uses the lastname, firstname, and id from the employee table. I use # but...

Hello, I have a union query that is grabbing last name(from the employee table) and also grabbing card number and expiry date(from cardholder table) It seems to work, but only when I have one UNION ALL. Anymore and I get this error "The Microsoft Office Access database engine could not find...