Search results

I have managed to get Right(Date, 2) to display the last two didgits of the year however if i store them in the table as integers as you suggested the leading Zero is deleted. Do you know any way around this?

Cheers mike that example displays 19/03/1905 Does anybody have any idea whay this is happeneing???

Thanks for the reply but it didnt seem to work below is the code im using Dim CurrentYear As Date CurrentYear = Date CurrentYear = Right(CurrentYear, 2) MsgBox CurrentYear I had tried using CurrentYear = Year([CurrentYear]) as you and the help files both suggested but i...

CurrentYear = Right(Date, 2) It might just be but does the above string not do what its supposed to? If you display the result of the string in a message box it displays 02/01/1900. If i just put in Date then i get the correct result. Does anybody have any idea whay this is happeneing? I have...

Thanks

Hi I have a table which stores infomation regarding videos and their rating ie: 18, 15, 12. I also have a table of users which stores the date of Birth of the member. From a form if the member is selected and the video is selected (from a combo box) would it be possible to produce an error...

Hi Is it possible to have a macro run only the first time a database is opend per day or assuming the Db is open to have it run at a specified time? Any advice on this is gratefully recieved Cheers Chris

Hi Is it possible to turn off the error messages given by Access using Visual Basic? Chris

Its ok i have managed to do another way using VB it may not be the simplest way but it works. Thnaks anyway Chris

Thanks for the reply. None of my combo boxes actually contain the primary key. I have three combos which list data in the relevant table. Each one is selected by the user and then i need the relevant primary key to appear on the form. If i can help it id like to prevent the user from having to...

Hi Yesterday i posted a question about populating a textbox or label with a primary key depending upon the results of combo selections. This post has seemed to be deleted. I was wondering (in my original post) if it was possible to have a priamry key displayed on a form depending upon the...

Doh!! How straghtforward was that (in hindsioght anyway) I should have known that. Thats about lesson four in VB School. - Sorry for wasting your time. Ive had a bad day today - Anyway Bring on the weekend Cheers Chris

How do i do this if the string is assigned data during run time?

in a query it is possible to reference a forms text box using forms!Form1Textbox1 is it at all possible to use a similar piece of SQL to reference a string in a VB module or would i have to put the entire piece of SQl in the VB and do it from there? Cheers Chris

Thanks im getting there now using the loops i was just wondering if i was doing it correctly - thaks for the help. I have managed to get the loops working - i think - however for some bizzare reason i have put mesages in to tell me the data it is searching - ie the data in the two fields. This...

kind of yeah. I just need to find if there is duplicate data in the two tables if there is other stuff happens but that is irrelevant for the example I have been playing about with loops to compare data. So far i have two loops one inside the other. The first reads the first field from the...

How would i go about designing a VB routine to compare two tables` data. For example take the field from the first table and compare it to the fields in the second table if its found then give a message. The take the second set of data and so on. Hope this makes sense Chris

Is it possible to read a rcord in linked ODBC table and copy it accross in to a table in to access? Does anyone know how would i even start going about this?

i think ill just have to leave it. I was hoping there was someway of opening of creating a new query from the switchboard using code or a macro or something. Nevermind Cheeers for the replies Chris

i am starting the databse with the switchboard and not showing the Databse window. All of other queries in the database work OK. Does it mean i cannot create one in these circumstances?