Search results

This is odd. My continuous form text box font name to Calibri. Bit, after opening the form in form view the font gets changed to MS San Sarif 11 point. When I change the font to any other font it's ok. Only when I set it to Calibri does the font revert back to MS San Sarif. If I set the font to...

I'm using the following code: Private Sub frmReminderFilter_Click() Dim strFilter As String Select Case Filter Case 1 'All records strFilter = "SELECT * FROM tblReminders ORDER BY ReminderDate, ReminderTypeID, ReminderTime, Reminder;" Case 2...

I have a split form with the datasheet on the left. This seems to have been an ongoing issue with the Navigation Buttons at the bottom of the form not displaying the number of records. This is occurring now only on one form but in the past it was happening om all my split forms. Why only this...

My subform doesn't sort the way I want. It was created with much help form this forum. To make it easier for me I attached the pertinent objects. As you can see the subform fsubWeeklyAgenda orders by date fine, but I want to order by the Reminder field also. You canb see this in each days list...

About a week ago we worked on a subreport on a form that persistently showed the unused part of the report. Most of it has been cleared but it still shows the unused part under certain conditions. The subreport has fields for reminders: ReminderDate, ReminderTime and Reminder. I click on the...

I have a report I put on a main form. The report footer backcolor is set to the same color as the main form detail backcolor. Even if I set the report footer to zero it shows up as a white box. If I set the report footer to 5 inches it looks fine. I even set the report footer to Visible-No and...

I downloaded the Split Form emulator (EmulateSplitForm v3accdb.) It work fine but I had to change something and was wondering about this for some time. It's about whether to use a '.' or a '!' When I first pasted the code in from the On Load event and replaced the object names with mine, I got...

I'm using a continuous form to display reminders. I set a Conditional Formatting rule for the fore color of the Reminder field based on the value of ReminderTypeID. If the value equals 1 then I want the fore color to be yellow.. The problem is Conditional formatting doesn't allow you to set...

Should I be turning off the Name Auto Correct setting? Also, is it a good idea to turn on Clear Cache on Close? James

I'm trying to create a new forms for a new db. When I create command button and then select it in design view and select the On Click event the code builder opens code from a different form. I've been having a lot of issues trying to create new forms, more than I could explain here. Any ideas.

I have a table I call tblNotes with only 3 fields: NoteID, NoteItem and NoteDetail. I've been using for some time now to printout certain record s as needed. One record which is my grocery list I've been using and printing out for a long time now. Today when I tried to print t out nothing was on...

When I make a multiple selection on form and use the 'Decrease Horizon' the form objects don't do what is expected. The second image is what happens when I click on 'Decrease Horizontal' in the 'Arrange' tab. James

I imported objects form Access database into a new Access Database. When I'm in a module code window and select 'Debug' the the compile command is showing the wrong database name. The name that is displayed is the database I imported from. I never seen this before. Any ideas?? James

I've been using this code for years to add a record. Although it's been a while since I used it on this particular table and form. The form is a split form. Code: DoCmd.GoToRecord , , acNewRec Me!DvdMovieTitle.SetFocus When I remark out the SetFocus line no error. This same code, except for the...

Odd. I have 4 items in the Quick Access Toolbar. When I do not have a form in design view all 4 are visible. The moment I put a form in design view the Toolbar only show the firs 2 item. Isn't this sort of defeating the purpose of the Quick Access Toolbar? Not in Design View: In...

I created a new form and placed 3 command buttons on it. When I select all 3 to space them all spacing commands, horizontal and vertical are disabled.

When I try to zoom in the Record Source in the Property Sheet Access closes. No error, nothing. This happens in all forms and all databases I have tried and happens when I press Shift-F2 or right click and select 'Zoom.' Any ideas? James

I have a split form with record id as the first column. The id field 'Display as Hyperlink' set to screen only so when I click on it and editing form opens on that recotd. On the OnClose of the editing form I requery the underlying form so the records are refreshed. Problem is, and this is...

I'm using the following to set certain properties on a SplitForm datasheet: Public Function DataSheetProperties(frm As Form) frm.DatasheetFontName = "Ebrima" frm.DatasheetFontHeight = 10 frm.DatasheetFontWeight = 700 frm.DataSheetRowHeight = ???? End Function I'm getting...

I'm using the following to set the font name for split form my datasheets: Public Function DataSheetProperties(frm As Form) On Error GoTo DataSheetProperties_Error: frm.DatasheetFontName = "Calibri" frm.DatasheetFontHeight = 11 frm.DatasheetFontWeight = 400 On Error GoTo 0...