Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sstasiak

    DOS command to copy shortcut

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

    DOS command to copy shortcut

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

    Disabling menus and right click

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

    Disabling menus and right click

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

    Searching a table

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

    Searching a table

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

    Searching a table

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

    Searching a table

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

    Searching by primary key and name

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

    Searching and Reporting

    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'...
  11. sstasiak

    Getting "Enter Parameter Value" popups

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

    Relationship advice

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

    Table entry within a form

    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?
  14. sstasiak

    Dynamic creation of forms

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

    Auto-populating a text box

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

    Can't refresh table

    gshen I'd like to see that code. Does this site have a private message feature?
  17. sstasiak

    Can't refresh table

    In my case, I sometimes need to select a name from a list, and sometimes need to add a new one right from the form. When I add a name, it doesn't automatically populate the combobox, so I need to select it. But the change in the table doesn't reflect in the list until the form is refreshed. I...
  18. sstasiak

    Auto-populating a text box

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

    Can't refresh table

    Not to good with the code, but I got it working. I just added a macro so the main form refreshes when the combobox is clicked. Thanks anyway
  20. sstasiak

    Can't refresh table

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

Part and Inventory Search

Back
Top