Search results

Your gut is correct. The database I have inherited is quite the fundamental design nightmare. I'm working slowly but surely to correct everything while also making the user happy. Thanks for the input. I will try to split it up that way. Thanks for the help!

Hello all, So, I'm having trouble creating a query to give me a count of all the males with a certain ethnicity and females with a certain ethnicity. I have a table that is setup for those two categories. It has the ethnicity and gender listed with check boxes (requested by the user) and...

Yes, that should work too. The older version of Access 2007 will work with the newer version. So, if you were to convert it to the older version on your PC then it should work on the other PC. I know that is true for Access 2000-2003 working in Access 2007-2010. But i'm not quite sure if that...

From what I have read up on, it appears to be an error that is saying your Database is corrupt. Maybe since your version of Access has SP3 installed and the other computer does not have SP3, you used something exclusive to SP3 and it has no way to open up the version you created. Try downloading...

I know, I was seeing if you were opening the file on your local machine or opening the file from the network on your machine. Have you tried taking the Front End off of the network and putting it on the local machine of the computer that is not able to open it?

It's amazing that this thread spans over 3 years haha. But I am an average FPS gamer and I have played each CoD after Modern Warfare 2 and played only Battlefield 3. I really think that Battlefield is better for me because of the larger maps (less time I am being killed) and the vehicles. CoD I...

Are you opening the Front End on your PC as a local file, or are you opening the file on the shared network?

If i'm not mistaken, you can find out which bit version of Access you have by going to the help menu and it should list it underneath the "About Microsoft Access." I'm not sure if Access 2007 is different than that. I'm using 2010 and that is how I found it.

I use Microsoft Security Essentials as well. And I scan my computer every now and then using Malwarebytes to get rid of malware and spyware if need be. I also use this combination at work and as long as user are taught what they should not click on when on the web, things should run smoothly.

I've been trying to do the same thing for the past month. The user wants to be able to see the picture of the PDF and then be able to send an email from the form as well. From what I have gathered, I have only been able to get just a mini image that pops up. Things like bitmap images work fine...

technical difficulties in

of the planet

SAS is like that with benefits. They don't even have a set schedule for work. As long as you log the 36-38 hours for the week, you can come in whenever. It seems like a really cool place to work. They even let you work from home in some cases.

Ah, I did not think of that. Thank you very much for the great idea! Gonna try that out.

The idea is that the Managers will not be doing anything but looking at and running reports to see evaluations of students in a Co-Op program so they won't be actually entering any data. The Co-Op coordinator will be handling entering the data. I haven't gotten all the details mainly because he...

Hello all! I am currently working on an Access 2010 DB and as of now only one user has access to it and the user is wanting to be able to distribute it to other Managers for them to look at. The problem I am running into is I need a way to hide the first 5 digits of the SSN so the...

That is quite the specific amount of beverage consumptions there. I usually have my big cup of coffee that last me until I reach around 9:00am then I switch between A soft drink of some kind (Mountain Dew) and water. Trying to nullify my bad drinks with water :D

Thanks for the reply Estuardo! After some more research I have found out that the OLE object itself can't be sent through email from the database. It can be sent as a report with the OLE object, but not alone. I have decided to just use a hyperlink referencing the spreadsheet in the database...

Hello, I am currently updating an Access database and was wondering if there was a way to send an OLE Object (in this case an Excel Spreadsheet) as an attachment to an email address using VBA code? I have looked all over the place and have not found anything that helps my situation. I made a...