Search results

I stumbled upon a problem in my Access database: as a Movie Buff I have a single dropdown to select or add an artist on the (List Video Clips) then I was in need of more info on the screen so I added another field named ArtistSub. That was the beginning of my Odyssey. So far I used a single...

Recently I added a few fields to an existing ACCESS form but I am not able to make them visible on my screen. View the code, Recentl If TrefCountE > 0 Then moSQL = "SELECT * FROM SeekTitleQry WHERE [TrefID]=" & TrefKiesE moDummy = ArtistSeek(moSQL, "Ignore") End If...

I made an Access 97 database where I keep various data on each row (record). See Attachment I have remote control and like to improve the screen visibility. Due to worsening eyesight (age) and high res screen the RecordSelectors became undetectable. I want to highlight the CurrentRecord and I...

Trouble Opening Project (Library) in Access 97 __________________________________________________ _______ Beauty resides in the eye of the beholder __________________________________________________ _______ Equiped with: HP - Compaq d530 CMT DG767AI OS = XP Professional SP3 Pentium IV at 2.66...

Windows 7 combined with Access 97 _________________________________________________________ Beauty resides in the eye of the beholder _________________________________________________________ Equiped with: HP - Compaq d530 CMT DG767AI OS = XP Professional SP3 Pentium IV at 2.66 GHZ RAM = 2.00...

I am trying to open a database form from another database and the first action(s) need to be the opening (or adding) an Artist and an Album in the external Database For that purpose I am using a dropdown list (with option to add): SELECT DISTINCTROW MmArtist.ArtistID, MmArtist.Artist...

Hello everyone, I have searched the forum but I just haven't found quite what I am looking for. I am trying to find out how many checkboxes are True on my continuous form, I am using an unbound textbox that contains the following expression =Aantal([Choice]=Waar) [[= Dutch]]...

I have a CurDir() question about MS Access: Thusfar I have used the following sub: But Access keeps telling me that it cannot find the Project or Library and this is the structure of my database: MultiMedia.mdb This MDB contains everything but the forms and is considered the Front End...

I have a graphics question about MS Access: Thusfar I have used the following sub: Private Sub GetFoto(Path As String) On Error Resume Next If moTabPage <> "PagVisu" Then Exit Sub If Me.Groep <> "Pic" Then Me.MPict.Picture = dxProgDir & "\Pics\NoPreview.bmp" Else...

Hi All I am looking for a method to shift a small pop-up window around on the screen. I want to avoid the overlap with the help function, which is an external program. I already tried this code in the form: Me.Left = Screen.Width / 2.5 But a form does not seem to have the property .Left or...