Search results

In my department we use several "linked" databases (from an MSSQL machine). Yesterday we had a catastrophic loss of data when another part of IT mistakenly wiped our machine and reinstalled a new OS. There were several things that failed, including us having an EXTERNAL backup of the .mdf files...

I have a form with several option groups, that when selected, store values in fields. Let's say one option group has the options of: A - D - VL - M - ADD If I select "D" then D is stored as a value. OK, now that we have that. The thing is, this forms need to be updatable. As it is, when I...

I've searched for this all day. I think my main problem is that when people ask about printing by using a button. I can do that all day long. I have data that I want to print as a report. The perfect "look" is to use Toggle Buttons for much of the selection data in the form. It's what the...

I recently pick up the new version of Office for personal use. I built quite a few DBs for work using 2003, and the developers extensions, but didn't have anything for home use. I saw where MS was releasing the 2007 runtime for free and got pretty excited. Now I'm ready to tackle my first...

I've got an unmatched query set up that works pretty well using a linked Excel file, and an Access Table. It compares a Name, Day of the Week, Start Time and End Time. The problem is that some that I KNOW are matching are turning up as unmatched. It typically seems to happen when it's an...

On my development machine everything works great, but I know that I'm going to run into problems with distribution. I don't think there is a way, but I'll ask. Is there any way to get around not having to install the ODBC MySQL drivers on each computer? One of the reasons I'm migrating to...

I use a timestamp field in my tables to help me with productivity metrics for about 6 individuals who use one of my databases. The issue I have is that their system times are constantly "out of whack." We fix them, and it just happens again. It apparently another program on the computer that...

One thing that I personally think I'm bad doing is creating GUIs. I think my forms look pretty bad overall, and I'd like to get some ideas/pointers from some of the more experienced folks. I've included a typical example.

After searching the forums, I've found some information, but not what I need or what works. I've got everything playing fine, from where people can play a file they choose from a list, but I need to add some advanced controls for Fast Fowarding and such. Searching google, I've managed to...

Say I have a table full of tasks. Some tasks are performed each day (Mon-Fri, Friday only, Saturday only, etc). Each day someone has to mark which tasks were not completed, and move those to another table (?). Each task may have small changes to it (length of time, who performs the task...

I'm trying to build a small app for some of my employees to quickly archive (and still be able to access) their email. I've come up with a couple was to do things, but I want something more "efficient." One way was to link a folder called "Archive" to the database, then have whatever they...

I've just signed up with a webhost that allows me to have SQL Server setups. I upsized one of my database backends, set it up and connected without many issues. The major issues seems to be speed. It is SLOW, especially if there are any queries involved. What is process that speed dependent...

I can't believe I haven't run into this before, and since search for the forum just gave me a database error... I have a Form, with combo box parameters that pass to a query that fills a subform. So I can see all the records from the beginning, each parameter uses a Like [parameter:] & "*"...

I've got a number of tasks that are set up throughout the day, I would like to be able the tasks between the two times, but can't seem to get this to work. This is a query based on three parameters. [Name:] [Team:] and Between [Time1:] and [Time2:] I can use the Like [Name:] & "*" on the...

I simply cannot visualize how I need to go about this. I've had idea, but really don't know how to do what I'm looking for. Here's the rundown: A supervisors has a list of tasks (one table) that are assigned to employees (another table), each of these tasks will have a certain outcome each...

Question: I notice that I have ACCESSRT.msi and ACCESSRT.CAB on my MS Office Professional CD. Why would I need VSTO? For the packaging wizard? Why can't I just install these files on the computers of my users and then an .mde file? Why would they have included these files if this wasn't their...

I need some basic help designing an environment where jobs can be assigned to personnel. Typically they'll have the same "job" every day, but if someone is absent then their job must be reassigned, distributed among the others. The large assigment of job can be done automatically on a daily...

Would this be a difficult thing to do... or is there an "easy" way to do it? I'll love to turn my app into a web based app! Are there any helpful GUIs that would assist me in doing such a thing? Here am I just getting my access application to work how I want, and now I want to move on...

This has been a nightmare all around. Because I can't get 40 licenses for Access I'm stuck doing transferspreadsheets every day, which has worked out mostly, but I'm reaching the absolute limits of my knowledge. I can't even think straight and need help with a solution. Here is the table data...

I have a large database that I need to add a "Team" (Pacific, Easter, Central) in front of each entry. Each enter has the name of an Editor, which is easy enough since they are assigned teams and another table has their names with the team they are assigned. The tough part (for me) is that...