Search results

I have two fields in a form which are linked to tables forming pull down lists. however these fields relate to each other and I am trying to make it so that if you pick an item from the first list, the second list only lets you choose items that are related to that list eg:- CADM FRIER CADM...

I have several dates in the format 01/02/1999. All I need to know is how to add seven days to this date so it reads 08/02/1999.?

I have a problem where by I need to change values in an access table which actually represents a date, they are stored like yymmdd, I have preceeding zeros to represent 2000 etc...ie. 000101 = jan 1st 2000. The problem I have is when I try to convert these dates into a new field name using:-...

If I wanted to update a value in an update query from 1000101 to 000101 how would I get access to display the preceeding zero's.:confused:

Function ChangeDate(adate As Long) As Long Dim t As Integer Dim num As Long Dim num2 As Long Dim max As Object Dim snumber As Object Set dbcurrent = currentdb() num = Left(adate, 3) num2 = Right(adate, 4) For t = 0 To t =...

I have been given a problem to solve in access (export in to excel), which involves some vb. This is fine, however I'm more of a beginner in C code but not Vb so any help would be appreciated. I have to write some code which will merge text from several lines onto one line but keep the line...