Search results

Thats way way over hy head!!

X86. Yes. Thats the trouible with doing things when your tierd and late at night !! yes i built in 32 and need to have compatible with 64. You mention api changes. Can you allaborate?

I'm building a database that stores data about people toy car collections. How easy is it to have an online database that the clients can add a model number that they own and it queries it and populates their fields with data about that car. Bit like mymovies.dk local db but looks up...

I have a table called tbl-owner this is where I store the registered owners details. Would your code store the serial number here also? I think would be nice to have a run once form if that's possible, asking for name surname and also in background record serial number to same table. What...

is it possible to create a form that runs only once when db first run for name etc. And then once saved cannot be changed by end user. The last bit I can do its just the making it run once as a popup. Dan

I have built a database on access 2010 x84. I thought most software that is x84 will run on x64. Yet when run on access 2010 x64 it errors and moans about architecture. Is there a way to make my db compatible with both without writing all over again for x64.

I also tried having a macro using if statement. but that just comes up with error saying cant find the query yet I was able to add to expression with its search tool. thought that would be simple.

Not sure how to tell it then to run a macro. In criteria at moment its basically comparing 2 numbers in a query. if they match goes green. [Qry-Reg1]![Expr1]=[Qry-Reg1]![Key] I then need to run mco-licence Are you sure it can do this?

I have conditional formatting on a field. green and red Is it possible to click a button and it looks at the fields font colour and if its green it runs a macro. I not sure if I asking to much of access. Hopefully an expert here might guide me. Thanks Dan

Sorry if I being stupid. But why? I hate access unfriendly messages. Or is there another reason why you both saying I should do this.

Hi , sorted last thing. Added DoCmd.SetWarnings False to the beginning before the if statement. Thanks

Wow, its working. I'm so pleased. One just small thing i'm sure you'll know. As its a del query it sais about deleting x number of rows etc. Can I turn those warnings off? I just want the yes/no box. in macro builder its called setwarnings. I guess this needs to be in the code. If...

Thanks for that. That sounds interesting. I struggle with code. Is it easy to implement?

Thanks, i'll try. I'm not a coder so what do I put in code to link to query? You put run your query.

its just a one off unlock to a full database. With there name in the forms, its less likely to be copied. theres no online checking. Purely done locally with maths calcs. i'll post in the vba posts

If you are to sell a db. What have people done to stop one person copying it to their mates. I have a way in which they send me their name,lastname and email. I then have a separate db that genertates a code based on a maths calculation. The users db does same calc. Then a comparison is...

I have a del query that I want to run from a button. When clicked I want a msgbox asking "are you sure you want to delete?" then have yes and no options. if yes is pressed it run my query. if no it closes form. I know I need to mess with styles but cant get them to work. I'm sing...