Search results

I plan on having a form that my users could use to save information into. I've gotten the shortcut to work, but not exactly like I want. I would like to know what ways others use. I am attempting: - A shortcut for the form - Pre-sized form window that can't be resized by users - When it opens...

I have a form where I would like the user to be able to choose multiple checkboxes, buttons, or whatever that would go in the same field in a table. Basically I have several locations. I would like the user to be able to choose several locations at once and once they save the document the...

Not sure whether to put this under tables or forms... I have a form that users are required to enter the date & time in the same column. If the users only enter time the database accepts that. I want the database to restrict them from not entering both date & time. These entries subtract...

I have a drop-down menu that has several pre-filled entries as options. How can I make that option where you have no choice but to choose an option within the drop-down menu? Currently you can either use the drop-down or start typing the last name of the person and they rest of their name pops...

I have several queries created. I have one column that takes hospitals and a second column that takes different medical issues. I want to create queries that can sort by a specific hospital and medical issues. For example: Hospital - PCMH Medical Issues - Code Stroke, Hemorrhage, Pnuemothorax...

I am attempting to setup a query that comes from another query and only lists patients on the query if they've had a Code Stroke. So pretty much, if they've had anything else it would emit those patients from the query. If possible, it would be great to do this w/o any coding.

In my query I have 2 columns. In each column there is a date & time. I have the columns subtract from each other and in another column give: D:HH:NN (which equals to DAYS:HOURS:MINUTES) Everything is correct except the day column, it's kinda correct. No matter what everything equals out to the...

I have a database that has columns that include date & time. In a similar excel spreadsheet, I have an additional column that can subtract the difference between those date/time columns and give you the days/hours/minutes left. How can I mimic this in database? I am by far not a program, so...

Is there a way to make a query that can give the difference of 2 columns that have date/time to give a result in days/hours/minutes in the 3rd column? I have a formula in excel that does this. I transferred that data into access and of course access is not calculating the time.

Does access have the ability to use formulas to calculate such as excel does? I am copying and pasting an excel spreadsheet I have into an access table. The excel spreadsheet has a formula: =TEXT(D2-C2,"d:h:mm") This formula calculates days/hours/minutes from 2 columns I have in the...

How do you adjust the values on the Y-Axis of a graph? I have numbers that represent minutes ranging from 0 minutes anywhere on up to 1200 or so minutes. Since the values are so broad the majority of the values that range between 0-60 minutes have nothing on the y-axis. It has the values 1600...

I plan on exporting the data I have in an excel spreadsheet to an access database. 2 of the columns in the excel spreadsheet have code in them that helps them calculate day/hours/minutes between dates from 3 other cells. When the information is entered in the form for the database will those...

Can you somehow link calculated data from one cell to appear in another cell in another format? I have the data in the cell calculating like TEXT(D2-C2,"d:h:mm") which gives time in days/hours/minutes. Is there a way I can make that result show up in another cell in minutes?

How do you link an Access Table to an Existing Excel spreadsheet? And when you put data in either the database or the spreadsheet will it reverse populate the other? Like, if I put something in Excel will it be in Access and vice versa?

How do I create a rolling calendar out of a yearly calendar I already have in excel? Or just how do I create one?

What do I need to do to have a field in my table to except numbers & text?

I am having difficulty creating a shortcut that only opens the access form. I have successfully created one that opens the form, but the database loads behind it. I do not want users to see all this, because it might confuse them, plus they don't need access to this much information. Is there...

I am using Access 2000. Evidently adding a Command Button isn't as cut and dry as clicking on it, selecting a location on your form, and going through the wizard and choosing what you want. I have added a Save Record & Add Record to my form. Evidently some VB coding is required. Which, I don't...

I am using Access 2000. I am trying to get my form to open up blank. So that when a user prepares to enter information in the blanks there is no data already in the fields. I am familar with access, but have no idea about this VB coding stuff. So if you have the time and decide to answer my...