Search results

Thanks for the help!:)

Hello, Is it possible to return a value from a query in VBA, something like the following? codeNumber=DoCmd.OpenQuery ("qryGetCodeNumber") Thank you in advance.

that works thank you :)

you mean the default value? I did that but if i checked the radio button and then try to uncheck it nothing happens.

I have a form full of radiobuttons in groups. They just informed me that they need to be able to uncheck a radion button without selecting another one from the group. (be able to reset their choice) Is this possible with radio option group? Thank you in advance.

Hello all, I have a back end database that i cannot access at the moment. Is it possible to set the link of the tables for the front end application based on the location that the database will be even though i can't see that location now? Thank you in advance.

Oh, i didn't know that, i just used the wizard. Thanks for the info, i will replace it!

I just realised i was doing something really stupid! I added the code line for saving the record in the wrong command button.:mad: The code is working just fine, I apologise for wasting your time :(

because i checked the table of form1 after form2 was opened and the record wasn't inserted.

I have a command button that connects two forms. I need to save form1 before opening form2. I added a line for saving the record and then open form2 as following but it doesn't work. Any suggestions? Private Sub Command30_Click() On Error GoTo Err_Command30_Click Dim stDocName As String...

thank you!

I have a button in a form which i want to print Report1 if the CompanyName is null or Report2 if the CompanyName is not null. I wrote the following code but when i click on the button i get the message "Object Required." Any suggestions? Thank you in advance. Private Sub Command62_Click() On...

with your help i made it work. Thanks a lot!

the page is landscape with margins (top:10,bottom:10,left:5,right:5) and i get the same error message. The size of the report is greater than one page because i design it for two pages, using page break.

i tried this and i get the error message "The sum of the top margin, the bottom margin, the height of the paper header and the height of the page footer is greater than the length of the page you are printing on."

that solves the problem! :) Thank you all for your help!

i changed it to DCount("CustName", "Customers", "[CustName] ='& Me.search_combo.Value &'") and i still get zero.

I 'm trying to design a report that will show on the front page all the data considering the Client (Name, Address, etc) and on the back page all the items than client bought last month. How can i design it? Thank you.

I used DCount as following and i always get result=0 :confused: DCount("*", "Customers", "[CustName] ='& Me.search_combo.Value &'") 'Me.search_combo.Value is the value of CustomerName in the form any suggestion what am i doing wrong?

thanks for the reference.