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...

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...

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...

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...

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...

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...

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...

I have a spreadsheet style report that acts as a calendar. It works fine and retreives all the data I want (vacation days taken) for each person, however if somone takes more than one vacation day in a week (the report only shows the data for a selected week) they will show up on two rows. I...

I don't really know alot about Outlook and its calendar/appointment system, but I was wondering if it would be possible to have a form in access export data to a blank calendar in outlook when a button is pressed?

So all of my users can run my macro to import data from excel into the access database, however sometimes they will ranomly get the following error Action Failed Macro Name: Import Condition: True Action Name: TransferSpreadsheet Arguments: Import, 10,Offline...

So I need to create a calendar to track vacation days for employees. Currently I have a table that stores all the data I should need to make the calendar (employee name, vacation date, ect ect) however Im not sure where to start with actually generating the calendar, isn't this something that...

So I've been looking for a way to automatically save my reports as PDFs in Access 2007. I have downloaded and installed the Microsoft add-in that is supposed to allow this. I can see the add-in inside of the office menu and it works fine, but I'm looking to tie it to a button with some VBA code...

So I'm in quite a pickle here and I have no idea why. I have a button at the bottom of a form that is used to edit some details. All it does is save the details and then run a few lines of VBA code, which disable warnings and run two action querys (one to append and one to delete) before...

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...

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...