Search results for query: *

I have a form with several tabs on it. I would like the form to Requery a specific query when I click on a certain tab. I tried putting the code in the "On Click" event of the tab, but it won't run. Where should I put the code? Thanks!

I need to refer to a subform field in a query. It pulls the info if my subform field is text, but if I try to refer to a number field on the subform, all I get is a character like this:
I get a blank field when I try to refer to a date. Yet all the text fields pull in fine. I'm...

I have four separate date fields in a record. I need to do an update query to compare all 4 date fields, and add the resulting lowest date to a new field in the record. What is the syntax I could use for that? I tried doing an if statement, but it got too big to try to compare all four dates...

I need to rotate a cell in Excel. I know I can rotate the TEXT part of the cell by going to Format, Cells, and Alignment, but I need to rotate the actual FILL color that is also in the cell. (45 degree angle) Someone sent me a worksheet where the fill was also rotated, but I can not figure out...

I'm trying to apply conditional formatting to a field in my form. I want the font color to be red if the value in the field is negative. This field is a calculated field, based on other fields in the form. I tried adding the code to the AfterUpdate, OnDirty, and OnChange events, but none of...

I currently have multiple queries that use the Count function. I have them all combined into one main query. My problem is that some of the Count queries do not find any records (and that is correct, there are currently no records meeting the criteria). But when the queries find no records...

I need help setting up an Access database to be able to input and analyze survey results. I want the user to be able to enter the survey results into a form that will list the 10 questions, each with 4 possible responses. I want to have a report that will list each question and the percent for...

I need to export an Access Report to a Text file with the fields each being a fixed width. What is the easiest way to format the report so I can tell what space a field will start at? Would any certain font in the design view help? I have been doing it field by field by trial and error, but...

I have a sort in Excel that is giving me a fit. Here are the Department Codes that I am trying to sort: 11903136655 119059921C7 119077921 51905799331 The above list is the order that I want them to be in. To me, 119031... should come before 119059... But here is the order that Excel is sorting...

I have an Access database that uses forms with some simple visual basic code. I have some tips and warnings pop up by using the With Assistant.NewBalloon command. The problem I am running into is that if someone has their Office Assistant turned off, the balloons are not showing up on their...

I am using a spreadsheet with many different sheets. When I choose File, Send To, Mail Recipient to send a certain sheet, the sheet shows up in receiver’s email with a blue background. There is no blue background on the sheet in the Excel file. When I do a print preview, there is no blue...

I have a form with a subform. I am unable to tab from the main form to the subform. If I click in the subform, I can not tab through the records in the subform, but I can't tab back to the main form after I have tabbed through all the subform records. The fields in the main and subform are...

I have a Form based on a Select query that pulls all Locations in a certain area. The user enters Square Footage (fieldname “Measured SF”) for each Location in the Detail Section of the form, and the Total Square Footage (fieldname “TotalMeasured”) entered is displayed in the Form Footer. I...

I have a form based on a query with a parameter. Everything works fine, but I want to be able to be in the form and be prompted again for a parameter, so the form will display different information. Example - Opening form prompts for Location. User enters location, and all matching records are...

Is there a way to subtotal in a query? What I'm trying to do is get my data to subtotal and create a separate table with records for only the subtotals on each value, instead of all the detail records in the original table. Is there any way I can do this? THANKS!!!

I would like the focus to be on a certain control/field (named "PlaintiffName") when I open a particular form. The tab index on the desired control is set to 1, and I've created the following Form Open Event for the form: DoCmd.Maximize DoCmd.GoToRecord acDataForm...

I have an SQL database in which I need to update using an HTML form & an ASP page. The table has 17 fields where one of the fields is an AutoNumber. My questions are: In my SQL statement, how do I update the AutoNumber? Does the SQL database do this automatically? Do I need a WHERE clause in...

I have an update query that I want to run in the background when a form is closed. It works fine except that it pops up message boxes to ask if I really want to update. I can turn off the message on MY computer by going to Tools, Options, Edit, and uncheck the Action Query box under Confirm...

I am trying to link three tables, and I am having trouble with records duplicating in a query. Here are my three tables: (all are linked by Record Series Number) Record Series Number - No duplicates allowed Box Data - Each box is assigned a record series, multiple boxes can have the same record...

Can I convert an Access 2000 database to a much older version of Access - as in Access 2.0 ??? If so, how?!