Search results

Guys that's why I ask the question and I appreciate the inputs so far. So I'll try and post as much relavent information that I can to show what's up but the computer sets at 50% the entire time which is taking up one of the two cores available on the machine. That is why I believe the...

I thought about using a crosstab but unfortunatly I can't see how a crosstab query will resolve the issue. If you can enlighten a little bit I would appreciate it. Spikepl: Understand all as far as not posting the code but I feel that's the problem trying to run vba in an active interface...

So I have been doing some investigating but have not found a good solution to my current problem. I have two tables. The first table stores jobs The second table stores different statuses on the job Its a one to many relationship but for meetings and other purposes I need to show all of the...

Please disregard I figured out it was just an access glitch and I had to delete the column and paste in my code again... figures But here is another problem I am having with it. If a value in a column is null and I have it in my exists line it wants to add the whole record anyway. Is there...

I have an issue where my Exists function in my Append query keeps giving me this error message "AggregateType is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not to long." Here is the exists line. Test: Exists (Select * from [SDSK...

Please understand I do not have enough time to give a complete tutorial on how to use or work with access right now. There are plenty of youtube videos and other resources out there that can get you to where you understand what I did in the code. If you have a specific question then I dont mind...

Ahh thanks exactly what I was looking for!

I have a mind boggling logic problem that I just can't seem to put my finger on what to do... I am trying to find all training that is happening during the period of one week. While I have been able to get this to work with using a between statement there is still a problem where it does not...

Your welcome and good luck :)

I believe that it's being limited by the number of rows of data so I'm ok I'll work around it. Thanks for your time and help.

Yes they do have that at the bottom and yes they can clear the filter out but it is only letting them filter one column at any one time instead of letting them filter one column then filter another column to get specific results. I apologies I should have not said they had to close it out every...

Option Compare Database ' InitOutlook sets up outlookApp and outlookNamespace. Private outlookApp As Outlook.Application Private outlookNamespace As Outlook.Namespace Sub InitOutlook() ' Initialize a session in Outlook ' This starts outlook or just uses the currently open one. Set...

Version 2007

So this may be a simple problem to fix or maybe its just the way access works but I have many queries where users can view as reference data. The problem I am facing is that when the user first opens the query they can select the little arrow next to the field and select what they want to filter...

Attached to this post should have the modified code. If this does not work then send me a few sample files and I'll debug the code.

I'll upload a new database sometime either today or tomorrow. It just sounds like a misunderstanding because the lines of code I put in red are only for closing an object not creating one.

It might be later on today because of my work load or even tomorrow but I'll try to explain it soon.

Add the following red lines to your function in the module at the exact spot I have shown here and it should resolve the issue. But if you keep getting error messages to get to that point then that needs figured out as well. Function GetDataFromExcelSheets(lSheetNumber As Long) Dim xlsApp...

spikepl Great find! It's the simple things that bite the hardest...

No worries. Gotta love adventures :D