Search results

I'm using the following code: Private Sub Form_Timer() Dim LocalTime, StartWindow, EndWindow As Date LocalTime = Format(TimeValue(Now()), "hh:mm") StartWindow = #11:46:00 AM# EndWindow = #11:48:00 AM# Dim Response Response = MsgBox("Run scheduled maintenance?" & vbCrLf & vbCrLf & _...

I have the following function that I found online. Unfortunately I can't remember where I got it since I've had it for a little while. Today, when I tried to actually put it to use it didn't work. I'm calling it from a form as follows: CompactDB (tblHotword) tblHotword is just a random table...

I've spent the last two days searching for answer to this one and all I've really found is enough ideas to come up with the code below. My environment is a split database with a few different front ends connecting to the same back end. Only one of the front ends will be used for data...

I have a report that will only be used in Report View. It pulls data from a table via a query. The number of records it will display is varied. The problem I have is that I've changed the Back Color to 'other than white', but I have several inches of the "report" section below the report...

I've got the following code on a form. The entirety of the sub is listed just in case. The relevant portion is below. Private Sub Form_Timer() 'timer set to fire once per minute 'AutoPurge old records (>7yrs) and take action if Hotword and/or NANU expire Dim Minute As String Minute...

I have a form that allows a user to view every record in the database (one at a time) via a combobox. The combobox displays a 'recordID' which is not the primary key and can (will) therefore have duplicates. The 'recordID' is reset back to 1 every calendar year. There are 3 different ways to...

I'm using the following code to generate a sequential number" Private Sub Form_Load() Me.txtReceivedDate = Now() 'assign an EmailID when form loads Dim CurMax As Long Dim NewMax As Long 'poll the current EmailIDs for the largest number from current year and add 1 If...

I have a database for log keeping. I've created popups to remind users when it is time for an entry. 'Popup reminders for watch entries '------------------------------------------------------------------------------ 'Update information between [ and ] for new reminders. Remove the brackets in...

I have a report that is opened via a Form that lets the user choose a date to filter the report. The report opens in Print Preview mode. What I'm attempting is to give the user an easy way to export the report once they've verified the report is accurate. One way I've tried to do this was to...

I've learned the hard way about using calculated fields in a table. I used on while building in Access 2010 for users that will be using Access 2007. Once my testers pointed out the error message, I did some research and realized my calculated field was the problem. So, I created a query to...

I was having a problem where the intellisense popup was going away as quickly as it displayed while writing code and changing my unfinished line of code to red text. In addition as I tried to type anything in the editor (commented lines included) the cursor was fighting me while entering spaces...

I have a form that can be opened in one of two ways. Either unfiltered by using a Command Button or filtered by selecting a Record from one of two List Boxes and then clicking the Command Button. Once the form is open in either filtered or unfiltered mode, I have a Combo Box that allows for...

**anywhere you see the word BANANA, I really meant e-m-a-i-l. Apparently I can't post e-m-a-i-l addresses because I haven't posted 10 times** Lets disregard the fact that there isn't a single @ in this post (well, there is now!) I have a form with two list boxes on it: listAllBANANA and...

So, about 3 weeks ago, I decided to rebuild a database that my workplace uses. The original was built in '05 and has been stagnant since that time. I hadn't used Access since about 2002 and had never written code before. Needless to say, this was a big undertaking. Everything I've learned is all...