Search results

Okay, I'm still having a little trouble with this. I added a text box for every field that might have the criteria in it. Then I added it to my query. However, I think because I want my criteria to be anything greater than a certain number, my query won't run. Here is my query with one of...

I apologize for the confusion. "Buckets" is the name for the field that I added to my form. A "bucket" is how my manager groups the service calls. I'm afraid, I misunderstood what you had suggested originally. I thought I needed a combo box for how many fields would have criteria on them...

That is what I want to do - vary the field on which to apply the criteria. I'm afraid, I'm a little unsure what to do though. I added a combo box containing all the available "buckets" to an existing form. Then I tried to add it to my query, but can't get it to run. The user will only need...

Is there any way to view a Saved Import to see what it is doing? I just inherited a database from someone that has several saved imports. I need to be able to see where the data is coming from and where it is going to so that I can recreate it using VBA.

Is it possible to have a parameter in the field row of a query? That way, the user could select the field they want to query against without going into the design view of the query.

Is there a way to have one parameter in a query effect multiple fields? I have a table that details service calls on our equipment. There are columns in that table for each part of the equipment that get marked, depending on what needed serviced (i.e. software, printer, keypad, monitor, etc)...

That worked perfectly. Thank you very much for your assistance.

Is there a way to take today's date and calculate the last day of the last month? Without the user needing to enter any parameters. In other words, if I ran the query today with this criteria, it would only show information for April 30, 2013. Is that possible?

That worked, a little slow, but it worked. Thank you very much.

I have a union query in my database that calculates the average hours it takes to install equipment for various customers. Right now, it lists everything down, like this: Customer Type ------ Average Install Hours ---- Install Month --- Install Year Strategic ------------ 4.5...

I didn't delete the indexes, and they weren't on the number fields I was going to change. I recreated the table, as you suggested with the new file sizes and with the indexes I wanted. Then I imported the data into the new table. After I removed the old table, I compacted and repaired again...

I have a database, that is really bloated, and I am trying to reduce the file size by changing five number fields from Decimal to Long Integer. However, it keeps telling me that it doesn't have the memory to perform this task. When I compact and repair it, it clears all the indexes I had in...

My manager just found a link to software that will capture data out of an e-mail and use it to update a database. I was just wondering if anyone has ever heard of or used Email2DB (http://www.email2db.com/email-to-database.aspx). If you have, is it good or bad?

I was just wondering if anyone knew anything about the command initializerepository. I have been using vba to connect to DB2 tables on a server. To do that, I used the InitializeServer command (actually, my manager set that up - I have never used IntializeServer when writing vba from scratch)...

That worked perfectly. Thank you very much. I have one more quick question. This query takes about five minutes to run. Do you know of any way to make it run quicker?

I tried changing it to read CLng((Reboots*'\'*[Base Units])) AS [Reboots per Unit], but it ran forever and eventually gave me a Type Mismatch error. Have I done something wrong?

I have a database that keeps track of service calls for my company. I am trying to create a query that will show how many times a technician has had to reboot the machine in order to solve the problem and then divide that by the number of machines at the customer site. Every service call has...

That worked perfectly. Thank you very much for your help.

Is there any way to password protect the VBA only in a database? I have spent several weeks programming a database to be used by myself and two other people for a huge project. I recently discovered that one or else both of the other people on the project have gone in and made changes to the...

Thank you for the information.