Search results

Make the first excel record value to text by adding an alpha character to the value. i.e if the value is 1234 amend it to read a1234 then import the data. Access will then set the data type of the field to text. In access remove the 'a' from the data. Job done.

Create a look up table to hold to months - 2 fields ID (1 to 12) and Month (Jan - Dec) then order the months by ID in the main table. This will give you the correct order.

Phil try this .... Function Work_Days(BegDate As Variant, EndDate As Variant) As Integer ' Note that this function does not account for holidays. Dim WholeWeeks As Variant Dim DateCnt As Variant Dim EndDays As Integer BegDate = DateValue(BegDate) EndDate = DateValue(EndDate) WholeWeeks =...

Phil try this... Function Work_Days(BegDate As Variant, EndDate As Variant) As Integer ' Note that this function does not account for holidays. Dim WholeWeeks As Variant Dim DateCnt As Variant Dim EndDays As Integer BegDate = DateValue(BegDate) EndDate = DateValue(EndDate) WholeWeeks =...

Tom, User the where clause to specify the unique record identifier. See below... Private Sub PrintIssueButton_Click() On Error GoTo Err_PrintIssueButton_Click Dim stDocName As String stDocName = "Issues Data Report" DoCmd.OpenReport stDocName, acNormal,,"Issue = Forms![Main Form]!Issue"...

GHudson, If a form is being opened from a toolbar, you cannot see or alter, as far as I'm aware, the code that access uses to open the form. The fact that you can open the form in datasheet view by clicking the button and then when you click the button again, as a user might do, the form opens...

Rob, Use FileCopy SourceFile, DestinationFile to copy the file and then use the Shell commend to start the database.

Create another db called start.mdb with one module and a AutoExec macro to run the function, this module contains the function to copy the actual fe from the server to the client c:\my databaes for instance and open it. Place a shortcut to the start.mdb on each users desktop. This means that...

Dan, You haven't entered in the Orders table which orders are for which client or A/C unit !

try this using your field names - The MAX function returns the highest record from a group... SELECT Record.Name, Max(IssueNo.Issue) AS MaxOfIssue FROM Record INNER JOIN IssueNo ON Record.intID = IssueNo.intRecordID GROUP BY Record.Name; Two tables Records and IssueNo - One Record can have...

The MAX function may help you. But I would imagine you'll have to make a couple of extra queries and base the final one on these queries to return the correct info.

Order your query by 'Change Issue' in desending order and only return the TOP 1 record. Therefore you'll only return the record with the highest Change Issue number. Hope this helps