Search results

If I understand it correctly. 1 artist can have many albums, 1 album has many songs, 1 album can have many artists, 1 song can have many albums etc... I would consider having three tables and two join tables. 1 artisttable ArtistID Artistname info info . etc 2. Albumtable AlbumID info . etc...

Isn´t it enough just to group by the payroll number? Fuga.

Can you give a little more info on your tables? Like what fields do they consist of etc. Would be easier to help you if you do.:) Fuga.

there is the interaction.appactivate that activates a window. Fuga.

In the query design view, click the summation button in the toolbar. A new line appears called total. There you can choose sum or avg or something. Fuga.

Perhaps this will work. Dim dtfirstdate as date, dtseconddate as date dtfirstdate = me.yourfirstdatefield dtseconddate = me.yourseconddatefield If dtseconddate < dtfirstdate then msgbox ("your date is not valid") me.yourseconddatefield.setfocus end if Fuga.

You bet!:cool: And it´s particularly beautiful in autumn. But then again, winter is coming:( Fuga.

I´m not sure, but try some thing like this. Use the addwords() sub as an after update or maybe lost focus event of your listboxes. sub addwords() Dim sWord1 as string, sWord2 as string....etc....sWord7 as string sWord1 = me.yourtextfield1 sWord2 = me.yourtextfield2 . . etc Me.yourtextbox =...

Select jobs from jobs table (select query) with the date as criteria, and then make a missmatch query on the employee fields. Fuga.

Not exactly. sWord1 is a variable that gets its value from textfield1 in the sWord = me.textfield1 line. The textfield1 should be a reference to your listbox1. Don´t know why I called it textbox1. Sorry if it was confusing. Then it repeats with sWord2, sWord3 etc. Fuga.

Try this. sub addwords() Dim rstable as DAO.recordset Dim sWord1 as string, sWord2 as string....etc....sWord7 as string sWord1 = me.yourtextfield1 sWord2 = me.yourtextfield2 . . etc set rstable = currentdb.openrecordset("yourtable") rstable.addnew rstable.fields("yourfield") = sWord1 & " "...

Don´t know if this is relevant, but I once did an export to excel of a query with a field (selected with listbox) as a criteria. I noticed it only worked occassionally like it was supposed to. In my case, I had forgotten to put me.refresh for the form, not updating the criteria field and thus...

Another one: http://support.microsoft.com/default.aspx?scid=kb;en-us;132056&Product=acc97 Good luck! Fuga.

This might be it! http://support.microsoft.com/default.aspx?scid=kb;en-us;153747&Product=acc97 Fuga.

Actually, this might be a bit more tricky. I tried once to find the top value every day for some 500 days with 20 or so entries/day. I ended up with a query that crashed the computer and then I gave up.:cool: But I think there´s an article on ms knowledge base. I´ll have a look. Also, there´s...

:) Glad to help. Fuga.

Don´t know if it´s better, but you could have made a link table with fields user and catalog and then search for the catalog that has no entries in this table (missmatch query). Or maybe that´s what you were saying yourself? (a bit tired right now...:rolleyes: ) Fuga.

In design view for the percentage field: sort descending Next to the summation sign in the toolbar where it says "all", put "1". or, in SQL view: SELECT TOP 1 yourtable.Percentagefield, yourtable.timefield FROM yourtable ORDER BY yourtable.Percentagefield DESC; Fuga.

If you´re ok with having it saved as - say - a .txt file and then format it in word or whatever and then import it to access, this is what I use. Put it in a module. Option Compare Database Option Explicit Public Declare Function URLDownloadToFile Lib "urlmon" Alias _ "URLDownloadToFileA"...

Ok, then I´m sorry I don´t know. Maybe the problem is in the strcontractor line? Fuga.