Search results for query: *

I'm trying to create a rather simple database that I will be linking with Crystal Reports. My task is to create a Vendor tracking system for each department within my company. For example, we have 15 different departments in 15 different locations. We have to pay various utilities bills for...

I created a rental database in which I have multiples of the same equipment but barcoded with a different number. I know most inventory type databases uses 1 number for the same item. Like i.e. cans of Ajax: 50 cans with the same product ID. In my case what I did is that I have a Product ID for...

Good day! I'm near completion on a database project that's taken me forever to complete. With the help of so many sample databases here I'm 95% near completion. Attached is my database for your review and suggestions. I have an Order Products table which basically holds the name of the product...

I just spent 3 days creating a form for my job with all the info they requested. Today I'm told to add a couple of other items they need to track so I want to go with a Tab Control. I really would hate to have to re-do all my designs and coding. I know with Access's Tab Controls you have to...

We need to create a script that will change the Power User access we have on all 300 of our employees workstations to Administrator. We're trying to setup a new proxy firewall into their internet explorer but in order for us to do that they need administrator access. We can do it manually by...

I've created a template form for my co-workers to be able to fill out easier by using VBA. The textfields work ok it's just the checkboxes. The form is also protected from the little lock on the forms toolbar. I created an OK command button so once they fill out all the boxes and text boxes...

Could really use some help with this problem. I'm trying to perform a mail merge into a Microsoft Word Table template from an Access Database. I created this template form that has 8 columns and 20 rows. Now when I click the button to perform the mail merge it works fine. BUT!!! the problem...

I'm currently working on a sharepoint server for my job and it required Windows 2003 Server which I did install. Now I'm trying to install Active Directory on that server but I get the following error message: The operation failed because: The active directory installation wizzard cannot...

I've just finished installing a test server for our company with Sharepoint Portal Server 2003. I followed all the steps accordingly from the Users help guide. Then when I try to connect from my Windows XP workstation I get the You are not authorized to view this page error. It asks me 3...

I'm doing an upgrade today with the Telco and I need to change this line on my router and I need to know how to do it please. I need to change the line below from channel 1-8 to 1-24 (it needs to be now tdm-group 1 timeslots 1-24) Can anyone tell me how I can make this change? I know all about...

I'm working on a database to keep track of courses our employees take at the job. I'm not sure how to setup my relationships based on the tables listed below. The database is going to look similiar to those of a purchase order type. There will be basic info regarding the student and then...

I have a database for our Human Resources Dept and one of the fields on the main form is wether or not an employee is terminated. What I did was use a blank area of the form and created a label with a character of X as the caption. So that when the data entry person clicks on the Terminated...

Years ago I created an old database using Symantec Q&A for DOS for my job. Time has come to convert this database data to Access with multiple users being able to use it. I've already converted the data to an Excel spreadsheet. Now here's the thing. I'm collecting data on patients at our...

I've got a preview report button on my form that runs a query that asks me to Enter a Start and End Date, however, I'd also like it to ask me to enter a Team Number but I don't know how to write the code in my code below. Private Sub PreviewRpt_Click() Dim strWhere As String strWhere = "1 =...

I just converted a dBase database records into an Access table and all went well. I have a field in my database that has an enrollment date for clients. There is another field which calculates that enrollment date and places the results into a due date field. However, I was hoping that after...