Recent content by sstasiak

Thanks crobin, that works after I add the .lnk extension

Not sure where to put this question, but I'm trying to create a batch file to map a network drive, then copy a shortcut from a folder on that drive to the desktop of the current users profile. I've tried a bunch of different things, but can't seem to get the copy part to work. Here's what I...

alan I already set my default startup form, which is the login form. Once this is set, the user should have no way to get to these options to set the default form to something else. If they were able to get to these options, that would pretty much give them the ability to bypass the security...

Hey everyone....hopefully someone here will be able to help me with this issue. Right now in the "Current Database" view in "Access Options", I have the navigation pane, ribbons, menus, and shortcut menus disabled. However, when I close and re-open the DB, I still see the "Home" ribbon and the...

Not sure how to accomplish what I'm looking to do with the wizard. Can you elaborate? Remember, you're talking to a rookie here. Thanks again

PHV I got a notification that you replied again, but don't see it here when I refreshed the link. Please repost.

After some research, I think the easiest way to find a record is using a combo box that looks at records in my main table. I have another problem though. When I select the record from the combo box, and hit enter, I want my main form to open with all fields populated by the data associated...

I have a table(tblOncReg) that contains a record number field(MedRecNo), last name(LNAME), and first name(FNAME). I want to create a form with 3 text boxes that will accept a record number, last name, or first name, and search tblOncReg for associated records. The record should populate all...

How do I create a query to search by medical record number(MEDRECNO), last name(LNAME), and first name(FNAME). I want to put a button on my switchboard that'll open up a form where you have the option to put in a MEDRECNO, LNAME, or FNAME, click a button to run the search, and open up the main...

I'm trying to set something up to track patients weight history. I have primary key in the main table(MEDRECNO) set to have many (WeightID)'s in the 'Weight' table. In the main form, I have a 'Weight' subform. I want to add a button in the subform that when clicked, will search the 'Weight'...

Hi all When trying to open up my main form, I get a pop up box with title "Enter Parameter Value" and is asking me for MEDRECNO, which is the primary key in my main table. This main form has 2 subforms that are linked to it by the MEDRECNO. If I click "Cancel" on the first popup, the same one...

I have a main table with a MedRecordNum as the primary key. Each MedRecordNum can have multiple treatment regimens, and each regimen can have multiple treatment dates. I'm just wondering if I'm setting the relationships properly. I'm going to set MedRecordNum to have a one to many...

Hey guys I've seen a form in a database that had what looked like an embedded table. This table had column names, along with combo boxes for certain fields in the table. Can someone explain how to embed a table in a form, if that's even possible?

OK I've got another one to throw at you guys. I'm trying to design a patient registry to track treatments. Here are the relations: One patient can have multiple treatment regimens(or cycles). Each cycle ranges from 1-10 weeks, where a series of meds is given once a week. Here's how I was...

niteraven That didn't work. In the BSA field I now see '#Name?'