Search results

this seems very logical, only problem is i already have a database of 100 or so employees i don't really want to recreate. but... i know there would be a way to switch to auto number as the key. or get around re-entering everything in a new table. any ideas?

I have made a few databases in the past and I've always had a field "full name" and "first name" and "last name" that I had the user fill in for new employees. The "full name" is the key for the table as it should be unique unless in extreme rare cases lol. I would really like it when new...

That was perfect, just what I needed! Thanks!

ok, so i am working on a database to track vacation/time off for my employees. Ive got "time off" records with a start and end date, as well as start and end times. My questions is, If I want to see just the time off records that falls between say 5/27 thru 5/30. How do I go about this? I...

We have what we believe to be an aging dell power edge 1800 server. It has 2gb of RAM, Intel Xeon 3GHz processor, a tape backup, and for space the OS drive is running low as is the General Storage drive. It is RAID. We have an office of around 15 people right now and we are using it as an...

Thanks DCrake for pointing me in the right direction. Really appreciate it. Sure I'll be back with more questions.

ok so i guess i do need to have everyone out then. makes sense. i thought there may be some way to get around that like i can with the front-end. how about archiving old data? our system os made up of a lot of "orders." I would love to write some sort of vba in conjunction with a form...

no i def did split front end back-end. I have done lots of improvements to the front end and it's automatically distributed when users close and reopen. but i need to add some tables for some new things i want to add aka i need to work on the back-end without kicking everyone out the program...

ok, so it's been a long time since i made this database for our small business. im by no means great in access but i learned quite a bit in the process of making it about a year ago. i now want to get back into it and make some major upgrades. but im wondering how to best work on adding to...

sorry. my vba knowledge is slim to none. i've been using macros a lot which i hear isn't good, not sure why. but i have done a few basic things in the code builder. sounds plausible but i would need some more specific instructions. Thanks James!

I have a form that shows some records and is based off a query. My users would then further filter the form using "Sort and Filter" block on the "Home" Tab. I have a report that is based off the original query but when the user does their own filtering, my report I made doesn't reflect it. Any...

alright, i skipped from macro builder to code builder and the click event of the button i have.... using the resource cited above i came up with..... DoCmd.OpenForm "frm_Inbound", , , "[PO#]=" & Me.[PO#] When I click it, it switches to the Inbound form but the VBA throws run-time error '3464'...

this is very similar to what I'd like to do http://bytes.com/topic/access/answers/642457-open-form-specific-record i've been trying this in the macro builder but it keep asking me for the value of Me.[PO#] in my case. not sure how it'd know which PO# I'm referring to when it's a list of many...

kinda treading down road of a query, then making a copy of "inbound orders" form and change it's record source to the query. right track??? prob not lol

Alright, I have "orders" that have been queried and turned into a form with limited fields in a list for nice viewing and editing. Let's call that form "local dispatch" i also have a form that shows all the orders, one per page, with all the fields for the order. Let's call that form "inbound...

got it working flawlessly, much thanks!

omg, i am so stupid!!!!! the query works perfectly, it's that the form needs to be refreshed. i click refresh all and BAM!. Wow, I am sorry VBAInet for taking so much of your time. now, I just need to add a refresh command i think and ill be all set!

alright, here we go. got the zip thing figured out. nice feature.

alright, here ya go. only the front end. hopefully enough to see what's going on. the frm_qry_local_deliveries form is based off the query qry_local_deliveries and is what i'm filtering. The qry_lcldel_br_go is the query i've been toying with the IIf and the check box in the form. it is...

that just made it return no records. yes, a button is opening the query. for the sake of troubleshooting, i even threw in a text box and named it finished2, just to clarify you do that in the property sheet, other tab, Name field: correct?? I then changed my query criteria to...