Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: paulwoods23
- Order by date
-
Converting date formats within VBA
I see what you mean, the query was reading a UK format as a US format so I needed to convert it to US format within the query. I used Format(Me.SDate, "mm dd yyyy") and it worked a treat. Thanks for the tip.- paulwoods23
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Converting date formats within VBA
I currently use a short date in UK format (dd/mm/yy) in a On Click event from a form to use in a query within some VB code. But this date is then used in US format (mm/dd/yy). How do I convert it back to UK format within the code so that the output is correct? I tried the following to convert it...- paulwoods23
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Compile Error with Form Code
Solved. Thanks to both of you.- paulwoods23
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Compile Error with Form Code
I have a form which, after selecting a "Staff" record and a year from two seperate comb boxes should list all sickness records for the selections in a list box. I am using the following code to do this - Private Sub cmbYearSelect_AfterUpdate() Dim StartDate As Date Dim...- paulwoods23
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Filtering displayed data on subform
I have a database used to store staff sickness. It currently consists of a "Staff" table to store staff details (name, number, salary etc) and a "Sickness" table to store sickness records. I have produced a form to displaying staff's name from "Staff" table and...- paulwoods23
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
