Search results

I must have tried almost every combination and i cannot get this to work. Could anybody give me a hand please. Is there another way i can achieve the same rtesult if i cant get this working? dtan_lib_no = text (eg. DTV03000) video_id = number (eg. 1263) vididmax = string (eg. 12222)...

I hope you can help? Why is the code causing this error? vididmax = Nz(DMax("video_id", "TblVideo")) dtan = DLookup("[dtan_lib_no]", "[TblVideo]", "[video_id]=""" & vididmax & """") MsgBox dtan Data type mismatch Im trying to look up the highest video_id and get the data from field...

Wow thanks working great now Thanks for your help

I have opened a record set as you have said but im getting this error runtime error 3464 Data type mismatch in criteria expression Set rs = db.OpenRecordset("Select artist_id FROM TblVideo WHERE artist_id = '" & artistid & "' " & "AND Name = '" & songname & "'") Any ideas? Thanks

Sorry im a bit new to all this, how can i make it give me a true outcome if it exists. Thank you

How can i search my video table for a record that has artistid as a string in one column and VideoName as a string in another column but both in the same record. Many Thanks

How can i change this code so if a record in the table TblArtist has the artist string in the artist_name column and has artistid string in the artistid column of the same record it returns false? If IsNull(DLookup("[artist_name]", "[TblArtist]", "[artist_name]=""" & artist & """")) = False...

This is what ive got If DCount("[Name]", "TblVideo", "[Name] = 'songname') > 0 Then MsgBox "It exists." Exit Sub End If and it says compile error Expected: list seperator or ) What have i done wrong

Is it possible for me to search a table column for a value stored in a variable using an if statement. eg if variable is in the the table column 1 then do this if not do this Is it possible to do this completly in vba Many Thanks

I cant get it to grab all the text before the - just individual words as some of the lines in the text file have more than one word.

No one got any ideas?

Grab data from text string I have a text string of # akon - dance How can i parse before the - without the # into one variable and after the - into another variable? Many Thanks

Wow Thanks guys that is great

Could somebody please help me write a code for creating 1 .txt file for every record in a table. Each filename will be field1 & .txt from the table and on each line inside the text file would be field2, next line field3 etc.. I also need to be able to put some writing before and after the fields...

Could somebody plese tell me why this code is giving me an error please. And how i can correct it please DoCmd.OpenReport "Envelope 11x22 DL Contact", acViewNormal, , "ContactID = " & Forms!Vatbook.List265.Column(3) The error is Runtime error 3075 Extra ) in query expresion '(ContactID...

Ok ive changed the Month to TaxMonth and Year To TaxYear. Although my table does not have any dates in it. It only has the month and the year. The first field is just a random number key field. Taking that into account your query will not work. Any other ideas Many Thanks for your help

Hi can someone help me with this conumdrum? I Have a table with 4 fields ID, Month, Year, Total 1, January, 2009 , 55 2, February, 2009 , 53 13, January, 2010 , 44 etc I have a form with 2 text box's. Startdate and enddate In the startdate i put 2009 and in the end date i put 2010. How can...

I figured it out thanks for your help

I have created the query and it shows me if the record exsists. But im sorry but im stuck with the I dont know the vba code to accomplish this. Many Thanks

The Year is in a hidden textbox and the month is in a hidden combobox. Both get there values from a public variable.