Search results

If I want to make changes accross the board how would I kick out everyone using the database. I send out an email right now, but there is always someone not at their desk and has it open. All help is appreciated.

How would I go about kicking out a user if he is idle for 15 minutes? The users do not log on to the database. T he tables are based in SQL and access serves as the front. All help is appreciated

I'm sure this is simple but I keep getting #error. I have field being pulled from a qry called Send in ##/##/#### date format. I want to either add 30 to it, or use Date Add. [Send] + 30 dateadd("m",1,[Send]) All is appreciated :D

I have a date and need to increase each one by 4 months. I'm currently just adding 120 days to it, but some of the dates are being put into the wrong month. [tblMasterList]![Loan Effective Date]+120 I would like to just add 4 months to the month column and not touch the days. Example...

I know you can turn on the message prompt on the whole database using Tools...Options. How could I have the prompt not show up just on one particular update query that runs when a form is opened. Thanks in advance Paps

I have an excel spreadsheet which pulled off an old database where the DOB was in the following format 21853 72738 92342 I would like to change these either in excel, or in access when imported in as 2/18/53 or if possible 2/18/1953 7/27/38 7/27/1938 9/23/42...

I have a report which pulls the current form's policy number off and sends the data to the report. Sometimes this form will bring several instances of a policy number with, so the report will want to print 4 pages. I only the first 2 pages of the report. So is there anyway to tell command to...

I have a report which pulls the current form's policy number off and sends the data to the report. Sometimes this form will bring several instances of a policy number with, so the report will want to print 4 pages. I only the first 2 pages of the report. So is there anyway to tell command to...

I want to assign a different color to a date field, if that date equals the current date. I tried to use conditional formatting, and some VB code but can't get it to work. Any suggestions would be appreciated

I would like to search using a drop down Combo box. The box displays the current policy number with all the info on the form. I used the wizard to create a drop down box where if the user types in a policy number it will go to that policy. I bound the the combo box with Policy Num #. The...

I have a form which has a subform that displays the multiple listings of a contract number. I need to print a report letter that contains values of the different fields of the same contract number. I either need to pull all the information from the subform, or pull one set of info off the...

I need to print a single record that shows up on a form. The form has a button that when pressed should print a report. When I press it, it prints out the entire report. I want it to just print the single record. Any help would be much appreciated. Thanks Pappy

I need the user to input a month such as 1 for January, but the query needs to pull the month inputted and the next month. How do I code this without asking the user for 2 monthes. I'm a newbie, be kind. Thanks

I need to create a time stamp in a field called "letter mailed" when a button is clicked. I know you have to use VB code, but I'm having some trouble getting it to work. Please kind I'm new to this... Thanks