Search results

IT here has started rolling over everybodys office packages from 2007 (32 bit) to 2010 (64 bit). The database we are currently using is a split MDB database. Right now one user has office 2010 and when I open the database theres all kinds of problems I can't seem to pinpoint or fix. I have...

So I've designed a database for several users using user level security with the older mdb file format. The database is split with the back end on a network drive. I'm looking into making the jump to SQL but I have a few questions about making the jump. Should I be using the accdb or adp file...

Exactly, I actually don't think that the people the database is designed for are computer literate enough to be able to recreate it :eek: Well IT here backs up the network drive every night, and if I recall correctly they keep backups for up to 3 or so weeks, so they should be able to roll...

Ok so the database I have created is setup with UAC, I actually set that all up quite awhile ago. My contract with this company is coming to an end in the next few days so I've been trying to make sure everyone is setup, knows what their doing and has everything they will need. Here is where we...

Cool beans! Thanks for the tip Bob!

So in one of my reports I use a memo field. However when the field is queried and placed into the report it is cut off at what I am assuming is 250 characters. I have had this happen in the past but I fixed it by setting the memo fields total property in the query to First instead of Group By...

Query not being consistent [Resolved] This is really confusing me. I have a form where a name is given along with two dates. Then a button is pressed which opens a report, the data source for the report is a query. The query uses the name given alongside the two dates to find all the errors...

Well the numerical ID is the employee number given to the person by HR, and the login ID is the ID that is used by the punch clock system, so it doesnt really make a whole lot of sense to have our entire operation changed to work around an access database, the problem is that whoever originally...

This query basically groups everything together, it pulls from one query that finds all of the last days entries. Then from there is pulls additional information about the employee (such as position, name ect), it also pulls the Performance and Offline data for the employee as well as there...

So within my database of employees, when the daily productivity reports are generated one employee is missing. I went back to the query that the report is based on and discovered that the query actually doesnt pull his record at all. I went back through my tables and all of the data for him is...

I'm personally waiting for a price drop. Im sure Kinect isn't a terrible idea but theres no way I'm paying $150 for it, plus there's no benefit being an early adopter because as mentioned earlier, most of the games will be low quality and buggy.

While this is mostly true, there are a few games ive purchased in this price range that have just been horrid. The x-men 3 movie game and megaman 10 off of the xbla (okay maybe this one wasnt horrible, just wasnt my style of game) are two the come to mind immediately.

Anybody given Darksiders a try on xbox 360 or ps3? I grabbed a copy of it for $3 new from work (trying to clear inventory, the games go to retail stores from our warehouse) and I've been enjoying it quite a bit. Alot of the reviews give it flak but I think thats just because it came out around...

Cant make the font any smaller (bosses orders :confused:) but the can grow property was set to yes and that appears to be the problem thanks for the assistance :D

Ok so ive uploaded screenshots on both the design view and report view of the forum, there isnt alot of ambiguous space in the report itself, I think I've done a pretty decent job at keeping everything tight and compact Edit: Also there are no subreports at all

So I was looking at one of my older spreadsheet style reports (I believe that is the name for it) and I realized that after the 6th record (of about 50) there is a large area of whitespace about twice the size of the space between every other record. Ive tried changing the sorting order and...

Yup that did it, thanks Bob, guess I should be more careful with my naming next time around

No the field is not named [Source] it is named [Logged], just didnt want to window back to check the name when I was typing my question

I don't know what I'm doing wrong or if I'm having a total brain fart here (hey it is friday) but I'm trying to apply the round function to a field in one of my reports. So I go into the control source of the field and when I change it to Round ([SOURCE],0) it asks for a parameter, if I build it...

After some further consideration, I think I should be able to make it work with DLookups and other functions if I can just get the Login field to be unique, even without the type field inside of the query EDIT: Aha! After tinkering with my Query and using some DLookups I got it working...