Search results

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

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

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

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

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

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

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.

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

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

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

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

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

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

perfect, thanks!

exactly -- can it be done?

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?

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

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

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?

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