Search results for query: *

I would like to create a query based on the 3rd & 4th characters in a field. The total field is 8 characters. ex. find all records where those characters are "FR" field name is trkNum. Any ideas?

ld like to put some recordset handling in a common module. When I try to call it from a form I get an error: "The expression On Click you entered as the event property setting produced the following error: Invalid Outside Procedure. * The expression may not result in the name of...

Can someone explain to me how to use a "module" for something, instead of having the code stored within a form? and/or where I can find information on it? Thanks

I took the following function code from an articl "How to: Find the Number of Days in a month in Access 2000. Problem is, when I try to test it like they say: "In the immediate window type ?DaysInMonth(Date())" I get a visual basic "Run-time error '13': Type mismatch" error. Function...

I want to use a msgbox to display a "Yes" & "No" button. If "Yes" is pressed I want to perform fnct1. If no is pressed I just want to cancel/clear the msg box. Can I do this? & how would I indicate the function to perform on "Yes" selection?

I have a cboPOC on a main form. When I select that POC, I want to access the POC table and update the dtLastUsed field in the POC table. (intPOC is the key to POC table, and the bound field for the cbo) I am using ADO. How might I do that?

I have a table it looks something like recNum user Day Hour 1. I need to find out the Min Hour & Max hour on a given day for a given user. 2. If there is a break between hours, I need a new record that has the min hour & max hour for that period i.e. if user1 has 8/22 hours 2 through...

I would like to use Msgbox to display some information. The catch is, I want it broken down by specific lines. How would I insert a carriage Return/Linefeed into the Msgbox. What I currently have: MsgBox "Request Added.", vbOKOnly + vbInformation, "Record Added

I have a form which uses a cbo to find a record. It has a reset button on it. I would like to trap the event/error when the button is pressed. Now if a record is selected, but not changed, it gives an error "The command or action 'Undo' isn't available now." I would like it to re-set the cbobox...

I would like to use an sql to fill a form. If field a is blank I want to display field b instead. Can I do this?

I have a mainform which will be used to select a record. It refreshes the data on the main form based on the cbo, as it should, however, I need it to also refresh the subform. How might I do this?

Is there a way to set the cursor location to the first character position when the user clicks on a formatted field? Currently when I click on the field it usually puts me in the middle of the field (wherever the mouse clicked)

I have a subform (default view continuous forms). It is a single row. Using a query for data. I need to add a blnfield, so if that field is checked I can take certain actions. I tried creating the field as blnDel: CBool(0), but this won't allow me to modify the field (I think because it is...

I have a subform, based on a query. I want to add a new field (Y/N) which I am setting to no on the initial query. I did that by creating a field blnDel: "blnDel: CBool(0)" I would like to make the subform show the field as a check box. I am not sure how I can do this (that option doesn't...

I may be posting this in the wrong forum, but: I have a field with format: >000000LLLL00 If the field is entered incorrectly I get the generic message "The value you entered isn't appropriate for the input mask '>000000LLLL00' I would like to put something meaningful to the user. I can't...

I have a field that should look like: 101910ZNOV03 I have created an input mask of: 000000LLLL00 I need to make sure the 7th character is a "Z" and the next three characters are the abreviations for Jan thru Dec. Is there an easy way to do this?

I know this should be easy, but I'm tired & hitting a wall. I have One table I add to and then after all checking is done, if there are any records in that table I want to copy them all to another table. How can I do this?

I have a form which accepts 15 date fields through the use of a calendar. dtSubmitted should be <= current date, the "request" dates should be >= current date. Problem: When an invalid date is entered for a "request" date, the next time the mouse is clicked on the date field, instead of the...

I have a form which adds records. I have a cmdbtn (Reset) which I want to enable when a field changes on the form. I tried the OnDataChange of the form, but, when I changed the value of one of the fields, the button didn't activate. Where should I put the command to enable the button?

I have a form with an option group. I want to change the caption on a cmdbutton if a particular radio button is selected. Which event would I put the "opt.caption =xx" in? (mouse down, key down, key up, key press??)