Search results

So when I made an access 2007 program to track time off at our company, everything worked. Only issue is, I need to account for different employee's schedules. Some employees work mon-fri. Others work mon, wed, fri, sat, etc. So my best thought to add this ability is to add to each employee...

I have Table of orders, and a table of comments. The comments table has fields that cover date/time entered, name of user that added the comment, the text comment, and of course a field that ties it to a certain order_id. So, I have a continuous form showing a certain range of orders (50ish on...

I have two tables in a query. A employee table. And a time-off table with time-off record. I have a combo box to select the employee whose records I'm interested in, and a few other ways to easily filter the time-off records. My issue is that when I filter out all records the bound text...

I have a vacation database that is coming along well but I am now to the tough part. I need to come up with a way to track the remaining days a employee has. I am having a tough time grasping the best way to implement a debit system of sorts. I would like it to be as automated as possible but...

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...

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...

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...

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 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...

alright, i have about 3 filters that i want to include on a form that is built off of an initial query. but i want to be able to use any combination of the filters. my idea was to write a query/filter using IIf statements that rely on check boxes in the criteria. I'm trying to get just one to...

I have a report where I'm trying to cram a lot of info into the width of one page. i have some fields that will have data that gets hidden like the "pickup/delivery location" field. is there a way to get access to expand the height of the field automatically to display the info on tow lines...

I've got this nice little database that is now ready for use by our 10 or so office staff. i have been doing research on how best to deploy it. i have split it into a front end and a back end and put the back end on our server. i have referenced everything without drive letters. i was sure...

I have 2 tabs with forms dragged and dropped in each. Every time I switch tabs, access scrolls down to the form header and hides the tabs. I can scroll up to see them but it's kind of annoying as i switch between them a lot. Any fix for this?

alright i got two queries i unioned through sql. they query separate tables that are similar enough. my results are shown together but I can't edit the table data from the query even if i convert to form and add text boxes etc. Is this just a byproduct of union queries?

i have a form that has a link to add a record. Upon returning from adding the record, the combo boxes that should now have that new record in their list don't. I've been doing some googling where they say I need to call a requery of the form possibly on the trigger of the form getting access...

Is there an option in the page setup when printing a form or report to scale the page by a percentage. I found that handy to just bump that percentage down to 80-90% to fit everything i wanted to see on one page but I don't see this option anywhere in access:eek:.

Ok, I'm new to Access. I am designing a access database for a trucking company to track all orders from ordering to delivering. I have created a "Customers" table which I want to pull from in the "Orders" table as "Who to Bill," "Delivery Location," and "Pickup Location". I created...