Search results

... And this should help you export the data from Access: http://btabdevelopment.com/export-a-table-or-query-to-excel-specific-worksheet-on-specific-workbook/

Hi, I can think of 2 options: 1) The form has a Locked property: Me.Locked. It's value is false by default, you can set it to true. For unlocking - have a button click open an InputBox, witch ca receive the contract number. If correct - it will set Me.Locked = False. 2) Each Control has a...

Hi, see #4 above: http://www.access-programmers.co.uk/forums/showpost.php?p=120940&postcount=4 basically, the query builder is a graphic interface for creating SQL statements, understanding SQL could help a lot. I recommend you red some SQL tutorials: http://www.sqlcourse.com/intro.html...

I skipped it? this link could help you: http://www.fmsinc.com/tpapers/primer/

FullAccession is a local variable, F_OpenMenu2 has no access to it. Make it a global variable: Public FullAccession As String' Better to have this variable in a global module, not on the forms module. Private Sub Command3_Click() FullAccession = Me.SiteAccession Debug.Print FullAccession...

Hi, For getting values from other forms use the Forms!FormName for loaded forms, or AllForms!formName for non loaded forms. But - as for using this value as a default, I would have the form Load event sign this value as a control default value, not a DB field. Changing DB field default value...

Here is an example in code: Sub a() Dim rst As DAO.Recordset Dim XlsRange As String 'Link to Excel: Set rst = CurrentDb.OpenRecordset("Employees", dbOpenDynaset, dbAppendOnly) XlsRange = "A2:A" & CStr(rst.Fields.Count - 1) 'There is a way to add Sheet name too...

Hi, I would use DoCmd.TransferSpreadsheet (https://msdn.microsoft.com/en-us/library/office/aa220766(v=office.11).aspx) to link to Excel data. This linked Excel data can be referred to as a table, and be part of a SQL query. Queries do not error on duplicates, these are just not inserted. All...

Hi, it seems to me you are missing the False section of the outer IIF. besides that, if this function should work on the results of the aggregation, try separating the queries: one for aggregating, and then another query, on the aggregation. I find it could sometimes help if you first save...

Yup, you are right about that, Sorry... looking at it again, It seems inaccurate. I converted weeks to days, you are looking for the first Tuesday in the 19th week. As for your formula, why do you multiply WeekNumber by 6? Why add 7? and as for the day offset, we maybe did not include Jan...

Glad I could help. ATB

Hi, Maybe this? ((Table1.Location)=[Enter Project Number]) AND ((Table1.EmployeeID)<>IIf([Location]="0217","075",[Table1].[EmployeeID]+1) ) If you are trying to exclude, then exclude the result of the iif function when true, Else make sure the result will give a value that will never be...

there is a drop-down list of aggregation functions, try changing it to 'expression'.

Hi, I am having difficulties understanding your question... basically, nesting IIF function, is putting an inner IIF function a result sections an outer IIF function: IIF(OuterCondition ,IIF(InnerCondition, 2Truse,OuterTrueInnerFalt), OuterFalt)

hi, Try looking into Dateadd() function: http://www.techonthenet.com/access/functions/date/dateadd.php Basically: I would take the date and add days to it: Dateadd("d", Weeknumber*7, CDate("1/1/" & MyYear)) (CDate - Converts a string to a date) ATB!

IIf([Location]="0217",[Table1].[EmployeeID],[Table1].[EmployeeID]) - Results to [Table1].[EmployeeID] in any case?...

Glad I could help (:

(tbl_status = -1) is an expression, the query would count these expessions, 1 per record... try this: SELECT [(SUM(iif(tbl_status = -1,1,0))/Count(tbl_status))*100] AS [Rate]" from tbl ATB!

Hi again, I found this link in No. 34 they refer to this curroption. I Quote: "One newsgroup poster reported that deleting the users roaming profile fixed this problem. However they also hadn't yet split the database. As always YMMV (Your mileage may vary.)" What is "the users roaming...

No, I have no other computer here, the file is some 250 MG, I cant pass it online...