Search results

So, when I try to create data access pages in my front-end, it freezes. Wizard, design mode, anything--freezes. It's not my version of access, b/c I can create them in other dbs...it's not my computer, because other users have the same problem.. any ideas? it's an a2k2/3 front end linked to...

so i have a button on my switchboard that prints a report... the problem is that when it's clicked, the database window -- which should be hidden! -- is revealed. the code is (it's just slightly modified wizard code): Private Sub cmdPrintAlphaRoster_Click() On Error GoTo...

Hello everyone, I have a report in which I have numerous records in a sort of step format, sort of like this What office they work in -> Position/Job title ->->Name/phone# etc. Now this , as you can tell, generates several groups of 'stepped' records. what I would like to (okay, love to)...

okay, so i hvae two tables, we'll call them "a" and "b". A has a series of names. B has a series of what we call "position numbers". For resource mgt purposes, we have to slot each individual into a position #. Now two people can belong to one position #, but one person cannot be in two...

so i have a table with like 5 email addresses, and some code that docmd.sendobject's a report or sometimes a query, and i want the to box to be populated with every record in the aforementioned table. i searched the archives but no simple answer leaped out at me -- is there one? thanks to...

so i have a field in a report, and i want it bold if it has a certain value. 1. where do i put that sort of code? 2. and what property controls fontweight of a text box programatically? thanks, bp

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

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

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

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

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

ok, so using the code i got from another post in this forum.... Dim EmailApp, NameSpace, EmailSend As Object Set EmailApp = CreateObject("Outlook.Application") Set NameSpace = EmailApp.getNameSpace("MAPI") Set EmailSend = EmailApp.CreateItem(0) EmailSend.to...

alright, i know this question has been addressed DOZENS of times before, but I've yet to see a definitive answer. i screwed with securities at one point or another but abandon that path. however, now my database randomly opens exclusively, meaning no one can use it... why is this? the...

so i have a combo box with a list of names sourced from my personnel roster. upon selecting a name, it references a query that holds the fields name, trained, and grade. it then populates a trained and grade txt box the criteria on name is Forms.frmPersonnel.cboRatersname i get the feeling...

With this syntax: Private Sub cboGrade_Click(Cancel As Integer) If Me!cboRank = "AMN" Or Me!cboRank = "AB" Or Me!cboRank = "A1C" Or Me!cboRank = "SRA" Or Me!cboRank = "SSGT" Or _ Me!cboRank = "TSGT" Or Me!cboRank = "MSGT" Or Me!cboRank = "SMSGT" Or Me!cboRank = "CMSGT" Then...

So before i release this onto the server for all 7 of my users, i'm curious, how will it perform? i'm running access 2000 and everyone uses either XP or win2k. generally at any given time 5-7 people will be manipulating one form, and possibly generating queries/reports/etc. there's not too...

so i'm addressing a problem ive been working on for a month or so, here goes: i have 2 cbo's on my form, one of which has a list of values: a b c d e f The second box is a list of possible suffixes for each possible value in box 1. so we'll say its 1, 2, 3, 4, 5 if a can only hae 1, 3...