Search results

I do not get any error when I close the database: I've made a database in mdb format for you - try it. What if you made a new simple database - do you still get the error? How did you compile the database?

No problem, have a nice weekend!:)

Are you running the database at a server or you local computer, (both Front- and Back-end)? Do you've any code running when you close the database? Do you have the option to save the database in another version like 2010 or 2003 or 2000? Else post your database with a few sample data in it...

The same as here - but even then when I search for dates the criteria must be in US-Format, (mm/dd/yy).

Good you got the problem solved, but to help others, what was the problem?

Create a new query switch to SQL-view and paste the below into it! Does that give the correct result?

Have you checked the "HyperLinkAddress" property for the control "VATx" just when you open the form.? Else I would suggest to create a label and set the "HyperLinkAddress" to the address you want.

If I use your code I got a Sign In page, (so I think it works okay by me?)!

I hope you like the solution! :) Please tell, where you did repost the database? :confused:

What report, what control, (seems not to exist a control with that name)? When you post a database, please post some sample data + an exactly description how to reproduce the problem.

Why are you first running a query and then open the report? Why are you not using the query as the record source in the report, (then it will trigger the query to run)? If you can't get it, post your database with some sample data + description to reproduce the problem.

You're missing spaces in the SQL-string, marked wit red, I've added them. cc_deq = "SELECT LISTA_EQ.ID, LISTA_EQ.[No INV], LISTA_EQ.DESCRICAO, LISTA_EQ.MARCA, LISTA_EQ.MODELO, LISTA_EQ.[Num_SERIE / MATRICULA] " _ & "FROM LISTA_EQ " _ & "WHERE ([CC_DEQ] = " & Me.cc_deq_combo_box & ") " _...

It depend of the printer and if it is able to print on both side. So look at the printer setup.

Ask them why they think so and also for evidence of their claims. What do they propose to use instead and if they able to do it, (or what they think it costs to get done if they are not willing/able to). One can always be criticized, but are those who criticize being able to give / make another...

(This # is the same I get from a similar select query without unique records required) Instead of a select query try to run a "Make Table" query, then look at the number of records, is that the same as the select query.

To start with, you could skip to code you've at start up. Because as I read your post, the database crash several times a day, so it will quickly prove whether it is something in the code that is the reason, then if the database run a whole day without crashing, then it is the code. Oh yeah I...

If you don't want previous months/years in the graph, then you should have avoid them in the example you posted.

Hi StuartG. That is what you should expect to see when you open the report "Opened by MonthAndProduct line", (except from the name of the month, it will be in you language).

Maybe not, but just in the moment I can't think of anything without involving a Crosstab query, don't hesitate to try! :)

Sorry, but that would not work, because the graph use a transform query!