Search results

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.

I've tried all of the above which is why I'm posting here. I'm out of ideas.

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...

There are also some differences with the tables that you may run into. Are you converting are using an existing database?

Thank you, I'll try to follow some of your suggestions and apply what you've said. We're thinking along the same lines, as I just finished doing some of what you suggested. Reoccurring and repetitive tasks are the hardest thing in access I've had to deal with. As you mentioned with running...

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...

Is there no way to use "*" without "Like"? I certainly can't get anything to work.

I appreciate that, but if you look in my first post, I actually list that technique. Since this is a subform, I don't need the [forms]![form]![parameter], but the idea is the same. Again, sorry if you misunderstand.

Nope, that's not it either. Let me explain it as names instead of number. When using a "Like" expression, it give you things that are "like" your parameter. Example: I select Jon and it give me: Jon, Jonathan and Jonas. However, I want ONLY Jon. When I leave it blank, I want Jon, Jonathan...

That'll give me the same issue. Remember, I'm using this in a form with a subform. It's already passing the parameter to the query to use in the subform. If I use the above, it won't show the results until I enter something. I need it to show all. Then, if they pick all entries that are...

Not sure what you mean. I don't see how that could work with my combo box. I need to give them the option to pick between 1 and 300. Using the quotations would give me a "set" parameter, correct?

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:] & "*"...

Nope, didn't help. Thanks though. I still can't figure this one out.

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...

It's very much like the "if" statements in excel if that is what you're used to... ...iif not... well. iif([condition is met], [then do this], [otherwise do this]) Example: You have a field called "Color" and you want it to display "Yes" in another field called "IsRed" if the color is red...