Search results for query: *

thread705-544592 I have a form that is based off a query (using certain criteria). It displays 1 record at a time. I want it to do the following. Run queries (These update queries use criteria from each record on the form. Queries already created) Move to the next record. Run the queries...

I have one query that retrieves a record with a date. I have another query that retrieves a record with a date range. I want to if the 1 date falls between the range... Any idea on how to do that?

I have two queries one that pulls a record in the current year with an EffDate of 5/1/12 and the other query for the previous year that has multiple rows. I want to find which of those 6 records was the one that was active 1 year ago using the EffDate from the current year query. Anyone have...

DoCmd.Requery Forms![dsh_dshbd_layout]![dsh_tab_HDMI_forSUBTABS].Form![frm_MITerms].Form![MktRent]

On one(main) form I have a subform(sub1) with a subform(sub2) that I want to requery. Can anyone help me with referencing and requerying a subform? DoCmd.Requery (reference to sub/subform)

I found some code and now I'm trying to troubleshoot it. I have 2 issues. the line with the ~~~~'s errors out and highlights the entire code to the end of the ~~~~'s The second question I have is that I have placed this in a module, how do I call the module from the form when a button is...

If I have a phone number in a comments field with words before, before and after or after with any of the formatting then I want to pull that data out and put it in a field called phone number. An update query or vb behind a form would be cool too. phone numbers could be formatted...

I want to get data from an ms access database using outlook to create a formatted e mail that can be sent out by the user. This e mail would use about 10 fields in a temporary table. In the table the user name of the person wondering if the person's e mail address could be used and linked to...

I want to prompt the user to make sure that they want to add a record. There is one exception... if the client is equal to clientid = 100, otherwise prompt text in the box "Are you sure you want to add the record?" Yes, then add No, then cancel

I have this query that uses MRI database if anyone knows that software. The query has 10 sub queries... I'm having trouble breaking up the 1 into it's 10 to find the problem... Any help would be appreciated. Thanks, Select distinct name.unitid AS [Unit ID], (Select Distinct chgcode from...

I have the desire to put my database on a web server. There are companies out there that host them. I am however concerned on the security of the data on the server and the transmission of the data from them to my sites. What options should I ask for to ensure that my data is safe from point...

I want to be able to have the report that's being run be dependent on a value in a record. i.e. if reportvalue = 1, then run reporta if reportvalue = 2, then run reportb if reportvalue = 3, then run reportc I know as much as that it is a nested if then statement... can anyone...

This is the problem area that is being highlighted by the debugger, this is a MS Access 2003 DB. txtCurrRent = Me.MktRent - forms_frm_MoveInDECredit!txt30Percent - forms_frm_MoveInDECredit!Gas - forms_frm_MoveInDECredit![W/S] - forms_frm_MoveInDECredit![Electric] -...

I have two list boxes with dates in them for the user to select from. List box 1 is the beginning date and 2 is the ending date. When the date in box 1 is selected I want box 2 to be set to the last day of the next month. i.e. box 1 selection 6/1/08, result box 2 default value 7/31/08 box...

Compile error: Ambigious name detected.... first line is highligted in yellow... 5th line where it says 'displaymessage' is highlighed in blue. Several areas in the DB where this code exists... is something formatted incorrectly?? Private Sub PhEmDate_Enter() On Error GoTo...

Hi, I have a form that will have a place for the user to enter a password. I want to use visual basic to compare what the user enters against the field on the form (hidden) and run macro 1 if it matches, run macro 2 if it does not. Any help would be appreciated. Thanks field names PIN(field...

Hi, I have a form that will have a place for the user to enter a password. I want to use visual basic to compare what the user enters against the field on the form (hidden) and run macro 1 if it matches, run macro 2 if it does not. Any help would be appreciated. Thanks field names PIN(field...

I have many records, all of them are at least 10 spaces some are 11 or 12 ... The 11th and 12th spaces are letters. I want to strip off the numbers and the letters and import them into seperate fields. An example of the data... parsing left 10 to a field and right blank to 2 charachters to...

I have a report requirement that shows quarterly sums in columns instead of rows. I have accomplished something like this before by making each column it's own subreport. I don't know that this is the best way. I have the following data summed up by company name and detailing out the...

>3 ... ellipsis changes changes to a Verticle bar in field. A High End user wants to be able to add more than 3 ellipsis and when that happens it changes them into a bar. Any way to get around this? Any help would be appreciated. Thanks