Search results

year(date)+20, you dont need to format as yyyy, it will just return the year number, i.e. 2011

CSTR, CLNG, CINT. It might be the field in your form is string, and the calculation is of number type. I would use clng on either side, see if that helps if clng(Me.[Entrance Doors - Flats (Renew Year) 20 LE]) = clng(Format(Date, "yyyy") + 20 ) then or if these are the only 2 criteria that...

looks like that should work, check that you dont need to convert the year entered or the year+20, you can also just use year(date)+20

you will need to do the following, I have a table _Addresses which has Address 1, Address 2, Address 3 and City, suitably badly populated I have _Cities, Whcih has Country, City I then did the following, one for each address line in the table Address 1 UPDATE _Addresses SET...

What i would do is have a separate table for each address. You can then link this to your main contract with a selection of addresses in the address table and an ID for the address in the contract table. ie. tbl_Main_Contract Main_Contract_ID AutoNum Main_Contraact_Name Text...

Hi, I am exploring creating custom controls, and am having a little bit of trouble. I have read various articles on the web about authoring the controls, and how to use them. I have created a control, 3 text boxes and one button, on clicking the button, each text box, gets populated, 1 in 1...

What i was getting at is, do you not need to reference the oSheet.Range(Cells(2, i), Cells(iNumRows, i)).Select as oSheet.Range(oSheet.Cells(2, i), oSheet.Cells(iNumRows, i)).Select

can you attach the DB to look at?

You have referenced cells in the 2nd line, different to the first, so access is trying to use the cells Correct If IsNumeric(oSheet.Cells(1, i).Value) Then Incorrect oSheet.Range(Cells(2, i), Cells(iNumRows, i)).Select Havent tested it, but think thats it. Thanks

Hi, I have inherited a database that uses PDF Distiller to produce PDF's, i have the code, but cant find the files that are needed in order to set it as a reference in my code. Can anyone assist? Thanks

I have written a custom control in vb.net. I have built it up in a test project (to test) and compiled as an EXE. The EXE file works exactly as planned, but i would like to use the custom text box i created in Access, when i try and register the DLL as a reference in Access, it says "cant add a...

I have written a custom control in vb.net. I have built it up in a test project (to test) and compiled as an EXE. The EXE file works exactly as planned, but i would like to use the custom text box i created in Access, when i try and register the DLL as a reference in Access, it says "cant add...

Hi, I am planning to audit certail tables in my DB using triggers. I am new to triggers, and have got all the documentation about creating etc, but still have one question. I wish to audit, Insert, Delete and Update. Do i create a trigger for all 3 on each table, or can i create one...

Just thought of the timer, have set up a 1.5sec delay. Thanks

Hi, I have created a splash screen for my database, and want to run some code once the splash has been displayed. The code, simply checks for the users registration on the database, and if they are not, points them in the right direction. If they are, the main menu opens, if not a warning...

Not sure i understand You will need to set intRecordLimitThen to the value of the main forms control

me.ATMT_Lst1.column(4)

Have you got this working now?

Try cbodate_Change() strSQL = "Select distinct '(All)' From qryLocationofTreeWork UNION ALL " & _ "Select distinct qryLocationofTreeWork.LocationZip " & _ "FROM qryLocationofTreeWork " & _ "WHERE qryLocationofTreeWork.TargetPlantingDate = '" & cboDate.Value & "' " & _ "ORDER BY...

Can you not just use DCOUNT as that field in the sub form.