Recent content by ctr1085

I have to replicate my database in a different location each day and I wanted to know if there's a way to retain the security and linkage once moved. My goal is to move the database. Front-End and Back-End as well as the security file so that it can be used at another site for reporting. Due...

Sorry for the dumb question. I figured out what was wrong. My back end data base was not configured correctly for the groups.

Ok so what your saying is the User itself will not show any privelages if I select them even after adding them to the groups with privelages? I'm a little confused because my user account did show the settings. Maybe it's because I'm the creater / administrator.

I moved my access database and not my user account do not have privelages. However, the group accounts they are linked to have been set-up correctly. Why would my group account privelages be ok, but when I look at each user individually they have no privelages set. I'm confused as to why...

Thanks for the reply. After searching everywhere and trying to add spaces I have found that message boxes are not very good when it comes to formatting. a pop-up message form is the easiest way to solve my issues. Thanks for your help.

Does anyone know if there is a way to align text in a message box? I have a number of categories I want to display with the values and I want everything to line up. I want the ":" to line up on each category EX. Statement_ID: 312030 Parent: ABC Statement_Amount: $50,000.00

Does anyone know if there is a way to align text in a message box? I have a number of categories I want to display with the values and I want everything to line up. I want the ":" to line up on each category EX. Statement_ID: 312030 Parent: ABC Statement_Amount: $50,000.00

Checo, I'm not having a problem transfering the data to excel. What I'm trying to accomplish is set ranges to calculate formulas in excel from Access. In excel I can declare ranges. Access does not allow this from what I have seen. Dim prngA as Range << Excel only? Here's the code I'm...

I'm a little confused about what your trying to say. Do you want a text box to be updated or have a message box? Maybe you could set up an unassigned text box and use a case statement based upon your criteria. Sub test() User = Environ("username") Select Case User Case "jel"...

From personal experience I have found it easier to declare variables as long integers and passing the date value into them. Microsoft has their own way to display dates. (i.e. 7/12/06 = 38910) When you pass 7/12/06 into a long integer variable you will see "38910" Your SQL Statement could be...

Is there a way to set a "Range" from vb code in Access? I use ranges a lot in excel to create formulas and I cannot figure out how to do this from access when exporting data to excel. Any information would be appreciated.

Thanks for the info.

I checked this option out. The only problem I'm running into is the fact that I don't want to save the spreadsheet. I want to open an Excel occurance without saving and paste the recordset. Is there a way to goto the header information in a recordset?

I am able to copy a recordset to excel, but I can't figure out how to copy the column headers. Any information would be appreciated.

Can you explaing how I can filter the query for my pivot table?