Search results

Thanks for the help namliam, now my query works almost perfectly! I just need to figure out how to turn the null value into a zero when it appears on the report. With the whole GROUP BY thing, I'm not too certain what I'm doing, I'm not versed in SQL in any way and I've been building all of my...

So right now I have a query that fetches all the information I need from one table. Now I need to add a field that will fetch data from another table, the problem is that the data in the second table may not have an entry for a given ID in the first table. This results in my query returning only...

So I was looking for a way to stop the user from closing my switchboard by right clicking the little tab thats above it in Access 2007. I figured I could do this by using the Default Shortcut Menu option and setting it to false. However I have a button titled Admin Mode. Whenever somone with...

I'm far from an access expert but wouldnt it be easier to generate the number at the same time as you enter the data?

Manually creating it worked, I don't know why that never came to mind when I was trying to solve this myself :(

So I have my database created and split and the user level security works great on it. Its on the network everyone can access it and do what they need to do, except for one or two of my users. They are using 64 bit windows seven, when they click the shortcut it fails and they get a messagebox...

SendObject function with a mailing list So what I need to do with my database is make it so that with the push of a button a report is generated and emailed. I figured a macro would do and the SendObject macro seems to be what I am looking for. However I want to have it Send to every email...

So I have my database split and setup on a network drive and it is working great. I also have the front end secured with ULS but the backend is not secured. I was wondering how I would go about securing the backend so that is uses the exact same workgroup file that the front end of the database...

So my database has user level security on it, and now I need to transfer it from my machine to its final location on the network drive. However I realised that I cannot just move the secured shortcut, workgroup file, front end (for others to copy) and backend onto the network as this does not...

So when I went to split my database I got a subscript error, I compiled my VBA code and checked and everything worked properly so I just followed the directions to split it manually. Now that it has been split when I go to use it none of my VBA code runs, the code is there, all functions and...

I definately have heard of the corruption problems, luckily the database isnt on the network yet, how I'm handling it at the moment is developing it locally on one machine and uploading a fresh copy (including backups) to the network drive at the end of every evening, this way my supervisors can...

Ok, this should work for the meantime but in the future the database will be split and distributed to about 10 or 15 different people on the network, what happens if multiple people are accessing the database?

This does shrink the database quite a bit. Is there anyway to make a button or command out of this? The person that will be administrating the database is pretty computer illiterate, and how often would you recommend this is done?

So I realize that Access 2007 has a file size limit of 2GB, and the database I am developing now is far from that, however I am noticing that as queries and forms are run the size of the database file grows. I was wondering if there was anyway to prevent this from happening or if there was...

Well looks like I got it all figured out, thanks for the help guys!

EDIT: Aha! I figured it out, just needed to edit one relationship to make it work perfectly

Yeah that is what it should read. Im getting the just of what you guys are saying. The name the person goes by in the system is the alias. Im not entirely sure were all on the exact same page. Basically what I need is a query that generates five fields. I need Hours from Warehouse Info...

Im pretty new to access and databases in general and I dont really know what I'm doing. I have a database that will track peoples punch in and out times for a warehouse and im trying to make a query that brings up the information for the latest set of entries (ie: The previous days). However...