Search results

no it comes back every time for some reason. i have put the file here if anyone would have a look for me. It is the form called "main" http://www.monkeygambling.com/pigs.zip thanks

there is no debug to press. it comes up with "compile error - expected: case"

i cant create or use any buttons as the error just comes up: "compile error" Option Compare Database SELECT FROM Query([Litters per year]) WHERE Month = [date?]

even when I create a new form and put command buttons on. that error still comes up. I don't know how to get rid of it.

I don't know much about SQL or VB. What I wanted to know is how to get rid of that code. Its stopping me putting any commant buttons on my form. Everytime I click them that comes up. Its not even a query i'm using or even have anymore. thanks

Hi, I have 2 related. In the first table I have a primary key number and another ID number. On the 2nd table which is related by the PrimKey I want the ID number to come up automatically. I can't remember how to do this. Can anyone help? thanks

Hi, I've created a button through the wizard but when I click it, this comes up: "compile error" Option Compare Database SELECT FROM Query([Litters per year]) WHERE Month = [date?] i've tried deleting both the code and the button,but the complie error just comes back.

I've created a button through the wizard but when I click it, this comes up: "compile error" Option Compare Database SELECT FROM Query([Litters per year]) WHERE Month = [date?] i've tried deleting it,but it just comes back

Hi, I get no wizard. The button just draws on the form. I could go to properties to do it, but I don't know how to.

How do I make a botton on a form open a report when pressed? thanks

In my database I have a Month([Date]) field which returns records from the criteria of month "1", "2" through to "12". However I want it to return them for those months only of this year. Is there a date function where I can have something like Month([Date]), Year ([=Now]) thanks

In my database I has a Month([Date]) field which returns records from the criteria of month "1", "2" through to "12". However I want it to return them for those months only of this year. Is there a date function where I can have something like Month([Date]), Year ([=Now]) thanks

sorry I don'y understand much of that

I'm not quite sure where to put that. I'll try explaining again. I have a set of data, which I want to produce a report of every month. The months report is of all the data with a date value within this month. I want to open my report and it to give me a list box or msg box asking for the...

Hi, I would like to have a report linked to a query. I want the query made with a date field. When the report is opened I want to be asked a month and it shows me all the dates data within that month. Could anyone help me with this please. I also want the data to be from the current year when...

Hi, I want to create a query that i can select a month from a list and display all data in my table from dates within this month. I have not had much luck doing this so far so any help would be much appreciated. Ultimately I would like to have a report that when I open, ask me to select a date...