Search results

  1. B

    Ambiguous name, ?

    With that in mind, I deleted the module and then imported it (as opposed to copy/pasting). Still same error :\
  2. B

    Ambiguous name, ?

    That was my initial guess, too. The thing is, this particular mdb only has one module and one form (and a table), and the form only has the code i posted earlier, and the module can be seen below. These bits of code were copied/pasted from another database where they worked flawlessly...
  3. B

    Ambiguous name, ?

    The code for the click function is below, the line it screws up at is: ChangeProperty "AllowBypassKey", dbBoolean, True Private Sub Command45_Click() On Error GoTo Err_bDisableBypassKey_Click Dim strInput As String Dim strMsg As String Beep strMsg = "Do you want to...
  4. B

    Ambiguous name, ?

    If i didn't shave my head, this would make me pull my hair out. in one db, i have a module that defines a changeproperty function, and a form that calls it onclick. i don't think what it does is relevant. anyway, in one database, it works fine. i create another databse, copy the button code...
  5. B

    is this code crapping out on me?

    Hi everyone. The code below is attached to the onload event of my switchboard. the db hides the database window and has shiftkey bypass and only allows certain users in (moderate security measures). flow of the function goes a bit like this: verify user is authorized, if not close database...
  6. B

    i am such a tool

    Ok, simple simple simple code with probably a simple simple error, but i can't catch it. as far as i know, a type mismatch is when you try to compare apples to oranges, which i don't think i'm doing here: If Environ("username") = ("PaquetteBM" Or "DunnSW" Or "WatsonHL" Or "RussellYR" Or...
  7. B

    object descriptions

    er just in case anyone reads this thread wanting to do the same thing: I just set up a table/query with descriptions and worked some row source magic with a list box.
  8. B

    object descriptions

    sorry for the timespaz of this post, but i've been researching this and still can't find anything. anyone have any ideas?
  9. B

    object descriptions

    So I have a form that lists all my queries, and you can pop one open with a click. My problem is that I want to display descriptions for each query. I imagine this is done by displaying the description field of that object somewhere on the form. i'm using an msysobjects query to gather the...
  10. B

    Database crapping out

    were you able to repair the db, though? also, you don't have a sample of that code do you? loops i'm familiar with but i'd like to see an example in action. I am running an audit trail module, and the form is shared, so that sounds pretty feasible. thanks BP
  11. B

    Database crapping out

    ,and, those kb pages imply that there's a data corruption problem, and that that causes the error -- but the 'back end' of the db works fine -- fields and all. the front end is the only one that's pissed out on me.
  12. B

    Database crapping out

    i clicked through there and read all that jazz, but it seems to imply those errors/fixes are for access 97 and all they suggest is to bring my jet engine up to date... i'm running 2002 so i'm assuming it has already been brought up to date. any ideas? i can't even repair the damned thing nor...
  13. B

    Database crapping out

    "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." That's the error when I try to open my split database that's stored on a shared drive. I've had all users reboot their systems to sever any leftover...
  14. B

    Creating a blank query programatically

    perfect, thanks!
  15. B

    Creating a blank query programatically

    exactly -- can it be done?
  16. B

    Creating a blank query programatically

    perused the vast access world threads for this answer, to no avail. trying to simply create a blank query through access. i want the user to simply be able to click on a button and have a new blank query pop up. there's gotta be a method to this.. anyone?
  17. B

    scheduled events

    Picture this: a member of your squadron goes on Quarters (that is, they're on medical leave at home). They're on this for 72 hours. You have a field in your database called status wherein one of the values is Quarters. So on 1 Feb you set it to Quarters from Active. Is there any sort of...
  18. B

    Turning filter off

    private sub form_onload() Me.FilterOn = false end sub does that work?
  19. B

    Rotate an image

    is it one tiff file or do you need the ability to rotate any image? if its the latter i'm at aloss; if its the former why not just store 2 images and switch between on whatever event?
  20. B

    code

    hrm... so i have something i want to write but am afraid i'm having trouble figuring out where to start. recently my squadron did a physical fitness test of running, pushups, situps, and abdomen measurement. the results of each gave you a point score based on age/gender. so for me, a 19 year...
Back
Top Bottom