Recent content by unknown2u

Ok I finally managed to find a solution. I tried formatting it to dd/mm/yyyy but i didn't work so i just changed it to - FindFirst "[TableFieldA] = " CLng(formFieldA) and it worked perfectly! Thanks anyways ��

That might be a problem. I'll post an example of it later today if there's no other way..

As I wrote, I already tried formatting it and even tried changing the field format but i always got the same result..

It is defined as a date type and I use the corresponding delimiters - #

I wrote a simple code to check for three values of three different fields in a form and find a record in a table if they match - I did it by using the findfirst method and checking for three criterias connected with "And". So for example if fieldA = x, fieldB = y and fieldC = w, open tableA and...

Great! Thanks, I read about it some more and tried changing it till it worked. I figured it has something to do with that union thingy but I thought there might be an easier way to do that in the properties of the combobox... Thanks again!

No design flaws. It just serves a different cause them what you'd expect. Any other help to offer?

I'm not sure if this needs vba but I haven't found a simple answer on google... maybe a wrong choice of keywords I have a combobox where I want to get its values from five different columns in one table. I can use an SQL query to get it but it's displayed in 5 different columns in a big table...

Thanks for the tip Pyro. I'll make note of that. arnelgp I didn't get what you mean by that... even you wrote that kind of expression and it even says so on Microsoft's Development Center https://msdn.microsoft.com/en-us/library/office/ff195128.aspx

AWESOME! Thank you so much you! 😃 I took what you guys wrote and changed it simply: rs.findlast "[test] LIKE '" & searchString &"*'" and it worked perfectly! So i just skipped the SELECT and FROM part. I never get all the quote marks and when to use one or two and where... Thanks again!

I tried writing rs.findlast(*insert the line you wrote*) and i got a syntax error. That's exactly the problem I don't know what the syntax should be.. Any ideas?

I stormed google searching for a solution for this and found nothing. I want to use the .findfirst\next\last method using a criteria that uses a string variable AND a "begins with" wildcard. I don't understand how to write it at all. Basically it should say something like this: In recordset...

Thanks, I'll give it a shot. But would that quit the program on other users' computers as well? What could be the reason for it not working on another computer? It's just a quit command isn't it?

Yeah I understand. What I want to overwrite is the data itself - records mostly..

The structure of the database works well according to the basic guidelines of how a database should be built with relationships and all that... I'm past that part. What I'm changing in the database is the data itself... records always change since it's dynamic data. I change it almost every...