Search results

Hi, i am writing an onclick event vba which insert values in my form to 2 different tables in one click. A main table and a subtable. The subtable is linked to the main table by a field called MainTableIndex and the main table generates the Index by autonumber. My question is how do i...

can anyone help? i lost the local administrator password. I want to reset it but the administrator does not show up under user accounts in control panel. i have access to another account also with admin rights but a different user ID. its a local pc, no network settings. Thanks.

Hi, i have written a function using vba in one of my form but i want it to be available for use in other forms i created too. How do i do that? The function is shown below. Public Function GetShift(StaffID As Long, InputDate As Date) As String On Error GoTo Err_GetShift ' Declare variables...

Which is better? having multiple Dlookup statements or using multiple recordsets in the vba statement?

Hi, i need help in condensing the following vba statement, i have a total of 35 sql to insert. How to i use the Do...while or For... Next to shorten the statements? SQL1 = "INSERT INTO tbl_shiftPlan([Date],[S#1],[S#2],[S#3],[S#4],[S#5],[S#6]) VALUES('" & InsertDate & "',' ','...

How do i program a macro to insert dates into a date field in an increasing sequence? example. ID Date 1 20/5/2008 2 21/5/2008 3 22/5/2008 ..........