Recent content by mws5872

Is this a one time deal or do the end users want to be able to do this regularly? If its a one-time deal I would just manually make that data importable--start a new spreadsheet and for every month bring in all the rows of data for that month and then add a new column titled 'month' and paste...

I have users that want to upload from excel the data for different months. Currently in access we have it already set to a column called 'months' and not 'january' - 'Decemeber' if that makes sense. How can I take it from a single entry and upload it into access as a field value. Let me know if...

Hi All, It's been awhile since I have posted but I am in the process of making an upload template in Access. I want to use an excel file containing the following fields. Year Sales Person User Role Goal type Month (Jan - Dec) listed as columns across the file. The top 4 fields will create a...

This may seem very simple but I need some help. I have two tables I want to use: Table 1: open invoices I want to use this as the base table to check against Table 2: invoices for a month containing all details. I want to use column 5 in table 2 to bump against 1 and matching numbers from...

I have this test file I am using. I want to figure out how to make a query( using the wizard or other functions are fine) . In this stream it always has Invoice Number: 385152769: I want to query to get 385152769 for every line. Is this possible?

I have access 2000 on my machine I have to first downgrade the database to 97 since all the machines here are 97. I put the database file on a network drive. How can I make this file able to be opened by multiple people and allow it to be updated from multiple locations. Also, is there a easy...

Hi everyone I just had a quick question about how to maximize my database. I want the controls to be hidden ex. file edit etc. I just want the switchboard to be full screen and the form. Can someone explain to me how you do this.

looked at it yeah it works great!!!! thank you soo much! but.... how did you do it :) thanks again.

M8KWR here is the file I have converted it.