Search results

It is rounding a number to x decimal places (...places as integer) The maths is saying I want to round eg 4.7980 to 2 decimal places. To do this, it muliplies the figure by 100 so moving it across by 2 places, rounds the figure and the returns it to 2dp. In the code this is done by saying...

Don't knw much about Julian but where does 03032 come from? Julian day count for 1st Feb 2003 is 245 2671. If you can explain the calc that returne 03032 then might be able to help

Auto: Not quite. In the Acc97 version I can open and do what I like. When I open it in 2k, it immediately tells me where to stick it as I am not the owner. No question as to whether I want to convert etc. Security. We do not use security settings. All of us are automaticaly deemed to be...

Am starting to get that impression as Workgroup administrator does not exist! The one above User and Group Permission is set Database password. Oh well ... here goes opening ablank db and transferring the contents. Bo*$@%s!!

I look forward to it .. cheers

When you select them, are you showing them through a query? If so then change the query to a make table query and then you will have the records until you rerun and change your selection

I have about 50 of these, with around 10 linktables per db and about 40 queries, 20 reports and 4 code modules. Just a pain in the a**e to do especialy if there is an easier way such as being able to assign <unknown. to admin or something like it! Comes down to laziness ;)

Autoeng - Have thought of that idea but am not too keen on it due to the size of the database ... though it does look like I will have to do it unless... GEMMA: How did you get around it?

I am in the process of converting all of our databases to Acc2k and in some cases I am unable to do so. This is because Acc2k comes up with: THE CURRENT USER ACCOUNT DOESN'T HAVE PERMISSION TO CONVERT OR ENABLE THIS DATABASE. Having reopened the database in Acc97 and gone to Security / User &...

Hope this is what you were after!!

Private Sub Command4_Click() Dim StrSQL As String DoCmd.SetWarnings False StrSQL = "INSERT INTO Attend ( Attemployee, AttDate, AttType ) " _ & "SELECT " & Me![scrStudent] & " AS F1, #" _ & Format(Me![Text0], "mm/dd/yy") & "# AS F2, " & Me![scrAttend] & " AS F3;" DoCmd.RunSQL StrSQL...

Instead of being a linked table, run a make table query on the data and create a table with data in it. Obviously I am not linked to your network so reading the linktable file is proving to be a bit difficult! :)

The way that I have suggested is for you to flag each record with a 1 or 0 depending upon which date range they fall into. You should then have a query showing the following data: Proj_ID, Dept, Proj_Date, Less<30,31-90, 91-180, 181-365...

Necessity and boredom!

The original formula was designed to get the first day of the last complete quarter and it was: tmpDate = DateAdd("m", -3, Date) Calc_Quart = DateValue("01/" & (Int((Month(tmpDate) - 1) / 3) * 3) + 1 & "/" & Year(tmpDate)) The logic is: Subtract 3 months from today so that the year bit will...

I am guessing that it might be easier to take a step back. How is the original data stored that feeds the query that you have shown? If you have a table with a record per project then it would be easier to carry out the test at that level in assigning each record to the correct column and then...

how about changing them to modal and back again using OnOpen and OnClose events?

Presuming the following: Table Name: Debitur Field: [Debitur ID] Field: [Name] Table name: Payment Field: [Debitur ID] Try this query: SELECT Debitur.[Debitur ID], Debitur.[Name] FROM Debitur LEFT JOIN Payment ON Debitur.[Debitur ID] = Payment.[Debitur ID] WHERE Payment.[Debitur ID] Is...

Are your quarters variable or 31 Mar, 30 Jun, 30 Sep and 31 Dec? This code is for the normal quarters. Also not too sure what you meant so here I am seeing if the quarter FINISHED more or less than 8 weeks ago. Sub 8Week_Gap() QuartDate = Calc_Quart If DateAdd("ww",-8,Date()) < QuartDate...

Presume that you want to change this to a make table query. If so then here is the code: SQL = " SELECT * INTO MyTableName" & _ " FROM dbo_v_claim_ap_pmtD " & _ " WHERE (clmstat = 'a' or clmstat = 'p') and (procstat = 'p' or procstat = 'f') and (fiscal_year = '2002' or fiscal_year = '2003')...