Search results for query: *

In a form, I have an unbound textbox (TEXT1) with an option button next to it (OPTION1). In a query, I have the field, LAST NAME. The criteria for LAST NAME is linked to TEXT1 in the form: [Forms]![frm_MAIN]![TEXT1] But, if the person highlights the option button, I want the criteria to...

I have a query that has about 500 names in it. The query is sorted in ascending order based off of last name. I have a form based off of that query. The form is a continuous form. In the form header, I have 26 labels for each letter of the alphabet, so that if I click on 'F', I want it to...

I have a DMAX function where I need 'XX' = me.textbox1.value: DMax("[Year]", "tbl_MAIN", "XX") I tried: DMax("[Year]", "tbl_MAIN", me.textbox1.value), but produces a run time error. I'm sure it's something simple, but I can't figure it out. Thank you!

I have a form that has a date field in it. All the date fields are blank, and I want to time stamp them. I have the following code through a command button: Me.TEXTBOX_DATE.Value = Date However, this only inserts the time for the first record and not all of them. My guess is it needs a...

Column A = employees last name Column B = a dollar amount The range A1:B11 is populated by employees and dollar amounts like so - Employee $$$ -------- ----- Smith 100 Johnson 200 Allen 2500 Smith 100 Smith 1000 Johnson 950 Allen 700 Allen...

I have the following macro that will sort range C3:H298 by column D - Range("c3:h298").Select Selection.Sort Key1:=Range("D:D"),Order1:=xlDescending, header:=xlNo, _OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom However, if someone adds a row, I don't want to change the...

I have the following DCount statement in my VBA: DCount("[Quantity]", "tbl_Main") This obviously counts all of [Quantity], but I want to be able to count the quantity of only records where FieldX in the same table equals 'Team'. I can't figure out how to add in the WHERE statement in my...

I bought a new PC that had 1 SATA drive installed. I bought a second one to install myself. The two HDs are identical (WD 250 GB SATA-II). The drive that came with the PC has no jumper pins, and the second one came with no jumper pins, so my understanding is that SATA does not need jumper...

I am trying to do a text search on files at work with no extensions. I am trying to find for example the text "5556666" in a flat ascii file with no extension. Windows search doesnt find it usually, but if I throw on a .txt extension, it does. My question is how can I search for text in files...

I have a table with 1 Field. That field is made up of a bunch of 10 digit numbers. There are a ton of numbers that begin with the same 7 digits. I want pull back a random number for each unique first 7 digits. Example: Field 1 -------- 1234567000 1234567111 1234567222 1234567NNN 7654321000...

In cell A1, I have the following formula: =HYPERLINK(B7, "Click Here") I want it so that when the user clicks on cell A1, the focus is moved to cell B7. The above formula does not work though. I am using Excel 2000. Any suggestions? TIA

I am trying to write a macro to import an .txt file that is tab delimited. The problem I run into is that on the import, it keeps all the data in the first field. Here is the code I have: Private Sub Command0_Click() DoCmd.TransferText acImportDelim, , "tbl_Main", "C:\text file.txt", 0 End...

In Excel, I want to send the active wrokbook to a specific address via Outlook. Here is the code I have: Sub Object15_Click() ' MACRO to email completed doc to specified Outlook Inbox ActiveWorkbook.SendMail _ Recipients:="joe@somewhere.com", _ Subject:="Active_Workbook" End Sub...

I have an array of text phrases (A1:A4). I have another array of text phrases (B1:B4) ___A___ ____B_____ __C__ 1 | Up | Northeast | T 2 | Down | Downward | T 3 | North | Up | T 4 | South | West | F In C1, I want a formula that says, take the value in B1 and...

I am trying to hyperlink an object (or assign a macro to it) so that when the end user clicks on the object in Slide Show view, the object will enlarge. Are there any sites, past forums, or simple solutions to achieve that? TIA.

I am trying to write a command to have the Windows Start Button show. I am using the SendKeys function for the first time, and here is what I wrote... Private Sub Command0_Click() SendKeys "^ESC", True End Sub Nothing happens, am I missing anyting? Thank you!

I have a field in an Access 2000 query that are email addresses. I am trying to define another field in the query to return the text after the '@'. Here is what I wrote... Email Provider: Right([EMAIL_ADDR],Len(([EMAIL_ADDR])-FIND("@",[EMAIL_ADDR]))) The problem is that Access does not...

In Excel, I have the following formula: =IF(B1 = $C$2, 1, (B1+1)) But I want the formula to be: =IF(B1 = $C$2, 01, (B1+1)) I want the cell to be 01, instead of 1. If I change the cell to text, then the formula shows as the value, and I have tried using a single quote and double quotes in...

In my form's OnCurrent event, I have the following code: Me.Text43.Value = Me.Recordset.RecordCount When the form opens, it give me the Runtime error 91: Object variable or with block variable not set However, I have the same code in another form, and it runs fine. Any thoughts?

I have 8 objects that I have to group in all possible pairs of 2. Using the formula, COMBIN(8,2), the result is 28 possible combinations. Is there any way for the formula, or an other formula to return those 28 results? thanks!