Search results

This is a real problem I'm working. I have not simplified it much...it is a simple problem already. My question is at the bottom in bold. At the end of every week seven spreadsheets are provided each containing information about the number of alarms received each day. Three of the sheets are...

This question is specifically about nuances of the Access 2010 Navigation Menu. That is important. I asked this question and got all kinds of answers but they overlooked that crucial aspect of my question. When I sort or filter records in a form that was opened (in Form View, not Design View)...

I noticed that somewhere along the line I no longer had to put the full reference to an object. For example, when I first coded my project five or six years ago (using Access XP or 2000) I had to do this: Application.Forms!frmContacts.Controls!imgContactPicture.Picture = sFullPath & "\" &...

When I open my forms the combo boxes have a white interior and black text, which is the default and the way I'd like them to stay. But when I browse records, the combo box becomes transparent, by which I mean the interior color of the combo box becomes the same as the color of the form. I hate...

The boundary between the bottom of the detail section and the top of the form footer keeps coming up in form view in a different place than where it is in design view. This covers up a couple of controls at the bottom of my detail section. I’ve played with form settings but have not figured out...

Occasionally after editing multiple forms I hit save and after a long wait the save fails and I get a nasty message about File Sharing lock count exceeded. When this happens some or all of my forms and tables dissappear until I close Access and reopen it (and one horrible time my database was...

My app was done in Access 2000 and the file is still in that format but the problem I am about to describe appeared when I started using Access 2007. I get the same behavior when I rebuild enough of the app in a native 2007 file to test. I have two list boxes. On the left is one that I populate...

I use VBA Automation to add and modify rows in a table in an Access 2003 (MyData.mdb) database file. The VBA compliant program that writes to the database is called RSView. When I used Access 2003 I could have an instance of Access open and be working on the database and without it interfering...

I want to know if it is possible to get at the password needed to open the database in code. The reason: I have some Word docs with the same password. I want to open them. As it stands now I have to hard code the Word password.

I tried creating a means for a user to look at the database relationships using Private Sub cmdShowRelationships_Click() DoCmd.RunCommand acCmdShowAllRelationships End Sub I get runtime error 2046: "The command or action ShowAllRelationships isn't available now." I'd appreciate tips on how to...

I am trying to figure out when it will be important for an Access developer to embrace .net. I guess that is the same as asking when will .net code be mandatory or at least highly recommended for Access? I use Office 2003 and my understanding is that right now, except for managed add-ins, you...

When I use the VBA AddItem method to add an entry to a List Box, I get line breaks when the string contains a comma. Here is an example for the case of the some music artists, the contents of the list box appear like this: Jackson Browne The Beatles Crosby Stills Nash and Young...

Consider two tables: tblSongs -SongID (primary key) -SongTitle -ArtistID (foreign key) tblArtists -ArtistID -ArtistName Is tblSongs normalized? In 3NF? It is possible to wind up with this anomoly: SongID SongTitle ArtistID 131 Lifes Good 5387 221 lifes Good...

I want to get the year, so I tried this: Dim vYear As Variant vYear = Year(Date) When I run this I get run time error 13, type mismatch. To sort this out, I tried running this sample code, straight out of the help. Dim MyDate, MyYear MyDate = #February 12, 1969# ' Assign a date...

I occasionally run across this term. If the members of this group have a clear boundary between themselves and members of other groups, then please tell me the names of the other groups. If what members of those groups work on is not intuitively obvious, than will you give me a super brief...

I have a problem with a Bound Object Control that is bound to a field of type OLE object in a table. The control is used to display an image. The following objects are relevant to my question: Table: “Girls” Field Name: “Picture” Field Type: OLE Object Form: “Girls” Control Name: OLEBound90...

I have a problem with a Bound Object Control that is bound to a field of type OLE object in a table. The control is used to display an image. The following objects are relevant to my question: Table: “Girls” Field Name: “Picture” Field Type: OLE Object Form: “Girls” Control Name: OLEBound90...

I have noticed diagrams showing Microsoft SQL Server accepting SQL statements sent by “SQL Requesters” over connections. I would like to know if Microsoft Access can be used in that fashion? Put another way, can Access be configured to accept an SQL statement that another program (e.g. a VBA...