Search results

This indicates that in fact you've got one flat table, sliced up in pieces. In other words, it means that your data structure is not normalised yet. Do a search on normalization and Codd, either here or on the Internet. You can find very helpfull sites, such as this one...

Most likely not the reply you're after, but you really should start normalising your structure. Otherwise, you'll end up having to use rather complicated and messy VBA ;) Referring to my reply in one of your previous threads: http://www.access-programmers.co.uk/forums/showthread.php?p=510783 RV

You'll have to use VBA to get what you want. Although you did inherit the DB, I would suggest to rebuild your table structure and use a query. Rebuilding will be a lot faster and easier then messing 'round with VBA. Just a thought ;) RV

Hard to tell from screendumps what's going on. Post your db, in Access 2000 format, winzipped. RV

What's you're counting is the total number of materials booked against a job, cause that's how you've set up your query ;) Have you tried the DCount function yet? If not, give it a go. RV

Why don't you use the form as provided in this thread: http://www.access-programmers.co.uk/forums/showthread.php?p=510728 Otherwise, build a report using a similar approach as for the form. You really should start thinking Access, instead of Excel. If you would have set up your applic in a...

This thread should help you out: http://www.access-programmers.co.uk/forums/showthread.php?t=100002 RV

No idea what you're after but yes, you could use an update query using the selected date as criterium. Rv

Private Sub filter_Click() On Error GoTo Err_filter_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Faktura_oversikt" stLinkCriteria = "[Status ID]=" & Me.Status_ID & " And [Action dato] >= #" & Format(Date, "mm-dd-yyyy") & "#"...

Yes there is. Put your code in the Before Update event of your control. Add this line of code after your current code: Cancel = True RV

Try this query: SELECT MyTable.PrimaryName, MyTable.SecondaryName, MyTable.JobDate FROM MyTable, MyTable AS MyTable1 WHERE MyTable.JobDate=MyTable1.JobDate AND (MyTable.PrimaryName=MyTable1.PrimaryName OR MyTable.SecondaryName=MyTable1.SecondaryName OR...

Column numbering starts at 0 (zero) Try Me.CustReq = Me.CustName.Column(1) RV

Define a Before Update event on your form field using the InStr function to check whether a full stop was entered: If Instr(Me.fieldname) = 0 Then MsgBox "You need to enter at least one full stop" Cancel = True RV

I'd say that indeed you've got some code somewhere. Hence the jpg file isn't much use. Post your database, zipped. RV

Using UNION ALL will retrieve duplicates. i'd suggest to use an autojoin in your query: SELECT table.* FROM table, table AS table1 WHERE (table.PrimaryName = table1.PrimaryName AND table.JobDate = table1.JobDate) OR (table.SecondaryName= table1.SecondaryNameAND table.JobDate = table1.JobDate) RV

Don't. You assign members to a Project hence you create rows in your junction table. RV

Bumping after one hour and one minute after starting a thread is considered to be quite rude. Remeber that next time as it will likely result in getting no reactions at all ;) Remember that we provide free advice here. If you're in a hurry, well, though luck. Basically, you need 3 tables...

Hello Aleksandra, I don't even know what API stands for ;) Can't help you. Perhaps somebody else can. Take into account that, assuming the code you found (where did you get it from?) works, it will impact all scrollbars in Windows based applications (amongst which Word and Excel, to mention a...

QUESTION 1 You need to replace the name of your query by the table name: SELECT Indices.Month,IIf(Indices.[SP 500 Index]>=0,1,0) AS BullDJWA FROM (SELECT Indices.Month,Abs(Indices.BullDJWA-1) AS BearDJWA FROM Indices) GROUP BY Indices.Month; (not tested) QUESTION 2 Search the forum or have...

Hello Aleksandra, your Windows settings control the color of your scrollbar. Although it seems that you use API's to change the color, I strongly advise you not to mess with settings. See Ken's reply in this link why you shouldn't mess with settings...