Search results

Hi guys, a company in my city is giving out prizes, and for each buy you get a sheet with 25 numbers ( kind of bingo thing). Well I have like 300 sheets . So i did an Access where I enter the SheetID and the 25 numbers. Now I have to do another table where I can insert the number that will be...

here is the picture

Hey, BO-1 is set with top margin to 6 so in case that there is 6 records, it all can fit in 1 page. What I want is that BO-1 look like BO-1-K ( that I changed manually top margin to 22) Is there anyway i can do that automatically? Like a vb code that check how...

Its on the footer report. that makes it center on the botton margin but but what I need is to center on the top margin. Is there any way to do that Thanks

Pretty much what I need is the margin to autoset depend how many record are add in the Detail part so the report its always in the center of the page. Example BO-1 , 2 records are added EXample BO-3, 6 records are added

Hi guys, I have this report that on the detail part can be 1 or 10 records, but I need to do this report autocenter verticaly no matter how many record was insert. Top margin will be 6( set it to fit 10 records on the same page) but if i enter 5 record, i need the top margin to be 10 or so. Is...

I go to Amostras.text Control Source: variable = DCount([SolicitaçãoID_P ],"Protoloco_O ","SolicitaçãoID=" & SolicitaçãoID.Text) and nothing happend, it doesnt even keep the code, it go back to the old value

im going to try yours cuz is way simple (since i am not vb programmer, though i made it work , hehehe) brb THanks

Thaks now I am getting this error 3061 not enought parameters on this line Set rs = db.OpenRecordset(strSQL, dbOpenSnapshot) . THanks

First thanks for the prompt answer. Second, you will kill me but i have no Tools>references :confused:

I am trying to count how many records has a table with a special value (SolicitaçãoID.Text) but I keep getting error: Compile Erro: User-Defined not defined And it goes to this line: Dim db As DAO.Database This is the command: Private Sub CmdAmostra_Click() Dim db As DAO.Database Dim rs As...