Search results for query: *

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

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

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

I have a form with fields 'Height' and 'BSA' stored in table OncRegMain, and a subform with fields 'Weight' and 'Datetaken' stored in table WeightUpdate. The two tables are linked by a Medical record#(MedRecNo) which is the primary key of OncRegMain. The ID for the WeightUpdate fields is...

Hi I have a form frmOncRegMain that contains a combo box for a list of names. Next to this box is a button to add a new name to the list. The button opens a NameEntry form that accepts text. In this NameEntry form I created a save button that is supposed to save the name to tblNames, close...

Hi guys I'm having some trouble with a database I'm building. I have a form named frmNewPhys that has a text box to input a new physician name into the database, and a button linked to a macro that saves it, updates the physician table, and closes the window. I'm trying to figure out how I...