Recent content by bowks14

jzwp22, thanks for the reply. In response to your question: "do your employees have calling plans that are seperate from the texting plans or are they bundled as 1 plan?" I would say no, because users could have a 450 minute plan and a 500 text message plan, while others could have 450...

Bumping this up. Sorry but I still have not figured this out and would appreciate any tips.

Hello all, I am using Access to build a database to track cell phone minutes, charges, etc. for a business of about 250 numbers. I have a back end master employee database which I intend to use to keep integrity. After that I am running into trouble setting it up. I need to be able to track...

Thanks for the quick reply.. I am still a little lost though. Can you explain how it should be setup from the start? I don't think my relationships are set up the right way?

Hi all, Here is what I would like to do, and I hope someone can help me: I want to build an Access database that tracks ticket sales. Here are the tables I have so far: Customer: customerID, companyname, address, email, phone, etc. Orders: orderID, customerID (to link to which customer...

Rodger, The two are in seperate tables, but are on the same form. I have a one-to-one relationship between the two tables, but display all of the info on the form for easy entry. I will try your suggestion and hopefully it will solve my problem! Thanks.

Rodger, Thanks for your quick response! I do not want to use a dropdown. I only want the records with cell phone numbers (not everyone has a cell phone in our department). What is the easiest way of doing this? Ross

Hi all, I am trying to make a form with fields that will run off of a query, rather than a table. Here is the problem. The field that dictates the query is set to "is not null" so I want only entries that have something in that field (it is a cell phone number field). When I go to add this...

Worked perfectly! Thank you!

Hi everyone, here is my dilemma. I am making a "paid time off" from work database. There are three tables I am working with: vacation_days, sick_days, and personal_days. In the vacation_days table, I have three fields: earned_vacation (days earned for the specific month, by accrual rate)...

Hi Everyone, I am making a database that tracks Employee's vacation/personal/sick days. I want to be able to automatically calculate accrual rates based on the time a specific employee has been working here. For example, our organization accrues 0.84 vacation days per month if you have...

Ok, I have the Filter by Form working. But now I want the recordset produced from the filter to be placed in a report to be easily printed out. Is this possible?

How do you do filter by form?

Hi all, I have a simple question. I have made a database that tracks deposits and also has several fields pertaining to these deposits (company, date, etc.) I need all of these fields to be searchable, sometimes even searching on a combination of fields. Obviously this is easily done in...

Hi everyone, I need to design a database to hold all deposits made to our company. These deposits come in "batches" ranging from batch 001-999. So for instance, batch 001 may have 10 deposits, then it will be closed. Batch 002 may have 7 deposits, then it will be closed. The batches may...