Search results

  1. C

    Linked Tables / Security upon move

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

    Security Issue - Group / User Accounts

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

    Security Issue - Group / User Accounts

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

    Security Issue - Group / User Accounts

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

    Align Text in Message Box

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

    Align Text in Message Box

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

    Align Text in Message Box

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

    Range in Excel from Access

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

    Assign value to textbox

    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"...
  10. C

    Passing Dates and Integers in vb

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

    Range in Excel from Access

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

    Saved Query Modification

    Thanks for the info.
  13. C

    Copy Recordset

    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?
  14. C

    Copy 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.
  15. C

    Saved Query Modification

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

    Conditional Formatting Problem.

    You need to put "Quotes" around your letters. Use an after_update procedure for your text box update. Here's an example. Unzip and open the DB. I have included a text box, which formats "A-H" in different colors with an After_Update procedure.
  17. C

    Saved Query Modification

    Does anyone know how to manipulate a saved query? I want to change the select statement with code so that my pivot table will use the new records. Any information would be appreciated.
  18. C

    Saved Query Modification

    Does anyone know how to manipulate a saved query? I want to change the select statement with code so that my pivot table will use the new records. Any information would be appreciated.
  19. C

    Conditional Formatting Problem.

    Try this: Try this. Private Sub txtbox_BeforeUpdate(Cancel As Integer) Select Case txtbox Case 1 txtbox.ForeColor = 255 Case 2 txtbox.ForeColor = 255 Case 3 txtbox.ForeColor = 255 Case 4 txtbox.ForeColor = 255 Case 5...
  20. C

    Queries from a form

    Anyone know how to update a saved query with new criteria? I was researching "QueryDef", but I'm not 100% sure how to go about it.
Back
Top Bottom