Search results

(sigh... So i know i messed up lol) In a complete oversight on my part I have a form where the user can enter data to be added to the master data table that holds programmatic information and the value of each item. In the form I designed the user only fills in 5 fields out of an available...

Perfect, Thank You!

I seem to always have these headache issues! A team im helping had an existing database that was created in all the wrong ways possible. It was not split, not indexed, UI was atrocious, and no real data controls or validation. The database was a basic inquiry type set up, someone calls the...

Thanks for the responses. I guess what I'm trying to do is eliminate the human element altogether. So I guess I'm wondering if there is something I can use to just scan the reports into, that will just record the data for me in some useable format that I can manually add up the data or even...

For years, I've used a setup where data is imported into an Access table, and users could use forms to query the data any way they liked. After they select from a series of drop down boxes, they can run a report and print out the pages and begin collecting data from the field. Members of the...

I am trying to convert a database that I created using Access 2007 to and Access 2010 Web Database (I have migrated to Access 2010). I have run the web compatibility check and have made corrections to all of my tables that were required. I then signed up for a trial of Access Web Services and...

Well, if you properly split the database (front end/Back end) and everyone is on the same network then the solution is pretty simple. Split your database by taking all of your tables and putting them in their own database (mybackend.accdb) on a server location that everyone has access to. Next...

In my effort to make a very simple database that compiles monthly data (linked from several Excel Spreadsheet) and exports the data back into Microsoft Excel, im stumped on 1 thing. My new plan requires the User to select from a combo box a list of the sites (or blank if All) and then a Date...

“If I had asked people what they wanted, they would have said faster horses.” In a nutshell I am creating the database so that my analyst can respont back to the customer in a more timely and accurate fashion. As time goes on we will slowly migrate the cutomer into using the Access database...

I Looked into that awhile earlier but the point I'm at now, doesnt really help. I wish I could have properly created this table but that is not an option, and migrating to a correct table format is a long way away (change is a scary thing for these people). Unless Im missing something the MID...

To be more specific Im working on a project where the users have used a MS Excel workbook to keep track of projects (Due Dates, Status, Project name and # etc). They now have thousands of records and find themselves overwhelmed. I've managed to import all the data into Access tables and create...

Missing Manual for Access 2007

You can purchase a cheap (but stable) Computer and use it to host a mySQL database. Convert your back end to mySQL and keep Access as your front end. Other than the cost of the host PC and possibly a static IP address if you think you need it, it's very cost effective. Somewhere in this forum is...

My quick answer is that you should get a an Access book and either read through it or use it as a reference book to guide you in your development of your database. I would suggest the "Missing Manual" series of books to help you in your task. Once you read up, you will see that Access can...

PatD, Please visit this link, it should answer your question. http://msdn.microsoft.com/en-us/library/bb501030(v=office.12).aspx

Sorry I should have added more detail. Typically with transfer speeds things are measured in bits and not bytes. However, the average user only knows about bytes. For example the average mp3 is around 10 Megabytes in size. However transfer speeds are typically measured in Megabits per second...

Other types of "overhead" come into play with data transfer speeds including things like hard drive speeds. However I want to clarify something, are you talking about Mb/s or MB/s???

You should purchase or borrow "Access 2007: The Missing Manual", assuming you have Access 2007. This is a great book to begin with and it covers exactly what you want to do in good detail.

I split all my databases as it is good practice. I have come up with a solution of using and update query and a linked table (for the other file). Sharepoint Server is completely overkill for this type of work.

I've designed a database that three people use. Each person has an identical split database on their PC's. However each person is in a different state. I'm trying to figure out a way in which they can send me a copy of their data table, I append the work they did, and then send them the fully...