Search results for query: *

I want to display a date from a subform on my form and format it like: Thursday, May 12, 2005 I currently have it displaying on a text box (like a caption for a subform) using: =[qryFrmSubSleepEpisode]!EpisodeDate but I can't seem to get the syntax right to format it like I want to (above)...

I've searched and found a million threads with a similar problem, but I can't find an answer that I can understand. Here's the problem: I have a crosstab query to which I would like to add 2 parameters. This crosstab query is based on another (regular) query. The fields to which I want to add...

Hello. I am using the Networkdays function in Excel to calculate the difference between two dates based on working days only (m-f). I am also using a named range called 'holidays' which contains dates which should not be counted. Here's the syntax: =NETWORKDAYS(C10, E10,Holidays) That works...

Does it work to use a tab control as a form and subform, i.e., will it work to use the first tab as the main form and then a second tab as a subform (with records on the many side related to the first tab)? I've never tried this and just wanted to know if it works. Thanks, Julia

Hello, I'm sure there is a real simple solution to this problem. I am trying type the acronym CNA (certified nursing assistant) into a form and spell check keeps changing it to CAN. I haven't found a way to add CNA to the dictionary. What's the solution? Help. Thank you, Julia

Hello, How can I make a checkbox be checked when a user tabs to it and presses Enter rather than using the mouse? If this works then I wouldn't I have to somehow make it so that using the enter key didn't do the same thing as the tab key? Any great ideas to allow checking a checkbox without...

Hello, I have looked around on Tek-Tips a bit for some help with this but haven't been able to get anything to work yet. Please help with the code to open an excel file from an Access form based on a field's value displayed on the form. I am going to name an excel file (.xls) with the same name...

Is there a way to bold just some of a string in one text box on a report? Just wondering... Julia

I am having difficulty appending some records from one table into another. The "Append To" table has a primary key field which is an autonumber field. The "Append From" table has all of the same exact fields as the "Append To" table except for the autonumber field...

I have read and read but can't figure out how to do this... I need to create a query that only pulls the records with the most recent date based on a field in the table (in the example below this field would be SSN). So, for example, if this is my data: ReminderNum SSN DateSent 1...

Hello, I have two tables which have a one to one relationship (enforce referential integrity, cascade update/delete). When in the form (frmProtocol) for the main table (tblProtocol) and the user clicks on a button to open the form (frmBRFReview) based on the related table (tblBRFReview), I...

Does anyone know how to make a "Bar of Pie" sub-type pie chart in Excel? I just don't know how to set up the data for this. Thank you in advance for any help, Julia

Hello, Using Microsoft query, I have linked an Excel Workbook to an Access query. If I send someone this Excel file they get a message asking if they want to "Enable" or "Disable" query refresh. If I send this to someone who does not have access to the Access database (like...

Hello, I am creating a database for some users who are off-site. I am planning to have the tables in one database and everything else in another. There will only be two users. If I want to make changes to the application datase (the front end) and send it to them what is the best way to send it...

Hello, I have been working on this same report all day. Luckily, I have found answers to most of my questions thanks to TekTips! But... I am still having difficulty with a subreport. I have subreport that is linked to the main report (by master/child fields and in the relationships) The report...

Hello, I need to separate a field in a database (text) into two fields. The field (SedativeDose)currently holds values such as: 30 mg .21 mg 3 mcg 10 mg I believe the only way to do this would be to separate the numeric from the text. Does anyone know a good way to do this so I can create two...

Hello! I have been using Access for several years and I have learned that there is always more than one way to do everything. I have a new database to create and I want to set it up the best way possible. The database will be used to track correspondence with many people at many companies...

I have two questions: 1) I have an unbound report with 6 subreports on it. Each subreport runs off of parameter queries that ask for the user to enter a year. They will be entering the same year for each query but the year doesn't always come from the same field in the original tables. Aside...

Hello, I posed this question at the bottom of another posting but I haven't gotten a response. I will try it by itself. I have a form with a button that opens a small form that is used for searching the form/subform records. The small form has a two combo boxes and two buttons. The user can...

I tried to search for a previous answer to this question but the search feature is not working at the moment on this site. Please help if you can. I have a form that tracks clinical trials and a subform to choose the physician(s) participating in the trial. The detailed physician information...