Search results

QviTitel Is a selection query (Q)uery(vi)deo(Titel) and a screenshot from it is in the original post. Yes the query failed, ass soon as I added it to QviTitel there was no movement possible. Meanwhile I created MmProtag (working fine) but I still have trouble with the implementation. Some how...

After having carried out the instructions by jzwp22 and with that I created a new table. (tblMediaPeople) Apparently no joy came from that because all actions with this table failed: First I added the table or its query to (QviTitel) but after that everything blocked I would very much like to...

Thanks for your contribution which gave me a lot to consider because it as an existing Database (well backed up) and it contains over 20.000 records so caution is required. You convinced me with your exposé on a many-to-many relationship and otherwise my many trials on QviTitel confirmed that...

Thanks for your contribution but you emphasize the creation of Tables (I use a similar method) where my problem is more focussed on the queries cause that what I have scarce knowledge of. I am still puzzled with OUTER JOINTS, INNER JOINTS,etc. Most of last weeks time I spent on trials on...

I will try this and then get back to you:)

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...

To answer your question: the fields you mention are independent rolldown selectors and the fields underneath are mere text fields set to numeric. Gladly I can tell you that I solved the problem myself, in a brief bright moment I decided to inspect the master module where from this subform is...

Greetings to Australia Herewith the whole code section of the ‘Class Module FviTitelSel’ my native tongue is Dutch and the naming of the various procedures corresponds to that but there is a mixture with English. A brief explication of abbreviations and translations: FviTitelSel =...

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...

Thanks a lot SOS.. I followed your instructions and the whole thing works fine:)

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...

Thanks for the effort RuralGuy but the property WindowLeft does not seem to exist. :( Me.windowleft = ixBreed / 2.5 Is where the compiler tells me that I try to assign a value to an unknown member of the object. I was able to find WindowHeight and WindowWidth but I can do very little with...

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...

Word Viewer I had the same problem where I did not want the files to be edited. For that I used the Word Viewer. ( Wd97vw32.exe installed) And the Call from Access would be.Private Sub ShowDocument() On Error Resume Next Dim myLink As String DoCmd.Hourglass True myLink = "C:\Program...