Search results

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...

Anyone can help please?

My database is used by a few users on a shared drive in "read-only" mode so they can't change any data. I set a scheduled task to copy an updated version of the database (which I edit) every morning. The problem is that when the users forget to close the database file I can't overwrite it. For...

Sorry to bother you but could you please just fix the error when you go past the last record? Then my this post is pretty much solved... Thanks

Thanks :) I'll look into it. Anyway you can help me with the error I mentioned?

Great! Combining what Galaxiom did with the code I wrote this works perfectly. But I noticed you changed a few things as in writing a query as the source of DemoForm. Can you please explain what you changed since I'm planning on creating a better version of the current full DB to make it work...